IBM DB2 9.7 Advanced Administration Cookbook -- Table of Contents -- IBM DB2 9.7 Advanced Administration Cookbook -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. DB2 Instance-Administration and Configuration -- Introduction -- Creating and configuring instances for non-partitioned environments -- Getting ready -- How to do it... -- How it works... -- There's more... -- Updating instances using the db2iuptd command -- Creating and configuring a client instance -- Getting ready… -- How to do it… -- How it works... -- There's more... -- See also -- Creating and configuring an instance for multipartitioned environments -- Getting ready -- How to do it... -- Set up NFS for sharing the instance home -- Creating the instance owner and fenced user -- Set up SSH for client authentication -- Install DB2 ESE software with a response file option -- Configuring communication for inter-partition command execution -- Configuring the nodes -- How it works... -- There's more... -- See also -- Starting and stopping instances -- Getting ready -- How to do it... -- How it works... -- There's more... -- Configuring SSL for client-server instance communication -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Listing and attaching to instances -- Getting ready -- How to do it... -- Listing instances -- Attaching to instances -- How it works... -- There's more... -- See also -- Dropping instances -- Getting ready -- How to do it...

How it works... -- There's more… -- 2. Administration and Configuration of the DB2 Non-partitioned Database -- Introduction -- Creating and configuring DB2 non-partitioned databases -- Getting ready -- How to do it... -- How it works... -- There's more... -- Command preview -- Automatic storage -- Adaptive self-tuning memory -- File and directory permission on database objects -- UNIX links -- Default codeset -- Territory -- Collate using -- Control files -- See also -- Using Configuration Advisor -- Getting ready -- How to do it... -- How it works... -- There's more... -- Main configuration characteristics of OLTP databases -- Main configuration characteristics of DSS databases -- Main configuration characteristics of mixed processing databases -- See also -- Creating a database from an existing backup -- Getting ready -- How to do it... -- How it works... -- There's more... -- Roll-forward recovery -- Redirected restore -- See also -- Configuring automatic database maintenance -- Getting ready -- How to do it... -- How it works... -- There's more... -- Backups -- Reorgs -- Runstats -- See also -- Managing federated databases-connecting to Oracle and MSSQL -- Getting ready -- How to do it... -- How it works... -- See also -- Altering databases -- How to do it… -- How it works… -- From Oracle to DB2 -- Startup/shutdown instance -- Startup/shutdown database -- Database file containers -- Log files -- How it works... -- There's more... -- Control files -- Quiesce instance/database -- Backup and recovery -- Standby databases -- See also -- Dropping databases -- Getting ready -- How to do it... -- How it works... -- There's more... -- Backup history -- Keep safe -- See also -- 3. DB2 Multipartitioned Databases-Administration and Configuration -- Introduction -- Creating and configuring a multipartitioned database -- Getting ready -- How to do it...

How it works... -- There's more... -- Adding database partitions -- Getting ready -- How to do it... -- Using Control Center -- Using the command line -- How it works... -- There's more… -- Creating database partition groups -- Getting ready -- How to do it… -- Using Control Center -- Using the command line -- Using Control Center -- Using the command line -- Create the NAV application's table spaces -- How it works... -- There's more... -- See also -- Altering database partition groups-adding partitions to database partition groups -- Getting ready -- How to do it... -- Using Control Center -- Using the command line -- How it works… -- There's more… -- See also -- Managing data redistribution on database partition groups -- Getting ready -- How to do it... -- Using the command line -- How it works… -- There's more… -- The table distribution key and its role in a multipartitioned environment -- Getting ready -- How to do it... -- Using the command line -- How it works... -- There's more... -- Table collocation -- Altering database partition groups-removing partitions from a database partition group -- Getting ready -- How to do it... -- Using the command line -- How it works... -- There's more... -- Removing database partitions -- Getting ready -- How to do it... -- Using Control Center -- Using the command line -- How it works... -- There's more... -- Converting a non-partitioned database to a multipartitioned database on MS Windows -- Getting ready -- How to do it... -- How it works... -- There's more... -- Configuring Fast Communication Manager -- Getting ready -- How to do it… -- How it works... -- There's more... -- See also -- 4. Storage-Using DB2 Table Spaces -- Introduction -- Creating and configuring table spaces within automatic storage databases -- Getting ready -- How to do it... -- How it works... -- There's more...

Using self tuning buffer pools -- Physical implementation -- Adding a storage path to a manual storage database -- Creating and configuring SMS table spaces -- Getting ready -- How to do it... -- How it works... -- There's more... -- Space allocation -- Tables and objects -- Limits -- Filesystem caching -- Limits -- See also -- Creating and configuring DMS table spaces -- Benefits -- Getting ready -- How to do it... -- How it works... -- There's more... -- Raw partitions -- Space allocation -- Tables and objects -- Filesystem caching -- Extent size -- Prefetch size -- Striping strategy -- High water mark -- See also -- Using system temporary table spaces -- Getting ready -- How to do it... -- How it works... -- There's more... -- Reorgs -- Using user temporary table spaces -- Getting ready -- How to do it... -- How it works... -- There's more... -- Page size for temporary table space -- SMS or DMS? -- See also -- Altering table spaces and dropping table spaces -- Getting ready -- How to do it… -- How it works... -- There's more... -- Container management -- Size management -- Physical characteristics -- Performance characteristics -- Dropping table space -- See also -- Table spaces in a multipartitioned environment -- Getting ready -- How to do it... -- How it works... -- There's more... -- Distribution maps -- Distribution keys -- Table space containers -- Partition groups -- Table space state -- Storage paths in an automatic storage-partitioned database -- See also -- 5. DB2 Buffer Pools -- Introduction -- Creating and configuring buffer pools -- Getting ready -- How to do it... -- How it works... -- There's more... -- Naming convention -- Specifying space size for the buffer pool -- Memory sizing -- Windows 32-bit environments: Address Windowing Extensions (AWE) and Extended Storage (ESTORE) -- Hidden buffer pools -- See also.

Configuring the block-based area -- Getting ready -- How to do it... -- How it works... -- There's more... -- Block size and table space extent size -- See also -- Managing buffer pools in a multipartitioned database -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Altering buffer pools -- Getting ready -- How to do it... -- How it works... -- There's more... -- Page size -- Buffer pool size -- Self-tuning -- Partitions -- Partition groups -- See also -- Dropping buffer pools -- Getting ready -- How to do it... -- How it works... -- There's more... -- IBMDEFAULTBP -- Dependencies -- See also -- 6. Database Objects -- Introduction -- Creating and using MDC tables and block-based indexes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Block indexes and aggregate functions in queries -- Block size and extents -- Using runstats to determine dimension candidates -- Restrictions on dimensions -- Rollout -- Partitioned database -- See also -- Creating and using materialized query tables -- Getting ready -- How to do it... -- How it works... -- There's more... -- Refresh deferred -- Maintained by system/user -- Query rewrites -- Combining with table partitioning -- Replicated MQTs and database partitioning -- See also -- Implementing table partitioning -- Getting ready -- How to do it... -- How it works... -- There's more... -- Scalability -- Non-partitioned indexes -- Partitioned indexes -- Storage strategies -- Adding a partition to a table -- Detach a partition from a table -- See also -- Using temporary tables -- Getting ready -- How to do it... -- How it works... -- Created global temporary table -- How to do it... -- How it works... -- There's more... -- Restrictions -- Recovery -- See also -- 7. DB2 Backup and Recovery -- Introduction -- Configuring database logging -- Getting ready.

How to do it...