DB2 性能调优入门1-Tools.ppt

Mountpoint: On Unix: this is the file-system where the database data is stored On Windows: this is the windows drive where the database data is stored Source Volume: ESSVOL Mountpoint: /mp1 Database:DB1 Table spaces: userspace1 tempspace1 syscatspace Target Volume: ESSBCK FC_Task1 Task Setting: FC_Task1 identifies the unique physical backup characteristics for the ESSVOL on the shark. This is created once as part of configuration and is referenced by the user when creating the backup specification for the database (DB1 in this case). Recovery Expert V2 Fast Backup The user selects a database and the desired task setting for Fast Backup. That’s it.! DB2 CONTROL CENTER How does it work: Fast Backup a database called DB1 In Table space Fast Backup, Just click on “Add related table spaces” to find the table spaces with related tables Note: only one table space can be on a volume. Recovery Expert V2 Fast Backup Using Fast Backup with Grouper Tab1a Tab2a USERSPACE1 Tab1b Tab2b Tab2c Tab2d Tab3 EGFSPACE Fast Backup will use DB2 Grouper to find table spaces that have related tables DB2 Grouper Set – Version Group1 = Tab1a, Tab1b Group2= Tab2a, Tab2b, Tab2c, Tab2d Recovery Expert V2 Fast Backup Using Fast Backup with Grouper (continued) Recovery Expert V2 Fast Backup Putting it all together Production Database Fast Backup DB2 Suspend I/O Use Fast Backup to FlashCopy the production database 1. 2. %*#@ !! (Logical Error) Production Database Use Recovery Expert to perform a point-in-time recovery 3. Fast Backup Logs Logs DB2 Logs Production Database Presentation summary DB2 Recovery Expert – the essential tool for enterprise data management Multiplies DBA productivity Encourages best practices for database cleanup, maintenance Provides an overall safer environment for new staff to work in Greatly reduces time to recovery Helps avoid full disaster recovery scenarios Keeps the enterprise onl