Q DRM * gives you the list of tapes in the COPY pool that aren't marked OFFSITE. (By default it also includes the DBBACKUPS, unless you specify something else on the Q DRM)
Depending on when you run the Q DRM, it MAY be the same as the tapes created that day. It will USUALLY be the tapes created since the last time you did vaulting. On 1/15/08, Matthew Warren <[EMAIL PROTECTED]> wrote: > > Would this be the count of tapes made mountable that day?, q drm * > wherestate=mountable? - I don;'t have access to a TSM server to test a > select for the same info. That would assume you are moving mountable tapes > to state 'vault' each day. > > > Matt. > > > > Internet > [EMAIL PROTECTED] > > > To > ADSM-L > Sent by: ADSM-L@VM.MARIST.EDU > cc > > 04/01/2008 > 18:12 > Subject > [ADSM-L] Select statement > > Please respond to > ADSM-L@VM.MARIST.EDU > > > > > > > > > Hello, > Does anyone has a select statement I can use to find out how many tapes > I used on a daily basis? > Thanks! > > > > > > This message and any attachments (the "message") is > intended solely for the addressees and is confidential. > If you receive this message in error, please delete it and > immediately notify the sender. Any use not in accord with > its purpose, any dissemination or disclosure, either whole > or partial, is prohibited except formal approval. The internet > can not guarantee the integrity of this message. > BNP PARIBAS (and its subsidiaries) shall (will) not > therefore be liable for the message if modified. > Do not print this message unless it is necessary, > consider the environment. > > --------------------------------------------- > > Ce message et toutes les pieces jointes (ci-apres le > "message") sont etablis a l'intention exclusive de ses > destinataires et sont confidentiels. Si vous recevez ce > message par erreur, merci de le detruire et d'en avertir > immediatement l'expediteur. Toute utilisation de ce > message non conforme a sa destination, toute diffusion > ou toute publication, totale ou partielle, est interdite, sauf > autorisation expresse. L'internet ne permettant pas > d'assurer l'integrite de ce message, BNP PARIBAS (et ses > filiales) decline(nt) toute responsabilite au titre de ce > message, dans l'hypothese ou il aurait ete modifie. > N'imprimez ce message que si necessaire, > pensez a l'environnement. >
