IBM Support

IC95149: MESSAGES ANR0162W WITH SQL1477N REPEAT AFTER DB2 HADR TAKEOVER HAS TAKEN PLACE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • After a DB2 HADR  takeover  has taken place, the following
    errors may appear on the standby Tivoli Storage Manager server
    after restart (and these message keep repeating):
    
     ANR0162W Supplemental database diagnostic information:
      -1:55019:-1477 ([IBM][CLI Driver][DB2/AIX64] SQL1477N
      For table "TSMDB1.EXTENDED_ATTRIBUTES" an object "185" in
      table space "2" cannot be accessed.  SQLSTATE=55019).
     ANR0157W Database operation FETCH for table
      Extended.Attributes failed with result code 9999 and  tracking
      ID: 111262698.
     ANR0158W Database operation FETCH for table
      Extended.Attributes failed with operation code 9999 and
      tracking id 111262698. The data for column 0 is: (string,
      len=6)0x534552564552.
     ANR0158W Database operation FETCH for table
      Extended.Attributes failed with operation code 9999 and
      tracking id 111262698. The data for column 1 is: (string,
      len=7)0x53565F524F4C45.
     ANR0106E admattrm.c(394): Unexpected error 9999 fetching
      row in table "Extended.Attributes".
    
    This may happen on different table.
    
    Tivoli Storage Manager Versions Affected:  All Version 6 server
    with HADR
    
    
    Customer/L2 Diagnostics:
    
    In db2diag.log the error bellow also repeat :
    
    2013-06-05-20.04.40.276325+120 E3351962A771       LEVEL: Warning
    PID     : 28836050             TID  : 3343        PROC : db2sysc
    0
    INSTANCE: tsmxx               NODE : 000         DB   : TSMDB1
    APPHDL  : 0-41                 APPID: *LOCAL.tsmxx.130605180446
    AUTHID  : TSMxx
    EDUID   : 3343                 EDUNAME: db2agent (TSMDB1) 0
    FUNCTION: DB2 UDB, data management, sqldSetupSQLCA, probe:3
    MESSAGE : ADM5570W  Access was attempted on an unavailable
    object with
    id "185"    in tablespace "2" for table
    "TSMDB1.EXTENDED_ATTRIBUTES".
    If the   object is a table it will have to be dropped.  If the
    object
    is a  partition it will have to be detached. If the object is a
              non-partitioned index the index will have to be
    dropped.
    
    Initial Impact: Low
    
    Additional Keywords:
    TSM HA cluster failover TbRepairTableForSchema "NOT  LOGGED
    INITIALLY"
    

Local fix

  • - Stop standby server and fall back to primary server
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of Tivoli Storage Manager server   *
    *                 using DB2 High Availability Disaster         *
    *                 Recover (HADR).                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: See Error Description.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available.  This     *
    *                 problem is currently projected to be fixed   *
    *                 in levels 6.3.5 and 7.1.1.  Note that this   *
    *                 is subject to change at the discretion of    *
    *                 IBM.                                         *
    ****************************************************************
    *
    

Problem conclusion

  • The problem was fixed.
    Affected Platforms: AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95149

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-23

  • Closed date

    2014-01-06

  • Last modified date

    2014-01-06

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

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

Modules/Macros

  • TBREPAIR RDBDB    DBDEFS
    

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63A

Reference #: IC95149

Modified date: 06 January 2014