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 <Matthew_WARREN AT bnpparibas DOT com> 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
>           Ricardo.Ribeiro AT SCHWAB DOT COM
>
>                                                                               
>                                                       To
>                                                 ADSM-L
>           Sent by: ADSM-L AT VM.MARIST DOT EDU
> cc
>
>           04/01/2008
> 18:12
> Subject
>                                                 [ADSM-L] Select statement
>
>                 Please respond to
>                ADSM-L AT VM.MARIST DOT 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.
>