IBM Support

IC92691: TAKEOVER DOES NOT OCCUR AFTER CHANGING LOGPATH IN THE STANDBY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Takeover does not occur after changing logpath and mirror
    logpath.
    
    In HADR environment, if we follow the steps below
    1. change the logpath in the primary and standby
    2. deactivate db and stop instance on standby
    3. start instance and activate db on standby
    4. issue takeover command on standby, but get error message on
    the standby
    
    $ db2 takeover hadr on db tst2
    SQL0902C  A system error (reason code = "") occurred.
    Subsequent SQL statements cannot be processed.
    
    - db2diag.log message
    ----------------------------------------------------------------
    ---------------
    2013-04-30-13.41.34.555907+540 I191574A545        LEVEL: Severe
    PID     : 26773                TID  : 2199371376976PROC :
    db2sysc 0
    INSTANCE: *********             NODE : 000         DB   : *****
    EDUID   : 24                   EDUNAME: db2loggr (*******) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgarl,
    probe:2780
    MESSAGE : BADLSN: RelativeByte 309998473472, ByteOffset 2514,
    PageNumber 3,
              extNum 76, ReadCount 1, rc1 3 Loop(i) 0, BlkOffset 4
    lastDiskLso
              1271722668 HighPso 000000004C2C3010 LowPso
    000000004C2C2010
    ----------------------------------------------------------------
    ---------------
    

Local fix

  • Before activating standby, copy the log files in the old
    logpath to new logpath manually.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 9.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92691

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-30

  • Closed date

    2013-12-10

  • Last modified date

    2013-12-10

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC92691

Modified date: 10 December 2013