HP 3000 Manuals HP 3000 Manuals
DICTDBU
Database Unload Utility
The Database Unload utility (DICTDBU) unloads the contents of an existing
IMAGE database. The database can be unloaded and stored either to a disc
file or to a tape file. Additionally, the database can be edited during
the unload process. Editing the unload process allows you to selectively
unload, that is, choose whether or not to unload a particular data set.
When the unloading process is complete, an audit report is produced.
The following description tells how to execute the DICTDBU utility
program and gives an explanation of each prompt.
To execute this utility enter the following MPE command:
RUN DICTDBU.PUB.SYS
After an acknowledgement message, the unload utility issues the following
prompt to establish a file for the storage of the database content:
STORE FILE>
If the database is to be stored on disc, enter a file name in response to
the prompt. The utility builds the file for you if it is a new file.
For an existing file, the utility issues a warning message and waits for
you to indicate that it can be overwritten before it continues.
If the database is to be stored on tape, enter [[RETURN]] in response to
the STORE FILE prompt. The utility issues the following message:
TAPE FILE REQUESTED(Y/N)?>
If you enter a "Y" or [[RETURN]], a request to mount a tape is issued on
the system console; otherwise, the prompt for STORE FILE is reissued. If
necessary, the utility can handle multiple tape reel stores.
When the utility completes the unloading process, it generates an audit
report about the unloading process. You specify where the report is to
be sent by responding to the following prompt:
LIST FILE>
Enter one of the following options in response to this prompt:
LP sends the report to the line printer. If there is no
device LP configured on your system, use a file equation
to redirect DICTLIST to another device.
NULL suppresses the audit listing.
filename sends the report to the existing or to a new disc file.
Before over-writing an existing file, you are prompted
to approve purging the existing file's contents.
*filename sends the report to the file identified in the
back-referenced file equation. Pressing [[RETURN]] in
response to this prompt sends the report to your
terminal.
After accepting your response to the prompt for LIST FILE, the utility
requests the name of the database to be unloaded with the following
prompt:
BASE>
Enter the name of the base in response to this prompt. If [[RETURN]] is
entered, an error message is displayed and the program is terminated.
Next, you are prompted to enter a password as follows:
BASE PASSWORD>
In response to this prompt, enter a password that grants read access to
the named database. The password is not displayed as you enter it. If
the password entered is incorrect or does not grant read access to the
database, a database operation error occurs during the unload process.
The utility issues an error message which tells you why the database
error occurred and then terminates.
To complete the information required to unload the database, the
following prompt is issued:
MODE>
Your response to the MODE prompt indicates the access mode to be used to
open the database. Any valid access mode is acceptable as a response to
this prompt. If [[RETURN]] is entered, the program uses the default
mode, which is 3. (Refer to the IMAGE/3000 Reference Manual for details
on "Access Modes" .)
If the database named in response to the BASE prompt cannot be found, the
following message is issued after the prompt for access mode:
*ERROR: NO SUCH DATABASE
Prompts are then repeated starting with the BASE prompt.
Next, prompts pertaining to the unloading process method are issued. The
first prompt is as follows:
UNLOAD AUTOMATIC MASTER SETS(N/Y)?>
If automatic master sets are to be converted into manual master sets, you
should respond with a "Y" ; otherwise, it is unnecessary to unload
automatic master sets.
The next prompt identifies how the detail sets are to be unloaded. The
prompt is as follows:
UNLOAD DETAIL SETS BY CHAIN(Y/N)?>
Although it takes longer to unload detail data sets with a chained read,
improvements in access time of chained reads can be seen after the
database is reloaded. Enter "N" as your response if you do not want to
unload the sets with a chained read.
The following prompt allows you to choose which data sets are or are not
to be unloaded:
UNLOAD EDIT(N/Y)?>
You must enter a "Y" to selectively unload the data sets. If you choose
to selectively unload the data sets, you are prompted as follows:
set name set type: UNLOAD(Y/N/C/X)?>
You can choose only one of the unload types. A description of each is as
follows:
Y which is short for YES, specifies that the data set is
to be unloaded. (This is the default.)
N which is short for NO, specifies that this data set is
not to be unloaded.
C which is short for CONTINUE, specifies that this data
set and all remaining data sets are to be unloaded.
X which is short for EXIT, specifies that this and all
remaining data sets are not to be unloaded and the
program terminates.
Note that entering a "C" ends the process of unloading data sets with
"editing" , but it does not terminate the program. To terminate the
program, an "X" must be entered. If [[RETURN]] is pressed in response to
this prompt, the data set is unloaded.
If you chose to unload with a chained read and also chose to unload with
editing, you will be prompted during the editing process to enter the
search item's name for the detail set as follows:
SEARCH ITEM FOR CHAINED UNLOAD>
You can enter the name or allow the program to use the default, which is
the primary path for the detail data set.
As each data set is unloaded, the program identifies the data set and the
number of entries unloaded on your terminal screen. When the entire
unload process is completed, the message "UNLOAD COMPLETED" is displayed,
and the utility program terminates. An audit report is generated and
sent to the file you indicated with your response to the LIST FILE
prompt.
The following examples show how to execute the Database Unload utility
program with an explanation of the responses given to the prompts.
Example
:RUN DICTDBU.PUB.SYS How to execute this utility.
<The Dictionary/3000 DB Unloader program banner appears here.>
STORE FILE> TEMPSTOR Name of a disc file.
LIST FILE> [[RETURN]] sends listing to terminal.
BASE> HOUSES Name of base to be unloaded.
BASE PASSWORD> Password used: MANAGER.
MODE> [[RETURN]] pressed; default used.
UNLOAD AUTOMATIC MASTER SETS(N/Y)?> [[RETURN]] pressed.
UNLOAD DETAIL SETS BY CHAIN(Y/N)?> [[RETURN]] pressed.
UNLOAD EDIT(N/Y)?> Y Unload with editing.
ZONING-MASTER M: UNLOAD(Y/N/C/X)?> Y Yes, unload this set.
CITY-MASTER M: UNLOAD(Y/N/C/X)?> Y
COMMERCIAL D: UNLOAD(Y/N/C/X)?> C Unload all remaining sets
without EDIT prompts.
SEARCH ITEM FOR CHAINED UNLOAD> ZONING-CODE Identifies the search item
ZONING-MASTER M:6/31 of the detail data set.
6 ENTRIES UNLOADED IN <1 CPU-SEC Identifies what is unloaded.
CITY-MASTER M:20/101
20 ENTRIES UNLOADED IN <1 CPU-SEC
LIST-PRICE-MSTR A:42/307
AUTO NOT UNLOADED
BATH-MASTER A:2/31
AUTO NOT UNLOADED
BEDS-MASTER A:4/11
AUTO NOT UNLOADED
COMMERCIAL D:10/209
10 ENTRIES UNLOADED IN <1 CPU-SEC
RESIDENTIAL D:40/200
40 ENTRIES UNLOADED IN <1 CPU-SEC
UNLOAD COMPLETED
END OF PROGRAM