IBM Support

IT06656: WHEN ADD STORAGE TO PRIMARY DATABSE FAILS WITH SQL1051N, LOG ENTRIES OF ALTER AND UNALTER CAUSE STANDBY TO SHUTDOWN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Commands done on PRIMARY:
    db2 alter database add storage on '/home/new_storage_path/'
    
    When the path is invalid, it failed with error SQL1051N.
    
    In this case, this Alter is propagated to STANDBY and Standby
    fails with the following error messages :
    
    015-01-02-23.53.54.155437+330 I6811062E575        LEVEL: Error
    PID     : 4731                 TID  : 46912753363264PROC :
    db2sysc 0
    INSTANCE: db2gras1             NODE : 000          DB   : STAND1
    APPHDL  : 0-13215              APPID: *LOCAL.DB2.160824070945
    EDUID   : 60                   EDUNAME: db2redom (STAND1) 0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbInitStorageGroupFiles, probe:1994
    MESSAGE :
    ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
              "Storage path does not exist or is inaccessible."
    DATA #1 : String, 26 bytes
    /new_storage_path/
    
    2015-01-02-23.53.54.155843+330 I6811638E688        LEVEL: Severe
    PID     : 4731                 TID  : 46912753363264PROC :
    db2sysc 0
    INSTANCE: db2gras1             NODE : 000          DB   : STAND1
    APPHDL  : 0-13215              APPID: *LOCAL.DB2.160824070945
    EDUID   : 60                   EDUNAME: db2redom (STAND1) 0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbInitStorageGroupFiles, probe:1994
    MESSAGE :
    ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
              "Storage path does not exist or is inaccessible."
    DATA #1 : String, 46 bytes
    Error during storage group file initialization
    DATA #2 : Pointer, 8 bytes
    0x000000020074acd9
    DATA #3 : Pointer, 8 bytes
    0x0000000200e00080
    
    
    2015-01-02-23.54.03.938567+330 I6820272E509        LEVEL: Severe
    PID     : 4731                 TID  : 46927605393728PROC :
    db2sysc 0
    INSTANCE: db2gras1             NODE : 000          DB   : STAND1
    APPHDL  : 0-13215              APPID: *LOCAL.DB2.160824070945
    EDUID   : 181                  EDUNAME: db2agent (STAND1) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpReplayMaster,
    probe:2500
    RETCODE :
    ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
              "Storage path does not exist or is inaccessible."
    
    2015-01-02-23.54.03.990863+330 E6820782E950        LEVEL:
    Critical
    PID     : 4731                 TID  : 46927605393728PROC :
    db2sysc 0
    INSTANCE: db2gras1             NODE : 000          DB   : STAND1
    APPHDL  : 0-13215              APPID: *LOCAL.DB2.160824070945
    EDUID   : 181                  EDUNAME: db2agent (STAND1) 0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeLocalDatabase::MarkDBBad, probe:10
    MESSAGE : ADM14001C  An unexpected and critical error has
    occurred:
              "DBMarkedBad". 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
    
    "/datagras/db2gras1/sqllib/db2dump/FODC_DBMarkedBad_2015-01-02-2
    3.54.
              03.939110_0000/". Please look in this directory for
    detailed evidence
              about what happened and contact IBM support if
    necessary to diagnose
              the problem.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Customer using HADR in DB2 V9.7                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7fp11                                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT06656

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-22

  • Closed date

    2015-10-13

  • Last modified date

    2015-10-13

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

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT06656

Modified date: 13 October 2015