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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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@VM.MARIST.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.
