Example 6 17 Log file information about the DB2 LOAD command
...
Deploying LOAD Scripts...
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/itsosj/mlog/catalog.dat".
...
SQL3110N The utility has completed processing. "21" rows were read from the
input file.
...
Number of rows read = 21
Number of rows skipped = 0
Number of rows loaded = 21
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 21
...
SQL3109N The utility is beginning to load data from file
"/home/itsosj/mlog/oenumber.dat".
...
Number of rows read = 8771
Number of rows skipped = 0
Number of rows loaded = 8771
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 8771
...
SQL3109N The utility is beginning to load data from file
"/home/itsosj/mlog/users.dat".
...
Number of rows read = 8
Number of rows skipped = 0
Number of rows loaded = 8
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 8
...
SQL3109N The utility is beginning to load data from file
"/home/itsosj/mlog/shopping_cart.dat".
...
Number of rows read = 3
Number of rows skipped = 0
Number of rows loaded = 3
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 3
...
Chapter 6. Data porting
151
footer
Our partners:
PHP: Hypertext Preprocessor Cheap Web Hosting
JSP Web Hosting
Ontario Web Hosting
Jsp Web Hosting
Cheapest Web Hosting
Java Hosting
Cheapest Hosting
Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved