Index

• access plan
• AGENTPRI parameter
• ASLHEAPSZ parameter
• asterisk (*) wildcard character
• asynchronous page cleaners

• benchmarking tool (1), (2)
• buffer pools
  • definition and purpose
  • memory allocation
• buffering
  • advantages
  • double

• cache, clearing
• caching
  • dynamic SQL
  • Windows system
• CandleNet Command Center
  • enabling historical collection
• cardinality
• CHNGPGS_THRESH parameter
• circular logging, definition and purpose
• Classic REORG
• clustered index
• Cold Backup
• COLLECT STATISTICS clause
• connection
  • inbound
  • outbound
  • pooling
• containers, definition and purpose
• control block information
• controllers, using separate
• COUNT and SKIP
• CPU utilization
• CURRENT DEGREE special register

• daily health checks
• data integrity, importance of logs
• data size, calculating
• data warehouse ratio
• Database Managed Space (DMS) table space
• database parameters
• databases
  • configuration parameters
  • heap
  • reorganization
• DB2 Control Center
• DB2BATCH
• db2batch tool
• db2empfa command
• DB2NTNOCACHE option
• DB2SET command
• DBHEAP parameter
• DEGREE bind option
• deployment
  • configuring your warehouse
  • installing additional agents
  • installing infrastructure components
  • installing your first agents
  • post-installation checklist
  • pre-installation checklist
• deployment task estimates
  • agents
  • deployment
  • fix packs
  • policies and workflows
  • situations
  • skills transfer
  • Summarization and Pruning agent
  • Tivoli Enterprise Console integration
  • Tivoli Universal Agent
  • Warehouse Proxy agent
  • Windows and UNIX environments
  • workspaces
  • z/OS servers
• DFT_DEGREE parameter
• disk I/O, minimizing
• disk space, calculating
• disks, drives
• documentation
  • See publications
• DSS ratio

• education
  • offerings
• EIB
• EIF Probe
• Enable Multipage File Allocation tool
• Enterprise Information Base
• explicit rebind

• file system caching
• firewall gateway
  • configuration
  • determine if you require
• Firewall gateway
• FLUSH PACKAGE CACHE statement
• fragmentation

• GET SNAPSHOT command
• GROUP BY clause

• hardware design
• hash JOINs
• health checks
  • daily
  • monthly
  • quarterly
  • weekly
• heaps (1), (2)
• heartbeat
  • tracking
• heartbeat interval
  • CTIRA_HEARTBEAT environment variable
  • performance issues
  • setting the interval
• heartbeat monitoring
  • CTIRA_HEARTBEAT environment variable
  • performance issues
  • setting the interval
• high availability and disaster recovery
  • agent and remote monitoring server considerations
  • hub monitoring server considerations
  • portal server considerations
  • Summarization and Pruning agent considerations
  • Tivoli Data Warehouse considerations
  • Warehouse Proxy agent considerations
• high speed link
• host variables

• I/O, minimizing (1), (2)
• I/O operations, parallel
• IBM Tivoli Monitoring
  • component status, monitoring
  • heartbeat monitoring
• IBM Tivoli Monitoring 5.x Endpoint
• implicit rebind
• In-Place REORG
• inbound connection
• indexes
  • cardinality
  • clustered
  • columns
  • dropped
  • extensive updates
  • new (1), (2)
  • perfectly ordered
  • rebuilt, reorganizing with REORG
  • statistics (1), (2)
  • synchronized statistics
• install
  • See deployment
• integrity, data
• INTRA_PARALLEL parameter
• IP PIPE
• IP SPIPE

• KHD_CNX_POOL_SIZE environment variable

• large environments
• large-scale deployment
• libraries
  • IBM Tivoli Monitoring
• link, high speed
• LOBs, DB2
• lock list
• LOCKLIST parameter
• Log Buffer parameter
• log retain logging, definition and purpose
• LOGBUFSZ parameter (1), (2)
• LOGFILSIZ parameter (1), (2)
• logging
  • circular
  • definition and purpose
  • log retain
  • mirroring
  • performance
  • records
• LOGPRIMARY parameter

• mainframe
  • deployment considerations
• maintenance (1), (2)
  • post-upgrade
  • pre-upgrade
• maintenance utilities for the database
• MAX_QUERYDEGREE parameter
• MAXLOCKS parameter
• medium environments
• memory
  • accessing
  • allocation
  • buffer pools
  • DB2 model
  • organization
  • parameters
  • tuning
• MINCOMMIT parameter
• mirroring log files
• Monitoring components
  • Firewall gateway
  • IBM Tivoli Monitoring 5.x Endpoint
  • Netcool/OMNIbus integration
  • Summarization and Pruning agent
  • Tivoli Data Warehouse
  • Tivoli Enterprise Console integration
  • Tivoli Enterprise Monitoring Agent
  • Tivoli Enterprise Monitoring Server
  • Tivoli Enterprise Portal client
  • Tivoli Enterprise Portal Server
  • Tivoli Universal Agent
  • Warehouse Proxy agent
• monitoring server
  • heartbeat interval, configuring
• monthly health checks
• motherboard
• MPP (Massively Parallel Processors)
• multiple nodes

• naming conventions
• Netcool/OMNIbus integration
• network, monitoring bandwidth
• NOCACHE option
• nodes, multiple
• non-sequential physical data pages
• NUM_IOCLEANERS parameter
• NUM_IOSERVERS parameter

• ODBC
• OLTP ratio
• ONLY ON KEY COLUMNS clause
• OPAL documentation
• Open Database Connectivity
• optimizer
  • access plan creator
  • intra-partition parallelism determination
  • purpose
  • statement binding with dynamic SQL
  • statistics influence
• OS Cluster

• packages
  • cache for dynamic and static SQL
  • invalid
  • static SQL
• page cleaners, asynchronous
• paging and swapping
• parallel I/O operations
• PCKCACHESZ parameter
• performance tuning for DB2 databases
• physical data pages, non-sequential
• placing components
• planning
  • See pre-deployment
• pooling, connection
• post-deployment
  • applying maintenance
  • maintenance
• post-installation
• post-upgrade
• pre-deployment
  • accelerating
  • additional ports
  • agent deployments
  • firewall gateway determination
  • high availability and disaster recovery
  • Monitoring component placement
  • multi-hub environments
  • planning checklist
  • platform support matrix
  • project management and planning
  • remote deployment
  • sizing your Tivoli Monitoring hardware
  • staffing
  • task estimates
  • Tivoli Universal Agent deployments
  • understanding your network
• pre-installation
• prefetch
  • definition
  • list
  • list sequential
  • quantity
  • sequential
• processor configurations
• product documentation
• project management and planning
• publications
  • OPAL
  • Redbooks
  • related
  • Technotes
  • types

• quarterly health checks
• queries
• queue delays, causes

• RAID device
• ratios, scaling up
• raw data size, calculating
• read operations, excessive
• REBIND utility
  • place in order of utilities
  • purpose
  • SQL types supported
• rebinding, explicit and implicit
• recovery, roll-forward
• Redbooks (1), (2), (3)
• REDISTRIBUTE DATABASE PARTITION GROUP utility
• registry variables (1), (2)
• remote deployment
• REORG utility
  • classic
  • In-Place
  • types
• resources
  • education
  • education offerings
  • IBM Tivoli Monitoring 6 Welcome Kit
  • other
  • product documentation
  • Redbooks
  • service offerings
  • support Web sites
• response time, delayed
• roll-forward recovery
• RUNSTATS utility
  • formats
  • list of purposes
  • options
  • precaution

• SAMPLE DETAILED clause
• scalability (1), (2), (3)
• scaling up ratios
• seek time
• sequential prefetch
• SET RUNTIME DEGREE command
• sharing
  • customization
• SHEAPTHRES parameter
• size of raw data, calculating
• SKIP and COUNT
• small environments
• SMP (Symmetric Multiprocessor)
• sockets
• SORTHEAP parameter (1), (2), (3)
• SQL
  • dynamic
  • optimizer
  • static
  • types
• staffing
• Star JOINs
• statistics
  • collected for RUNSTATS
  • comparing current and previous
  • distribution
  • index
  • queries
  • types of collections
• Summarization and Pruning agent
  • configuration
  • considerations
  • deployment task estimates
  • high availability and disaster recovery considerations
• support Web sites
• swapping
• switches
• system caching, files
• System Managed Space (SMS) table space

• table spaces
  • containers
  • definition and purpose
  • multiple page sizes
  • types
• TCP
• Technotes
• throughput (1), (2), (3)
• Tivoli Data Warehouse
  • high availability and disaster recovery considerations
  • sharing
• Tivoli Enterprise Console integration
  • deployment task estimates
• Tivoli Enterprise Monitoring Agent
  • deployment task estimates
  • installing
• Tivoli Enterprise Monitoring Server
  • changing configuration settings
  • high availability and disaster recovery considerations
  • hub considerations
  • multiple hub considerations
  • remote considerations
  • remote high availability and disaster recovery considerations
  • using remote monitoring servers with Universal Agents
• Tivoli Enterprise Portal client
  • considerations
• Tivoli Enterprise Portal Server
  • considerations
  • high availability and disaster recovery considerations
• Tivoli Monitoring environment
  • additional ports used
  • changing monitoring server configuration settings
  • components
  • configuration checklist
  • customizing your environment
  • enabling historical collection
  • installing components
  • maintenance
  • platform support matrix
  • sizing your hardware
• Tivoli Universal Agent
  • deployment considerations
  • deployment task estimates
  • deployment versioning considerations
  • firewall considerations
  • large-scale deployment
  • using with remote monitoring servers
• tools
  • benchmarking
  • db2batch
  • Enable Multipage File Allocation
  • Event Monitor
  • Explain Facility
  • monitoring
  • Snapshot Monitor
• transactions (1), (2)
• tuning
  • DB2 performance on Windows, UNIX, and Linux
  • guidelines
• tuning parameters
  • AGENTPRI
  • ASLHEAPSZ
  • CHNGPGS_THRESH
  • DBHEAP
  • DFT_DEGREE
  • INTRA_PARALLEL
  • LOCKLIST
  • LOGBUFSZ
  • LOGFILSIZ
  • LOGPRIMARY
  • MAX_QUERYDEGREE
  • MAXLOCKS
  • NUM_IOCLEANERS
  • NUM_IOSERVERS
  • PCKCACHESZ
  • SHEAPTHRES
  • SORTHEAP

• Uni-Processor
• UNIX environment
• upgrade
  • steps
• utilization, CPU

• variables, host
• versioning

• Warehouse load projection spreadsheet
• Warehouse Proxy agent
  • configuration
  • considerations
  • deployment task estimates
  • high availability and disaster recovery considerations
  • Warehouse load projection spreadsheet
• weekly health checks
• WHERE clause
• Windows environment
• work
  • roll-forward recovery
  • rollbacks

• z/OS server

[ Top of Page | Previous Page | Contents | Index ]