Utilities 7-15

dbload: Load Data from a Command File

Thenext command imports the stores5 database from tape into the auckland
dbspace. The database is created with unbuffered logging. The command
suppresses the echo of the SQL statements and continues processing unless
fatal errors occur.
dbimport -cq -d auckland -l -t /dev/rmt0 -b 16 -s 24000 stores5
dbload: Load Data from a Command File
The dbload utility transfers data from one or moreASCII files into one or
more existing tables. Thedbload utility offers four advantages over the
LOAD statement:
You can create the data thatdbload will load, unrestricted by the
format or the arrangement of data in an existing input file. The
dbloadcommand file can accommodate data from entirely different
database management systems.
You can specify a starting point in the load by directingdbload to
read but ignorex number of rows.
Youcan specify a batch size so that after every xnumber of rows are
inserted, the insert is committed.
You can limit the number of bad rows read, beyond whichdbload
ends.
The cost ofdbload flexibility is time and effort spent creating thedbload
command file, which is requiredfor dbload operation. The ASCII input files
are not specified as part of thedbload command line. Neither are the tables
into which the data is inserted. This information is contained within the
command file.
The presence of indexes greatly affects the speed with which thedbload
utility loads data. For best performance, drop any indexes on the tables
receiving the data before you rundbload. You can create new indexes after
dbload has finished.