Index
A
- -a option / How to do it...
- ABORT clause / ABORT
- ACCESSCTRL
- ACTION_RETRIES parameter / How to do it...
- active audit log path
- configuring / Configure audit data path and archive path:
- activity information
- querying, table functions used / Querying activity information using table functions
- activity monitoring
- Add Database Partitions Wizard screen / Using Control Center
- Add Instance windows / How to do it...
- administrative view
- archived audit log path
- configuring / Configure audit data path and archive path:
- array security label components
- asynchronous stats
- collecting / Background stats collecting (asynchronous)
- ASYNC mode / Getting ready, How it works...
- ASYNC synchronization mode
- changing to / Changing back to ASYNC synchronization mode
- audit data
- audit data path
- configuring / Configure audit data path and archive path:
- audit policies
- using / Using audit policies
- audit scopes
- configuring / Configuring auditing scopes
- AUTOCONFIGURE command
- about / AUTOCONFIGURE
- automated client rerouting
- using, with HADR / Using automated client rerouting with HADR
- NAV primary database, connecting to / How to do it...
- database takeover, performing / How to do it...
- automatic database maintenance
- configuring / Configuring automatic database maintenance, Getting ready, How to do it...
- backups / Backups
- reorgs / Reorgs
- runstats / Runstats
- automatic statistics profiling
- about / Automatic statistics profiling
- partitioned database / Partitioned database
- automatic storage databases
- table spaces, creating / Creating and configuring table spaces within automatic storage databases, How to do it...
- table spaces, configuring / Creating and configuring table spaces within automatic storage databases, How to do it...
- self tuning buffer pools, using / Using self tuning buffer pools
- physical implementation / Physical implementation
- storage path, adding to manual storage database / Adding a storage path to a manual storage database
- AUTO_RUNSTATS database / Background stats collecting (asynchronous)
- AUTO_STATS_PROF database / Automatic statistics profiling
- average log writes/transaction, snapshot monitor / Average log writes/transaction
- average sort overflows
- about / How to do it...
- average sort time
- about / How to do it...
B
- backup, DB2 pureScale environments / Backup and recovery in DB2 pureScale environments
- backup image / How it works...
- BECOMING_PRIMARY, cluster facility state / Getting ready
- benchmark testing scenario
- creating / Creating a benchmark testing scenario, How to do it...
- warm-up run / Warm-up run
- BINDADD
- BIND command / There's more...
- block / Block size and extents
- block-based area
- configuring / Configuring the block-based area, How it works...
- block size and table space extent size / Block size and table space extent size, See also
- buffer pool hit ratios
- monitoring / How to do it...
- buffer pool hit ratios, snapshot monitor / Buffer pool hit ratios
- buffer pool physical reads and writes, snapshot monitor
- per transaction / Buffer pool physical reads and writes per transaction
- buffer pools
- creating / Getting ready, How to do it..., How it works...
- configuring / Getting ready, How to do it..., How it works...
- naming convention / Naming convention
- space size, specifying / Specifying space size for the buffer pool
- memory sizing / Memory sizing
- Windows Address Windowing Extensions (AWE) / Windows 32-bit environments: Address Windowing Extensions (AWE) and Extended Storage (ESTORE)
- Extended Storage (ESTORE) / Windows 32-bit environments: Address Windowing Extensions (AWE) and Extended Storage (ESTORE)
- hidden / Hidden buffer pools
- managing, in multipartitioned database / Managing buffer pools in a multipartitioned database, How to do it..., How it works...
- altering / Altering buffer pools, How to do it...
- page size / Page size
- size / Buffer pool size
- self-tuning / Self-tuning
- partitions / Partitions
- partition groups / Partition groups
- dropping / Dropping buffer pools, How it works...
- about / How to do it..., Buffer pools
- Business Intelligence (BI) database / Creating and configuring DB2 non-partitioned databases
C
- caching facilities, DB2 pureScale
- managing / Managing the DB2 pureScale caching facilities
- stopping / Stopping the caching facility
- starting / Starting pureScale cluster facilities
- capacity planning
- about / Tuning memory utilization
- Cartesian joins / Watch out for...
- catalog cache
- about / How to do it..., Catalog cache
- catalog cache hit ratio
- monitoring / How to do it...
- catalog locks
- avoiding / There's more...
- CATALOG TCPIP NODE command / How to do it...
- catchup / How to do it…
- CATCHUP(n%), cluster facility state / Getting ready
- CF server configuration parameters
- CF_DIAGLEVEL parameter / Managing the DB2 pureScale caching facilities
- CF_DIAGPATH parameter / Managing the DB2 pureScale caching facilities
- CF_MEM_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_NUM_CONNS parameter / Managing the DB2 pureScale caching facilities
- CF_NUM_WORKERS parameter / Managing the DB2 pureScale caching facilities
- CF structure configuration parameters
- CF_DB_MEM_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_GBP_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_LOCK_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_SCA_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_DB_MEM_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_DIAGLEVEL parameter / Managing the DB2 pureScale caching facilities
- CF_DIAGPATH parameter / Managing the DB2 pureScale caching facilities
- CF_GBP_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_LOCK_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_MEM_SZ parameter / Managing the DB2 pureScale caching facilities
- CF_NUM_CONNS parameter / Managing the DB2 pureScale caching facilities
- CF_NUM_WORKERS parameter / Managing the DB2 pureScale caching facilities
- CF_SCA_SZ parameter / Managing the DB2 pureScale caching facilities
- Change button / Using Control Center
- client authentication
- SSH, setting up for / Set up SSH for client authentication
- client instance
- configuring / Creating and configuring a client instance, There's more...
- creating / Creating and configuring a client instance, There's more...
- cluster facility state, DB2 pureScale / Getting ready
- STOPPED / Getting ready
- RESTARTING / Getting ready
- BECOMING_PRIMARY / Getting ready
- CATCHUP(n%) / Getting ready
- PEER / Getting ready
- memory structures, monitoring / Monitoring cluster facility memory structures
- GBP memory area / Monitoring cluster facility memory structures
- CNAM column
- encrypting / Getting ready
- command line
- using, to add database partitions / Using the command line
- using, to create database partition groups / Using the command line
- using, to add partitions / Using the command line
- used, for managing data redistribution / Using the command line
- using, in table partitioned key / Using the command line
- using, to remove partitions / Using the command line
- using, to remove database partitions / Using the command line
- using, to set up HADR / Setting up HADR by using the command line, How to do it...
- using, to perform takeover operation / Using the command line to perform a takeover
- using, to perform takeover by force operation / Using the command line to perform a takeover by force
- communication
- configuring, for inter-partition command execution / Configuring communication for inter-partition command execution
- configuration advisor
- using / Using Configuration Advisor, How to do it...
- working / How it works...
- OLTP databases, configuration characteristics / Main configuration characteristics of OLTP databases
- DSS databases, configuration characteristics / Main configuration characteristics of DSS databases
- mixed processing databases, configuration characteristics / Main configuration characteristics of mixed processing databases
- Configuration Assistant (CA) / There's more...
- CONNECT
- considerations, logging
- catalog locks, avoiding / Catalog locks
- recovery / Recovery
- HADR / High Availability Disaster Recovery (HADR)
- control center
- using, to add database partitions / Using Control Center
- using, to create database partition groups / Using Control Center, Using Control Center
- using, to add partitions / Using Control Center
- using, to remove database partitions / Using Control Center
- used, for setting up HADR / Setting up HADR by using Control Center, Getting ready, How to do it..., How it works...
- using, for configuring network connections / Using Control Center
- using, for cataloging instances / Using Control Center
- using, for cataloging databases / Using Control Center
- using, for uncataloging instances / Using Control Center
- using, for uncataloging databases / Using Control Center
- CPU bottlenecks
- resolving / Resolving CPU bottlenecks, How to do it...
- utilities / Utilities
- context switches / Context switches
- crash
- about / Crash recovery
- recovering, steps / How to do it...
- recovery, working / How crash recovery works to ensure database integrity
- database, inspecting / Inspect database
- INSPECT command / Inspect database
- CREATE command / Restrictions on dimensions
- created global temporary table / Using temporary tables
- CREATETAB
- CREATE_EXTERNAL_ROUTINES
- CREATE_NOT_FENCED_ROUTINE
- current mdc rollout mode special register / Rollout
D
- -d option / How to do it...
- D / List history
- DATAACCESS
- database-level authorities
- DBADM / Managing database-level authorities and privileges
- SECADM / Managing database-level authorities and privileges
- CONNECT / Managing database-level authorities and privileges
- BINDADD / Managing database-level authorities and privileges
- CREATETAB / Managing database-level authorities and privileges
- CREATE_EXTERNAL_ROUTINES / Managing database-level authorities and privileges
- CREATE_NOT_FENCED_ROUTINE / Managing database-level authorities and privileges
- IMPLICIT_SCHEMA / Managing database-level authorities and privileges
- LOAD / Managing database-level authorities and privileges
- QUIESCE_CONNECT / Managing database-level authorities and privileges
- DATAACCESS / Managing database-level authorities and privileges
- WLMADM / Managing database-level authorities and privileges
- SQLADM / Managing database-level authorities and privileges
- ACCESSCTRL / Managing database-level authorities and privileges
- database-level authorities and privileges
- Database Connection Services directory / How it works...
- database heap
- about / How to do it...
- database load, snapshot monitor / Database load
- database logging
- configuring / Configuring database logging, How it works...
- database partition groups
- about / Creating database partition groups
- creating / How to do it…
- creating, control center used / Using Control Center, Using Control Center
- creating, command line used / Using the command line, Using the command line
- NAV application's table spaces, creating / Create the NAV application's table spaces
- working / How it works..., How it works...
- altering / Altering database partition groups—adding partitions to database partition groups, How to do it..., Altering database partition groups—removing partitions from a database partition group
- partitions, adding / Altering database partition groups—adding partitions to database partition groups, How to do it...
- control center using, to add partitions / Using Control Center
- command line using, to add partitions / Using the command line
- data redistribution, managing / Managing data redistribution on database partition groups, How to do it...
- data redistribution managing, command line used / Using the command line
- partitions, removing / Altering database partition groups—removing partitions from a database partition group, Removing database partitions
- command line using, to remove partitions / Using the command line
- database partitioning
- database partitions
- advantages / Adding database partitions
- adding, steps / Getting ready
- control center, using to add database partitions / Using Control Center
- command line using, to add database partitions / Using the command line
- working / How it works...
- removing / Removing database partitions
- control center, using to remove database partitions / Using Control Center
- command line, using to remove database partitions / Using the command line
- database recovery
- full database recovery / Full database recovery
- restore option / Getting ready, How it works...
- database backup recovering from, in another logging mode / Attempting to recover from a backup of database in another logging mode
- database recovery, DB2 pureScale environments
- performing / Performing database recovery
- database rollforward recovery
- about / Database rollforward recovery
- performing, steps / How to do it...
- working / How it works...
- database state / Database state after restore
- point-in-time recovery / Point-in-time recovery on a partitioned database
- restore operations, history / History of restore operations, See also
- recovering / Recovering table spaces—full and rollforward recovery, How to do it...
- databases
- creating, from existing backup / Creating a database from an existing backup, How to do it..., How it works...
- Roll-forward recovery / Roll-forward recovery
- redirected restore / Redirected restore
- altering / Altering databases, How to do it…
- Oracle to DB2 / From Oracle to DB2
- quiesce database / Quiesce instance/database
- quiesce instance / Quiesce instance/database
- backup and recovery / Backup and recovery
- standby databases / Standby databases
- dropping / Dropping databases, How it works...
- backup, history / Backup history
- cataloging / Cataloging and uncataloging instances and databases, How to do it...
- uncataloging / Cataloging and uncataloging instances and databases, How to do it...
- control center, using / Using Control Center
- Data definition language (DDL) / Introduction
- Data manipulation language (DML) / Introduction
- data objects information
- querying, table functions used / Querying data objects information using table functions
- data objects monitoring
- data redistribution
- managing, on database partition groups / Managing data redistribution on database partition groups, How to do it...
- data type casting / There's more...
- DATA_ENCRYPT / There's more...
- DB2
- about / Introduction, Introduction, How it works...
- dependencies / Dependencies
- instance level authority / Managing instance-level authorities
- database level authority / Managing instance-level authorities
- DB2 auditing
- about / Auditing DB2
- db2audit facility, configuring / Getting ready
- audit policies, using / Using audit policies
- working / How it works...
- DB2 Connect / Communications with DRDA servers (z/OS and i/OS)
- DB2 Discovery
- using / Using DB2 Discovery, How to do it...
- DB2 ESE software
- installing, with response file option / Install DB2 ESE software with a response file option
- DB2 fault monitor
- about / Using the DB2 fault monitor
- using / How to do it...
- FM_ON parameter / How to do it...
- FM_ACTIVE parameter / How to do it...
- START_TIMEOUT parameter / How to do it...
- STOP_TIMEOUT parameter / How to do it...
- STATUS_TIMEOUT parameter / How to do it...
- STATUS_INTERVAL parameter / How to do it...
- RESTART_RETRIES parameter / How to do it...
- ACTION_RETRIES parameter / How to do it...
- NOTIFY_ADDRESS parameter / How to do it...
- DB2 non-partitioned database
- creating / Creating and configuring DB2 non-partitioned databases, How to do it..., There's more...
- configuring / Creating and configuring DB2 non-partitioned databases, How to do it..., There's more...
- command preview / Command preview
- automatic storage / Automatic storage
- adaptive self-tuning memory / Adaptive self-tuning memory
- file permission, on database objects / File and directory permission on database objects
- directory permission, on database objects / File and directory permission on database objects
- UNIX links / UNIX links
- default codeset / Default codeset
- territory / Territory
- collate, using / Collate using
- control files / Control files
- DB2 pureScale
- about / Introduction
- software components / Introduction
- instance, creating / Creating and managing a DB2 pureScale instance
- instance, configuring / Creating and managing a DB2 pureScale instance
- instance creating, command format / Creating and managing a DB2 pureScale instance
- members, managing / Managing DB2 pureScale members
- members, starting / Starting pureScale members
- caching facilities, managing / Managing the DB2 pureScale caching facilities
- CF server configuration parameters / Managing the DB2 pureScale caching facilities
- UPDATE DBM CFG command / Managing the DB2 pureScale caching facilities
- CF structure configuration parameters / Managing the DB2 pureScale caching facilities
- caching facility, stopping / Stopping the caching facility
- cluster facility, starting / Starting pureScale cluster facilities
- members, in maintenance mode / Put pureScale members in maintenance mode
- environments, monitoring / Monitoring DB2 pureScale environments, Getting ready
- DB2 security
- instance-level authorities, managing / Managing instance-level authorities, Getting ready, How to do it..., How it works...
- database-level authorities and privileges, managing / Managing database-level authorities and privileges, Getting ready, How to do it...
- security administrator authority / Security administrator authority
- object privileges, managing / Managing object privileges, Getting ready, How to do it...
- roles, using / Using roles, Getting ready
- table encryption, using / Using table encryption, How to do it..., How it works...
- data privacy, strengthening with LBAC / Using label-based access control (LBAC) to strengthen data privacy, Getting ready…
- audit / Auditing DB2
- DB2's optimizer
- db2audit facility
- configuring, for different scopes / Getting ready
- auditing scopes, configuring / Configuring auditing scopes
- archive path, configuring / Configure audit data path and archive path:
- audit data path, configuring / Configure audit data path and archive path:
- audit data, extracting / Archiving, formatting, and extracting the audit data:
- audit data, archiving / Archiving, formatting, and extracting the audit data:
- audit data, formatting / Archiving, formatting, and extracting the audit data:
- db2ckbkp
- about / Using db2ckbkp—DB2 check backup tool for backup integrity, Getting ready
- NAV database, backing up / How to do it...
- backups, listing / How to do it...
- backup file, integrity checking / How to do it...
- backup file, corrupting / How to do it...
- backup image, checking / How to do it...
- -h option / There's more...
- DB2COMM
- setting / There's more...
- DB2COMM variable / How to do it...
- db2dart
- about / Using db2dart—DB2 database analysis and reporting tool command, How to do it...
- levels / Using db2dart—DB2 database analysis and reporting tool command
- table level / Using db2dart—DB2 database analysis and reporting tool command
- table space level / Using db2dart—DB2 database analysis and reporting tool command
- database level / Using db2dart—DB2 database analysis and reporting tool command
- table spaces checking, command for / How to do it...
- exporting, in dump COMM table / How to do it...
- table dump / How to do it...
- db2dba
- about / Getting ready
- DB2DETAILDEADLOCK event monitor / How to do it...
- db2diag.log entries / How it works...
- db2instance -list -cf command / Stopping the caching facility
- db2instance -list command / How to do it…
- db2isetup wizard / Creating and managing a DB2 pureScale instance
- db2look utility
- as alternative backup methods / db2move and db2look utilities as alternative backup methods, How to do it..., How it works...
- db2move utility
- as alternative backup methods / db2move and db2look utilities as alternative backup methods, How to do it..., How it works...
- using, to load data / Using db2move to load data
- db2mtrk
- using / Using db2mtrk—DB2 memory tracker
- memory allocation at instance level, identifying / How to do it...
- memory allocation at database level, identifying / How to do it...
- -v switch / How to do it...
- -v option / How to do it...
- memory allocation, for NAV database / How to do it...
- -a option / How to do it...
- -p option / How to do it...
- -d option / How to do it...
- -i option / How to do it...
- -w option / There's more...
- db2pd
- about / Using db2pd—DB2 problem determination tool, How to do it...
- operating system information gathering, command for / How to do it...
- current HADR status, command for / How to do it...
- db2rinh role
- about / Getting ready
- db2rlus role
- about / Getting ready
- db2secad security
- about / Getting ready
- db2support
- using, to collect diagnostic data / Using db2support to collect diagnostic data
- summary description of options, command for / How to do it...
- NAV database information, command for / How to do it...
- starting in interactive mode, command for / How to do it...
- db2users group
- about / Getting ready
- DB2_CF / Getting ready
- DB2_CF system view / Stopping the caching facility
- DB2_CLUSTER_HOST_STATE / Getting ready
- DB2_CLUSTER_HOST_STATE administrative view / How to do it…
- DB2_GET_CLUSTER_HOST_STATE / Getting ready
- DB2_GET_INSTANCE_INFO / Getting ready, How to do it…
- DB2_GET_INSTANCE_INFO table function / Managing DB2 pureScale members
- DB2_INSTANCE_ALERTS / Getting ready
- DB2_MEMBERS / Getting ready
- DB2_PARALLEL_IO
- about / RAID 5 and DB2_PARALLEL_IO
- DBADM
- dbpartitionnum verify command / Using the command line
- DCS database / How it works...
- deadlock and lock timeouts, snapshot monitor / Deadlocks and lock timeouts
- declared global temporary table / Using temporary tables
- decrypt_bin function / How to do it..., How it works...
- decrypt_char function / How to do it...
- default automatic statistics collection
- about / Default automatic statistics collection
- statistics, collecting using statistics profile / Collecting statistics using a statistics profile
- asynchronous stats, collecting / Background stats collecting (asynchronous)
- background stats, collecting / Background stats collecting (asynchronous)
- real-time stats, collecting / Real-time stats collecting (synchronous)
- priority, specifying / Setting priority
- automatic statistics profiling / Automatic statistics profiling
- DEFERRED, MQT / Creating and using materialized query tables
- diagnostic data
- collecting, db2support used / Using db2support to collect diagnostic data
- diagpath
- dimension candidates
- determining, runstats used / Using runstats to determine dimension candidates
- directories / How it works...
- dirty steal BP clean/transaction, snapshot monitor / Dirty steal BP clean/transaction
- DISABLE value / How it works...
- DISCOVER parameter / How it works...
- ENABLE value / How it works...
- DISABLE value / How it works...
- SEARCH value / How it works...
- DISCOVER_DB parameter / How it works...
- DISCOVER_INST / How it works...
- Disk Input/Output
- about / I/O tuning
- Distinct clause / Watch out for...
- DISTRIBUTE BY HASH ( store ) command / Partitioned database
- distribution key / Partitioned database
- distribution keys / Distribution keys
- distribution maps / Distribution maps
- DMS table spaces
- configuring / Creating and configuring DMS table spaces, How to do it..., How it works...
- creating / Creating and configuring DMS table spaces, How to do it..., How it works...
- benefits / Benefits
- DRDA servers
- communications with / Communications with DRDA servers (z/OS and i/OS), How to do it..., How it works...
- DSS
- about / Introduction
- DSS databases
- configuration characteristics / Main configuration characteristics of DSS databases
E
- ENABLE value / How it works...
- ENCRYPT function / How to do it...
- Engine Dispatchable Units (EDU)
- about / How it works...
- environments, DB2 pureScale
- monitoring / Monitoring DB2 pureScale environments, Getting ready
- member states / Getting ready
- about / High availability in DB2 pureScale environments
- CF failure, simulating / Getting ready, How to do it…
- recovery / Backup and recovery in DB2 pureScale environments, How to do it…
- backing up / Backup and recovery in DB2 pureScale environments, How to do it…
- offline database backup, performing / Performing an offline database backup
- online database backup, performing / Performing an online database backup
- restore recovery, performing / Performing a restore and rollforward recovery
- rollforward recovery, performing / Performing a restore and rollforward recovery
- database recovery, performing / Performing database recovery, How it works…
- ERROR, cluster facility state / Getting ready
- ERROR, member state / Getting ready
- event monitor
- about / Configuring and using event monitoring
- table space, creating / How to do it...
- system temporary table space, creating / How to do it...
- DB2DETAILDEADLOCK event monitor / How to do it...
- creating / How to do it...
- activating / How to do it...
- working / How it works...
- event table, unformatted / Unformatted event table
- db2evmonfmt tool, using for reporting / Using the db2evmonfmt tool for reporting
- table space use / Table space use
- tables, pruning / Pruning event monitor tables
- monitor's counters, resetting / Resetting a monitor's counters
- Workload management (WLM) / Workload management (WLM)
- event monitoring / Introduction
- EVMON schema / How to do it..., How it works...
- EXPLAIN PLAN
- using / Using EXPLAIN PLAN, How to do it...
- working / How it works...
- sample output / Sample output
- extent / Block size and extents
F
- F / List history
- Fast Communication Manager (FCM)
- configuring / How to do it...
- FCM
- about / Configuring Fast Communication Manager
- INTRA_PARALLEL database manager parameter / Configuring Fast Communication Manager
- parameters, for controlling / How to do it…
- working / How it works...
- channels issue, monitoring / There's more...
- buffers issue, monitoring / There's more...
- configuring, for optimal performance / Monitoring and configuring FCM for optimal performance
- monitoring, for optimal performance / Monitoring and configuring FCM for optimal performance
- activating, for NAV non-partitioned database / How to do it...
- buffers / How to do it...
- NAV multipartitioned database, connecting to / How to do it...
- controlling, parameters used / How it works...
- fcm_num_buffers parameters / How it works...
- fcm_num_channels parameter / How it works...
- FCMBP
- about / How to do it...
- fcm_num_buffers parameter / How it works...
- fcm_num_channels parameter / How it works...
- federated database
- FM_ACTIVE parameter / How to do it...
- FM_ON parameter / How to do it...
- full table scans / Watch out for...
G
- get authorizations command / There's more...
- gethint function / How to do it...
- global memory parameters
- package cache / How to do it...
- catalog cache / How to do it...
- buffer pools / How to do it...
- Database heap / How to do it...
- log buffer / How to do it...
- Lock Manager Heap / How to do it...
- global temporary table
- creating / Created global temporary table, There's more...
- restrictions / Restrictions
- recovery / Recovery
H
- -help switch / There's more...
- -h option / There's more...
- HADR
- about / How it works..., Introduction
- benefits / Introduction
- restrictions / Introduction
- operations, replicated / Introduction
- operations, not replicated / Introduction
- setting up, command line used / Setting up HADR by using the command line
- configuration, setting up / How to do it...
- IBM DB2 9.7 Enterprise Server Edition (IBM DB2 ESE), installing on nodedb22 / Install IBM DB2 ESE on nodedb22
- table space containers, additional directories creating for / Creating additional directories for table space containers, archive logs, backup, and mirror logs
- log archives, additional directories creating for / Creating additional directories for table space containers, archive logs, backup, and mirror logs
- backup, additional directories creating for / Creating additional directories for table space containers, archive logs, backup, and mirror logs
- mirror logs, additional directories creating for / Creating additional directories for table space containers, archive logs, backup, and mirror logs
- permissions, setting up on new directories / Setting permissions on the new directories
- log archive, configuring / Configuring archive log and mirror log locations
- mirror log locations, configuring / Configuring archive log and mirror log locations
- LOGINDEXBUILD paremeter, configuring / Configuring LOGINDEXBUILD and INDEXREC parameters
- INDEXREC parameter, configuring / Configuring LOGINDEXBUILD and INDEXREC parameters
- primary database, backing up / Backing up the primary database
- database backup, copying to nodedb22 / Copying the database backup to nodedb22
- database NAV, restoring on nodedb22 / Restoring the database NAV on nodedb22
- communication ports, setting up / Setting up HADR communication ports
- parameters, setting up on primary database / Setting up HADR parameters on the primary database
- active hosts, parameters / Setting up HADR parameters on the primary database
- _LOCAL_HOST parameter / Setting up HADR parameters on the primary database
- _REMOTE_HOST parameter / Setting up HADR parameters on the primary database
- communication services, parameters / Setting up HADR parameters on the primary database
- _LOCAL_SVC parameter / Setting up HADR parameters on the primary database
- _REMOTE_SVC parameter / Setting up HADR parameters on the primary database
- remote instances, parameters / Setting up HADR parameters on the primary database
- _REMOTE_INST parameter / Setting up HADR parameters on the primary database
- synchronization mode, parameters / Setting up HADR parameters on the primary database
- _SYNCMODE parameter / Setting up HADR parameters on the primary database
- database restarting, to activae HADR parameters / Setting up HADR parameters on the primary database
- parameters, setting up on standby database / Setting up HADR parameters on the standby database
- starting, on standby database / Starting HADR on standby database
- starting, on primary database / Starting HADR on primary database
- monitoring / Monitoring HADR
- working / How it works…
- _TIMEOUT database configuration parameter / The hadr_timeout and hadr_peer_window database configuration parameters
- _PEER_WINDOW database configuration parameter / The hadr_timeout and hadr_peer_window database configuration parameters
- setting up, control center used / Setting up HADR by using Control Center, Getting ready, How to do it..., How it works...
- synchronization modes / Changing HADR synchronization modes
- automated client rerouting, using / Using automated client rerouting with HADR
- HADR setting up, control center used
- about / Setting up HADR by using Control Center, Getting ready, How to do it..., How it works...
- IBM DB2 ESE, installing / Getting ready
- HADR_LOCAL_HOST parameter / Setting up HADR parameters on the primary database
- HADR_LOCAL_SVC parameter / Setting up HADR parameters on the primary database
- HADR_PEER_WINDOW database configuration parameter / The hadr_timeout and hadr_peer_window database configuration parameters
- HADR_REMOTE_HOST parameter / Setting up HADR parameters on the primary database
- HADR_REMOTE_INST parameter / Setting up HADR parameters on the primary database
- HADR_REMOTE_SVC parameter / Setting up HADR parameters on the primary database
- HADR_SYNCMODE parameter / Setting up HADR parameters on the primary database, Getting ready
- HADR_TIMEOUT database configuration parameter / The hadr_timeout and hadr_peer_window database configuration parameters
- handshake / How it works...
- hard_timeout value / How it works…
- Health Monitor
- about / Using Health Monitor, How to do it..., How it works...
- health indicator settings, configuring / How to do it...
- Instance Settings, configuring / How to do it...
- object settings, configuring / How to do it...
- recommendations, getting for alert / Getting recommendations for an alert
- command line, using to set configuration / Using the command line to check and set configuration, See also
- command line, using to check configuration / Using the command line to check and set configuration, See also
- High Availability Disaster Recovery (HADR)
- history file
- recovering / Recovery history file
- recovering, steps / How to do it...
- db2rhist.asc / Location
- LIST HISTORY command / List history
- database, dropping / Drop database
- database, restoring / Restore database
- hit ratios
- monitoring / Hit ratios and their role in performance improvement
- about / Hit ratios and their role in performance improvement
- buffer pool hit ratios, monitoring / How to do it...
- catalog cache hit ratio, monitoring / How to do it...
- package cache hit ratio, monitoring / How to do it...
- log buffer read hit ratio, monitoring / How to do it...
- working / How it works...
I
- -i option / How to do it...
- I/O tuning
- about / I/O tuning
- transaction logs / I/O tuning
- debugging / I/O tuning
- spindles / I/O tuning
- tables and indexes / I/O tuning
- performing / How to do it...
- log path, checking / How to do it...
- log path, comparing / How to do it...
- log path, changing / How to do it...
- I/O hot spots, checking / How to do it...
- IBMCATGROUP database partition group / How it works...
- IBM DB2 ESE
- installing, as new DB2COPY on nodedb22 / Install IBM DB2 ESE on nodedb22
- IBMDEFAULTBP / IBMDEFAULTBP
- IBMDEFAULTGROUP database partition group / How it works...
- IBMTEMPGROUP database partition group / How it works...
- IMMEDIATE, MQT / Creating and using materialized query tables
- IMPLICIT_SCHEMA
- incremental cumulative database backup
- about / Performing an incremental cumulative database backup
- performing, steps / How to do it...
- working / How it works...
- incremental delta database backup
- about / Performing an incremental delta database backup
- performing, steps / How to do it...
- working / How it works...
- table space name change / Table space name change
- history file, recovering / Recovery history file
- incremental restore
- about / Incremental restore
- performing, steps / How to do it...
- archive log file / Archive log file not associated with the current log sequence
- indexes
- tuning with / Tuning with indexes, How to do it..., How it works...
- sample output / Sample output
- recommendations / Recommendations
- INDEXREC control / Configuring LOGINDEXBUILD and INDEXREC parameters
- INDEXREC parameter, configuring / Configuring LOGINDEXBUILD and INDEXREC parameters
- INSPECT command / Inspect database
- instance
- configuring, for multipartitioned environments / Creating and configuring an instance for multipartitioned environments
- home sharing, by setting up NFS / Set up NFS for sharing the instance home
- owner, creating / Creating the instance owner and fenced user
- fenced user, creating / Creating the instance owner and fenced user
- starting / Starting and stopping instances, How it works...
- stopping / Starting and stopping instances, How it works...
- listing / Listing and attaching to instances, Listing instances
- attaching to / Attaching to instances
- dropping / Dropping instances, How it works...
- instance, DB2 pureScale
- creating / Creating and managing a DB2 pureScale instance
- configuring / Creating and managing a DB2 pureScale instance
- creating, command format / Creating and managing a DB2 pureScale instance
- instance-level authorities
- managing / Managing instance-level authorities, Getting ready, How to do it...
- SYSADM / Getting ready
- SYSCTRL / Getting ready
- SYSMAINT / Getting ready
- SYSMON / Getting ready
- operating groups, creating / How to do it...
- users, creating / How to do it...
- assigning, to users / How to do it...
- working / How it works...
- instances
- creating, for non-partitioned environments / Creating and configuring instances for non-partitioned environments, Getting ready, How to do it..., How it works...
- configuring, for non-partitioned environments / Creating and configuring instances for non-partitioned environments, Getting ready, How to do it..., How it works...
- cataloging / Cataloging and uncataloging instances and databases, How to do it...
- uncataloging / Cataloging and uncataloging instances and databases, How to do it...
- control center, using / Using Control Center
- inter-partition command execution
- communication, configuring for / Configuring communication for inter-partition command execution
- INTRA_PARALLEL database manager parameter / Configuring Fast Communication Manager
K
- kernel parameters
- SHMMAX / How to do it...
- SHMALL / How to do it...
- kernel.sem / How to do it...
- kernel.msgmni / How to do it...
- kernel.msgmax / How to do it...
- kernel.msgmnb / How to do it...
- modifying / How to do it...
L
- LBAC
- used, for strengthening data privacy / Using label-based access control (LBAC) to strengthen data privacy, Getting ready…
- about / Using label-based access control (LBAC) to strengthen data privacy
- security label component, creating / Creating security label components
- security component types / Creating security label components
- set components / Creating security label components
- array elements / Creating security label components
- tree elements / Creating security label components
- security policies / Defining security policies
- security labels, creating / Creating security labels
- read and write access rules, modifying using exemptions / Modifying read and write access rules by using exemptions
- working / How it works...
- additional information / There's more…
- LIST HISTORY command / List history
- LOAD
- LOAD utility / LOAD with care
- LOB columns / Introduction
- local database directory / How it works...
- Lock Manager Heap
- about / How to do it...
- lock wait time, snapshot monitor / Lock wait time
- log archive
- configuring / Configuring archive log and mirror log locations
- LOGARCHMETH1 variable / Attempting to recover from a backup of database in another logging mode
- log buffer
- about / How to do it..., Log buffer
- log buffer read hit ratio
- monitoring / How to do it...
- LOGBUFSZ / Configuring archive log and mirror log locations
- log cacheup / How it works…
- logging
- about / Using logging and nologging modes
- considerations / Getting ready
- LOGINDEXBUILD paremeter, configuring / Configuring LOGINDEXBUILD and INDEXREC parameters
- logpath
- about / Logpath
M
- maintenance mode
- DB2 pureScale members, putting in / Put pureScale members in maintenance mode
- Materialized Query Table (MQT) / Watch out for...
- MDC
- about / Introduction
- tables, using / Creating and using MDC tables and block-based indexes, How to do it..., How it works...
- tables, creating / Creating and using MDC tables and block-based indexes, How to do it..., How it works...
- block-based indexes, using / Creating and using MDC tables and block-based indexes, How to do it..., How it works...
- block-based indexes, creating / Creating and using MDC tables and block-based indexes, How to do it..., How it works...
- block indexes / Block indexes and aggregate functions in queries
- aggregate functions / Block indexes and aggregate functions in queries
- block size / Block size and extents
- extents / Block size and extents
- dimension candidates determining, runstats used / Using runstats to determine dimension candidates
- dimension restrictions / Restrictions on dimensions
- rollout / Rollout
- members, DB2 pureScale
- managing / Managing DB2 pureScale members
- starting / Starting pureScale members
- putting, in maintenance mode / Put pureScale members in maintenance mode
- states / Getting ready
- member state, DB2 pureScale
- STARTED / Getting ready
- STOPPED / Getting ready
- RESTARTING / Getting ready
- WAITING_FOR_FAILBACK / Getting ready
- memory structure, cluster facility state
- areas / Monitoring cluster facility memory structures
- GBP memory area / Monitoring cluster facility memory structures
- locking memory area / Monitoring cluster facility memory structures
- memory, used for locking / Monitoring cluster facility memory structures
- memory, for shared communication area / Monitoring cluster facility memory structures
- global buffer pool memory allocation, monitoring / Monitoring cluster facility memory structures
- memory utilization
- tuning / Tuning memory utilization, Getting ready, How to do it...
- Fast Communication Manager (FCM), configuring / How to do it...
- working / How it works...
- AUTOCONFIGURE command, using / AUTOCONFIGURE
- memory visualizer
- about / Using Memory Visualizer
- invoking, from command line / How to do it...
- refresh rate, configuring / How to do it...
- database global memory, checking for / How to do it...
- self-tuning memory / Self tuning memory management
- mirror log locations
- configuring / Configuring archive log and mirror log locations
- mixed processing databases
- configuration characteristics / Main configuration characteristics of mixed processing databases
- monitoring
- about / Introduction
- system monitoring / Introduction
- snapshot monitoring / Introduction
- event monitoring / Introduction
- mon_heap_sz / How to do it...
- MQT
- about / Introduction
- creating / Creating and using materialized query tables, How to do it...
- using / Creating and using materialized query tables, How to do it...
- DEFERRED / Creating and using materialized query tables
- IMMEDIATE / Creating and using materialized query tables
- refreshing / Refresh deferred
- system maintained / Maintained by system/user
- user maintained / Maintained by system/user
- query rewrites / Query rewrites
- combining, with table partitioning / Combining with table partitioning
- and database partitioning, replacing / Replicated MQTs and database partitioning
- MS Windows
- non-partitioned database, converting to multipartitioned database / Converting a non-partitioned database to a multipartitioned database on MS Windows, How to do it..., There's more...
- multipartiotioned database
- buffer pools, managing / Managing buffer pools in a multipartitioned database, How to do it..., How it works...
- multipartitioned database
- creating / Creating and configuring a multipartitioned database, How to do it...
- configuring / Creating and configuring a multipartitioned database, How to do it...
- non-partitioned database converting to, on MS Windows / Converting a non-partitioned database to a multipartitioned database on MS Windows, How to do it..., There's more...
- multipartitioned environments
- instances, configuring for / Creating and configuring an instance for multipartitioned environments
N
- nav.comm table
- about / How to do it...
- NAV application's table spaces
- creating / Create the NAV application's table spaces
- NAVDATAGRP database partition group / There's more…
- NAV multipartitioned database / How to do it...
- NAV_INDX table space / Getting ready
- NAV_TBLS table space / Using the command line, Getting ready
- NEARSYNC mode / Getting ready, How it works...
- NEARSYNC synchronization mode
- changing to / Changing to NEARSYNC synchronization mode
- network connections
- about / Configuring network communications, How to do it...
- control center, using / Using Control Center
- newlogpath database parameters
- about / Logpath
- NFS
- setting up, for sharing instance home / Set up NFS for sharing the instance home
- NODE21 instance node / Using Control Center
- nodedb21 / Getting ready, Using the command line to perform a takeover by force
- nodedb22 / Getting ready, Using the command line to perform a takeover
- database backup, copying / Copying the database backup to nodedb22
- database NAv, restoring / Restoring the database NAV on nodedb22
- node directory / How it works...
- nodes
- configuring / Configuring the nodes
- non-partitioned database
- converting, to multipartitioned database on MS Windows / Converting a non-partitioned database to a multipartitioned database on MS Windows, How to do it..., There's more...
- non-partitioned environments
- instances, creating / Creating and configuring instances for non-partitioned environments, Getting ready, How to do it..., How it works...
- instances, configuring / Creating and configuring instances for non-partitioned environments, Getting ready, How to do it..., How it works...
- non-partitioned indexes / Non-partitioned indexes
- NONRECOVERABLE option / LOAD with care
- NOTIFY_ADDRESS parameter / How to do it...
- NOT LOGGED INITIALLY attribute / LOAD with non-recoverable option
- NOT LOGGED INITIALLY option / Introduction
- numdb parameter / How to do it...
O
- Obj / List history
- object privileges
- managing / Managing object privileges, Getting ready, How to do it...
- object statistics
- offline backup
- about / Performing an offline database backup
- performing, steps / How to do it...
- working / How it works...
- backup image / How it works...
- performing / There's more...
- naming convention, backing up / Backup naming convention
- partitioned database / Partitioned database
- recovering from / Recovery from offline backup
- offline database backup, DB2 pureScale environments
- performing / Performing an offline database backup
- OLTP
- about / Introduction
- OLTP databases
- configuration characteristics / Main configuration characteristics of OLTP databases
- online database backup
- performing, steps / How to do it...
- working / How it works...
- resource usage / Resource usage
- restrictions / Restrictions
- backup, pending / Backup pending
- online database backup, DB2 pureScale environments
- performing / Performing an online database backup
- Op / List history
- operating system
- tuning / Operating system tuning, How to do it...
- major components / Operating system tuning
- working / How it works...
- virtual storage / Virtual storage
- file system caching, disabling on table process / Disabling file system caching on table spaces
- historic record, maintaining / Maintaining a historic record
- operating system components
- kernel parameters / Operating system tuning
- paging / Operating system tuning
- Input/Output / Operating system tuning
- CPU / Operating system tuning
- Network / Operating system tuning
- OperationB / List history
- Oracle to DB2
- shutdown instance / Startup/shutdown instance
- startup instance / Startup/shutdown instance
- shutdown database / Startup/shutdown database
- startup database / Startup/shutdown database
- database file containers / Database file containers
- log files / Log files
P
- -p option / How to do it...
- p (table space) / List history
- package cache
- about / How to do it..., Package cache
- package cache hit ratio
- monitoring / How to do it...
- package cache inserts/transaction, snapshot monitor / Package cache inserts/transaction
- parallelism
- using / Using parallelism, How to do it...
- working / How it works...
- partitioned database
- rollout / Partitioned database
- partitioned indexes / Partitioned indexes
- partitioned table / Partitioned table
- partition groups / Partition groups
- partitioning
- about / Introduction
- PAYMENT table / How to do it...
- PCTDEACTIVATE option / Table space use
- PEER, cluster facility state / Getting ready
- piped sort
- about / Piped sorts
- point-in-time recovery / Point-in-time recovery on a partitioned database
- POS_MON table space / How to do it...
- primary database
- backing up / Backing up the primary database
- HADR parameters, setting up / Setting up HADR parameters on the primary database
- HADR, starting / Starting HADR on primary database
- production statistics
- importing / Importing production statistics
Q
- QUIESCE_CONNECT
R
- R / List history
- RAID 5
- about / RAID 5 and DB2_PARALLEL_IO
- RAID configuration
- about / RAID 5 and DB2_PARALLEL_IO
- RDMA / How it works…
- read-only mode
- standby database, opening / Opening the standby database in read-only mode, How to do it…
- read-only standby open mode
- restrictions / There's more...
- read and write access rules
- modifying, exemptions used / Modifying read and write access rules by using exemptions
- recovery, DB2 pureScale environments / Backup and recovery in DB2 pureScale environments
- REDIRECT clause / How it works...
- redirected restore
- about / Redirected restore
- performing, steps / How to do it...
- ABORT clause / ABORT
- REFRESH TABLE command / How it works...
- Reorgchk
- about / Reorgchk
- REPLACE_CREATE command / Restrictions on dimensions
- REPLACE_CREATE option / Using db2move to load data
- RESTARTING, cluster facility state / Getting ready
- RESTARTING, member state / Getting ready
- RESTART_RETRIES parameter / How to do it...
- restore recovery, DB2 pureScale environments
- performing / Performing a restore and rollforward recovery
- RID (regular) index update operation / Rollout
- role
- using, in DB2 security / Using roles, Getting ready
- about / Using roles
- db2rlus / Getting ready
- db2rinh / Getting ready
- creating / Getting ready
- granting, to db2rlus group / Getting ready
- revoking / Getting ready
- creating, WITH ADMIN OPTION used / Creating roles using the WITH ADMIN OPTION
- rollforward command / Archive log file not associated with the current log sequence, How to do it...
- rollforward pending mode / Database state after restore
- rollforward recovery, DB2 pureScale environments
- performing / Performing a restore and rollforward recovery
- rollout operation / Rollout
- rows read/rows selected, snapshot monitor / Rows read/rows selected
- RUNSTATS utility / Using runstats to determine dimension candidates
- RUNSTAT utility
S
- SEARCH value / How it works...
- SECADM
- seclabel_by_name function / Creating security labels
- security administrator authority
- about / Security administrator authority
- security label component
- about / Creating security label components
- creating / Creating security label components
- security labels
- creating / Creating security labels
- security policies
- about / Defining security policies
- creating / Defining security policies
- select command / Creating security labels
- Selected database partitions listbox / Using Control Center
- Self-tuning memory
- about / Tuning memory utilization
- in partitioned database environments / Self-tuning memory in partitioned database environments
- self tuning buffer pools
- using / Using self tuning buffer pools
- SESSION.TMP_INVCDET table / How it works...
- SET PROFILE clause / Collecting statistics using a statistics profile
- set security label components
- about / Creating security label components
- creating / Creating security label components
- SMS table spaces
- configuring / Creating and configuring SMS table spaces, How to do it..., How it works...
- creating / Creating and configuring SMS table spaces, How to do it..., How it works...
- space allocation / Space allocation, Space allocation
- tables and objecrs / Tables and objects
- filesystem caching / Filesystem caching, Filesystem caching
- limits / Limits
- raw partitions / Raw partitions
- tables and objects / Tables and objects
- extent size / Extent size
- prefetch size / Prefetch size
- striping strategy / Striping strategy
- high water mark / High water mark
- snapshot monitor
- about / Configuring and using snapshot monitoring, How to do it...
- executing, on database / How to do it...
- executing, on table spaces / How to do it...
- executing, on application / How to do it...
- executing, on dynamic SQLs / How to do it...
- database load / Database load
- buffer pool hit ratios / Buffer pool hit ratios
- buffer pool physical reads and writes, per transaction / Buffer pool physical reads and writes per transaction
- sorting time, average / Average sorting time
- sorting time, per transaction / Sorting time per transaction
- lock wait time / Lock wait time
- deadlock and lock timeouts / Deadlocks and lock timeouts
- Rows read/rows selected / Rows read/rows selected
- dirty steal BP clean/transaction / Dirty steal BP clean/transaction
- package cache inserts/transaction / Package cache inserts/transaction
- average log writes/transaction / Average log writes/transaction
- snapshot monitoring / Introduction
- sorting
- tuning / Tuning sorting, How to do it...
- average sort time / How to do it...
- sort time per transaction / How to do it...
- average sort overflows / How to do it...
- working / How it works...
- practices, coding / Coding practices
- sorting time, snapshot monitor
- average / Average sorting time
- per transaction / Sorting time per transaction
- sort overflows
- about / Sort overflows
- SortsPerTransaction / How to do it...
- sort time per transaction
- about / How to do it...
- spindles
- about / I/O tuning
- SQL2154N error message / How to do it...
- SQLADM
- SSH
- setting up, for client authentication / Set up SSH for client authentication
- SSL
- configuring, for client-server instance communication / Configuring SSL for client-server instance communication, How to do it...
- about / Configuring SSL for client-server instance communication
- standby database
- about / Introduction
- HADR parameters, setting up / Setting up HADR parameters on the standby database
- HADR, starting / Starting HADR on standby database
- standby database, read-only mode
- opening, in read-only mode / Opening the standby database in read-only mode, How to do it…
- instance, restarting / How to do it…
- NAV standby database, connecting to / How to do it…
- HADR, stopping / How to do it…
- HADR, starting / How to do it…
- STARTED, member state / Getting ready
- START_TIMEOUT parameter / How to do it...
- statistics profile
- STATUS_INTERVAL parameter / How to do it...
- STATUS_TIMEOUT parameter / How to do it...
- STOPPED, cluster facility state / Getting ready
- STOPPED, member state / Getting ready
- STOP_TIMEOUT parameter / How to do it...
- storage must be defined state / How it works...
- SVCENAME port numbers / How to do it...
- synchronization modes, HADR
- about / Changing HADR synchronization modes
- NEARSYNC synchronization mode, changing to / Changing to NEARSYNC synchronization mode
- SYNC synchronization mode, changing to / Changing to SYNC synchronization mode
- ASYNC synchronization mode, changing to / Changing back to ASYNC synchronization mode
- description / How it works...
- SYNC / How it works...
- NEARSYNC / How it works...
- ASYNC / How it works...
- synchronous stats
- collecting / Real-time stats collecting (synchronous)
- SYNC mode / Changing HADR synchronization modes, How it works...
- SYNC synchronization mode
- changing to / Changing to SYNC synchronization mode
- SYSADM(system administration authority) / Getting ready
- SYSCTRL(system control authority) / Getting ready
- SYSMAINT(system maintenance authority) / Getting ready
- SYSMON(system monitoring authority) / Getting ready
- system database directory / How it works...
- system information
- querying, table functions used / Querying system information using table functions
- system monitoring / Introduction
- about / Configuring and using system monitoring, How to do it...
- system information querying, table functions used / Querying system information using table functions
- activity information querying, table functions used / Querying activity information using table functions
- data objects information querying, table functions used / Querying data objects information using table functions
- system temporary table spaces
- using / Using system temporary table spaces, How to do it...
- reorgs / Reorgs
- page size / Page size for temporary table space
T
- table
- loading / Loading a table
- table encryption
- using, in DB2 security / Using table encryption, How to do it..., How it works...
- using, demonstrating / Getting ready
- table function (interfaces), for monitoring cluster facilities
- DB2_GET_CLUSTER_HOST_STATE / Getting ready
- DB2_GET_INSTANCE_INFO / Getting ready
- DB2_CLUSTER_HOST_STATE / Getting ready
- DB2_CF / Getting ready
- DB2_INSTANCE_ALERTS / Getting ready
- table function (interfaces), for monitoring members
- DB2_GET_CLUSTER_HOST_STATE / Getting ready
- DB2_GET_INSTANCE_INFO / Getting ready
- DB2_CLUSTER_HOST_STATE / Getting ready
- DB2_MEMBERS / Getting ready
- DB2_INSTANCE_ALERTS / Getting ready
- table functions
- used, for querying system information / Querying system information using table functions
- used, for querying activity information / Querying activity information using table functions
- used, for querying data objects information / Querying data objects information using table functions
- about / Table functions and administrative views
- table partitioning
- about / Implementing table partitioning
- implementing, steps / How to do it..., How it works...
- scalability / Scalability
- non-partitioned indexes / Non-partitioned indexes
- partitioned indexes / Partitioned indexes
- storage strategies / Storage strategies
- adding / Adding a partition to a table
- detecting / Detach a partition from a table
- table partition key
- about / The table distribution key and its role in a multipartitioned environment
- command line using / Using the command line
- working / How it works...
- tablespace backup
- about / Backing up table spaces
- performing, steps / How to do it...
- working / How it works...
- online tablespace backups, incompatible operations / Operations incompatible with online table space backups
- table space containers / Table space containers
- table spaces
- within automatic storage databases, configuring / Creating and configuring table spaces within automatic storage databases, How to do it...
- within automatic storage databases, creating / Creating and configuring table spaces within automatic storage databases, How to do it...
- altering / Altering table spaces and dropping table spaces, How to do it…, How it works...
- dropping / Altering table spaces and dropping table spaces, How to do it…, How it works..., Dropping table space
- container management / Container management
- size management / Size management
- physical characteristics / Physical characteristics
- performance characteristics / Performance characteristics
- in multipartitioned environment / Table spaces in a multipartitioned environment, There's more...
- distribution maps / Distribution maps
- distribution keys / Distribution keys
- table space containers / Table space containers
- partition groups / Partition groups
- state / Table space state
- storage paths, in utomatic storage-partitioned database / Storage paths in an automatic storage-partitioned database
- recovering / Recovering table spaces—full and rollforward recovery, How to do it...
- table_access security policy / Creating security labels
- takeover operation
- performing / Performing takeover and takeover by force
- by force / Performing takeover and takeover by force
- from NAV primary to NAV standby / Getting ready, Using Control Center
- performing, control center used / Using Control Center
- performing, command line used / Using the command line to perform a takeover
- by force performing, command line used / Using the command line to perform a takeover by force
- tape-based backup
- configuring, TSM used / Configuring tape-based backup with IBM Tivoli Storage Manager, How to do it..., How it works...
- TCP/IP
- configuring / Getting ready
- temporary tables
- about / Using temporary tables, How it works...
- transaction logging
- transaction logs
- about / I/O tuning, There's more...
- transfer ownership
- about / Getting ready
- tree security label components
- creating / Creating security label components
- TSM
- about / Configuring tape-based backup with IBM Tivoli Storage Manager
- used, for configuring tape-based backup / Configuring tape-based backup with IBM Tivoli Storage Manager, How to do it..., How it works...
- partitioned database environment / Partitioned environment
- TSM Application program interface (API) / Configuring tape-based backup with IBM Tivoli Storage Manager
U
- USER-DEFINED temporary table / Using temporary tables
- USERSPACE1 table space / How it works...
- user temporary table spaces
- UTIL_IMPACT_PRIORITY 20 clause / Resource usage
V
- -v option / How to do it...
- -v switch / How to do it...
- vmstat command / Context switches
W
- -w option / There's more...
- WAITING_FOR_FAILBACK, member state / Getting ready
- WITH ADMIN OPTION
- used, for creating role / Creating roles using the WITH ADMIN OPTION
- WLMADM
- Workload management (WLM)
- Workload Management Administrator (WLMADM) authority / How to do it...
Z
- z/OS operating system database / How it works...