LEADER 05281nam 2200649 a 450 001 9910461190403321 005 20200520144314.0 010 $a1-280-11892-X 010 $a9786613523211 010 $a1-84968-333-6 035 $a(CKB)2670000000160433 035 $a(EBL)934498 035 $a(OCoLC)787844573 035 $a(SSID)ssj0000646202 035 $a(PQKBManifestationID)12197010 035 $a(PQKBTitleCode)TC0000646202 035 $a(PQKBWorkID)10684853 035 $a(PQKB)11682819 035 $a(MiAaPQ)EBC934498 035 $a(PPN)228013011 035 $a(Au-PeEL)EBL934498 035 $a(CaPaEBR)ebr10537862 035 $a(CaONFJC)MIL352321 035 $a(EXLCZ)992670000000160433 100 $a20120317d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aIBM DB2 9.7 advanced administration cookbook$b[electronic resource] $eover 100 recipes focused on advanced administration tasks to build and configure powerful databases with IBM DB2 : [quick answers to common problems] /$fAdrian Neagu, Robert Pelletier 210 $aOlton Birmingham [England] $cPackt Pub.$d2012 215 $a1 online resource (480 p.) 300 $aIncludes index. 311 $a1-84968-332-8 327 $aCover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: DB2 Instance-Administration and Configuration; Introduction; Creating and configuring instances for non-partitioned environments; Creating and configuring a client instance; Creating and configuring an instance for multipartitioned environments; Starting and stopping instances; Configuring SSL for client-server instance communication; Listing and attaching to instances; Dropping instances; Chapter 2: Administration and Configuration of the DB2 Non-partitioned Database 327 $aIntroductionCreating and configuring DB2 non-partitioned databases; Using Configuration A dvisor; Creating a database from an existing backup; Configuring automatic database maintenance; Managing federated databases-connecting to Oracle and MSSQL; Altering databases; Dropping databases; Chapter 3: DB2 Multipartitioned Databases-Administration and Configuration; Introduction; Creating and configuring a multipartitioned database; Adding database partitions; Creating database partition groups; Altering database partition groups-adding partitions to database partition groups 327 $aManaging data redistribution on database partition groupsThe table distribution key and its role in a multipartitioned environment; Altering database partition groups-removing partitions from a database partition group; Removing database partitions; Converting a non-partitioned database to a multipartitioned database on MS Windows; Configuring Fast Communication Manager; Chapter 4: Storage-Using DB2 Table Spaces; Introduction; Creating and configuring table spaces within automatic storage databases; Creating and configuring SMS table spaces; Creating and configuring DMS table spaces 327 $aUsing system temporary table spacesUsing user temporary table spaces; Altering table spaces and dropping table space; Table spaces in a multipartitioned environment; Chapter 5: DB2 Buffer Pools; Introduction; Creating and configuring buffer pools; Configuring the block-based area; Managing buffer pools in a multipartitioned database; Altering buffer pools; Dropping buffer pools; Chapter 6: Database Objects; Introduction; Creating and using MDC tables and block-based indexes; Creating and using materialized query tables; Implementing table partitioning; Using temporary tables 327 $aCreated global temporary tableChapter 7: DB2 Backup and Recovery; Introduction; Configuring database logging; Performing an offline database backup; Performing a full online database backup; Performing an incremental delta database backup; Performing an incremental cumulative database backup; Backing up table spaces; Crash recovery; Full database recovery; Database rollforward recovery; Incremental restore; Recovering table spaces, full and rollforward recovery; Redirected restore; Recovery history file; Configuring tape-based backup with IBM Tivoli Storage Manager 327 $adb2move and db2look utilities as alternative backup methods 330 $aThis cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints. If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you. This book assumes that you have a basic understanding of DB2 database concepts. 606 $aDatabase management$vHandbooks, manuals, etc 606 $aIBM computers$vHandbooks, manuals, etc 608 $aElectronic books. 615 0$aDatabase management 615 0$aIBM computers 676 $a005.7565 700 $aNeagu$b Adrian$0950663 701 $aPelletier$b Robert$0950664 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910461190403321 996 $aIBM DB2 9.7 advanced administration cookbook$92149358 997 $aUNINA