ADSM-L

Re: SQL command

2002-03-06 19:11:02
Subject: Re: SQL command
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Wed, 6 Mar 2002 16:08:32 -0800
This actually isn't a very easy question to answer, and I'm not sure how
useful this data would be.  Files from a single node can be bound to
multiple management classes, so you would have to check each file.  If you
really want to let your TSM database grind away for a while, you can try
this, but be warned, it'll take quite a while.  I've occasionally crashed
TSM servers with big queries, and that might happen with this one.

select class_name, node_name from backups group by class_name, node_name

I _THINK_ that'll work, but I didn't want to try it on my server.

Good luck.

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail



<Prev in Thread] Current Thread [Next in Thread>