count(*) of the segment tables not in sync with ins_rows-del_rows

[Valentin Schmid]

Hello all,

After a migration, we did a quantity-check of the inserted amount of documents in a ApplicationGroup.
There were discrepancies.
Then we did a deeper look into it and realized, that the "ins_rows-del_rows" values in the ARSSEG tables are not always correct.

Code: [Select]

$ db2 "select arsseg.table_name,arsseg.ins_rows,arsseg.del_rows,arsseg.ins_rows-arsseg.del_rows as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid and arsag.name='myApplGrp'"

TABLE_NAME         INS_ROWS             DEL_ROWS             TOTAL_ROWS         
------------------ -------------------- -------------------- --------------------
LBA1                            5422800                60000              5362800

  1 record(s) selected.

but

Code: [Select]

$ db2 "select count(*) as cnt from LBA1"

CNT       
-----------
    5423418

  1 record(s) selected.

How could this happen?
Is there a way to fix the ins_rows and del_rows columns?

Best Regards
Valentin