Cindy asks:

> I am trying to locate a database on an old HP3000 server.
>  I am a complete newbie to HP servers and I have no idea
>  how the databases are setup.  I believe that there is a
>  database on the server.  However, I have no idea what the
>  name of the database is, what user account or group
>  might have created the database. I believe that the data
>  is there because there is a client application that is able
>  to search this data.  I just want access to the database so
>  I can convert/import the data into another database on a
>  new server.  I know that I can use the Minisoft software
>  to make an ODBC connection, but I need to know the name
>  of the database first.
>
>  Can anyone provide me with a few commands or ideas that I
>  can use to determine the name of the database on the server?
>  Or to determine if I am off, and there isn't actually a
>  database on the server.
>
>  I'm looking through the HP documentation, but I'm running
>  out of time.  Any and all help is greatly appreciated.
>
>  I apologize for not providing more information, but I
>  really don't know enough to even know where to start.

The MPE command that you want to issue is this:

     :listfile @[log in to unmask]@,2;seleq=[code=priv]

IMAGE databases on the HP3000 are priviledged files (their filecode is
"PRIV"; a filecode in MPE is much like a file extension (".txt", ".pdf", etc.) on
Windows or UNIX). The above command will go through every file on your machine
and list out only those files that priviledged.

File names on the HP3000 can only be 8 characters in length; database file
names, in contrast, can only be 6 characters long. The two final characters in a
database's name are its set numbers, thus a database named CINDY would look
like this:

CINDY
CINDY01
CINDY02
CINDY03
etc.

The output below is part of the actual listing generated by the MPE LISTFILE
command above on one of my machines. The database is a standard English
dictionary, containing five datasets (tables):

=======================================

ACCOUNT=  QCTERM      GROUP=  WORDS

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

WORDSP    PRIV    128W  FB           7          7   1       16  1  1
WORDSP01  PRIV    512W  FB       23751      23751   1    95008  1 32
WORDSP02  PRIV    512W  FB        1668       1668   1     6688  1 32
WORDSP03  PRIV    384W  FB           2          2   1       16  1  1
WORDSP04  PRIV    128W  FB           1          1   1       16  1  1
WORDSP05  PRIV    512W  FB       31667      31667   1   126672  1 32

========================================

The LISTFILE command won't tell you which database is the one you're looking
for, but it will certainly give you a leg up -- and it will tell you where
each database is located on the machine.

Wirt Atmar

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *