"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/13/2007
10:23:42 AM:
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Lawrence Clark
> >  a q node would show those clients that have not accessed the system
> in
> > some time.
>
> Yes, but if only a subset of filespaces are stale, QUERY NODE won't
> differentiate them.
>
> A select statement is the best bet, and isn't that hard to set up as a
> macro.
>

Our problem around here is deleted filesystems.  We seem to churn
filesystems
a lot.  Those old filesystems hang around in TSM forever as long as the
node exists.

I use the following cmd that runs every morning in our morning report to
look for these.  It reports filespaces that haven't been backed up
in 7 days.

dsmadmc -se=<> -id=<> -password=<> -outfile=xxx$$ -tab -noc -quiet <<EOD
  select -
      node_name, -
      filespace_name, -
      filespace_id, -
      unicode_filespace, -
      cast((current_timestamp-backup_end)days   as decimal(5,0)) -
   from -
      filespaces -
   where -
      cast((current_timestamp-backup_end)days  as decimal(5,0)) \> 7 -
   order by node_name, -
          filespace_id
EOD


-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.