Help with listc command for db2 VSAM Extent Report

Amit Sinha

Help with listc command for db2 VSAM Extent Report
Hi,

Can I pass vcatname and condition of > integer value to the command listc
so that it retrieves only those dataset with the vcatname and extent greater
than the value passed in IKJEFT01 environment. If yes can you send me the
command :-)

What I am trying to do is make an extent report for a particular vcatname &
only for those vsam datasets which is in extent greater than the specified
value.


Thanks for all your help.

Amit



III Edward(Ed) J. Finnell

Re: Help with listc command for db2 VSAM Extent Report
(in response to Amit Sinha)
What I taught our DBAs to do is use ISPF 3.4 with hlq.DSNDBD.dbname
with space attribute(2) then on command line sort XT (for extents). Usually
just the first screen is enough to keep them busy for awhile.
Edward(Ed) J. Finnell, III
Enterprise Systems/Proj. Mgr.
url:www.ua.edu



Peter [IBM GSA] Robinson

Re: Help with listc command for db2 VSAM Extent Report
(in response to III Edward(Ed) J. Finnell)
One way is to write a rexx that calls listcat and processes the output to
give you a list of datasets that have multiple extents or whatever you want.
Run it in batch under control-m at some regular interval.

Contact me if you want a copy of some rexx I wrote a while back that does
some reporting from listcat - you could then change it for whatever you
want.

PJR

Peter Robinson
Senior Performance DBA
Performance & Tuning
IBM-GSA Enterprise Services
Brisbane, Australia

* BG07, PO Box 435, Brisbane 4001
> ' (07) 3887-8129 or 0418-400-959
> 7 (07) 3221-1798
> * [login to unmask email]
[login to unmask email]



James Campbell

Re: Help with listc command for db2 VSAM Extent Report
(in response to Peter [IBM GSA] Robinson)
Rather than using LISTCAT, might I suggest calling IGGCSI00? (Documented
in an appendix in DFSMS Managing Catalogs.) While it takes a little
getting used to, it does provide a "defined" format for data - rather than
decoding LISTCAT output, which is not "defined". (Although I suspect the
outcry if it was ever changed means that it is effectively fixed.)

James Campbell



On Thu, 27 Sep 2001 15:39:11 +1000, Robinson, Peter [IBM GSA]
<[login to unmask email]> wrote:

>One way is to write a rexx that calls listcat and processes the output to
>give you a list of datasets that have multiple extents or whatever you
want.
>Run it in batch under control-m at some regular interval.
>
>Contact me if you want a copy of some rexx I wrote a while back that does
>some reporting from listcat - you could then change it for whatever you
>want.
>
>PJR
>
>Peter Robinson
>Senior Performance DBA
>Performance & Tuning
>IBM-GSA Enterprise Services
>Brisbane, Australia
>
>* BG07, PO Box 435, Brisbane 4001
>> ' (07) 3887-8129 or 0418-400-959
>> 7 (07) 3221-1798
>> * [login to unmask email]
> [login to unmask email]
>



Carol A - CNF Powers

Re: Help with listc command for db2 VSAM Extent Report
(in response to James Campbell)
The listc command doesn't have the capability you want. There are several
ways to do this, though. DCOLLECT is an IDCAMS command that writes
information about datasets to a flat file. One of the pieces of info it
writes is the number of extents. If you talk with your dasd folks you may
find that they run this already, so you may be able to just use the output
they have. Use your favorite reporting tool (we use MXG) to process the
output. Record layouts for DCOLLECT output are in an appendix the IDCAMS
manual. You could also use ISMF (comes standard with the operating system
and DFSMS) if you want an online tool. In the dataset application you can
limit your display by a number of things, and extents is one of them (it's
on the second panel). Of course you can always write the listcat output to
a dataset and process it with your favorite programming language.

> -----Original Message-----
> From: Sinha, Amit [SMTP:[login to unmask email]
> Sent: Wednesday, September 26, 2001 7:41 PM
> To: [login to unmask email]
> Subject: Help with listc command for db2 VSAM Extent Report
>
> Hi,
>
> Can I pass vcatname and condition of > integer value to the command listc
> so that it retrieves only those dataset with the vcatname and extent
> greater
> than the value passed in IKJEFT01 environment. If yes can you send me the
> command :-)
>
> What I am trying to do is make an extent report for a particular vcatname
> &
> only for those vsam datasets which is in extent greater than the specified
> value.
>
>
> Thanks for all your help.
>
> Amit
>
>
>
>
>



Amit Sinha

Re: Help with listc command for db2 VSAM Extent Report
(in response to Carol A - CNF Powers)
Thanks James, Powers , Peter, Edward for all your help.

Edward you are right the ispf 3.4 sort xt is good way :-) that's what we do
now but automating will be so much good.
We do have Mics for extent reporting but there is some problem with it it's
report is not current due to the batch process..........

Peter I was just waiting that somebody else will ask for your rexx and may
be you could shared with the list, doesn't it seems so.

Hey it's so much important for me can you send it to me not good at REXX
will try.

Thanks.

Amit