舉報 
會員
IBM DB2 9.7 Advanced Administration Cookbook
最新章節：
Index
Thiscookbookhasrecipeswritteninasimple,easytounderstandformat,withlotsofscreenshotsandinsightfultipsandhints.IfyouareaDB2DatabaseAdministratorwhowantstounderstandandgethandsonwiththeunderlyingaspectsofdatabaseadministration,thenthisbookisforyou.ThisbookassumesthatyouhaveabasicunderstandingofDB2databaseconcepts.
最新章節
- Index
- Backup and recovery in DB2 pureScale environments
- High availability in DB2 pureScale environments
- Monitoring DB2 pureScale environments
- Managing instances members and cluster facilities in DB2 pureScale
- Introduction
品牌：中圖公司
上架時間：2021-08-20 15:26:10
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-20 15:33:44
- Backup and recovery in DB2 pureScale environments
- High availability in DB2 pureScale environments
- Monitoring DB2 pureScale environments
- Managing instances members and cluster facilities in DB2 pureScale
- Introduction
- Chapter 14. IBM pureScale Technology and DB2
- Creating a benchmark testing scenario
- Using EXPLAIN PLAN
- Loading a table
- Using parallelism
- Using logging and nologging modes
- I/O tuning
- Hit ratios and their role in performance improvement
- Tuning sorting
- Tuning with indexes
- Default automatic statistics collection
- Collecting object statistics with the RUNSTAT utility
- Tuning memory utilization
- Resolving CPU bottlenecks
- Operating system tuning
- Introduction and general tuning guidelines
- Chapter 13. DB2 Tuning and Optimization
- Using Health Monitor
- Using Memory Visualizer
- Configuring and using event monitoring
- Configuring and using snapshot monitoring
- Configuring and using system monitoring
- Introduction
- Chapter 12. Monitoring
- Monitoring and configuring FCM for optimal performance
- Communications with DRDA servers (z/OS and i/OS)
- Using DB2 Discovery
- Cataloging and uncataloging instances and databases
- Configuring network communications
- Introduction
- Chapter 11. Connectivity and Networking
- Auditing DB2
- Using label-based access control (LBAC) to strengthen data privacy
- Using table encryption
- Using roles
- Managing object privileges
- Managing database-level authorities and privileges
- Managing instance-level authorities
- Introduction
- Chapter 10. DB2 Security
- Using db2support to collect diagnostic data
- Using db2ckbkp—DB2 check backup tool for backup integrity
- Using db2dart—DB2 database analysis and reporting tool command
- Using db2pd—DB2 problem determination tool
- Using db2mtrk—DB2 memory tracker
- Introduction
- Chapter 9. Problem Determination Event Sources and Files
- Using the DB2 fault monitor
- Opening the standby database in read-only mode
- Using automated client rerouting with HADR
- Performing takeover and takeover by force
- Changing HADR synchronization modes
- Setting up HADR by using Control Center
- Setting up HADR by using the command line
- Introduction
- Chapter 8. DB2 High Availability
- db2move and db2look utilities as alternative backup methods
- Configuring tape-based backup with IBM Tivoli Storage Manager
- Recovery history file
- Redirected restore
- Recovering table spaces—full and rollforward recovery
- Incremental restore
- Database rollforward recovery
- Full database recovery
- Crash recovery
- Backing up table spaces
- Performing an incremental cumulative database backup
- Performing an incremental delta database backup
- Performing a full online database backup
- Performing an offline database backup
- Configuring database logging
- Introduction
- Chapter 7. DB2 Backup and Recovery
- Created global temporary table
- Using temporary tables
- Implementing table partitioning
- Creating and using materialized query tables
- Creating and using MDC tables and block-based indexes
- Introduction
- Chapter 6. Database Objects
- Dropping buffer pools
- Altering buffer pools
- Managing buffer pools in a multipartitioned database
- Configuring the block-based area
- Creating and configuring buffer pools
- Introduction
- Chapter 5. DB2 Buffer Pools
- Table spaces in a multipartitioned environment
- Altering table spaces and dropping table spaces
- Using user temporary table spaces
- Using system temporary table spaces
- Creating and configuring DMS table spaces
- Creating and configuring SMS table spaces
- Creating and configuring table spaces within automatic storage databases
- Introduction
- Chapter 4. Storage—Using DB2 Table Spaces
- Configuring Fast Communication Manager
- Converting a non-partitioned database to a multipartitioned database on MS Windows
- Removing database partitions
- Altering database partition groups— removing partitions from a database partition group
- The table distribution key and its role in a multipartitioned environment
- Managing data redistribution on database partition groups
- Altering database partition groups—adding partitions to database partition groups
- Creating database partition groups
- Adding database partitions
- Creating and configuring a multipartitioned database
- Introduction
- Chapter 3. DB2 Multipartitioned Databases—Administration and Configuration
- Dropping databases
- Altering databases
- Managing federated databases—connecting to Oracle and MSSQL
- Configuring automatic database maintenance
- Creating a database from an existing backup
- Using Configuration Advisor
- Creating and configuring DB2 non-partitioned databases
- Introduction
- Chapter 2. Administration and Configuration of the DB2 Non-partitioned Database
- Dropping instances
- Listing and attaching to instances
- Configuring SSL for client-server instance communication
- Starting and stopping instances
- Creating and configuring an instance for multipartitioned environments
- Creating and configuring a client instance
- Creating and configuring instances for non-partitioned environments
- Introduction
- Chapter 1. DB2 Instance—Administration and Configuration
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Credits
- IBM DB2 9.7 Advanced Administration Cookbook
- coverpage
- coverpage
- IBM DB2 9.7 Advanced Administration Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- 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
- Introduction
- Creating and configuring DB2 non-partitioned databases
- Using Configuration Advisor
- 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
- Managing data redistribution on database partition groups
- The 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
- Using system temporary table spaces
- Using user temporary table spaces
- Altering table spaces and dropping table spaces
- 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
- Created global temporary table
- Chapter 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
- db2move and db2look utilities as alternative backup methods
- Chapter 8. DB2 High Availability
- Introduction
- Setting up HADR by using the command line
- Setting up HADR by using Control Center
- Changing HADR synchronization modes
- Performing takeover and takeover by force
- Using automated client rerouting with HADR
- Opening the standby database in read-only mode
- Using the DB2 fault monitor
- Chapter 9. Problem Determination Event Sources and Files
- Introduction
- Using db2mtrk—DB2 memory tracker
- Using db2pd—DB2 problem determination tool
- Using db2dart—DB2 database analysis and reporting tool command
- Using db2ckbkp—DB2 check backup tool for backup integrity
- Using db2support to collect diagnostic data
- Chapter 10. DB2 Security
- Introduction
- Managing instance-level authorities
- Managing database-level authorities and privileges
- Managing object privileges
- Using roles
- Using table encryption
- Using label-based access control (LBAC) to strengthen data privacy
- Auditing DB2
- Chapter 11. Connectivity and Networking
- Introduction
- Configuring network communications
- Cataloging and uncataloging instances and databases
- Using DB2 Discovery
- Communications with DRDA servers (z/OS and i/OS)
- Monitoring and configuring FCM for optimal performance
- Chapter 12. Monitoring
- Introduction
- Configuring and using system monitoring
- Configuring and using snapshot monitoring
- Configuring and using event monitoring
- Using Memory Visualizer
- Using Health Monitor
- Chapter 13. DB2 Tuning and Optimization
- Introduction and general tuning guidelines
- Operating system tuning
- Resolving CPU bottlenecks
- Tuning memory utilization
- Collecting object statistics with the RUNSTAT utility
- Default automatic statistics collection
- Tuning with indexes
- Tuning sorting
- Hit ratios and their role in performance improvement
- I/O tuning
- Using logging and nologging modes
- Using parallelism
- Loading a table
- Using EXPLAIN PLAN
- Creating a benchmark testing scenario
- Chapter 14. IBM pureScale Technology and DB2
- Introduction
- Managing instances members and cluster facilities in DB2 pureScale
- Monitoring DB2 pureScale environments
- High availability in DB2 pureScale environments
- Backup and recovery in DB2 pureScale environments
- Index 更新時間：2021-08-20 15:33:44
