IBM Support

IT25956: AUTOMATIC RESTORE FEATURE CAN PROVIDE AN INCORRECT SYNTAX IN THECOMMAND PASSED TO DB2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In some cases where there are parallel backup entries in the
    history file, empty directories can be passed through the
    commands generated by DB2's automatic restore algorithm.  This
    can result in a crash of the instance that may include a similar
    entry in the db2diag.log:
    
    2018-07-26-05.31.20.792782+000 E912821E1020 LEVEL: Critical
    
    PID : 46789 TID : 140686326228736 PROC : db2sysc 0
    
    INSTANCE: db2inst1 NODE : 000 DB : TEST1
    
    APPHDL : 0-55 APPID: *N0.db2inst1.180726053224
    
    AUTHID : db2inst1 HOSTNAME: db2test1.ibm.com
    
    EDUID : 138 EDUNAME: db2agent (db2test) 0
    
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:10
    
    MESSAGE : ADM14001C An unexpected and critical error has
    occurred: "Panic".
    
    The instance may have been shutdown as a result. "Automatic"
    FODC
    
    (First Occurrence Data Capture) has been invoked and diagnostic
    
    information has been recorded in directory
    "/db2test/db2dump/NODE0000/FODC_Panic_2018-07-26-05.31.20".
    
    Please look in this directory for detailed evidence about what
    happened and contact IBM support if necessary to diagnose the
    problem.
    
    A trap similar to this may be produced:
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356
    ossDumpStackTraceV98 + 0x002b
    OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7
    sqlo_trce + 0x03c7
    sqloEDUCodeTrapHandler + 0x03b1
    gsignal + 0x0037
    abort + 0x0148
    sqloExitEDU + 0x0174
    sqle_panici + 0x06a4
    SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb + 0x028e
    sqlofmblkEx + 0x079e
    sqludautControllerbPcjPiP12SQLU_BAPP_CBP26sqlu_tablespace_bkrst_
    listP15sqlu_media_listbP5sqlca + 0x1d91
    sqludrsa_route_inP5sqldaS0_P5sqlca + 0x0ebe
    sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgentP5sq
    lca + 0x0eae
    sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x1397
    sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x0618
    sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
    erface + 0x010b
    sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x054e
    sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x011f
    sqeAgent6RunEDUEv + 0x0de3
    sqzEDUObj9EDUDriverEv + 0x0116
    clone + 0x006d
    

Local fix

  • Consider avoiding parallel backups or move to fix pack that
    includes fix.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25956

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-08-13

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018