146 IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
6.4.1 Scenario time line
Table 6-3 shows the time line of activity against the database for this scenario.
Table 6-3 Time line for activity against database
We want to undo the delete operations that were done by the batch job. Multiple
tables have been affected in two table spaces. Therefore, we decide to perform a
database level recovery.
6.4.2 Details of activity against the database
Example 6-12 shows the row counts before the batch job ran.
Example 6-12 Row count before batch job was run.
/db2backup->db2 "select count(*) from vps.customer"
1
-----------
253456
1 record(s) selected.
/db2backup->db2 "select count(*) from vps.car"
1
-----------
119986
1 record(s) selected.
/db2backup->db2 "select count(*) from vps.part"
1
-----------
200000
1 record(s) selected.
Time Action
T1 Full offline backup taken.
T2 Batch job executed by mistake, which delete operations data
from VPS.CAR and VPS.CUSTOMER tables in SMSDAT1
table space and VPS.PART table in DMSDAT1 table space.
T3 Alter table DDL is run against table VPS.CAR

Get IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.