A fix is available
APAR status
Closed as program error.
Error description
problem with the DB2 Bulk Load common connector IS 8.1 with Rollup 2 where job aborts with the following SQL error: [IIS-CONN-DB2-000277] CC_DB2Partitioner.cpp:(1,179) sqlugrpn() m_sqlca.sqlcode = -6,044 Item #: 754 Event ID: 2045 Timestamp: 2009-12-02 14:49:58 Type: Fatal User Name: iisadmin Message Id: IIS-CONN-NGBR-00002 Message: FILE,3: [IIS-CONN-DB2-000365] An error occurred while determining the row partition. The method sqlugrpn returned reason code 0, SQLCODE -6,044. (CC_DB2Partitioner::partitionOneTopLevelDataItem, file CC_DB2Partitioner.cpp, line 1,190)
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users of DB2 Connector accessing partitioned databases **************************************************************** PROBLEM DESCRIPTION: When a string value is converted to the server encoding the length of the converted string may exceed the maximum for the column. In such a case sqlugrpn() fails with SQL6044N. **************************************************************** RECOMMENDATION: Install the patch ****************************************************************
Problem conclusion
Fixed-length strings are padded to the right up to their specified length. When these strings are converted and the converted string is longer then the max length, it is OK to truncate them if the extra characters are all pad characters. Added code to truncate fixed length strings if it is OK and throw a truncation error in other cases.
Temporary fix
Comments
APAR Information
APAR number
JR35064
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-12-08
Closed date
2010-01-06
Last modified date
2010-01-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DB2CONN
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021