IBM Support

IZ17770: CRASH RECOVERY FAILS FOLLOWING "INTERRUPT. USER CANCEL." MESSAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Crash Recovery Fails Following "Interrupt. User Cancel." Message
    
    DB2 Linux/Unix/Windows crash recovery fails with the following
    symptoms:
    
    db2diag.log contains messages similar to the following:
    
    
    2008-03-02-07.16.19.430863-300 I26985E453 LEVEL: Error
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxt040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2350
    RETCODE : ZRC=0x800F0003=-2146500605=SQLO_INTRP "Interrupt. User
    Cancel."
    DIA8003C The interrupt has been received.
    
    2008-03-02-07.16.19.431588-300 I27439E493 LEVEL: Error
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxx040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
    DATA #1 : String, 140 bytes
    Crash recovery failed with rc -2146500605
    LowtranLSN 000002F33A07D026 MinbuffLSN 000002F34407D00C
    Recovery started on log file S0019160.LOG.
    
    2008-03-02-07.16.19.456611-300 E27933E392 LEVEL: Error
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxx040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
    MESSAGE : ADM1532E Crash recovery has failed with SQLCODE
    "-1044".
    
    2008-03-02-07.16.19.456987-300 I28326E407 LEVEL: Error
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxx040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, base sys utilities, sqleInitEngineComponents,
    probe:111
    MESSAGE : Restart failed due to interrupt with type: -2080374783
    
    2008-03-02-07.16.19.457228-300 I28734E478 LEVEL: Severe
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxx040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, base sys utilities, sqleInitEngineComponents,
    probe:202
    MESSAGE : If 'DATALINK: file server not registered' appears
    above and
    DATALINKS=NO, set DATALINKS=YES and try RESTART again
    
    2008-03-02-07.16.19.457383-300 I29213E358 LEVEL: Severe
    PID : 14084 TID : 182968993600PROC : db2agntp (MARCH) 3
    INSTANCE: xxxxx040 NODE : 003 DB : MARCH
    APPHDL : 1-53 APPID: AC1364B8.C00E.012E82121509
    FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:140
    RETCODE : ZRC=0xFFFFFBEC=-1044
    
    
    Subsequent crash recovery operation may fail with the following
    messages
    
    
    2008-03-02-14.20.05.487184-300 I6309E426          LEVEL: Warning
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
    MESSAGE : Crash recovery started. LowtranLSN 000002F33A07D026
    MinbuffLSN
              000002F34407D00C
    
    2008-03-02-14.20.05.490137-300 I6736E407          LEVEL: Warning
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
    MESSAGE : Using parallel recovery with 9 agents 9 QSets 72
    queues and 128 chunks
    
    2008-03-02-14.20.05.723779-300 I7144E436          LEVEL: Warning
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
    MESSAGE : DIA2051W Forward phase of crash recovery has
    completed.  Next LSN is
              "000002F33A07D026".
    
    2008-03-02-14.20.05.724271-300 I7581E379          LEVEL: Severe
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4110
    MESSAGE : Recovery did not reach the end of the logs!
    
    2008-03-02-14.20.05.724412-300 I7961E183          LEVEL: Severe
    PID:23732 TID:182968993600 NODE:003 Title: SQLP_DBCB
    Dump
    File:/var/ibmdb2/xxxxx040/sqllib/db2dump/237322580367168.003
    
    2008-03-02-14.20.05.724745-300 I8145E492          LEVEL: Error
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
    DATA #1 : String, 140 bytes
    Crash recovery failed with rc -2045771763
    LowtranLSN 000002F33A07D026 MinbuffLSN 000002F34407D00C
    Recovery started on log file S0019160.LOG.
    
    2008-03-02-14.20.05.724916-300 I8638E380          LEVEL: Warning
    PID     : 23732                TID  : 182968993600PROC :
    db2agent (MARCH) 3
    INSTANCE: xxxxx040             NODE : 003         DB   : MARCH
    APPHDL  : 3-210                APPID: *N3.xxxxx040.080302192004
    FUNCTION: DB2 UDB, base sys utilities, sqlePdbRemap, probe:100
    MESSAGE : ZRC 8610000d remapped to SQLCODE -1042
    

Local fix

  • N/A
    

Problem summary

  • See error description.
    

Problem conclusion

  • First Fixed in DB2 UDB Version 8.1 Fixpak 17
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ17770

  • Reported component name

    DB2 DPF

  • Reported component ID

    5724N7400

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-14

  • Closed date

    2008-10-15

  • Last modified date

    2008-10-15

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

    IZ17769

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

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R810 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2008