P.S. Take a look at your domain's archive retention (grace period) setting and the corresponding HELP DEFINE DOMAIN information regarding the ARCHRETENTION setting, which covers what happens if you delete an archive copy group to which files are already bound. You should also have a look at the chapter in the TSM Administrator's Guide about implementing policies for client data. There is a section "How Files and Directories Are Associated with a Management Class" that talks about (among other things) the ramifications of deleting copy groups or management classes to which existing versions are bound.
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:09:47: > 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.
