IBM Support

IT03272: MISSING ASSOCIATIONS VIEW DURING SERVER STARTUP WHEN STATUS MONITORING IS ENABLED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During server startup, the initial status collection may
    encounter errors related to a missing ASSOCIATIONS view.
    
    The problem is timing related and may not occur on every server
    startup.
    
    L2/Customers diagnostics:
    
    The Tivoli Storage Manager activity log shows the following
    messages:
    
    ANR1959I Status monitor collecting current data at <time>
    ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1568) Thread<7>:
    Missing sqlState=56098, sqlCode=-727 from table. Returning rc =
    9994.
    ANR9999D Thread<7> issued message 9999 from:
    ANR9999D Thread<7>  000007FEEDAB0825 OutDiagToCons()+155
    ANR9999D Thread<7>  000007FEEDAAA75C outDiagfExt()+10c
    ANR9999D Thread<7>  000007FEED847930 ReportSQLDiagInfo()+2a0
    ANR9999D Thread<7>  000007FEED8468F1 DbiEvalSQLOutcomeX()+4f1
    ANR9999D Thread<7>  000007FEED822AA3 tbRegExecEx()+4c3
    ANR9999D Thread<7>  000007FEED4CB31C
    csGetLastResultForNode()+2ec
    ANR9999D Thread<7>  000007FEED2B4123 IsNodeAtRisk()+113
    ANR9999D Thread<7>  000007FEED28F881 admMonitorNodes()+a81
    ANR9999D Thread<7>  000007FEED66A9AA StatusMonitorThread()+67a
    ANR9999D Thread<7>  000007FEED1D707C startThread()+13c
    ANR9999D Thread<7>  000007FEF94C3FEF beginthreadex()+107
    ANR9999D Thread<7>  000007FEF94C4196 endthreadex()+192
    ANR9999D Thread<7>  000000007696652D BaseThreadInitThunk()+d
    ANR9999D Thread<7>  0000000076D4C521 RtlUserThreadStart()+21
    ANR0162W Supplemental database diagnostic information:
    -1:56098:-727 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0727N  An
    error occurred during implicit system action type "2".
    Information returned for the error includes SQLCODE "-204",
    SQLSTATE "42704" and message tokens "TSMDB1.ASSOCIATIONS".
    SQLSTATE=56098).
    ANR0993I Server initialization complete.
    **************************
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Sever 6.3.4.x and 7.1.0.x on all
    supported platforms.
    
    Initial Impact:
    Low
    
    Additional Keywords:
    association start startup failure error collection monitor TSM
    

Local fix

  • No action is required - the error can be safely ignored.
    Subsequent status collections will not encounter the error
    because the ASSOCIATIONS view will have been created before the
    next collection.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager Operation Center users.           *
    ****************************************************************
    * 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

    IT03272

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-21

  • Closed date

    2014-07-21

  • Last modified date

    2014-07-21

  • 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

    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: 63W

Reference #: IT03272

Modified date: 21 July 2014