PJ38907: GUI blocks when using sampling function of the table target operator in mining flow.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • This happens when the underlying database table is locked by the
    database, this can happen for instance when a flow is executing
    that inserts data into this table. The mining flow runs in the
    background and inserts records into the table, and the user
    calls the table sampling that performs a "select" on the table
    in the foreground. So the GUI blocks until the database unlocks
    the table, in this case when the "insert" has finished when the
    flow execution has finished.
    

Local fix

  • Workaround:None
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This happens when the underlying database table is locked by *
    * the                                                          *
    * database, this can happen for instance when a flow is        *
    * executing                                                    *
    * that inserts data into this table. The mining flow runs in   *
    * the                                                          *
    * background and inserts records into the table, and the user  *
    *                                                              *
    * calls the table sampling that performs a "select" on the     *
    * table                                                        *
    * in the foreground. So the GUI blocks until the database      *
    * unlocks                                                      *
    * the table, in this case when the "insert" has finished when  *
    * the                                                          *
    * flow execution has finished.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fix pack 9.7.7                                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in version 9.7 fix pack 7.
    At a minimum, this fix should be applied on the Design studio.
    
    After applying this fix, the sampling function in the context
    menu of table target operator in mining flow will work well.
    

Temporary fix

  • Interim fix 9.7.2.v20110511 contains this APAR fix..
    

Comments

APAR Information

  • APAR number

    PJ38907

  • Reported component name

    DWE DESIGN STUD

  • Reported component ID

    5724DWEDS

  • Reported release

    971

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-04

  • Closed date

    2012-11-19

  • Last modified date

    2012-11-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DWE DESIGN STUD

  • Fixed component ID

    5724DWEDS

Applicable component levels

  • R973 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Warehouse
DWE - Design Studio

Software version:

971

Reference #:

PJ38907

Modified date:

2012-11-19

Translate my page

Machine Translation

Content navigation