DB2 returns zero(0) count after repeated loading of millions of records...Any idea what is happening here?
Posted on 2015-01-26
I have repeatedly loaded a table with data and after each load operation, I do a select count(1) or select (*) from the table but surprised to get a zero return count. Here is my example:
RAPMQ01HDQRA /db2storage >db2 -tvf load_ptl_table.sql -z load_ptl_table.out
alter table PERISCOPE.PRODUCT_TRANS_LOG activate not logged initially
DB20000I The SQL command completed successfully.
load from periscope_product_trans_log.ixf of ixf savecount 50000 messages A315.msg insert INTO periscope.product_trans_log indexing mode rebuild allow read access
Number of rows read = 19408704
Number of rows skipped = 0
Number of rows loaded = 19408704
Number of rows rejected = 0
Number of rows deleted = 19408704
Number of rows committed = 19408704
SQL3107W There is at least one warning message in the message file.
RAPMQ01HDQRA /db2storage >db2 "select count(*) from periscope.product_trans_log"
1 record(s) selected.
Can someone help explain why this is happening?