Shulou(Shulou.com)06/01 Report--

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:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.