Db2 emptying the table causes the table to appear Unavailable
Possible reasons
1 、 bad page
2. Rollback emptying occurs in transaction without logging.
Test for the second case
Four windows are opened, and the test log is full, which leads to the failure of emptying the table until the table state changes to Unavailable.
Session 1: analog real-time business, appid 800,
Session 2: perform online backup, appid 1721
Session 3: execute emptying table, appid 1498
Session 4: open db2top
Session 5: view appid holding the oldest transaction log, appid 1922
Start execution:
