IBM Support

JR37905: 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 the users who has db2_v91fp4                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * unexpected db2 stop, restart, db2 crash recovery but than    *
    * db2 stopped again.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The customer has to upgraded db2_v91fp10 or higher versions  *
    * to resolve the crash issue.                                  *
    ****************************************************************
    

Problem conclusion

  • After installing the db2_v91fp10 or higher versions the crash
    issue will be resolved.
    

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    JR37905

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-04

  • Closed date

    2011-06-10

  • Last modified date

    2011-06-10

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

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

    JR37944 JR37955 JR37962 JR37971 JR37984 JR37996 JR38010 JR38028
    JR38038 JR38051 JR38071 JR38083 JR38094 JR38115 JR38138 JR38146
    JR38603 JR38613 JR38620 JR38627 JR38632 JR38642 JR38655 JR38665
    JR38675 JR38683 JR38718 JR38723 JR38732 JR38743 JR38752 JR38764
    JR38776 JR38785 JR39200 JR39201

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSN

       UP

  • R910 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":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 June 2011