A readme is available
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