LEADER 11738nam 22006974a 450 001 9910814485703321 005 20200520144314.0 035 $a(CKB)1000000000522894 035 $a(OCoLC)61446919 035 $a(CaPaEBR)ebrary10112448 035 $a(SSID)ssj0000949204 035 $a(PQKBManifestationID)11596454 035 $a(PQKBTitleCode)TC0000949204 035 $a(PQKBWorkID)10970046 035 $a(PQKB)10332534 035 $a(Au-PeEL)EBL3306460 035 $a(CaPaEBR)ebr10112448 035 $a(OCoLC)842285405 035 $a(CaSebORM)0738426792 035 $a(MiAaPQ)EBC3306460 035 $a(OCoLC)835961060 035 $a(OCoLC)ocn835961060 035 $a(EXLCZ)991000000000522894 100 $a20031202d2002 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDB2 recovery expert for multiplatforms /$f[Bart Steegmans, Mark Samson, Manish Shah] 205 $a1st ed. 210 $a[San Jose, Calif. $cIBM Corp., International Technical Support Organization]$d2002 215 $a1 online resource (300 p.) 225 1 $aIBM redbooks 300 $a"SG24-6421-00." 300 $a"DB2. Data management software"--Cover p. [1]. 311 $a0-7384-2679-2 320 $aIncludes bibliographical references (p. 263-264) and index. 327 $aFront cover -- Summary of changes -- November 2002, First Edition -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction to DB2 Tools for Multiplatforms -- 1.1 The DB2 Tools for Multiplatforms -- 1.1.1 Database administration tools -- 1.1.2 Performance management tools -- 1.1.3 Recovery and replication tools -- 1.1.4 Application management tools -- 1.2 DB2 Web Query Tool -- 1.3 DB2 Table Editor -- 1.4 DB2 Recovery Expert -- 1.5 DB2 High Performance Unload -- 1.6 DB2 Performance Expert -- 1.7 DM Tools for Multiplatforms ordering information -- Chapter 2. Introduction to DB2 Recovery Expert -- 2.1 Overview -- 2.2 Key features -- 2.2.1 Simple, easy to use interface -- 2.2.2 Dropped object restore -- 2.2.3 Greater granularity in recovery operations -- 2.2.4 Point-in-time recovery of objects -- 2.2.5 Enhanced recovery performance -- 2.2.6 SQL report generation -- 2.2.7 Selective SQL undo/redo -- 2.3 Key concepts -- 2.3.1 Versioning Repository -- 2.3.2 Minilogs -- 2.3.3 Log analysis -- 2.3.4 Object translation -- 2.3.5 Our environment -- Chapter 3. Installation and configuration -- 3.1 Installation requirements -- 3.1.1 Hardware requirements -- 3.1.2 Software requirements -- 3.2 Installation instructions -- 3.2.1 Starting InstallShield -- 3.2.2 The InstallShield process -- 3.3 Post-installation configuration -- 3.3.1 Environment variables -- 3.4 Getting started -- 3.4.1 Launching DB2 Recovery Expert -- 3.4.2 Connecting to a database -- 3.5 DB2 configuration changes -- 3.5.1 LOGRETAIN -- 3.5.2 Performance -- 3.5.3 USEREXIT (optional) -- 3.5.4 DROPPED TABLE RECOVERY (optional) -- 3.6 DB2 Recovery Expert tasks -- 3.6.1 Create Versioning Repository -- 3.6.2 Create minilogs -- 3.7 Troubleshooting. 327 $a3.7.1 Tracing the install process -- 3.7.2 The DB2 Recovery Expert log file -- 3.7.3 Changing the amount of information logged -- 3.7.4 Common problems -- Chapter 4. Managing recovery assets -- 4.1 Backups -- 4.1.1 The importance of backups -- 4.1.2 Backup types -- 4.1.3 Storage managers -- 4.1.4 Scheduling backups -- 4.2 Versioning Repository -- 4.2.1 The importance of the Versioning Repository -- 4.2.2 How to create and update the Versioning Repository -- 4.2.3 When to update the Versioning Repository -- 4.2.4 Backing up the Versioning Repository -- 4.3 Minilogs -- 4.3.1 The importance of minilogs -- 4.3.2 How to create and update minilogs -- 4.3.3 For which objects should I create minilogs? -- 4.3.4 How often to update minilogs -- 4.3.5 When are minilogs used? -- 4.4 DB2 Recovery Expert metadata -- Chapter 5. Log analysis -- 5.1 Introduction to log analysis -- 5.1.1 What is log analysis? -- 5.1.2 Prerequisites for log analysis -- 5.1.3 Accessing log analysis -- 5.2 Scenario A: Recovery using log analysis -- 5.2.1 Scenario description -- 5.2.2 Prerequisites for the scenario -- 5.2.3 Scenario time line -- 5.2.4 Recovery options without DB2 Recovery Expert -- 5.3 The DB2 log analysis tool -- 5.3.1 Getting started with the DB2 log analysis tool -- 5.3.2 Analyzing changes to a single table -- 5.3.3 Analyzing changes to all tables -- 5.3.4 Problem resolved -- 5.4 The command line interface: db2la -- 5.4.1 Analyzing changes to the EMPLOYEE table -- 5.4.2 Analyzing changes to all tables -- 5.5 Considerations -- 5.5.1 Recovery Expert quiesces the table space -- 5.5.2 Recovery Expert works one row at a time -- 5.5.3 Redo SQL will not necessarily be the same as the original SQL -- 5.5.4 Masked update reconstruction -- 5.5.5 It only shows committed transactions -- 5.5.6 DATA CAPTURE CHANGES -- 5.5.7 Referential Integrity -- 5.5.8 GENERATED ALWAYS columns. 327 $a5.5.9 Triggers -- 5.6 FAQ -- 5.6.1 Which interface should I use? -- 5.6.2 Can you find all changes made by one application? -- 5.6.3 Can you find all changes made by one user (authid)? -- 5.6.4 Does log analysis work with LOB data? -- 5.6.5 What if the table has changed? -- 5.6.6 What if other SQL is run while Undo/Redo SQL is running? -- Chapter 6. Point-in-time recovery -- 6.1 Scenario B: PIT recovery if SQL has been run -- 6.1.1 Scenario description -- 6.1.2 Prerequisites for the scenario -- 6.1.3 Scenario time line -- 6.1.4 Recovery without DB2 Recovery Expert -- 6.2 PIT recovery of a table -- 6.3 PIT recovery of a table space -- 6.3.1 UNDO SQL using the DB2 logs -- 6.3.2 Restore from a backup image and roll forward -- 6.4 PIT recovery of a database -- 6.4.1 UNDO SQL using the DB2 logs -- 6.4.2 Restore from a backup image and roll forward -- 6.5 Scenario C: PIT recovery if DDL has been run -- 6.5.1 Scenario description -- 6.5.2 Prerequisites for the scenario -- 6.5.3 Scenario time line -- 6.5.4 Recovery options without DB2 Recovery Expert -- 6.6 Recovery from Scenario C -- 6.7 PIT recovery of DEPARTMENT table -- 6.8 PIT recovery of ORG table -- 6.9 PIT recovery of a table space -- 6.10 PIT recovery of database -- 6.11 Scenario D: PIT recovery with Referential Integrity -- 6.11.1 Scenario description -- 6.11.2 Prerequisites for the scenario -- 6.11.3 Scenario time line -- 6.11.4 Recovery without DB2 Recovery Expert -- 6.12 Recovery from Scenario D -- 6.12.1 Recovery using the DB2 RE GUI -- 6.12.2 Recovery using db2la -- 6.12.3 Further discussion of the effects of Referential Integrity -- 6.13 Scenario E: PIT recovery using command line -- 6.13.1 Scenario description -- 6.13.2 Prerequisites for the scenario -- 6.13.3 Scenario time line -- 6.13.4 Recovery without DB2 Recovery Expert -- 6.14 Recovery from Scenario E. 327 $a6.14.1 Determine table and table space IDs -- 6.14.2 Recover the table image from a backup using db2ox -- 6.14.3 Determine the table space directory -- 6.14.4 Backup the original table data file -- 6.14.5 Lock the table -- 6.14.6 Copy the table data file into the table space directory -- 6.14.7 Backup the table space -- 6.14.8 Obtain Redo SQL -- 6.14.9 Run Redo SQL -- 6.15 Command line versus GUI -- 6.16 Summary of DB2 vs. DB2 RE PIT recovery methods -- 6.16.1 Scenario B: SQL run since PIT -- 6.16.2 Scenario C: SQL and DDL run since PIT -- 6.16.3 Scenario D: PIT recovery with Referential Integrity -- 6.16.4 Scenario E: PIT recovery using command line -- Chapter 7. Dropped object recovery -- 7.1 Scenario F: Recovery of a dropped table -- 7.1.1 Scenario description -- 7.1.2 Prerequisites for the scenario -- 7.1.3 Scenario time line -- 7.1.4 Recovery without DB2 Recovery Expert -- 7.1.5 Situation before the table is dropped -- 7.1.6 Recovering a dropped table using DB2 Recovery Expert -- 7.2 Scenario G: Recover a dropped table using minilogs -- 7.2.1 Scenario description -- 7.2.2 Prerequisites for the scenario -- 7.2.3 Scenario time line -- 7.2.4 Before the table is dropped -- 7.2.5 Creating a minilog for the DEPARTMENT table -- 7.2.6 Recovering the dropped table using minilogs -- 7.3 Scenario H: Recovery of a dropped table space -- 7.3.1 Scenario description -- 7.3.2 Scenario time line -- 7.3.3 Prerequisites for the scenario -- 7.3.4 Without DB2 Recovery Expert -- 7.3.5 Situation before the table space is dropped -- 7.3.6 Recovering a dropped table space using DB2 Recovery Expert -- 7.4 Scenario I: Recovery of a dropped database -- 7.4.1 Prerequisites for the scenario -- 7.4.2 Recover a dropped database using DB2 commands -- 7.5 Using DB2 RE to undrop a database -- Chapter 8. Cloning a database or a table -- 8.1 Scenario J: Cloning a database. 327 $a8.1.1 Scenario description -- 8.1.2 Prerequisites for the scenario -- 8.2 Steps to clone the database -- 8.2.1 Before we start -- 8.2.2 Cloning a database using the DB2 Recovery Expert GUI -- 8.3 Scenario K: Clone a specific table -- 8.3.1 Scenario description -- 8.3.2 Prerequisites for the scenario -- 8.3.3 Without DB2 Recovery Expert -- 8.4 Steps to clone the table using DB2 Recovery Expert -- 8.4.1 Obtain DDL for the table from the source database -- 8.4.2 Create the table at the target database -- 8.4.3 Obtain IDs for the table at the source and target database -- 8.4.4 Get the table data file image from the backup -- 8.4.5 Change the database signature in the data file -- 8.4.6 Place the new data file in the target database -- Appendix A. Sample applications -- The DEMOAPP application -- Appendix B. Full log analysis reports -- Reports for the EMPLOYEE table -- Reports for all tables -- Reports for a table with a BLOB column -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover. 330 $aDB2 Recovery Expert is one of the most recent IBM Data Management Tools for Multiplatforms. It provides an easy-to-use environment that even less experienced DBAs can successfully use, to complete highly sophisticated and efficient recovery techniques in minimal time. Built-in SMART (Self-Managing and Resource Tuning) features provide intelligent analysis of altered, incorrect or missing database assets - including tables, indexes, or data - and automate the process of rebuilding those assets to a correct point in time, often without taking the database or business operations offline. This IBM Redbooks publication describes how to recover database objects safely, precisely, and quickly by using DB2 Recovery Expert for Multiplatforms, without having to resort to full disaster recovery processes. This book gives assistance for expert recovery, describes summary and detail reports from log analysis, and provides point-in-time recovery scenarios, via roll forward or back out, and also shows how to recover objects that were dropped by accident. 410 0$aIBM redbooks. 606 $aDatabase management 606 $aData recovery (Computer science) 615 0$aDatabase management. 615 0$aData recovery (Computer science) 676 $a005.8/6 700 $aSteegmans$b Bart$01598674 701 $aSamson$b Mark$01156682 701 $aShah$b Manish$01665837 712 02$aInternational Business Machines Corporation.$bInternational Technical Support Organization. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910814485703321 996 $aDB2 recovery expert for multiplatforms$94024709 997 $aUNINA