IBM Support

IT21981: RESTORE DATABASE COMMAND HAVING HISTORY FILE OPTION FAILED AND INSTANCE CRASHED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The restore database command could fail and it could cause the
    instance crash in the following condition.
    
    1. Backup command  was executed with TO option with multiple
    directories.
    
    2. Execute restore database command against the backup image
    taken above and the command has HISTORY option and FROM option
    with one directory.
    
    Example:
    
    * Executing backup command having TO option with three
    directories.
    
    $ db2 "BACKUP DATABASE DBNAME TO
    '/home/db2inst/backup','/home/db2inst/backup','/home/db2inst/bac
    kup' WITH 4 BUFFERS"
    
    Backup successful. The timestamp for this backup image is :
    20160731225703
    
    * Executing restore database command for the above backup
    command having FROM option with onde directory.
    
    $ db2 "restore db DBNAME history file from
    '/home/db2inst/backup' taken at 20160731225703"
    SQL1224N  The database manager is not able to accept new
    requests, has
    terminated all requests in progress, or has terminated the
    specified request
    because of an error or a forced interrupt.  SQLSTATE=00000
    
    At this error, the instance crashed with the following
    db2diag.log
    
    2016-07-31-22.57.53.582793-240 E37600A425         LEVEL: Severe
    PID     : 29032624             TID  : 1946        PROC : db2sysc
    INSTANCE: db2inst              NODE : 000         DB   : DBNAME
    APPHDL  : 0-35                 APPID:
    *LOCAL.db2inst.160801025753
    AUTHID  : DB2INST
    EDUID   : 1946                 EDUNAME: db2agent (DBNAME)
    FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:800
    MESSAGE : Restore Terminated.
    
    <snippet>
    
    2016-07-31-22.59.09.189955-240 I44738A560         LEVEL: Severe
    PID     : 29032624             TID  : 2002        PROC : db2sysc
    INSTANCE: db2inst              NODE : 000         DB   : DBNAME
    APPHDL  : 0-38                 APPID:
    *LOCAL.db2inst.160801025909
    AUTHID  : DB2INST
    EDUID   : 2002                 EDUNAME: db2agent (DBNAME)
    FUNCTION: DB2 UDB, RAS/PD component,
    pdResilienceIsSafeToSustain, probe:800
    DATA #1 : String, 37 bytes
    Trap Sustainability Criteria Checking
    DATA #2 : Hex integer, 8 bytes
    0x0000000501001800
    DATA #3 : Boolean, 1 bytes
    false
    
    Not that this problem happens for V9.7 FP9 and later.
    

Local fix

  • Execute restore database command with same directories used by
    backup database command as;
    
    db2 "restore db DBNAME history file from
    '/home/db2inst/backup','/home/db2inst/backup','/home/db2inst/bac
    kup' taken at 20160731225703"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21981

  • 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

    2017-08-11

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

    IT16391

  • 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":"BU048","label":"IBM Software"},"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:
19 March 2018