Querying Nodes, Events, Schedules and Sessions from the TSM Server

IBM TSM (Tivoli Storage Manager) is a well known backup and restore tool for enterprise and midsize companies. Once you are connected to TSM server using following command, you can query using 2 ways i.e. using select query and TSM predefined query commands.

dsmadmc -se=<tsm server>

Following are the commands that you need to query node, Event, Schedule and Sessions: –

  • q node – display information of one or more registered nodes
  • q event – display information of scheduled event’s status
  • q schedule – display information of one or more schedules
  • q session – display information of current session of TSM server.

Examples:-

Querying Nodes

Display the information on all registered client nodes :

tsm> q node

Display the information on the node named ALPHA:

tsm> q node ALPHA

Display complete information on the node named ALPHA :

tsm> q node ALPHA f=d

Querying Nodes

Display the information for 10 days, for all events, scheduled on the node named ALPHA:

tsm> q event * * begind=-10 endd=today node=ALPHA

Display the complete information for 10 days :

tsm> q event * * begind=-10 endd=today f=d node=ALPHA

Display the information, for all events, scheduled on the node named ALPHA, during specific days :

tsm> q event * * begind=01/15/2013 endd=01/20/2013 node=ALPHA

Querying Schedules

Display the information on all registered schedules :

tsm> q sched

Display the information about schedule INCR_2000 in domain STND_ALL:

tsm> q sched STND_ALL INCR_2000

Display the complete information about schedule INCR_20H :

tsm> q sched * INCR_2000 f=d

Display associated schedules, for the node named ALPHA:

tsm> q sched node=ALPHA

Display nodes associated with a schedule INCR_2000 :

tsm> q assoc * INCR_2000

Display nodes without associated schedule :

tsm> SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

Querying Sessions

Display the information on all current sessions :

tsm> q sess 

Display the information on sessions from a node named ALPHA:

tsm> SELECT client_name,session_id,start_time,CAST(bytes_sent/1024/1024 \
AS DEC(8,2)) AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,2)) \
AS "MB_Rcvd" FROM sessions WHERE client_name='ALPHA'

 

PS: Thanks for IBM & ShellHacks . For more info you can always refer IBM redbooks.

Advertisements

About bijolianabhi

Graduate from Engineering College Bikaner, India in 2010 and working as Open Source activist. I love programming and implementing interesting ideas. I have interest in Mozilla Firefox extension development. I am currently learning basics of python to develop some interesting applications.
This entry was posted in TSM (Tivoli Storage Manager), Tutorials and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s