DB性能调优入门Tools.ppt

Lab overview Lab 1 – DB2 Snapshot and db2pd Lab overview Lab 2 – DB2 Health center and Activity monitor Lab overview Lab 3 – DB2 Event Monitor What is DB2 Recovery Expert? Economical Recovery Tool for Enterprise Users Common look and feel on Windows, Unix and Linux A simple, self managing, recovery solution that minimizes downtime and recovery errors Supports Point-in-Time Recovery, so that objects may be brought back to their last, consistent state Has a greater granularity for recovery, so that specific objects, such as tables, can be restored Powerful diagnostic, reporting and recovery capabilities Combines Functionality from Log Analysis Object Restore Change Accumulation Standard Recovery What does DB2 Recovery Expert do? Point-In-Time recovery Reclaim previous states of objects, data Also: “Just In Time” recovery Recover / change only objects or data you need Much faster than disaster recovery Much more specific than disaster recovery Data change reporting Quickly target sensitive data changes for rollback Recovery Expert – An expert for DB2 recovery Analysis Ideal for logical recovery scenarios Filter and generate detail transaction reports of log data Useful for when there is a problem and you need to find out who did what and when Autonomic Reclaim previous states (schemas) of an application -object, data, and dependencies can be recovered Automate complex recoveries The user just specifies the object to recover and the point-in-time to recover to, Recovery Expert does the rest. Assistance Fine grained recovery offered / minimum recovery scope for the application For example, recover a dropped table vs. the entire database. Analyze possible recovery paths and recommend minimum cost alternative Offers selective point-in-time recovery via roll forward or back out (Undo/Redo SQL) Recovery Expert version 2 new function summary New Backup capability New Fast Backup function exploiting disk hardware FlashCopy Snapshot New DB2 Grouper Component to recogniz