Re: Find Databases (275 Views)
Posts: 22
Registered: ‎08-07-2003
Message 1 of 6 (275 Views)

Find Databases

How can I generate a list of all the All Base Databases on a system and which ldevs they are located on?
Honored Contributor
Posts: 830
Registered: ‎10-03-2000
Message 2 of 6 (275 Views)

Re: Find Databases


If you have MPEX from Vesoft, using their listf,4 will provied a listing of where all the extents are located.

%listf @.@.@(code=db),4

Depending on which version of MPEX the syntax for the 'code=' will vary.


"Show me the $$$$$"
Honored Contributor
Posts: 1,162
Registered: ‎07-10-2000
Message 3 of 6 (275 Views)

Re: Find Databases

Hello Mark,

The Allbase DBE and DBEfiles have respectively filecode of -491 and -493.

Try this dummy :STORE command which provides the list of DBE files however it won't give you the Ldev#:

FILE T=$NULL <---dummy tape device
STORE @.@.@;*T;SHOW;FCRANGE=-493/-491

Like Chuck suggested, if you have MPEX utility from VeSoft, the following command will give you all databases files including IMAGE DBs and ALLBASE DBEs:

%listf @.@.@(code=PRIV),4
King is the customer!
Esteemed Contributor
Posts: 201
Registered: ‎03-25-1998
Message 4 of 6 (275 Views)

Re: Find Databases


There is another way to do this if you don't have MPEX. You can use the LISTFILE command. It has many options that you can specify but here is one example using the file codes that Emile provided:


There are several options for the format, just do a HELP LISTFILE,ALL to see a list of your choices.

I like the MPEX format the best but it's nice to have choices.

Trusted Contributor
Posts: 72
Registered: ‎12-23-1996
Message 5 of 6 (275 Views)

Re: Find Databases

A big file can spread on multiple ldevs.
Honored Contributor
Posts: 830
Registered: ‎10-03-2000
Message 6 of 6 (275 Views)

Re: Find Databases

Mark and Dan,

Yep the MPEX solution is nice, but I like Dan's option.
"Show me the $$$$$"
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.