Script started on Wed May 03 11:26:35 2000
db(1)% loadcap test1
(c) Copyright IBM Corporation 1993,1997
Command Line Processor for DB2 SDK 5.0.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => 
   Database Connection Information

 Database product       = DB2/SUN 5.0.0
 SQL authorization ID   = EONEIL
 Local database alias   = TEST1

db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => DB20000I  The SQL command completed successfully.
db2 => SQL3501W  The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file
"/home/eoneil/dbppp/loadcap/db2ud/custs.dat".

SQL3500W  The utility is beginning the "LOAD" phase at time "05-03-2000
11:26:54.660936".

SQL3110N  The utility has completed processing.  "5" rows were read from the
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "5".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "05-03-2000
11:26:55.419893".

SQL3500W  The utility is beginning the "BUILD" phase at time "05-03-2000
11:26:55.548027".

SQL3515W  The utility has finished the "BUILD" phase at time "05-03-2000
11:26:55.746830".


Number of rows read         = 5
Number of rows skipped      = 0
Number of rows loaded       = 5
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 5

db2 => SQL3501W  The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file
"/home/eoneil/dbppp/loadcap/db2ud/agents.dat".

SQL3500W  The utility is beginning the "LOAD" phase at time "05-03-2000
11:26:57.608714".

SQL3110N  The utility has completed processing.  "6" rows were read from the
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "6".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "05-03-2000
11:26:58.390629".

SQL3500W  The utility is beginning the "BUILD" phase at time "05-03-2000
11:26:58.514075".

SQL3515W  The utility has finished the "BUILD" phase at time "05-03-2000
11:26:58.720851".


Number of rows read         = 6
Number of rows skipped      = 0
Number of rows loaded       = 6
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 6

db2 => SQL3501W  The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file
"/home/eoneil/dbppp/loadcap/db2ud/prods.dat".

SQL3500W  The utility is beginning the "LOAD" phase at time "05-03-2000
11:27:00.562419".

SQL3110N  The utility has completed processing.  "7" rows were read from the
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "7".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "05-03-2000
11:27:01.328596".

SQL3500W  The utility is beginning the "BUILD" phase at time "05-03-2000
11:27:01.455019".

SQL3515W  The utility has finished the "BUILD" phase at time "05-03-2000
11:27:01.653607".


Number of rows read         = 7
Number of rows skipped      = 0
Number of rows loaded       = 7
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 7

db2 => SQL3501W  The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file
"/home/eoneil/dbppp/loadcap/db2ud/orders.dat".

SQL3500W  The utility is beginning the "LOAD" phase at time "05-03-2000
11:27:03.531316".

SQL3110N  The utility has completed processing.  "16" rows were read from the
input file.

SQL3519W  Begin Load Consistency Point. Input record count = "16".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "05-03-2000
11:27:04.316231".

SQL3500W  The utility is beginning the "BUILD" phase at time "05-03-2000
11:27:04.437711".

SQL3515W  The utility has finished the "BUILD" phase at time "05-03-2000
11:27:04.644597".


Number of rows read         = 16
Number of rows skipped      = 0
Number of rows loaded       = 16
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 16

db2 => db(2)% exit
script done on Wed May 03 11:27:14 2000