APAR status
Closed as program error.
Error description
After applying the patch for APAR IZ24442_IZ29235 the DB2 EE Stage using LOAD TRUNCATE with 0 rows, does not execute the command.
Local fix
Use WRITE/TRUNCATE or the db2 load command. This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: All users using DB2 Enterprise Stage **************************************************************** PROBLEM DESCRIPTION: Unable to truncate DB2 table using DB2 Enterprise SJR30505tage LOAD write method with zero record input **************************************************************** RECOMMENDATION: Apply the patch for APAR JR30505. ****************************************************************
Problem conclusion
DB2 Enterprise Stage Load write method checks if input record has no record. If it contains no record, operator was finishing the job without executing LOAD. If we have zero record input from source, the DB2 Enterprise stage won't be able to truncate table. This was implemented to avoid AIX bug, and this problem was resolved by AIX patch Y86254.060621.epkg. If customer has applied AIX patch Y86254.060621.epkg, user can install this patch to enable DB2 table truncation using zero record input. For other platforms, no Operating System patch is required.
Temporary fix
Comments
APAR Information
APAR number
JR30505
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-26
Closed date
2008-10-09
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
PXDB2
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010