Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Sep 26
    2001

    Help with listc command for db2 VSAM Extent Report

    Amit Sinha
    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
    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
    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
    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
    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
    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




    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact