dsmadmc -id=admin -password=admin q vol stgpool=3583_ARCPOOL

This is a good example of tsm querry which runs on unix and give output on screen or a file if you redirect it.

Thanks

V M A

-----Original Message-----
From: Newbie-Slingshot [mailto:oracledba-ezmlmshield-x46075264.[Email address protected]
Sent: Wednesday, September 06, 2006 11:37 AM
To: LazyDBA Discussion
Subject: TSM scripts ...

Hi all,

Does anyone have an example TSM script that I can use to query the TSM
database for backup pieces or something like that? Just need something
to start with.

For example, to query the backup pieces of a TSM node, I do

root:/>dsmadmc
enter username and password

tsm>select ll_name from backups where node_name = 'ORACLE_PRD'

Press <ENTER> or C to <CANCEL>


What am wanting to do is to get all these commands into a UNIX script
and re-direct the output to a file? If anyone have an example to do
this, preferably one that produces a formatted output, please email to
me. Note that file attachments are not allowed so please cut-and-paste
to email.

Thanks in advance.




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DISCLAIMER:
This message,including any attachments contains confidential and privileged information for the sole use of the intended recipient(s), and is protected by law. If you are not the intended recipient, please destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.
Bajaj Auto reserves the right to record, monitor, and inspect all email communications through its internal and external networks. Your messages shall be subject to such lawful supervision as Bajaj Auto deems necessary in order to protect its information, interests and reputation. Bajaj Auto prohibits and takes steps to prevent its information systems from being used to view, store or forward offensive or discriminatory material. If this message contains such material, please report it to [Email address protected]

Oracle LazyDBA home page