A fix is available
APAR status
Closed as program error.
Error description
When Host (ZOS) job aband, and DB2 II instance got -902 error, and this caused Information Integration thread dump: 2006-08-16-08.18.19.703000-240 I2393182H699 LEVEL: Severe PID : 2068 TID : 5328 PROC : db2syscs.exe INSTANCE: DB2IHB1 NODE : 000 DB : IHBF1 APPHDL : 0-744 APPID: *LOCAL.DB2IHB1.060816121748 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 5 sqlerrmc: 65535 sqlerrp : sqlri1rc sqlerrd : (1) 0xFFFFFFFF (2) 0x0000FFFF (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2006-08-16-08.18.19.703000-240 I2393883H161 LEVEL: Severe PID:2068 TID:5328 NODE:000 Title: SQLCA Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2IHB1\20685328.000
Local fix
Problem summary
SUMMSRY: Users Effected: This problem happens on DB2 II accessing z/OS DB2 database. Problem Description: When Host (ZOS) job aband, and DB2 II instance got -902 error, and this caused Information Integration thread dump: Problem Summary: DB2 CONNECT THREAD COULD DUMP WHEN HOST JOB ABAND.
Problem conclusion
Conclusion: defect 374439 CSD First fixed in DB2 UDB Version 8, FixPak 14 module sqqg_odbc
Temporary fix
Temperary Fix: Upgrade to DB2 Version 8, FixPak 14.
Comments
APAR Information
APAR number
JR25138
Reported component name
DB2 UDB PE WIND
Reported component ID
5724B5501
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-10-30
Closed date
2006-11-28
Last modified date
2006-11-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
eng_sqjs sqg_odbc
Fix information
Fixed component name
DB2 UDB PE WIND
Fixed component ID
5724B5501
Applicable component levels
R820 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"820"}]
Document Information
Modified date:
06 October 2021