Is there a specific reason why you need an SQL command? If you just want
to know who has any archived data, QUERY OCCUPANCY will show it to you.
Add the TYPE=ARCHIVE option to limit the output strictly to archive
occupancy info. Use HELP QUERY OCCUPANCY for further info on this command.

There is no function per se to disable the ARCHIVE function, but you can
effectively achieve that by deleting any archive copy groups that might
exist (see the QUERY COPYGROUP and DELETE COPYGROUP commands).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-08
10:02:44:

> We are currently not using the archive feature of TSM.
> I would like to know if I can run a SQL command that will tell me if
> anyone has archived files/directories.  In addition, how can I disable
the
> archive feature from running?
>
> Thanks in advance.