Readmes are available
APAR status
Closed as program error.
Error description
When loading data from a remote database, ISW inserts the data into a global temporary table before moving it to a target database which causes a performance degradation.
Local fix
Workaround: none Interim Fix SQW_9.7.2.v20110629 or later fixes this problem
Problem summary
**************************************************************** * USERS AFFECTED: * * All users running Design Studio 9.7.2 * **************************************************************** * PROBLEM DESCRIPTION: * * When loading data from a remote database, ISW inserts the * * data * * into a global temporary table before moving it to a target * * * * database which causes a performance degradation. * **************************************************************** * RECOMMENDATION: * * Upgrade to InfoSphere Warehouse 9.7.3 or apply the v9.7.2 * * interim fix SQW_9.7.2.v20110629 * ****************************************************************
Problem conclusion
The problem has been fixed on v9.7.2 with interim fix SQW_9.7.2.v20110629 and also version 9.7 fixpack 3. After applying the fix, there will be an option allow the user use a cataloged database and load the data directly without the temporary table
Temporary fix
Comments
APAR Information
APAR number
PJ39152
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-06-28
Closed date
2013-01-07
Last modified date
2013-01-07
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
R972 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCMVBF","label":"DWE - Design Studio"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"971","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
07 January 2013