How to list the datasets in a particular region?

himanshu7 · Posted: Thu Mar 12, 2009 10:28 am

Can somebody assist in developing a tool or JCL to list out all the datasets present in one particular mainframe region?

dick scherrer · Posted: Thu Mar 12, 2009 10:39 am

Hello,

What does "one particular mainframe region" mean to you?

One way to list datasets is using LISTCAT. There are multiple examples in the forum.

himanshu7 · Posted: Thu Mar 12, 2009 10:59 am

Hi,

My requirement is to list the DSN's of the particular region.For example we have divided LPAR's as development region and Production region, now we just want to list all the DSN's used in any of the region i.e Dev or Prod.

I believe LISTCAT will list out all the details for the particular dataset name provided and which is not what i asked for.

Thank you Dick for the reply..

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Hi Himanshu Sharma,
Do you have only one id for that region because if you have multiple ids(users) then i hope you cannot list all the datasets on a single shot.

himanshu7 · Posted: Thu Mar 12, 2009 11:29 am

Hi Anand,

Yes we do have multiple user's(Ids).

I think there is the way to list out all the DSN by their HLQ's for the region.

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

If you find that please let me know by the way what is HLQ's (send PM)

himanshu7 · Posted: Thu Mar 12, 2009 11:59 am

Hi,

HLQ's ----> High level qualifier..

expat · Posted: Thu Mar 12, 2009 12:23 pm

SYS1.SAMPLIB(IGGCSIRX) will do the trick.

Anuj D posted a good example of using it in the forum a while ago.

What about shared HLQ's between the two LPARs ?

himanshu7 · Posted: Thu Mar 12, 2009 1:30 pm

Hi

Where can i find this? SYS1.SAMPLIB(IGGCSIRX)

expat · Posted: Thu Mar 12, 2009 2:31 pm

Errmmmmmmmmmm it's a PDS

Anuj Dhawan · Posted: Thu Mar 12, 2009 3:16 pm

expat · Posted: Thu Mar 12, 2009 3:52 pm

Assuming that the member is in the PDS shipped by IBM, and that you have READ access this should do it

himanshu7 · Posted: Thu Mar 12, 2009 5:06 pm

Hi,

We donot have access to SYS1.SAMMPLIB,Need to find out another way to resolve.

Anuj,
The requirement is to list out all the files in the region and then delete the files which are not as per the clients standards.

expat · Posted: Thu Mar 12, 2009 5:21 pm

Ask a sysprog to copy the member for you, or someone who has access to the files.

If you have a legitimate reason for using the file, then ask for it.

Anuj Dhawan · Posted: Thu Mar 12, 2009 5:21 pm

Robert Sample · Posted: Thu Mar 12, 2009 5:28 pm

You keep using the term "region" -- terminology can be critical so it is important to be accurate. It sounds like you're referring to an LPAR -- but you could be talking about a catalog as well. Usually on a mainframe the term "region" refers to a CICS address space, not an LPAR.

If you don't have access to SYS1.SAMPLIB, can you contact your systems support group and get access? Most of the tools to generate lists of data sets require some sort of system-level access which it sounds like you may not have; your task is much more difficult in this case.

I also have a concern about your statement

himanshu7 · Posted: Fri Mar 13, 2009 12:45 pm

Requirement is to clean up the non-standard files from test and that means the dataset could be on different LPAR's.

Well i have created REXX tool which is extracting the files with their HLQ's in the output dataset.

But the problem is time consumption.

expat · Posted: Fri Mar 13, 2009 1:00 pm

The code for CSI is as follows. It should be much faster than your own code, and uses all of the standard wildcard combinations.

JCL

himanshu7 · Posted: Fri Mar 13, 2009 1:26 pm

Thank you Expat..