IBM Support

JR25138: -902 ERROR CAUSED INFORMATION INTEGRATION THREAD DUMP

Subscribe

You can track all active APARs for this component.

 

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