IBM Support

JR39200: Unexpected db2 stop, restart, db2 crash recovery started but db2 stopped again.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Unexpected db2 stop, restart, db2 crash recovery started but db2
    stopped again.
    
    db2diag.log entries:-
    -------------------------
    2010-09-15-09.20.53.430000+120 I173619H507        LEVEL: Severe
    PID     : 2052                 TID  : 1104        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   :
    CMM_DAK1
    APPHDL  : 0-34                 APPID:
    11.2.16.26.53008.100915071730
    AUTHID  : UF13DB2
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
    DATA #1 : Hexdump, 8 bytes
    0x08A2D872 : 4E55 4C4C 4944 2020                        NULLID
    
    2010-09-15-09.20.53.430000+120 I174128H565        LEVEL: Severe
    PID     : 2052                 TID  : 1104        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   :
    CMM_DAK1
    APPHDL  : 0-34                 APPID:
    11.2.16.26.53008.100915071730
    AUTHID  : UF13DB2
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
    DATA #1 : Hexdump, 18 bytes
    0x08A2D860 : 4442 434D 4D30 2020 2020 2020 2020 2020    DBCMM0
    
    0x08A2D870 : 2020
    
    2010-09-15-09.20.53.430000+120 I174695H565        LEVEL: Severe
    PID     : 2052                 TID  : 1104        PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   :
    CMM_DAK1
    APPHDL  : 0-34                 APPID:
    11.2.16.26.53008.100915071730
    AUTHID  : UF13DB2
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : RDS UCINTFC: pCurrentPID->pkgname =
    DATA #1 : Hexdump, 18 bytes
    0x08A2D884 : 5359 5353 4831 3030 2020 2020 2020 2020    SYSSH100
    
    0x08A2D894 : 2020
    
    ...
    
    
    
    DATA #1 : String, 48 bytes
    
    pool(TID)=5, obj(FID)=2, indexid(IID)=0, class=0
    
    
    
    ...
    
    
    
    DATA #1 : String, 50 bytes
    
    pool(TID)=8, obj(FID)=2, indexid(IID)=0, class=128
    
    
    
    ...
    
    
    
    DATA #1 : String, 48 bytes
    
    pool(TID)=3, obj(FID)=4, indexid(IID)=0, class=0
    
    
    
    Stack entries:-
    -----------------
    
    <StackTrace>
    <![CDATA[
    --EBP------EIP------ARGS-----------------------------
    08FB9810 6EF9C621 08A26D80 2804E5DC 27750734 2804E61C offset:
    00000311 in
    <?sqlri_cast2ls@@YAHPAUsqlrr_cb@@PAUsqlz_value@@11H@Z>
    <sqlri_str_sclr.C:5190>
    08FB9834 6EF9C2DB 08A26D80 078CAC98 2804E380 08A26D80 offset:
    00000049 in <?sqlri_cast2ls_e@@YAHPAUsqlrr_cb@@@Z>
    <sqlri_str_sclr.C:6712>
    08FB9860 6EF7F9E4 08A26D80 2804E590 00000000 00000000 offset:
    00000098 in
    <?sqlriSectInvoke@@YAHPAUsqlrr_cb@@PAUsqlri_opparm@@@Z>
    <sqlri_exe.C:836>
    08FB98E8 6EEEB025 08A26D80 00000000 00004000 08A2D860 offset:
    000003CB in
    <?sqlrr_process_execute_request@@YAHPAUsqlrr_cb@@H@Z>
    <sqlrr_sql.C:1249>
    08FB9920 6EEAA92F 08A2D660 08FB9978 08CC0150 08A2D660 offset:
    000000D5 in
    <?sqlrr_execute@@YAHPAUdb2UCinterface@@PAUUCstpInfo@@@Z>
    <sqlrr_req_sql.C:772>
    08FB99E0 6E803327 08A2D660 08FB9A98 00000000 08C4FFE0 offset:
    000003F3 in
    <?sqljs_ddm_excsqlstt@@YAHPAUdb2UCinterface@@PAUsqljsDDMObject@@
    @Z>
    <sqljsexe.C:1332>
    08FB9A44 6E7F8B4E 6E5A2CF8 078CAD00 08CC08C4 00000000 offset:
    0000004A in
    <?sqljsParseRdbAccessed.@@YAHPAUsqljsDrdaAsCb@@PAUsqljsDDMObject
    @@PAUdb2UCinterface@@@Z>
    <sqljspar.C:356>
    08FB9AB8 6E7F865D 08CC0060 08A2D660 0000FEEF 078CAD00 offset:
    0000024F in
    <?sqljsParse@@YAHPAUsqljsDrdaAsCb@@PAUdb2UCinterface@@@Z>
    <sqljspar.C:827>
    08FB9B2C 6E7E0548 00000000 00000000 00000110 08D500F0 offset:
    00000F02 in <?sqljsDrdaAsDriver@@YAHPAUsqlcc_init_struct@@@Z>
    <sqljsqam.C:1386>
    08FB9B6C 6E7E02FE 08FBF1D0 00000074 00000000 08FB9BD0 offset:
    00000CB8 in <?sqljsDrdaAsDriver@@YAHPAUsqlcc_init_struct@@@Z>
    <sqljsqam.C:1952>
    08FB9BA4 6E7DF7BB 078CAB64 00000001 00000000 00000000 offset:
    00000175 in <?sqljsDrdaAsDriver@@YAHPAUsqlcc_init_struct@@@Z>
    <sqljsqam.C:617>
    08FBF25C 6E7DF6B1 078CAB64 00000000 00000000 00000000 offset:
    0000006B in <?sqljsDrdaAsDriver@@YAHPAUsqlcc_init_struct@@@Z>
    <sqljsqam.C:434>
    08FBF510 6E6B87F5 08FBFD30 00000004 6DB9471E 00000000 offset:
    00000787 in <?sqleRunAgent@@YAXPADI@Z> <sqleagnt.C:3419>
    08FBFFB8 6DAD39E8 02A7EE64 00000000 00000000 02A7EE64 offset:
    00000244 in <_sqloEDUEntry@4> <sqloedu.C:2572>
    08FBFFEC 7C82482F 6DAD37A4 02A7EE64 00000000 00000000
    ]]></StackTrace>
    <StackDump>
    
    No errors in DB2DART
    -----------------------
    ___________________
    
             The requested DB2DART processing has completed
    successfully!
                         All operation completed without error;
                       no problems were detected in the database.
                         ______________________________________
    
                            Complete DB2DART report found in:
    C:\PROGRAMME\SQLLIB\DB2\DART0000\CMM_DAK1.RPT
    
        _______    D A R T    P R O C E S S I N G    C O M P L E T E
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 Users                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * unexpected db2 stop, restart, db2 crash recovery but than    *
    * db2 stopped again.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The customer has to upgraded db2_v95fp8 or higher versions   *
    * to resolve the crash issue.                                  *
    ****************************************************************
    

Problem conclusion

  • After installing the db2_v95fp8 higher versions the crash  issue
    will be resolved
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR39200

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-21

  • Closed date

    2011-07-21

  • Last modified date

    2011-07-21

  • APAR is sysrouted FROM one or more of the following:

    JR37905

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 July 2011