ADSM-L

Re: Query Output Format in Version 5.3

2005-09-05 15:44:14
Subject: Re: Query Output Format in Version 5.3
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 5 Sep 2005 12:44:17 -0700
You can tailor a SELECT statement to get the output format you want. Here
is the basic syntax you can work with:

   select stgpool_name, \
          devclass, \
          est_capacity_mb, \
          pct_utilized, \
          pct_migr, \
          highmig, \
          lowmig, \
          nextstgpool \
      from stgpools

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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 AT VM.MARIST DOT EDU> wrote on 2005-09-05
02:23:51:

> Hi
>
> QUERY STGPOOL has a different output format in Version 5.3 (z/OS):
>
> Storage       Device        Estimated     Pct     Pct   High   Low
> Next
> Pool Name     Class Name     Capacity    Util    Migr    Mig   Mig
> Storage
>                                                          Pct   Pct
> Pool
> -----------   ----------   ----------   -----   -----   ----   ---
> -----------
> ARCHPD01      DISK                7 G     0,0     0,0     10     0
> ARCHPT02
> ARCHPT02      TAPE_POOL2        0,0 M     0,0     0,0     90    70
>
> BACKPD01      DISK               19 G     3,7     3,5     10     0
> BACKPT02
> BACKPT02      TAPE_POOL2      5'865 G     3,7     8,0     90    70
>
> COPYPT02      TAPE_COPY2      5'767 G     3,8
>
>
> Now it shows the "Estimated capacity" with number and unit. Before it
> had only a number and MB in the title.
>
>
> Is there any documentation about this change?
>
> Is it possible to get an output with a different field size and format?
>
> Thanks for any help
> Regards
> Werner Nussbaumer

<Prev in Thread] Current Thread [Next in Thread>