Fixes are available
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
A DRDA control block is not initialized to 0 which causes incorrect MGRLVLLS maybe picked up when Concentrator turned on. SQLJR_BADCOM error maybe returned in db2diag.log From db2diag.log ---------------- 2009-07-01-11.04.11.203808-240 I27036A954 LEVEL: Error PID : 8600 TID : 2199325239648PROC : db2sysc INSTANCE: dbctib01 NODE : 000 DB : N090DSN APPHDL : 0-28197 APPID: GA099D5E.CDDA.0A0531150220 AUTHID : E0413X1 EDUID : 30 EDUNAME: db2agent (N090DSN) FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:20 MESSAGE : ZRC=0x80370084=-2143879036=SQLJR_BADCOM "Op not supported" DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30005 sqlerrml: 43 sqlerrmc: N090DSN DSN08015 0x1055"("02")" sqlerrp : sqljrerm sqlerrd : (1) 0x80370084 (2) 0x00000084 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: .. -----------------
Local fix
Turn off Connection Concentrator
Problem summary
A DRDA control block is not initialized to 0 which causes incorrect MGRLVLLS maybe picked up when Concentrator turned on. SQLJR_BADCOM error maybe returned in db2diag.log From db2diag.log ---------------- 2009-07-01-11.04.11.203808-240 I27036A954 LEVEL: Error PID : 8600 TID : 2199325239648PROC : db2sysc INSTANCE: dbctib01 NODE : 000 DB : N090DSN APPHDL : 0-28197 APPID: GA099D5E.CDDA.0A0531150220 AUTHID : E0413X1 EDUID : 30 EDUNAME: db2agent (N090DSN) FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:20 MESSAGE : ZRC=0x80370084=-2143879036=SQLJR_BADCOM "Op not supported" DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30005 sqlerrml: 43 sqlerrmc: N090DSN DSN08015 0x1055"("02")" sqlerrp : sqljrerm sqlerrd : (1) 0x80370084 (2) 0x00000084 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: .. -----------------
Problem conclusion
First fixed in V9.5 FP5
Temporary fix
Turn off Connection Concentrator
Comments
APAR Information
APAR number
LI74715
Reported component name
DB2 CUE ISER LI
Reported component ID
5724M1504
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-14
Closed date
2009-12-21
Last modified date
2009-12-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
LI74779 IC62279
Fix information
Fixed component name
DB2 CUE ISER LI
Fixed component ID
5724M1504
Applicable component levels
R950 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":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
17 October 2021