IBM Support

IT07897: ANS1017E/ANS8064E AND ANR0162W/SQL0433N/ANR0516E ERRORS WITH SEL ECT FROM NODES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager administrative client can report
    errors similar to the following when issuing the SELECT from
    NODES or SELECT from NODESVIEW commands:
    
      tsm: TSM1>select * from nodes
      ANS1017E Session rejected: TCP/IP connection failure.
      ANS8001I Return code -50.
      ANS8064E Communication timeout.  Reissue the command.
    
    The following errors can also be reported in the server
    activity log for the same operation:
    
      ANR0162W Supplemental database diagnostic information:
               -1:22001:-433 (■IBM■CLI Driver■DB2/AIX64 SQL0433N
               Value "<B>ABCDEFG</B><B>ABCDEFG2</B><B>ABCDEFG3</B>
               <B>ABCDEFG4</B><B>ABCDEFG" is too long.
               SQLSTATE=22001
      ANR9999D_3146658462 NewAdmSQLExecute(admsql.c:2635) Thread
               <118633995>: Unexpected rc 2332 from
               tbSQLExecuteFetch.~
      ANR9999D Thread<118633995> issued message 9999 from:~
      ANR9999D Thread<118633995> 0x0000000 StdPutText ~
      ANR9999D Thread<118633995> 0x0000000 OutDiagToCons ~
      ANR9999D Thread<118633995> 0x0000000 outDiagfExt ~
      ANR9999D Thread<118633995> 0x0000000 NewAdmSQLExecute ~
      ANR9999D Thread<118633995> 0x0000000 AdmSQLExecute ~
      ANR9999D Thread<118633995> 0x0000000 AdmCommandLocal ~
      ANR9999D Thread<118633995> 0x0000000 admCommand ~
      ANR9999D Thread<118633995> 0x0000000 SmAdminCommandThread ~
      ANR9999D Thread<118633995> 0x0000000 StartThread ~
      ANR0516E SQL processing for statement select * from
               NODESVIEW failed.~
      ANR0486W Session 118127286 for node ADMIN (WinNT) terminated
               - internal error detected.~
    
    This behavior occurs when the PROXY_AGENT column within the
    nodes/nodesview table/view contains a record with more than
    6144 characters.  While rare, this can happen if a significant
    number of nodes have been granted proxynode access to a
    particular node.
    
    Customer/L2 Diagnostics:
    None.
    
    Initial Impact:
    Medium
    
    Tivoli Storage Manager Versions Affected:
    All V7 Tivoli Storage Manager servers
    
    Additional Keywords:
    TSM SELECT NODES NODEVIEW NODESVIEW ANR0486W ANR0516E ANR0162W
    SQL0433N QUERY PROXY PROXY AGENT PROXYNODE REVOKE GRANT 88769
    

Local fix

  • Reduce the number of proxy node definitions for any given node
    by using the REVOKE PROXYNODE command to ensure that the
    PROXY_AGENT column does not exceed 6144 characters.  Use
    the QUERY NODE F=D command to identify nodes that have a
    significant number of proxynode agents defined to then.
    Alternatively, use the QUERY NODE command instead of SELECT
    from NODES to review node information.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This                      *
    * problem is currently projected to be fixed                   *
    * in level 7.1.3. Note that this is                            *
    * subject to change at the discretion of IBM.                  *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IT07897

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-03-24

  • Closed date

    2015-05-04

  • Last modified date

    2015-05-04

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"71A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
04 May 2015