APAR status
Closed as program error.
Error description
The Tivoli Storage Manager Server fails to start after successful upgrade to V7.1. Customer/L2 Diagnostics: The following messages are displayed during server startup: ANR0162W Supplemental database diagnostic information: -1:42601:-104 (■IBM■CLI Driver■DB2/NT64 SQL0104N An unexpected token "(" was found following ""."NODES" SET WHERE". Expected tokens may include: "@". SQLSTATE=42601). ANR0157W Database operation UPDATE for table Nodes failed with result code 2343 and tracking ID: 00000000024B2490. ANR0158W Database operation UPDATE for table Nodes failed with operation code 2343 and tracking id 00000000024B2490. The data for column 0 is: (string, len=10)0x4644495246494C524547. ANR0103E admnode.c(25990): Error 2343 updating row in table "Nodes". ANR9999D_1490373789 AdmConvertNodeAttrs(admnode.c:25815) Thread<0>: Error 2343 converting the attributes for node NODENAME ANR9999D Thread<0> issued message 9999 from: ANR9999D Thread<0> 000007FEE6AA0825 OutDiagToCons()+155 ANR9999D Thread<0> 000007FEE6A9A75C outDiagfExt()+10c ANR9999D Thread<0> 000007FEE62A1BCB AdmConvertNodeAttrs()+1ab ANR9999D Thread<0> 000007FEE6239E56 admInitPart2()+42c6 ANR9999D Thread<0> 000007FEE62356C4 admInit()+54 ANR9999D Thread<0> 000007FEE61E043E StartServer()+3be ANR9999D Thread<0> 000007FEE61DBC5F admStartServer()+ff ANR9999D Thread<0> 000007FEE61C23FF adsmMain()+134f ANR9999D Thread<0> 000000013FB7110D main()+8d dsmserv.c:241 ANR9999D Thread<0> 000000013FB7271B __tmainCRTStartup()+10f crtexe.c:536 ANR9999D Thread<0> 00000000773C652D BaseThreadInitThunk()+d ANR9999D Thread<0> 00000000777AC541 RtlUserThreadStart()+21 ANR9999D_3211700223 AdmConvertNodeAttrs(admnode.c:25826) Thread<0>: Node Attributes conversion failed with error 2343. ANR9999D Thread<0> issued message 9999 from: ANR9999D Thread<0> 000007FEE6AA0825 OutDiagToCons()+155 ANR9999D Thread<0> 000007FEE6A9A75C outDiagfExt()+10c ANR9999D Thread<0> 000007FEE62A1C4F AdmConvertNodeAttrs()+22f ANR9999D Thread<0> 000007FEE6239E56 admInitPart2()+42c6 ANR9999D Thread<0> 000007FEE62356C4 admInit()+54 ANR9999D Thread<0> 000007FEE61E043E StartServer()+3be ANR9999D Thread<0> 000007FEE61DBC5F admStartServer()+ff ANR9999D Thread<0> 000007FEE61C23FF adsmMain()+134f ANR9999D Thread<0> 000000013FB7110D main()+8d dsmserv.c:241 ANR9999D Thread<0> 000000013FB7271B __tmainCRTStartup()+10f crtexe.c:536 ANR9999D Thread<0> 00000000773C652D BaseThreadInitThunk()+d ANR9999D Thread<0> 00000000777AC541 RtlUserThreadStart()+21 ANR0369I Stopping the database manager because of a server shutdown. ANR0991I Server shutdown complete. The error is caused by one or more nodes not accessing the server since before V5.5. Initial Impact: High Tivoli Storage Manager Versions Affected: 7.1/Windows, Linux Additional Keywords: TSM ANR0103E ANR0162W ANR0157W
Local fix
The following SQL statement can be used to find a list of node names that have this problem: db2 => connect to tsmdb1 db2 => set schema tsmdb1 db2 => select nodename from nodes left join extended_attributes on nodes.nodename = extended_attributes.owner where extended_attributes.owner is NULL For each of these nodes an entry needs to be created in the extended attributes table: db2 => insert into extended_attributes (OWNER,NAME,TYPE,INT32) values ('NODENAME','NODE_PASSEXP',3,99) Where NODENAME is replaced by a node name from the above select statement. This will set a password expiration of 99 days for that node. The UPDATE NODE command can be used to reset the password expiration once the server is started successfully.
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.1. 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
IC99083
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-01-30
Closed date
2014-03-31
Last modified date
2014-03-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
dsmserv
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":"71W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 March 2014