If you don't have any 3rd party utilities, then you'll need to write a
CI script and make use of QUERY. But as Wirt said it may not be worth
the effort. Depending on how often you may need this tool, and how many
databases and data items you are dealing with, it may easier to do ti
manually. Without any 3rd party utilities the following command will
show you all the Image databases you have on the system:
Logon as MANAGER.SYS
LISTFILE @[log in to unmask]@;SELEQ=[CODE=-400];FORMAT=6
If you route the output of the above command into a MSG file, you can
then begin to read it back into a script that could build an input file
to be used by query.pub.sys.
If you have ADAGER http://www.adager.com , you could also use the same
script to build an input file for ADAGER
RUN ADAGER.PUB.REGO
database.group.account
REPORT CAPACITY
exit
Or, if you have VESOFT's MPEX you could try the following:
MPEX:
:RUN MAIN.PUB.VESOFT;INFO="listf @[log in to unmask]@(ispriv),db"
Also maybe still available is GUI3000, awesome product in my opinion.
GUI3000 is a graphical front end for the HP3000, similar to the Windows
"Explorer" or "File Manager" products. The Database Explorer allows you
to review database capacities, number of entries, %full, discspace
usage, bla, bla, bla.. and this data is one click away from being
imported into Excel or Access. GUI3000 will also make use of ADAGER, and
will allow you to change DB capacities from within the GUI, by building
an ADAGER job stream transferring it to MPE, and streaming it, and it
even returns the job number. Then (in 1 or 2 clicks) using the GUI3000
Spool File Explorer, you can view the $STDLIST...
Check out a demo at OmniSolutions
http://www.gui3000.com/
--
Michael Anderson
Spring Independent School District
16717 Ella Boulevard
Houston, Texas 77090-4299
office: 281.586.1105
fax: 281.586.1187
-
>>> Venkataraman Ramakrishnan <[log in to unmask]> 03/02/04
12:01AM >>>
Hello everybody,
I want to find out the number of records present in each of the
datasets
in all the databases that we have in our system.
Also I want to list the elements of each dataset for all the
databases.
Both of these can be obtained by doing an "FO" of the each of the
databases individually, I just wanted to know if there is any other
simpler way other than this as this is very time-consuming.
Regards,
Venkat
"The way I see it, if you want the rainbow, you gotta put up with the
rain."
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
