Direct links to fixes
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