dear all:
I have an 8 million-row file to be loaded into a db2 table
through this command--> db2 "load from /anypath/rol_EMP.09122007 of del modified by coldel| decpt. savecount 20000 insert into anyschema.anytable NONRECOVERABLE"

it seems to end successfully

however when it comes to querying the table I see no rows at all!!!!

is there any step further?

something else.


does this utility skip duplicate rows or does it stop when one is found?


regards

What's the complete output of the load? How do you query the table? What is the output from the query (error or not)? Which version of DB2 are you using on which platform?

What's the complete output of the load?
SQL3520W Load Consistency Point was successful.

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

SQL3520W Load Consistency Point was successful.

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

SQL3520W Load Consistency Point was successful.

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

SQL3520W Load Consistency Point was successful.

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

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

SQL3520W Load Consistency Point was successful.

SQL3515W The utility has finished the "LOAD" phase at time "12/14/2007
13:37:26.821288".

SQL3500W The utility is beginning the "BUILD" phase at time "12/14/2007
13:37:26.905529".

SQL3213I The indexing mode is "REBUILD".

SQL3515W The utility has finished the "BUILD" phase at time "12/14/2007
13:38:10.791861".


Number of rows read = 7806406
Number of rows skipped = 0
Number of rows loaded = 7806406
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 7806406
DB21007E End of file reached while reading the command.

How do you query the table? What is the output from the query (error or not)?
select * from tabla

15:03:24 [SELECT - 0 row(s), 1.203 secs] Empty result set fetched
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 1.203/0.000 sec [0 successful, 1 warnings, 0 errors]
NO ERRORS

Which version of DB2 are you using on which platform?
Database server = DB2/6000 8.2.3 on UNIX AIX 5.0

the command file is not correctly terminated
DB21007E End of file reached while reading the command.
maybe there is a rollback after is error

Try loading the data again with the same command and use replace term instead of insert.
while load is being performed, do the query
db2 LOAD QUERY table tablename(table into which load is being performed)

After load is done,
perform select count(*) from schemaname.tabname