Get out of the PITs fast

PiT Recovery automates, controls, and speeds up all the necessary actions needed for a point in time (PIT) recovery of ERP and CRM systems like Peoplesoft, SAP, and Siebel.

A PIT recovery is always needed when unwanted and irreversible SQL updates are made to the DB2 database, e.g., a program error or a flawed operational procedure such as running a batch application twice or using bad input. Subsequent SQL update processing makes the situation even worse because it may result in additional erroneous data. In a situation like this, pinpointing the corrupted table spaces and indexes is especially difficult with ERP and CRM because the referential constraints (RI) are ruled by the application, instead of using the physical RI feature of the DB2 database. Therefore, a DBA cannot be certain that all data tables are logically consistent with each other when recovering just a subset of the ERP and CRM tables. The alternative solution is a recovery of all table spaces and indexes of an ERP or CRM system to a prior point. With tens of thousands of objects, this implies a very disruptive outage for several hours and makes this scenario impractical. Because the need for a point in time recovery is never entirely eliminated, SOFTWARE ENGINEERING was encouraged to develop a software solution that addresses and solves the problems with a PIT recovery for black box DB2 applications.

Key Benefits

• Automates a point in time recovery for ERP and CRM systems
• Determines the most efficient method of recovery, i.e., offline backup, IC, or V8 backup
• Recalls migrated data sets before the recovery starts
• Submits and controls all recovery jobs
• Supports all in-house solutions for database REORG and COPY without any changes
• Provides a training mode
• Guarantees the fastest recovery possible, speeding up a V8 RESTORE as well
• Requires no QUIESCE to establish PIT
• Supports DB2 V5, V6, V7, V8
• Cares for DDL changes and handles LOG NO events
• Cleans up obsolete logs
• Automates and controls the steps required for V8 BACKUP RESTORE

Product Description (PDF, 118 KB)

Interactive presentation including HSC - Homogeneous System Copy