TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

386 Chapter8
Using the Database Utilities
DBLOAD
for instructions about console interaction.
Using
ControlY
When executing DBLOAD in session mode,
ControlY can be pressed to request the
approximate number of entries in the current data set that have already been copied.
DBLOAD prints the following message on $STDLIST:
<CONTROL Y> DATA SET m : x ENTRIES HAVE BEEN PROCESSED
Example
:RUN DBLOAD.PUB.SYS
WHICH DATABASE? ORDERS/SELL
DATA SET 1: AUTOMATIC MASTER
DATA SET 2: 19 ENTRIES
DATA SET 3: 25 ENTRIES
DATA SET 4: 12 ENTRIES
DATA SET 5: 32 ENTRIES
DATA SET 6: 258 ENTRIES
END OF VOLUME 1, 0 READ ERRORS RECOVERED
DATABASE LOADED
END OF PROGRAM
Initiate execution of DBLOAD. Supply the database name and maintenance word. DBLOAD
indicates the number of entries copied. Data set 1 is an automatic master so 0 entries are
copied; the entries are created as related detail entries are copied to the database.
One volume was copied with no read errors.
NOTE For optimum performance, DBLOAD uses deferred output when it adds entries
to a database. With deferred output, data and structural information cannot
be written back to disk each time DBPUT returns to the DBLOAD program. As a
result, the database is not considered to be logically or structurally complete
on disk until the DBLOAD is complete. During DBLOAD the database being
loaded is considered inconsistent ("bad") and only at the completion of a
DBLOAD run is the database considered consistent ("good") again.
During a load if an MPE/iX or hardware failure occurs, the database is
definitely not structurally intact, and it returns its "bad" flag. After the
system is brought back up, TurboIMAGE/XL does not allow the database to
be opened for normal access. If you get a "bad database" error in such a
situation, erase the database with DBUTIL and then perform the load again.
(For more information on the error message "Bad Database" refer to appendix
A). Alternatively, the database can be purged with DBUTIL and then restored
from a backup copy.