IBM DB2 V8 Instrukcja Użytkownika Pobierz pdf (Strona 43)

XVI DB2 Backup/Recovery Notes (OSS Note 83000)

NOTE: The procedures described here are applicable to DB2 Version 8. Version 8

provides two new utilities for backup and point in time recovery that provides a more

robust solution that is less prone to errors, and reduces recovery time and labor time.

These new utilities are described later in this section.

DB2 Backup

- DB2 Image Copy

- Volume Level (hardware assisted such as FlashCopy or DSS DASD Dump/Restore)

Database Recovery

- to current end of log

- to prior point in time represented by a log RBA

- determined by business needs

DB2 Image Copy

- Offline - not useful with R/3 in general

- Online - used by almost all customers, used for recover to cu rrent

Volume Level

- DB2 Suspend Log

- FlashCopy/SnapShot/EMC TimeFinder

- DB2 Resume Log

- used as a base for prior point in time recovery

*Need to perform both types of backup, image copy:

- allows recovery of individual tablespaces

- allows management of the size of SYSLGRNX by deleting old image copies

Unit Of Recovery

- DB2 : does not span R/3 dialog steps, resolved at DB2 startup

- SAP: spans multiple dialog steps, uses VBLOG, resolved using transaction SM13 and

parameter rdisp/vbreorg

Recover to Current

- Standard DB2 Recovery

- Recover damaged objects

- RECOVER TABLESPACE/RECOVER INDEXSPACE

- Image Copy + Apply Logs

IBM Solutions Technical Sales (STS) 12/18/2007Page 43 of 51

12/18/2007

Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 49 50 51

Brak uwag

IBM DB2 V8 Instrukcja Użytkownika Strona 43