Fixes are available
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
A LOAD job can unexpectedly end with issue raised on build phase of the LOAD reporting "Unexpected msg. , 28, 0, Detected in file:sqluvld.C, Line:5506". Issuing the same job a second time most often succeed. Symptoms in db2diag.log : 2017-03-29-22.03.49.137730+000 I30026460A575 LEVEL: Warning PID : 12648892 TID : 43353 PROC : db2sysc 1 INSTANCE: xxxxxx NODE : 001 DB : xxxxx APPHDL : 0-24524 APPID: xxx.xx.xxx.152.33465.170329215211 AUTHID : xxxxxx HOSTNAME: xxxxxxxx EDUID : 43353 EDUNAME: db2lrid0 1 FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:315 DATA #1 : String, 104 bytes LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26) Starting BUILD phase at 03/29/2017 22:03:49.134619. 2017-03-29-22.03.49.144039+000 I30027036A582 LEVEL: Error PID : 12648892 TID : 73769 PROC : db2sysc 1 INSTANCE: xxxxxx NODE : 001 DB : xxxxxx APPHDL : 0-24524 APPID: xxx.x.xxx.152.33465.170329215211 AUTHID : xxxxxxxx HOSTNAME: xxxxxxxx EDUID : 73769 EDUNAME: db2lload 1 FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag, probe:0 DATA #1 : String, 113 bytes LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26) Unexpected msg. , 28, 0, Detected in file:sqluvld.C, Line:5506 2017-03-29-22.03.49.145281+000 I30027619A1046 LEVEL: Error PID : 12648892 TID : 73769 PROC : db2sysc 1 INSTANCE: xxxxxx NODE : 001 DB : xxxxxx APPHDL : 0-24524 APPID: xxx.x.xxx.152.33465.170329215211 AUTHID : xxxxxxxx HOSTNAME: xxxxxxxx EDUID : 73769 EDUNAME: db2lload 1 FUNCTION: DB2 UDB, database utilities, sqlulFRMResponse, probe:5509 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes LOADID: 40662.2017-03-29-21.52.11.535870.0 (32;26) DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2044 sqlerrml: 1 sqlerrmc: 4 sqlerrp : SQLUVLD sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000001 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2017-03-29-22.03.49.147511+000 I30028666A537 LEVEL: Severe PID : 12648892 TID : 73769 PROC : db2sysc 1 INSTANCE: xxxxxx NODE : 001 DB : xxxxxx APPHDL : 0-24524 APPID: xxx.x.xxx.152.33465.170329215211 AUTHID : xxxxxxxx HOSTNAME: xxxxxxxx EDUID : 73769 EDUNAME: db2lload 1 FUNCTION: DB2 UDB, database utilities, sqlulFRMResponse, probe:5509 MESSAGE : DIA0001E An internal error occurred. Report the following error code : "". 2017-03-29-22.03.49.148644+000 I30029204A573 LEVEL: Severe PID : 12648892 TID : 73769 PROC : db2sysc 1 INSTANCE: xxxxxx NODE : 001 DB : xxxxxxxx APPHDL : 0-24524 APPID: xxx.x.xxx.152.33465.170329215211 AUTHID : xxxxxxxx HOSTNAME: xxxxxxx EDUID : 73769 EDUNAME: db2lload 1 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50 MESSAGE : rc DATA #1 : Hexdump, 4 bytes 0x0A000000C4BFBC28 : 0000 0000 .... 2017-03-29-22.03.49.149623+000 I30029778A180 LEVEL: Severe PID:12648892 TID:73769 NODE:001 Title: commacb Dump File:/db2fs/xxxxxx/NODE0001/db2dump/12648892.73769.001.dump.bin 2017-03-29-22.03.49.151080+000 I30029959A180 LEVEL: Severe PID:12648892 TID:73769 NODE:001 Title: loadacb Dump File:/db2fs/xxxxxx/NODE0001/db2dump/12648892.73769.001.dump.bin
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Using LOAD command * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 11.1 M3 FP3 * ****************************************************************
Problem conclusion
First fixed in version 11.1 M3 FP3
Temporary fix
Comments
APAR Information
APAR number
IT23141
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-11-13
Closed date
2018-03-16
Last modified date
2022-04-03
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
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022