Troubleshooting
Problem
Trying to add a new spoke server to the Operations Center will fail with error: "ANRG0166E: The Operations Center cannot connect to the specified server"
Diagnosing The Problem
The activity log from the spoke server, related to the timeframe on which the operation to add the new spoke server has been executed, will show a specific error on a select ran for spoke server:
ANR1696E Server SPOKE attempted to process command ' SELECT' but encountered errors. (SESSION: 123456)
ANR1697I Command 'SELECT' processed by 1 server(s): 0 successful, 0 with warnings, and 1 with errors. (SESSION: 123456)
And into the spoke server's activity log, the following select is shown in error:
select * from status
ANR2939E The reference 'select * from status ' contains an unknown SQL table name.
ANS8001I Return code 28.
Instead, the QUERY STATUS executed on the spoke server will work fine:
ie.
tsm: SPOKE>q status
Storage Management Server for Linux/x86_64 - Version 7, Release 1, Level 7.0
Server Name: SPOKE
Server host name or IP address: spoke
Server TCP/IP port number: 1500
Crossdefine: Off
......
Resolving The Problem
Connect to TSMDB1 (the database of the spoke server) and set the database schema:
ie.
db2 connect to tsmdb1
db2 set schema tsminst1
Collect the output from DB2 select:
db2 "SELECT tabname FROM SYSCAT.TABLES order by tabname"
The output will show that the STATUS table is missing.
This table can be easily recreated by restarting the IBM Spectrum Protect server.
So halt the spoke server and restart it.
[{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Operations Center","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22014000