Space on DB2 Packs ....

Raquel Rodriguez

Space on DB2 Packs ....
ok, there has to be a way for this (it 'sounds' so
simple). I want to write a Rexx to find out the space
usage (Total space, free space) on the DB2 packs we
have.

Rexx does not (can't believe it!) seem to have any
function/command that does it.

As for IEHLIST, it seems to only generates the 'free
space' on a particular pack. Without knowing the
'total' space (capacity) of the pack, in my opinion
'free space' looses a lot of its sheen since it is
actually the %free-space that helps in statistical
analysis.

Obviously shops *are* doing it in some way easier than
looking at the ISPF 3.4 VTOC info. one by one for all
the packs.

We don't have File aid (even if it does have this
pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim McAlpine

Re: Space on DB2 Packs ....
(in response to Raquel Rodriguez)
Raquel,

You don't make it obvious as to whether you want this in batch or online,
but for an online display of this (and lots of other good system info) you
could download the freeware MXI product from -

http://www.rocketsoftware.com/portfolio/mxi/download.htm

Alternatively, there are lots of other good freeware programs on the CBT
tape at -

http://www.cbttape.org

I'm sure you could find some programs on there to do it in batch also.

Jim McAlpine



-----Original Message-----
From: Raquel Rodriguez [mailto:[login to unmask email]
Sent: 06 January 2005 09:51
To: [login to unmask email]
Subject: [DB2-L] Space on DB2 Packs ....


ok, there has to be a way for this (it 'sounds' so
simple). I want to write a Rexx to find out the space
usage (Total space, free space) on the DB2 packs we
have.

Rexx does not (can't believe it!) seem to have any
function/command that does it.

As for IEHLIST, it seems to only generates the 'free
space' on a particular pack. Without knowing the
'total' space (capacity) of the pack, in my opinion
'free space' looses a lot of its sheen since it is
actually the %free-space that helps in statistical
analysis.

Obviously shops *are* doing it in some way easier than
looking at the ISPF 3.4 VTOC info. one by one for all
the packs.

We don't have File aid (even if it does have this
pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst Cedar Software Ltd
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. Cedar Software Ltd grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.


For more information on Cedar Software and our products,
please visit our web site at http://www.cedar.com/Home.asp

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: Space on DB2 Packs ....
(in response to Jim McAlpine)
Our storage guy uses DCOLLECT to get this information. Maybe your storage
guys/gals could show you how to use this utility.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Jim McAlpine
Sent: Thursday, January 06, 2005 5:47 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Space on DB2 Packs ....

Raquel,

You don't make it obvious as to whether you want this in batch or online,
but for an online display of this (and lots of other good system info) you
could download the freeware MXI product from -

http://www.rocketsoftware.com/portfolio/mxi/download.htm

Alternatively, there are lots of other good freeware programs on the CBT
tape at -

http://www.cbttape.org

I'm sure you could find some programs on there to do it in batch also.

Jim McAlpine



-----Original Message-----
From: Raquel Rodriguez [mailto:[login to unmask email]
Sent: 06 January 2005 09:51
To: [login to unmask email]
Subject: [DB2-L] Space on DB2 Packs ....


ok, there has to be a way for this (it 'sounds' so
simple). I want to write a Rexx to find out the space
usage (Total space, free space) on the DB2 packs we
have.

Rexx does not (can't believe it!) seem to have any
function/command that does it.

As for IEHLIST, it seems to only generates the 'free
space' on a particular pack. Without knowing the
'total' space (capacity) of the pack, in my opinion
'free space' looses a lot of its sheen since it is
actually the %free-space that helps in statistical
analysis.

Obviously shops *are* doing it in some way easier than
looking at the ISPF 3.4 VTOC info. one by one for all
the packs.

We don't have File aid (even if it does have this
pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. Any unauthorised distribution or
copying is strictly prohibited. Whilst Cedar Software Ltd
takes steps to prevent the transmission of viruses via e-mail,
we cannot guarantee that any email or attachment is free from
computer viruses and you are strongly advised to undertake your
own anti-virus precautions. Cedar Software Ltd grants no
warranties regarding performance, use or quality of any e-mail
or attachment and undertakes no liability for loss or damage,
howsoever caused.


For more information on Cedar Software and our products,
please visit our web site at http://www.cedar.com/Home.asp

-----------------------------------------------------------------------------
----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Robert Lawrence

Re: Space on DB2 Packs ....
(in response to Tina Hilton)
Raquel,
you can do this in REXX but there is no function per se that will give the numbers to
you want. I do similar things now using REXX to call the CATALOG SEARCH INTERFACE[1] for
various pieces of information. You can also use ISPF services[2] to do your own dataset
list functions similar to option 3.4.

[1] z/OS DFSMS: Managing Catalogs Appendix B: Catalog Search Interface User's Guide
[2] z/OS V1R2.0 ISPF services guide chapter 2.26 (in bookmanager)

Hope that helps.

If you need further assistance feel free to request it. Meanwhile I will look to see what
I have


Bob Lawrence
DBA
Boscov's Dept Stores LLc
r l a w r e n c e at b o s c o v s dot c o m



> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Raquel Rodriguez
> Sent: Thursday, January 06, 2005 4:51 AM
> To: [login to unmask email]
> Subject: [DB2-L] Space on DB2 Packs ....
>
>
> ok, there has to be a way for this (it 'sounds' so
> simple). I want to write a Rexx to find out the space
> usage (Total space, free space) on the DB2 packs we
> have.
>
> Rexx does not (can't believe it!) seem to have any
> function/command that does it.
>
> As for IEHLIST, it seems to only generates the 'free
> space' on a particular pack. Without knowing the
> 'total' space (capacity) of the pack, in my opinion
> 'free space' looses a lot of its sheen since it is
> actually the %free-space that helps in statistical
> analysis.
>
> Obviously shops *are* doing it in some way easier than
> looking at the ISPF 3.4 VTOC info. one by one for all
> the packs.
>
> We don't have File aid (even if it does have this
> pack-analysis feature.).
>
> TIA
> Raquel.
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage less.
> http://info.mail.yahoo.com/mail_250
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Amit Sinha

Re: Space on DB2 Packs ....
(in response to Robert Lawrence)
I have written a small Rexx routine that does What you are trying to do.
It's a two step process
first it does ls list and then REXX routine browse thru the output to find
all volumes with % free.

If this interest you mail me directly and I will send it to you.

Thanks,

Amit

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Raquel Rodriguez
Sent: Thursday, January 06, 2005 3:51 AM
To: [login to unmask email]
Subject: [DB2-L] Space on DB2 Packs ....


ok, there has to be a way for this (it 'sounds' so
simple). I want to write a Rexx to find out the space
usage (Total space, free space) on the DB2 packs we
have.

Rexx does not (can't believe it!) seem to have any
function/command that does it.

As for IEHLIST, it seems to only generates the 'free
space' on a particular pack. Without knowing the
'total' space (capacity) of the pack, in my opinion
'free space' looses a lot of its sheen since it is
actually the %free-space that helps in statistical
analysis.

Obviously shops *are* doing it in some way easier than
looking at the ISPF 3.4 VTOC info. one by one for all
the packs.

We don't have File aid (even if it does have this
pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

"This e-mail may contain confidential and/or legally proprietary material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies."

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Wayne Mckay

Re: Space on DB2 Packs ....
(in response to Amit Sinha)
Raquel

Search the DB2 Archives on Dcollect. You can write Rexx's to go against
the Dcollect report files to produce just about any dasd usage report
you want.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Raquel Rodriguez
Sent: Thursday, January 06, 2005 2:51 AM
To: [login to unmask email]
Subject: [DB2-L] Space on DB2 Packs ....

ok, there has to be a way for this (it 'sounds' so
simple). I want to write a Rexx to find out the space
usage (Total space, free space) on the DB2 packs we
have.

Rexx does not (can't believe it!) seem to have any
function/command that does it.

As for IEHLIST, it seems to only generates the 'free
space' on a particular pack. Without knowing the
'total' space (capacity) of the pack, in my opinion
'free space' looses a lot of its sheen since it is
actually the %free-space that helps in statistical
analysis.

Obviously shops *are* doing it in some way easier than
looking at the ISPF 3.4 VTOC info. one by one for all
the packs.

We don't have File aid (even if it does have this
pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Robert Galambos

Re: Space on DB2 Packs ....
(in response to Wayne Mckay)



Amit.

If you would like, you can submit this to 'THE CODE PLACE' AREA within the
www.idug.org and then anyone can d/l without needing to request that you do
so individually.

This is where these type of helpful codes etc can be found that
other have felt the 'desire' to share (so to speak)


If you have any questions feel free in contacting me




Robert Galambos

Compuware Senior Technical Specialist
IBM Certified Solutions Expert -
DB2 UDB for OS/390 V7 Database Administration
[login to unmask email]


Tel: +1 905 803 8600
Toll Free: +1 800 348 8299
Fax: +1 905 803 8603
Quebec: +1 877-281-1888

Compuware Canada

Service is our best product
Les renseignements contenus dans le présent message électronique sont
confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s).
Il est strictement interdit de distribuer ou de copier ce message. Si vous
avez reçu ce message par erreur, veuillez répondre par courriel à
l'expéditeur et effacer ou détruire toutes les copies du présent message.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Sinha, Amit
Sent: January 6, 2005 11:03 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Space on DB2 Packs ....

I have written a small Rexx routine that does What you are trying to do.
It's a two step process
first it does ls list and then REXX routine browse thru the output to find
all volumes with % free.

If this interest you mail me directly and I will send it to you.

Thanks,

Amit

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Raquel Rodriguez
Sent: Thursday, January 06, 2005 3:51 AM
To: [login to unmask email]
Subject: [DB2-L] Space on DB2 Packs ....


ok, there has to be a way for this (it 'sounds' so simple). I want to write
a Rexx to find out the space usage (Total space, free space) on the DB2
packs we have.

Rexx does not (can't believe it!) seem to have any function/command that
does it.

As for IEHLIST, it seems to only generates the 'free space' on a particular
pack. Without knowing the 'total' space (capacity) of the pack, in my
opinion 'free space' looses a lot of its sheen since it is actually the
%free-space that helps in statistical analysis.

Obviously shops *are* doing it in some way easier than looking at the ISPF
3.4 VTOC info. one by one for all the packs.

We don't have File aid (even if it does have this pack-analysis feature.).

TIA
Raquel.



__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

"This e-mail may contain confidential and/or legally proprietary material
for the sole use of the intended recipient. Any review or distribution by
others is strictly prohibited. If you are not the intended recipient,
please contact the sender and delete all copies."

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm