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
|