APAR status
Closed as program error.
Error description
DS 7.5.1A on AIX 5.3 The DB2 EE stage job generated following fatal error but it finished running successfully. Item #: 147 Event ID: 146 Timestamp: 2009-09-21 12:21:09 Type: Fatal User Name: etldstge Message: SYLVAIN_TEST,1: Error in row #3 [db2Upsert.C:1974] Primary Error: [db2Upsert.C:1976] sqlcode=-407, state=23502, message=[IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=278, TABLEID=12, COLNO=4" is not allowed. SQLSTATE=23502 [db2Upsert.C:2329] Secondary Error: [db2Upsert.C:1979] sqlcode=100, state=02000, message=[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 We can workaround the problem by setting envirnomental variable APT_DB2UPSERT_HIDE_REJECT_MESSAGES to 1 However, the customer asked if there is a PATCH that correct the problem permantently without use the variable.
Local fix
We can workaround the problem by setting envirnomental variable APT_DB2UPSERT_HIDE_REJECT_MESSAGES to 1
Problem summary
**************************************************************** USERS AFFECTED: DataStage 751 on AIX, DB2-upsert **************************************************************** PROBLEM DESCRIPTION: fatal error problem with DB2 UPSERT or DELETE option of DB2 Enterprise stage. **************************************************************** RECOMMENDATION: Install the patch: JR34474_aix_DS751.tar.Z ****************************************************************
Problem conclusion
Fxied, back ported the code from upper brach to 751
Temporary fix
Comments
APAR Information
APAR number
JR34474
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-07
Closed date
2009-10-22
Last modified date
2009-10-22
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R751 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":"7.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
22 October 2009