IBM Support

PJ40230: DATA STATION OPERATOR (WITH "RUNSTATS" OPTION) DOESN'T WORK PROPERLY WHEN JOINED WITH ANOTHER REMOTE TABLE.

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

  • Problem description:
    
    When Data Station operator (with "Runstats" option selected) was
    joined with another remote table, the generated code could be
    problematic because the DGTT (Declare Global Temporary Table)
    created previously is invisible for another DB2 execution
    session (DB2 SQL Script unit).
    

Local fix

  • Workaround:Un-check the "Runstats" option in Data Station
    operator.
    Interim fix SQW_9.5.2.v20120522.zip or later fixes
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When Data Station operator (with "Runstats" option selected) *
    * was                                                          *
    * joined with another remote table, the generated code could   *
    * be                                                           *
    * problematic because the DGTT (Declare Global Temporary       *
    * Table)                                                       *
    * created previously is invisible for another DB2 execution    *
    * session (DB2 SQL Script unit).                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to product Infosphere Warehouse V9.7.7               *
    ****************************************************************
    

Problem conclusion

  • This problem has been fixed in version 9.5 Fixpack 2 2012-05-22
    interim fix build. At a
    minimum, the latest interim fix for V9.5.2 should be applied on
    the Design Studio.
    
    
    After applying this fix, When Data Station operator (with
    "Runstats" option selected) was
    joined with another remote table, the execution will be
    successful.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PJ40230

  • Reported component name

    DWE SQL WHSE TO

  • Reported component ID

    5724DWESQ

  • Reported release

    952

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-15

  • Closed date

    2013-08-19

  • Last modified date

    2013-08-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 SQL WHSE TO

  • Fixed component ID

    5724DWESQ

Applicable component levels

  • R952 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCMVBH","label":"DWE - SQL Warehousing Tool"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"952","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 August 2013