APAR status
Closed as program error.
Error description
DB2 Load operation fails with error SQL27906N when database default table organization (DFT_TABLE_ORG) is set to "COLUMN" Item #: 404 Event ID: 748 Timestamp: 2017-05-24 09:42:01 Type: Warning User Name: gprasad1 Message Id: IIS-CONN-DB2-00314 Message: DB2_WRT_USUSERDB_PROFILE_DATA,3: The DB2 Load API call failed with SQLCODE -27906. Load messages are stored in message file:/etrade/dit/dsadm/batch/uscrm/ common/db2_rejects/gprasad1/DW_DM_TMP.USUSERDB_PROFILE_DATA_S/US USERDB_ PROFILE_DATA_S.msg. Item #: 405 Event ID: 749 Timestamp: 2017-05-24 09:42:01 Type: Fatal User Name: gprasad1 Message Id: IIS-CONN-DB2-00315 Message: DB2_WRT_USUSERDB_PROFILE_DATA,3: An error occurred while loading the table. (CC_DB2APILoadRecordDataSetConsumer::complete, file CC_DB2APILoadRecordDataSetConsumer.cpp, line 2010) SQL27906N The load operation was not performed because the specified parameters are not supported with the type of the target table. If you manually modify the clp file to remove the following lines: PARTITIONED DB CONFIG OUTPUT_DBPARTNUMS (3); Then the job run successful.
Local fix
NA
Problem summary
**************************************************************** USERS AFFECTED: Users performing LOAD operation with REPLACE action into DB2 that has column-organized table. **************************************************************** PROBLEM DESCRIPTION: During data load operation into column-organized tables with bulk load mode set to LOAD REPLACE, connector reports SQL27906N error and load fails. **************************************************************** RECOMMENDATION: Install patch JR57999. ****************************************************************
Problem conclusion
When connector detects column-organized table and bulk load operation is configured with LOAD REPLACE action, connector will automatically switch into 'sequential' execution mode.
Temporary fix
n/a
Comments
APAR Information
APAR number
JR57999
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-06-07
Closed date
2017-11-16
Last modified date
2017-11-16
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
RB50 PSY
UP
RB70 PSY
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":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 November 2017