best method to completely list all cataloged data sets

Depends (maybe) on what you mean by "really all".
Some years ago I was playing with the CSI and it found *all* the
catalogs and datasets within them.
- including an MCAT for another system that was connected as a UCAT
- and including an MCAT for another system that was *NOT* connected as a
UCAT.

That last one surprised me more than a little. Possibly the MCAT had
been connected at some time, and was still cached. I had to adapt the
code to only look for what I wanted.
This was assembler (merely for speed), but I suspect the REXX interface
will also chase down everything.

Shane ...

On Wed, 1 Dec 2010 08:02:09 +0100

Post by Dr. Stephen Fedtke
hi all,
what is the best method to achieve a complete list of all currently
cataloged data sets? really "all". actually, like using "**" in the
3.4 data set criterion.
is there actually the need to determine all catalogs/aliases, and
perform (recursiveley) list on them, ...

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Elardus Engelbrecht

2010-12-01 09:34:14 UTC

Post by Dr. Stephen Fedtke
what is the best method to achieve a complete list of all currently

cataloged data sets? really "all". actually, like using "**" in the 3.4 data set
criterion.

Use Catalog Search Interface with Assembler or REXX.

It is faster than =3.4 or IDCAMS LISTC and perhaps ISMF too.

HTH!

Groete / Greetings
Elardus Engelbrecht

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Schwarz, Barry A

2010-12-01 19:32:04 UTC

An IDCAMS batch job (not TSO) with the command
LISTCAT USERCATALOG
will give you the name of all the catalogs connected to your master catalog.

You can then issue multiple commands (also in batch)
LISTCAT ALL CATALOG(dsn)
to list all the datasets, aliases, etc that are in each. (The ALL determines how much data is listed for each entry, not which entries are listed. If all you want is the name, you can omit it.)

You should not need to do anything special with aliases.

If you have catalogs not connected to the master catalog, you will have to find them some other way. I don't think you can list one until it is connected.

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@bama.ua.edu] On Behalf Of Dr. Stephen Fedtke
Sent: Tuesday, November 30, 2010 11:02 PM
To: IBM-***@bama.ua.edu
Subject: best method to completely list all cataloged data sets

hi all,

what is the best method to achieve a complete list of all currently
cataloged data sets? really "all". actually, like using "**" in the 3.4
data set criterion.

is there actually the need to determine all catalogs/aliases, and perform
(recursiveley) list on them, ...

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Tom Marchant

2010-12-01 19:50:42 UTC

Post by Schwarz, Barry A
If you have catalogs not connected to the master catalog, you
will have to find them some other way. I don't think you can list
one until it is connected.

Right. Because a catalog that is not connected is not cataloged.
Of course, if some of the user catalogs are actually the master
catalogs for other systems, there could be usercatalogs connected
to them that are not connected to the master catalog on the
system where you are running. To find out you could
LISTCAT USERCATALOG CATALOG(dsn)

for all of the usercatalogs that you found.

--
Tom Marchant

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Mark Zelden

2010-12-01 21:36:30 UTC

On Wed, 1 Dec 2010 03:33:24 -0600, Elardus Engelbrecht

Post by Dr. Stephen Fedtke

Post by Dr. Stephen Fedtke
what is the best method to achieve a complete list of all currently

cataloged data sets? really "all". actually, like using "**" in the 3.4

data set

Post by Dr. Stephen Fedtke
criterion.
Use Catalog Search Interface with Assembler or REXX.
It is faster than =3.4 or IDCAMS LISTC and perhaps ISMF too.

3.4 doesn't allow * or **.

No options with IDCAMS to list everything from all catalogs.

The CSI is a good option, but since if you tell it to list all catalogs you
could
end up with a bunch of "dead" catalog entries. For example, a user catalog
that was previously a master from another system, or an alias for an HLQ
points to the "correct catalog" but maybe pointed to a different catalog at
one time and the entries weren't deleted or merged out. No one would
ever know about those entries to clean them up unless they looked for them.
(you can do this with CATSRCH from my web site: TSO %CATSRCH **

If you did it with CSI and wrote intelligent code around it, then it would
be more accurate. For example, list the master catalog and the aliases,
then only list the HLQs in the catalogs that the aliases in the master catalog
pointed to.

Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
mailto:***@flash.net
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
Systems Programming expert at http://expertanswercenter.techtarget.com/

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Don Imbriale

2010-12-01 23:42:50 UTC

I've used * and ** in 3.4 for the dsname level.

From User's Guide II:

1. If you enter a high-level qualifier of ’*’ or ’**’, ISPF displays a
pop-up window
to warn you that the search will be for all catalogs on the system and will
take
time. If there are many catalogs, this search could take a considerable
amount
of time. You can press Enter to continue the search, or you can enter Cancel
or
End from the pop-up window to cancel the search. Be aware that if you have
mount authority, a catalog search with ’*’ or ’**’ as the high-level
qualifier can
require that volumes be mounted for the catalogs to be searched.
2. The ISPF Configuration table contains a selectable option, named
DISALLOW_WILDCARDS_IN_HLQ, to disallow the use of the ’*’ or ’%’ in the
high-level qualifier

- Don Imbriale

Post by Mark Zelden
3.4 doesn't allow * or **.
No options with IDCAMS to list everything from all catalogs.
The CSI is a good option, but since if you tell it to list all catalogs you
could
end up with a bunch of "dead" catalog entries. For example, a user catalog
that was previously a master from another system, or an alias for an HLQ
points to the "correct catalog" but maybe pointed to a different catalog at
one time and the entries weren't deleted or merged out. No one would
ever know about those entries to clean them up unless they looked for them.
(you can do this with CATSRCH from my web site: TSO %CATSRCH **
If you did it with CSI and wrote intelligent code around it, then it would
be more accurate. For example, list the master catalog and the aliases,
then only list the HLQs in the catalogs that the aliases in the master catalog
pointed to.
Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>
Systems Programming expert at http://expertanswercenter.techtarget.com/

Schwarz, Barry A

2010-12-01 23:52:39 UTC

Only in conjunction with another DSN qualifier that is not just a ** or *.

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@bama.ua.edu] On Behalf Of Don Imbriale
Sent: Wednesday, December 01, 2010 3:42 PM
To: IBM-***@bama.ua.edu
Subject: Re: best method to completely list all cataloged data sets

I've used * and ** in 3.4 for the dsname level.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

shmuel+ (Shmuel Metz , Seymour J.)

2010-12-02 17:48:35 UTC

In <AANLkTimYXmjyixoNNAsvVG13cbGsCrM368+mXpSm+***@mail.gmail.com>, on
12/01/2010

Be aware that if you have mount authority, a catalog search with
* or ** as the high-level qualifier can require that volumes be
mounted for the catalogs to be searched.

It's been a while since they updated that ;-)
--
Shmuel (Seymour J.) Metz, SysProg and JOAT
ISO position; see <http://patriot.net/~shmuel/resume/brief.html>
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Chase, John

2010-12-02 12:44:35 UTC

Post by Schwarz, Barry A
-----Original Message-----
From: IBM Mainframe Discussion List On Behalf Of Mark Zelden
On Wed, 1 Dec 2010 03:33:24 -0600, Elardus Engelbrecht

[ snip ]
Use Catalog Search Interface with Assembler or REXX.
It is faster than =3.4 or IDCAMS LISTC and perhaps ISMF too.

3.4 doesn't allow * or **.

Hmmm.... When did that change?

Haven't had occasion to try it "recently", but it used to work at z/OS
1.7 (and, I think, 1.9). Now, on z/OS 1.11 it gives "Invalid Dsname
Level" (single or double asterisk).

-jc-

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

R.S.

2010-12-02 14:05:03 UTC

"In order to list catalog entries, you must specify at least one partial
qualifier. Any Dsname Level that contains only asterisks is invalid."

The behavior haven't changed at least since 1998.

BTW: there are workarounds (or cheats) - like in every computer game ;-)))
Masks like: *% or %*.** do work.
--
Radoslaw Skorupka
Lodz, Poland

Post by Chase, John

Post by Schwarz, Barry A
-----Original Message-----
From: IBM Mainframe Discussion List On Behalf Of Mark Zelden
On Wed, 1 Dec 2010 03:33:24 -0600, Elardus Engelbrecht

[ snip ]
Use Catalog Search Interface with Assembler or REXX.
It is faster than =3.4 or IDCAMS LISTC and perhaps ISMF too.

3.4 doesn't allow * or **.

--
BRE Bank SA
ul. Senatorska 18
00-950 Warszawa
www.brebank.pl

Sd Rejonowy dla m. st. Warszawy
XII Wydzia Gospodarczy Krajowego Rejestru Sdowego,
nr rejestru przedsibiorców KRS 0000025237
NIP: 526-021-50-88
Wedug stanu na dzie 16.07.2010 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.248.328 zotych.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

shmuel+ (Shmuel Metz , Seymour J.)

2010-12-02 17:44:40 UTC

In
<***@ch2wpmail1.na.ds.ussco.com>,
on 12/02/2010

Post by Chase, John
Haven't had occasion to try it "recently", but it used to work at
z/OS 1.7 (and, I think, 1.9). Now, on z/OS 1.11 it gives "Invalid
Dsname Level" (single or double asterisk).

Check your options.
--
Shmuel (Seymour J.) Metz, SysProg and JOAT
ISO position; see <http://patriot.net/~shmuel/resume/brief.html>
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Clark Morris

2010-12-02 15:29:05 UTC

Post by Mark Zelden
On Wed, 1 Dec 2010 03:33:24 -0600, Elardus Engelbrecht

Post by Dr. Stephen Fedtke

Post by Dr. Stephen Fedtke
what is the best method to achieve a complete list of all currently

cataloged data sets? really "all". actually, like using "**" in the 3.4

data set

Post by Dr. Stephen Fedtke
criterion.
Use Catalog Search Interface with Assembler or REXX.
It is faster than =3.4 or IDCAMS LISTC and perhaps ISMF too.

If I were bothering to list all catalog entries, I would want two
lists - the good entries and the bad ones. Getting rid of garbage and
confusion is goodness.

Clark Morris

Post by Mark Zelden
Mark

Mark Zelden

2010-12-02 00:27:46 UTC

Hmmm, what level are you running. Unless this changed in z/OS 1.12
(and I don't think it did), it isn't allowed. I get a pop up warning message:

"In order to list catalog entries, you must specify at least one partial
qualifier. Any Dsname Level that contains only asterisks is invalid."

In addition, help has this information:

"When Dsname Level is specified, it defines the level qualifiers for
the data
set names to be included in the list. Qualifiers can be specified
fully,
partially or defaulted. At least one qualifier must be partially
specified. A
Dsname Level of '*' or '**' or any combination of '*' and '**'
qualifiers is
invalid. "

Your 2nd point I was not aware of. Thanks. I am still using the sample
ISRNOGEN for that. Since I don't want to look it up, can you (or anyone)
recall when that option was added (I'm running z/OS 1.11 now)? One
less usermod to install! BTW, when I just tested * and ** again in my
sandbox, I used a dummy ISRNOGEN (IEFBR14) in my TSOLIB instead of the
real one... otherwise I couldn't test any generic HLQs.

Regards,

Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
mailto:***@flash.net
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
Systems Programming expert at http://expertanswercenter.techtarget.com/

Post by Don Imbriale
I've used * and ** in 3.4 for the dsname level.
1. If you enter a high-level qualifier of * or **, ISPF displays a
pop-up window
to warn you that the search will be for all catalogs on the system and will
take
time. If there are many catalogs, this search could take a considerable
amount
of time. You can press Enter to continue the search, or you can enter Cancel
or
End from the pop-up window to cancel the search. Be aware that if you have
mount authority, a catalog search with * or ** as the high-level
qualifier can
require that volumes be mounted for the catalogs to be searched.
2. The ISPF Configuration table contains a selectable option, named
DISALLOW_WILDCARDS_IN_HLQ, to disallow the use of the * or % in the
high-level qualifier
- Don Imbriale

Don Imbriale

2010-12-02 00:37:26 UTC

The quote from the manual came from 1.11. It may be as Barry has stated
that at least one qualifier must be specified that is not just * or **.

- Don Imbriale

Post by Mark Zelden
Hmmm, what level are you running. Unless this changed in z/OS 1.12
"In order to list catalog entries, you must specify at least one partial
qualifier. Any Dsname Level that contains only asterisks is invalid."
"When Dsname Level is specified, it defines the level qualifiers for
the data
set names to be included in the list. Qualifiers can be specified
fully,
partially or defaulted. At least one qualifier must be partially
specified. A
Dsname Level of '*' or '**' or any combination of '*' and '**'
qualifiers is
invalid. "
Your 2nd point I was not aware of. Thanks. I am still using the sample
ISRNOGEN for that. Since I don't want to look it up, can you (or anyone)
recall when that option was added (I'm running z/OS 1.11 now)? One
less usermod to install! BTW, when I just tested * and ** again in my
sandbox, I used a dummy ISRNOGEN (IEFBR14) in my TSOLIB instead of the
real one... otherwise I couldn't test any generic HLQs.
Regards,
Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>
Systems Programming expert at http://expertanswercenter.techtarget.com/

Post by Don Imbriale
I've used * and ** in 3.4 for the dsname level.
1. If you enter a high-level qualifier of ’*’ or ’**’, ISPF displays a
pop-up window
to warn you that the search will be for all catalogs on the system and

will

Post by Don Imbriale
take
time. If there are many catalogs, this search could take a considerable
amount
of time. You can press Enter to continue the search, or you can enter

Cancel

Post by Don Imbriale
or
End from the pop-up window to cancel the search. Be aware that if you have
mount authority, a catalog search with ’*’ or ’**’ as the high-level
qualifier can
require that volumes be mounted for the catalogs to be searched.
2. The ISPF Configuration table contains a selectable option, named
DISALLOW_WILDCARDS_IN_HLQ, to disallow the use of the ’*’ or ’%’ in the
high-level qualifier
- Don Imbriale

Post by Mark Zelden
3.4 doesn't allow * or **.
No options with IDCAMS to list everything from all catalogs.
The CSI is a good option, but since if you tell it to list all catalogs

you

Post by Mark Zelden
could
end up with a bunch of "dead" catalog entries. For example, a user

catalog

Post by Mark Zelden
that was previously a master from another system, or an alias for an HLQ
points to the "correct catalog" but maybe pointed to a different catalog

Post by Mark Zelden
one time and the entries weren't deleted or merged out. No one would
ever know about those entries to clean them up unless they looked for

them.

Post by Mark Zelden
(you can do this with CATSRCH from my web site: TSO %CATSRCH **
If you did it with CSI and wrote intelligent code around it, then it

would

Post by Mark Zelden
be more accurate. For example, list the master catalog and the aliases,
then only list the HLQs in the catalogs that the aliases in the master
catalog
pointed to.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Elardus Engelbrecht

2010-12-02 06:47:05 UTC

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

Warning: Your session will take a long time to process all those entries. (dead
entries, live entries, duplicate entries, and catalogs connected too.)

Post by Mark Zelden
The CSI is a good option, but since if you tell it to list all catalogs you

could end up with a bunch of "dead" catalog entries.

Yup.

Post by Mark Zelden
If you did it with CSI and wrote intelligent code around it, then it would

be more accurate. For example, list the master catalog and the aliases,
then only list the HLQs in the catalogs that the aliases in the master catalog
pointed to.

Yup. Agreed. Wrap some code around while working with one catalog at a
stage.

Groete / Greetings
Elardus Engelbrecht

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Chase, John

2010-12-02 13:00:51 UTC

Post by Schwarz, Barry A
-----Original Message-----
From: IBM Mainframe Discussion List On Behalf Of Elardus Engelbrecht

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

OK, on z/OS 1.11 that mimics the "old" behavior. (But the sandbox could
use more/faster engines for it. :-) )

-jc-

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Mark Zelden

2010-12-02 15:05:43 UTC

On Thu, 2 Dec 2010 00:45:27 -0600, Elardus Engelbrecht

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

Okay, that does work. I compared to to my CATSRCH exec with **
in my sandbox and it was 10 less entries returned - 29487 vs. 29497
for CATSRCH (no, I'm not going to try and figure out what is being
reported differently).

BTW, CATSRCH took about 2 wall clock seconds and ISPF 3.4 took about
25 seconds, but my exec only returns the data set names and volser
information.

Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
mailto:***@flash.net
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
Systems Programming expert at http://expertanswercenter.techtarget.com/

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Scott Rowe

2010-12-02 15:16:47 UTC

hehe, I don't know if I even want to try this, with 18 SAP DB2 subsystems my
total should be well over 1 million ;-)

Post by Mark Zelden
On Thu, 2 Dec 2010 00:45:27 -0600, Elardus Engelbrecht

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

Okay, that does work. I compared to to my CATSRCH exec with **
in my sandbox and it was 10 less entries returned - 29487 vs. 29497
for CATSRCH (no, I'm not going to try and figure out what is being
reported differently).
BTW, CATSRCH took about 2 wall clock seconds and ISPF 3.4 took about
25 seconds, but my exec only returns the data set names and volser
information.
Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>
Systems Programming expert at http://expertanswercenter.techtarget.com/
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains
confidential and privileged information intended only for the addressee.
If you are not the intended recipient, please be advised that you have
received this material in error and that any forwarding, copying, printing,
distribution, use or disclosure of the material is strictly prohibited.
If you have received this material in error, please (i) do not read it,
(ii) reply to the sender that you received the message in error, and
(iii) erase or destroy the material. Emails are not secure and can be
intercepted, amended, lost or destroyed, or contain viruses. You are deemed
to have accepted these risks if you communicate with us by email. Thank you.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

ibmnew

2010-12-07 08:23:58 UTC

Hi all

Our shop is a monoplex configuration

When we use BPXISYZR member to create the sysplex root ZFS data set, I found that shareoptions was 2.

Could you tell me it is correct or not? Could I use SHAREOPTIONS(3) as the following?

---------------------------------------------------------
DEFINE CLUSTER (NAME(OMVS.PLEXBDZ3.ROOT) -
VOLUMES(BD3S01) -
LINEAR CYL(200 0) SHAREOPTIONS(3))

Thanks a lot!

Jason Cai

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Mark Zelden

2010-12-02 15:26:02 UTC

That's why I used my sandbox! :-)

Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
mailto:***@flash.net
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
Systems Programming expert at http://expertanswercenter.techtarget.com/

Post by Scott Rowe
hehe, I don't know if I even want to try this, with 18 SAP DB2 subsystems my
total should be well over 1 million ;-)

Post by Mark Zelden
On Thu, 2 Dec 2010 00:45:27 -0600, Elardus Engelbrecht

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>

Post by Scott Rowe

Post by Mark Zelden
Systems Programming expert at http://expertanswercenter.techtarget.com/
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains
confidential and privileged information intended only for the addressee.
If you are not the intended recipient, please be advised that you have
received this material in error and that any forwarding, copying, printing,
distribution, use or disclosure of the material is strictly prohibited.
If you have received this material in error, please (i) do not read it,
(ii) reply to the sender that you received the message in error, and
(iii) erase or destroy the material. Emails are not secure and can be
intercepted, amended, lost or destroyed, or contain viruses. You are deemed
to have accepted these risks if you communicate with us by email. Thank you.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Scott Rowe

2010-12-02 15:33:09 UTC

Yeah, but because I'm such a small shop, my sandbox shares the catalog
structure, but I went ahead and gave it a shot on my sandbox. With a 1G
region (and quite a bit of paging) the total was just shy of 2.5M catalog
entries ;-)

Post by Mark Zelden
That's why I used my sandbox! :-)
Mark
--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>
Systems Programming expert at http://expertanswercenter.techtarget.com/

Post by Scott Rowe
hehe, I don't know if I even want to try this, with 18 SAP DB2 subsystems

Post by Scott Rowe
total should be well over 1 million ;-)

Post by Mark Zelden
On Thu, 2 Dec 2010 00:45:27 -0600, Elardus Engelbrecht

Post by Mark Zelden
3.4 doesn't allow * or **.

Try out *% (Asterisk followed by percentage sign without any spaces)

http://home.flash.net/~mzelden/mvsutil.html<http://home.flash.net/%7Emzelden/mvsutil.html>
<http://home.flash.net/%7Emzelden/mvsutil.html>

Post by Scott Rowe

printing,

Post by Scott Rowe
distribution, use or disclosure of the material is strictly prohibited.
If you have received this material in error, please (i) do not read it,
(ii) reply to the sender that you received the message in error, and
(iii) erase or destroy the material. Emails are not secure and can be
intercepted, amended, lost or destroyed, or contain viruses. You are

deemed

Post by Scott Rowe
to have accepted these risks if you communicate with us by email. Thank

you.

Post by Scott Rowe
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Bruce Hewson

2010-12-07 10:03:37 UTC

I didn't know about the "*%" option.....the ISPF developers haven't blocked
that the same way they block "*" and "**".

I have been using "*.**" ever since that block went in when I need to do that
sort of search.

Regards
Bruce Hewson

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Mark Zelden

2010-12-07 14:09:16 UTC

Post by Bruce Hewson
I didn't know about the "*%" option.....the ISPF developers haven't blocked
that the same way they block "*" and "**".
I have been using "*.**" ever since that block went in when I need to do that
sort of search.
Regards
Bruce Hewson

*.** gives me this error (z/OS 1.11):

+-------------------------------------------------------------------------+
| In order to list catalog entries, you must specify at least one partial |
| qualifier. Any Dsname Level that contains only asterisks is invalid. |
+-------------------------------------------------------------------------+

--
Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS
mailto:***@flash.net
Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html
Systems Programming expert at http://expertanswercenter.techtarget.com/

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to ***@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Donnelly, John P

2010-12-07 16:17:36 UTC

DSLIST - Data Sets Matching *.%* Row 1 of 638351

John Donnelly
National Semiconductor Corporation
2900 Semiconductor Drive
Santa Clara, CA 95051

408-721-5640
408-470-8364 Cell
***@nsc.com

-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-***@bama.ua.edu] On Behalf Of Mark Zelden
Sent: Tuesday, December 07, 2010 6:08 AM
To: IBM-***@bama.ua.edu
Subject: Re: best method to completely list all cataloged data sets

Mark Zelden

2010-12-07 15:20:47 UTC