Select statements from another server

[waelti]

For reporting I use Tivoli Manager Console 5.5.7 (Windows) to generate a daily report for TSM (7.1.6, Linux)
We have one server, there are 3 server instances running. One for backup (SRV_BCK1), one for archive (SRV_ARC1) and one for the library (SRV_LIB). Is there a possibility to make a select statement from one server instance to another? In my case I want to make a "select count(*) as SV from libvolumes where status='Scratch'" to get this value from SRV_LIB, the server instance, who asks for it, is SRV_BCK1.
So I could create one reportfile. Normally I would generate 3 reports, one for SRV_BCK1, one for SRV_ARC1 and one for SRV_LIB. Ony one report is much more clearer than 3 separate.

Kind regards
Walter Reis

 

[moon-buddy]

You cannot query through select statements another TSM from within another TSM server directly.

Since you are running 3 TSM server instances on one physical server, why don't you use dsmadmc.exe to query all three from the OS side and combine the queries into one output? This is what I do.

 

[fidel]

For reporting I use Tivoli Manager Console 5.5.7 (Windows) to generate a daily report for TSM (7.1.6, Linux)
We have one server, there are 3 server instances running. One for backup (SRV_BCK1), one for archive (SRV_ARC1) and one for the library (SRV_LIB). Is there a possibility to make a select statement from one server instance to another? In my case I want to make a "select count(*) as SV from libvolumes where status='Scratch'" to get this value from SRV_LIB, the server instance, who asks for it, is SRV_BCK1.
So I could create one reportfile. Normally I would generate 3 reports, one for SRV_BCK1, one for SRV_ARC1 and one for SRV_LIB. Ony one report is much more clearer than 3 separate.

Kind regards
Walter Reis

Hello,

for Linux TSM servers, on one "central" server:
- add all servers in dsm.sys
"SERVERNAME server_a
commmethod tcpip
TCPPort 1500
tcpwindowsize 0
tcpnodelay yes
tcpserveraddress server_a
passwordaccess generate

SERVERNAME server_b
commmethod tcpip
TCPPort 1500
tcpwindowsize 0
tcpnodelay yes
tcpserveraddress server_b
passwordaccess generate

...

- use dsmadmc -server=xxx -id=yyy -password=zzz "select ..."