In the db2 database, use "alter table table name activate the not logged initially with the empty table" after the empty table data, query the table is an error "to the table and table space can be accessed" 4 "objects in 97", this problem has been for a long time, please answer

CodePudding user response:

The way lead to table hangs, and data unrecoverable, try not to use production, according to the time (the time field best indexed) cycle to delete, reduce the impact on the table