Hi Joe, The paper that Andy wrote is a great resource, but it was written for ADSM 3.1, so the list of tables is out of date. Use the paper as a reference for "how to", but to see what tables are available for your own version do this:
select * from syscat.tables At my level (4.1.3) there is indeed at BACKUPSETS table. So then you can do this: select * from syscat.columns where TABNAME='BACKUPSETS' That gives you the same info that was in Andy's paper, but for your own server version . One day when I have some free time (oh yeah, like really...) I'm gonna work at creating an SQL script that will pull the stuff out in a "nice" format like Andy's. BTW, I think you will need a select that does a join with VOLHISTORY table somehow, to get the volume name you want matched with the NODE_NAME. Anyway, hope that helps. ************************************************************************ Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Joe Cascanette [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 2:14 PM To: [EMAIL PROTECTED] Subject: Backup Sets Is a select command that will allow me to search the nodes and find out what backup sets they have and what volume they reside on? I am playing around with doing a backup set for my key servers on a daily basis for disaster purposes. These tapes are send offsite daily. I need to be able to view what servers backup sets reside on which tape. I was just going to do a search in the activity log for them, but a select statement would be great to use. I looked through the ADSTAR paper that Andrew Raibeck wrote with the tables, but never came across anything of use.. any thoughts?? Another problem is when I load the client to access the backup set I am unable to drill down the trees. I am opening a call with Tivoli about this. Thanks Joe Cascanette The Cumis Group
