DB2 solution Information Center home
Overview of the DB2 technical information
DB2 troubleshooting information
DB2 PDF and printed documentation
Printing topics and subtopics
Documentation updates
Updates available for download
Updating the DB2 Information Center
Manually updating the Information Center
Updating the Workstation version of the DB2 Information Center
Mirroring the update site
Features of the DB2 Information Center
DB2 Information Center installation options
Starting the DB2 Information Center
Starting and stopping the Workstation version of the DB2 Information Center
Navigating in the information center
Using the Index view to access topics in the Information Center
Searching the Information Center
Setting bookmarks in the information center
Accessing different versions of the DB2 Information Center
Setting the location for accessing the DB2 Information Center
Displaying topics in your preferred language
Accessibility
Keyboard shortcuts and accelerators
Accessing help from a DB2 tool, window, wizard or advisor
Terms and Conditions
Tutorials
Standards compliance
Dotted decimal syntax diagrams
Release Notes
Notices
Contacting IBM
Ordering printed DB2 books
Invoking SQL state help from the command line
Overview of the DB2 technical information
DB2 troubleshooting information
DB2 PDF and printed documentation
Printing topics and subtopics
Documentation updates
Updates available for download
Updating the DB2 Information Center
Manually updating the Information Center
Updating the Workstation version of the DB2 Information Center
Mirroring the update site
Features of the DB2 Information Center
DB2 Information Center installation options
Starting the DB2 Information Center
Starting and stopping the Workstation version of the DB2 Information Center
Navigating in the information center
Using the Index view to access topics in the Information Center
Searching the Information Center
Setting bookmarks in the information center
Accessing different versions of the DB2 Information Center
Setting the location for accessing the DB2 Information Center
Displaying topics in your preferred language
Accessibility
Keyboard shortcuts and accelerators
Accessing help from a DB2 tool, window, wizard or advisor
Terms and Conditions
Tutorials
Standards compliance
Dotted decimal syntax diagrams
Release Notes
Notices
Contacting IBM
Ordering printed DB2 books
Invoking SQL state help from the command line
Product overviews
DB2 Database for Linux, UNIX, and Windows
DB2 features and functions by edition
Common licensing questions
Development and test licenses
Entitlement by processor or users
Entitlement by limited use virtual server
Entitlement by limited use socket
Processor value unit pricing
Memory usage restrictions for DB2 Express Edition and Workgroup Server Edition
Licensing for high availability
End of marketing and end of support dates
Release notes
What's New overview
New features and functionality
Product packaging enhancements
Component names have changed
Compression enhancements
XML data stored in the XML storage object of tables can be compressed
Temporary tables can be compressed
Indexes can be compressed
Data replication source tables can be compressed
Manageability enhancements
Existing databases can now use automatic storage
Automatic storage supports dropping storage paths and rebalancing table spaces
Reclaiming unused space from table spaces is supported
Reclaiming space from MDC tables has been enhanced
Enhanced access to DB2 administration commands through SQL
Table data can be moved online using a new stored procedure
Table space capacity for large and temporary table spaces has increased
Distribution map supports larger data warehouses
Database partition servers are online immediately after being added to an instance
DESCRIBE command provides additional index information
pureXML enhancements
Partitioned tables support XML data
MDC tables support XML columns
Declared temporary tables support XML columns
Inlined SQL functions support the XML data type
Partitioned database environments support the pureXML feature
The ALTER TABLE statement supports REORG-recommended operations containing XML data
Predicate pushdown is available for SQL/XML and XQuery statements
XML parsing and validation can return more detailed messages
Multiple XML documents in a column can be decomposed at the same time
Optimization profiles support guidelines for XML data
XML data stored in the XML storage object of tables can be compressed
Write access is supported during creation or reorganization of indexes over XML data
Monitoring enhancements
New relational monitoring interfaces are light weight and SQL accessible
New monitor elements and database configuration parameters provide more granular monitoring
New relational interface to monitor dynamic and static SQL statements in package cache
A new unit of work event monitor supports transaction monitoring
Time-spent monitor elements are more comprehensive
Lock event reporting has been enhanced
The section for SQL statements captured by activity event monitor can now be collected
High availability, backup, logging, resiliency, and recovery enhancements
Cluster management software integration support has been extended (Solaris)
Enhanced resilience to errors and traps reduces outages
Administration notification and diagnostic logs occupy specified amount of disk space
Performance enhancements
Access plan reuse ensures consistent performance
Statement concentrator enables access plan sharing
Statistics collection sampling performance for statistical views has been improved
Optimization guidelines for packages can be applied more easily
Cost model has been improved for queries in partitioned database environments
Cursor stability (CS) isolation level enhancements provide more concurrency
Scan sharing improves concurrency and performance
Partitioned indexes on partitioned tables improve performance
MQT matching includes more scenarios
Small LOBs can be stored in table rows and compressed
IOCP is used by default for asynchronous I/O (AIX)
Isolation level locking intent can be specified in subselect and fullselect clauses
SQL compatibility enhancements
SQL*Plus compatible command line processor has been added
Oracle data dictionary-compatible view support has been added
PL/SQL language is supported by DB2 interfaces
Data type support has been extended
Alternative SQL language syntax is supported
Oracle-compatible mode can be enabled
Workload management enhancements
Workloads support activity-based threshold controls
Workload connection attributes have been enhanced
Workload-level aggregate activity data collection and new high watermarks provide additional statistics
Buffer pool I/O priority can be controlled for service classes
DB2 workload manager supports integration with Linux workload management (WLM)
New thresholds provide additional activity control
Time-based thresholds support 1-minute check intervals
Support for priority aging of in-progress activities has been added
Security enhancements
DB2 authorization model has been enhanced to allow separation of duties
AES encryption of user ID and password enhances security
SSL client support expanded and configuration simplified
Transparent LDAP authentication and group lookup is supported (AIX)
Passwords can be the maximum length supported by the operating system
SYSMON authority has been extended to LIST commands and the db2mtrk command
Fenced mode process (db2fmp) privileges can be customized (Windows)
Application development enhancements
Columns can be renamed using the ALTER TABLE statement
REPLACE added as an option on several CREATE statements
Transactions can include an increased limit of ALTER TABLE operations
CREATE with errors support has been added for certain database objects
Soft invalidation and automatic revalidation support added
ALTER COLUMN SET DATA TYPE support has been extended
The SELECT INTO statement supports the FOR UPDATE clause
TRUNCATE added as an SQL statement
Created temporary tables are supported
Scalar function support has been extended
Implicit casting simplifies application enablement
TIMESTAMP data type allows for parameterized precision
Temporary tables support LOB-type columns
Public aliases simplify global object referencing
Default and named parameters promote flexibility for creating and calling procedures
Autonomous transactions are supported
Python application development support has been added
System-defined modules simplify SQL PL and application logic
Common SQL API supports the development of portable administrative applications
IBM Database Add-Ins for Visual Studio have been enhanced
New DB2 sample programs have been added
IBM data server clients and drivers enhancements
JDBC and SQLJ support has been enhanced
IBM Data Server Driver Package has been enhanced
Trusted context support has been extended
Sysplex support is extended to IBM data server clients and non-Java data server drivers
CLI functionality has been enhanced
IBM Data Server Provider for .NET has been enhanced
SQL Procedural Language (SQL PL) enhancements
Related database object definitions can be encapsulated in new module database object
Compiled compound statement support has been added
Triggers can now contain SQL PL
SQL PL functionality has been extended for user-defined functions
New data types are supported
Anchored data type
Boolean data type
Associative array data type
Cursor data type
Row data type
Net Search Extender enhancements
Full-text searches support partitioned tables
Full-text searches support in partitioned database environments has been extended
Incremental update based on integrity processing is supported
Installation, upgrade, and fix pack enhancements
Instances and DB2 Administration Server can be created in a shared DB2 copy (Linux and UNIX)
db2rspgn command supported on Linux and UNIX operating systems
Uninstalling using a response file is supported in more situations
UPGRADE_PRIOR_VERSIONS response file keyword has been added
Product installation can be validated using db2val command
Product update service support has been extended
Product installation on Linux and UNIX platforms has been enhanced
IBM Tivoli SA MP support has been extended (AIX, Linux and Solaris)
IBM Database Add-Ins for Visual Studio can be installed by more users
Installation images can be reduced (Linux and UNIX)
Universal fix packs support has been extended (Windows)
Fix pack installations can require less space (Linux and UNIX)
What's changed
Changed functionality
Administration changes summary
Partitioned indexes are created by default for partitioned tables
Some database manager configuration parameters have been changed
NO FILE SYSTEM CACHING for table space containers is the default for GPFS
Some registry and environment variables have changed
Primary and secondary log files use non-buffered I/O by default
AUTOCONFIGURE command has been changed
The CONCURRENTDBCOORDACTIVITIES threshold has changed
DESCRIBE command lists information about additional index types
Database setup and product installation changes summary
Licensing control for DB2 Express, DB2 Workgroup Edition, and workload management has been changed
License enforcement policies list has been updated
Some database configuration parameters have been changed
INTERACTIVE response file keyword
Registry files have been removed from the DB2 installation path
DB2 Text Search installation has changed
Security changes summary
System administrator (SYSADM) authority scope has changed
Security administrator (SECADM) abilities have been extended
Database administrator (DBADM) authority scope has changed
SSLconfig.ini and SSLClientconfig.ini files replaced with new database manager configuration parameters
Audit stored procedures and table functions now require only the EXECUTE privilege
Net Search Extender command authorizations have changed
DB2 Text Search command and stored procedure authorizations have changed
Application development changes summary
Cursor stability (CS) level behavior for newly created databases has been changed
Maximum limit of log sequence numbers has increased
Some system catalog views, system-defined administrative routines and views have been added and changed
New SYSIBM functions override unqualified user-defined functions with the same name
Untyped NULL keyword specifications no longer resolve to identifier names
CHAR(decimal-expression) scalar function return behavior
DOUBLE(string-expression) scalar function return behavior
Result data type for unary minus and unary operators in untyped expressions
DEFAULT keyword specification
XML data is passed by reference in SQL stored procedures
Type annotations for validated XML documents are unavailable
Merge modules for .NET, ODBC, and CLI have been combined (Windows)
Result data type for integer division in number_compat mode has been changed
Deprecated functionality
Control Center tools and DB2 administration server (DAS)
DB2 Governor and Query Patroller
Health monitor
LONG VARCHAR and LONG VARGRAPHIC data types
Worksheet Format (WSF) for Export and Load utilities
LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands
SDK 1.4.2 support for Java routines
sqlugrpn API
sqlugtpi API
Subset of Net Search Extender features and commands
CREATE EVENT MONITOR FOR DEADLOCKS statement and DB2DETAILDEADLOCK event monitor
CREATE EVENT MONITOR FOR TRANSACTIONS statement
Some registry and environment variables
-s option of the db2iupdt command (Linux and UNIX)
Instance and database migration commands and APIs
Some response file keywords
Discontinued functionality
Some operating systems are no longer supported
Type-1 indexes
32-bit partitioned databases (Windows)
Netscape browser support
XML Extender
Web Object Runtime Framework (WORF) support
DB2 embedded application server (EAS)
db2uiddl command
db2secv82 command
GET AUTHORIZATIONS command
sqluadau API and sql_authorization data structure
-a and -p options of the db2ilist command
DB2_THREAD_SUSPENSION registry variable
Version 9 deprecated and discontinued DB2 functionality summary
Documentation updates
DB2 Connect
Licensing
DB2 Connect Version 9.7 features and functions by edition
Entitlement by processor or users
Licensing for replication
Release notes
DB2 Connect enhancements and changes summary
Data Studio products
DB2 Database for Linux, UNIX, and Windows
DB2 features and functions by edition
Common licensing questions
Development and test licenses
Entitlement by processor or users
Entitlement by limited use virtual server
Entitlement by limited use socket
Processor value unit pricing
Memory usage restrictions for DB2 Express Edition and Workgroup Server Edition
Licensing for high availability
End of marketing and end of support dates
Release notes
What's New overview
New features and functionality
Product packaging enhancements
Component names have changed
Compression enhancements
XML data stored in the XML storage object of tables can be compressed
Temporary tables can be compressed
Indexes can be compressed
Data replication source tables can be compressed
Manageability enhancements
Existing databases can now use automatic storage
Automatic storage supports dropping storage paths and rebalancing table spaces
Reclaiming unused space from table spaces is supported
Reclaiming space from MDC tables has been enhanced
Enhanced access to DB2 administration commands through SQL
Table data can be moved online using a new stored procedure
Table space capacity for large and temporary table spaces has increased
Distribution map supports larger data warehouses
Database partition servers are online immediately after being added to an instance
DESCRIBE command provides additional index information
pureXML enhancements
Partitioned tables support XML data
MDC tables support XML columns
Declared temporary tables support XML columns
Inlined SQL functions support the XML data type
Partitioned database environments support the pureXML feature
The ALTER TABLE statement supports REORG-recommended operations containing XML data
Predicate pushdown is available for SQL/XML and XQuery statements
XML parsing and validation can return more detailed messages
Multiple XML documents in a column can be decomposed at the same time
Optimization profiles support guidelines for XML data
XML data stored in the XML storage object of tables can be compressed
Write access is supported during creation or reorganization of indexes over XML data
Monitoring enhancements
New relational monitoring interfaces are light weight and SQL accessible
New monitor elements and database configuration parameters provide more granular monitoring
New relational interface to monitor dynamic and static SQL statements in package cache
A new unit of work event monitor supports transaction monitoring
Time-spent monitor elements are more comprehensive
Lock event reporting has been enhanced
The section for SQL statements captured by activity event monitor can now be collected
High availability, backup, logging, resiliency, and recovery enhancements
Cluster management software integration support has been extended (Solaris)
Enhanced resilience to errors and traps reduces outages
Administration notification and diagnostic logs occupy specified amount of disk space
Performance enhancements
Access plan reuse ensures consistent performance
Statement concentrator enables access plan sharing
Statistics collection sampling performance for statistical views has been improved
Optimization guidelines for packages can be applied more easily
Cost model has been improved for queries in partitioned database environments
Cursor stability (CS) isolation level enhancements provide more concurrency
Scan sharing improves concurrency and performance
Partitioned indexes on partitioned tables improve performance
MQT matching includes more scenarios
Small LOBs can be stored in table rows and compressed
IOCP is used by default for asynchronous I/O (AIX)
Isolation level locking intent can be specified in subselect and fullselect clauses
SQL compatibility enhancements
SQL*Plus compatible command line processor has been added
Oracle data dictionary-compatible view support has been added
PL/SQL language is supported by DB2 interfaces
Data type support has been extended
Alternative SQL language syntax is supported
Oracle-compatible mode can be enabled
Workload management enhancements
Workloads support activity-based threshold controls
Workload connection attributes have been enhanced
Workload-level aggregate activity data collection and new high watermarks provide additional statistics
Buffer pool I/O priority can be controlled for service classes
DB2 workload manager supports integration with Linux workload management (WLM)
New thresholds provide additional activity control
Time-based thresholds support 1-minute check intervals
Support for priority aging of in-progress activities has been added
Security enhancements
DB2 authorization model has been enhanced to allow separation of duties
AES encryption of user ID and password enhances security
SSL client support expanded and configuration simplified
Transparent LDAP authentication and group lookup is supported (AIX)
Passwords can be the maximum length supported by the operating system
SYSMON authority has been extended to LIST commands and the db2mtrk command
Fenced mode process (db2fmp) privileges can be customized (Windows)
Application development enhancements
Columns can be renamed using the ALTER TABLE statement
REPLACE added as an option on several CREATE statements
Transactions can include an increased limit of ALTER TABLE operations
CREATE with errors support has been added for certain database objects
Soft invalidation and automatic revalidation support added
ALTER COLUMN SET DATA TYPE support has been extended
The SELECT INTO statement supports the FOR UPDATE clause
TRUNCATE added as an SQL statement
Created temporary tables are supported
Scalar function support has been extended
Implicit casting simplifies application enablement
TIMESTAMP data type allows for parameterized precision
Temporary tables support LOB-type columns
Public aliases simplify global object referencing
Default and named parameters promote flexibility for creating and calling procedures
Autonomous transactions are supported
Python application development support has been added
System-defined modules simplify SQL PL and application logic
Common SQL API supports the development of portable administrative applications
IBM Database Add-Ins for Visual Studio have been enhanced
New DB2 sample programs have been added
IBM data server clients and drivers enhancements
JDBC and SQLJ support has been enhanced
IBM Data Server Driver Package has been enhanced
Trusted context support has been extended
Sysplex support is extended to IBM data server clients and non-Java data server drivers
CLI functionality has been enhanced
IBM Data Server Provider for .NET has been enhanced
SQL Procedural Language (SQL PL) enhancements
Related database object definitions can be encapsulated in new module database object
Compiled compound statement support has been added
Triggers can now contain SQL PL
SQL PL functionality has been extended for user-defined functions
New data types are supported
Anchored data type
Boolean data type
Associative array data type
Cursor data type
Row data type
Net Search Extender enhancements
Full-text searches support partitioned tables
Full-text searches support in partitioned database environments has been extended
Incremental update based on integrity processing is supported
Installation, upgrade, and fix pack enhancements
Instances and DB2 Administration Server can be created in a shared DB2 copy (Linux and UNIX)
db2rspgn command supported on Linux and UNIX operating systems
Uninstalling using a response file is supported in more situations
UPGRADE_PRIOR_VERSIONS response file keyword has been added
Product installation can be validated using db2val command
Product update service support has been extended
Product installation on Linux and UNIX platforms has been enhanced
IBM Tivoli SA MP support has been extended (AIX, Linux and Solaris)
IBM Database Add-Ins for Visual Studio can be installed by more users
Installation images can be reduced (Linux and UNIX)
Universal fix packs support has been extended (Windows)
Fix pack installations can require less space (Linux and UNIX)
What's changed
Changed functionality
Administration changes summary
Partitioned indexes are created by default for partitioned tables
Some database manager configuration parameters have been changed
NO FILE SYSTEM CACHING for table space containers is the default for GPFS
Some registry and environment variables have changed
Primary and secondary log files use non-buffered I/O by default
AUTOCONFIGURE command has been changed
The CONCURRENTDBCOORDACTIVITIES threshold has changed
DESCRIBE command lists information about additional index types
Database setup and product installation changes summary
Licensing control for DB2 Express, DB2 Workgroup Edition, and workload management has been changed
License enforcement policies list has been updated
Some database configuration parameters have been changed
INTERACTIVE response file keyword
Registry files have been removed from the DB2 installation path
DB2 Text Search installation has changed
Security changes summary
System administrator (SYSADM) authority scope has changed
Security administrator (SECADM) abilities have been extended
Database administrator (DBADM) authority scope has changed
SSLconfig.ini and SSLClientconfig.ini files replaced with new database manager configuration parameters
Audit stored procedures and table functions now require only the EXECUTE privilege
Net Search Extender command authorizations have changed
DB2 Text Search command and stored procedure authorizations have changed
Application development changes summary
Cursor stability (CS) level behavior for newly created databases has been changed
Maximum limit of log sequence numbers has increased
Some system catalog views, system-defined administrative routines and views have been added and changed
New SYSIBM functions override unqualified user-defined functions with the same name
Untyped NULL keyword specifications no longer resolve to identifier names
CHAR(decimal-expression) scalar function return behavior
DOUBLE(string-expression) scalar function return behavior
Result data type for unary minus and unary operators in untyped expressions
DEFAULT keyword specification
XML data is passed by reference in SQL stored procedures
Type annotations for validated XML documents are unavailable
Merge modules for .NET, ODBC, and CLI have been combined (Windows)
Result data type for integer division in number_compat mode has been changed
Deprecated functionality
Control Center tools and DB2 administration server (DAS)
DB2 Governor and Query Patroller
Health monitor
LONG VARCHAR and LONG VARGRAPHIC data types
Worksheet Format (WSF) for Export and Load utilities
LIST TABLESPACES and LIST TABLESPACE CONTAINERS commands
SDK 1.4.2 support for Java routines
sqlugrpn API
sqlugtpi API
Subset of Net Search Extender features and commands
CREATE EVENT MONITOR FOR DEADLOCKS statement and DB2DETAILDEADLOCK event monitor
CREATE EVENT MONITOR FOR TRANSACTIONS statement
Some registry and environment variables
-s option of the db2iupdt command (Linux and UNIX)
Instance and database migration commands and APIs
Some response file keywords
Discontinued functionality
Some operating systems are no longer supported
Type-1 indexes
32-bit partitioned databases (Windows)
Netscape browser support
XML Extender
Web Object Runtime Framework (WORF) support
DB2 embedded application server (EAS)
db2uiddl command
db2secv82 command
GET AUTHORIZATIONS command
sqluadau API and sql_authorization data structure
-a and -p options of the db2ilist command
DB2_THREAD_SUSPENSION registry variable
Version 9 deprecated and discontinued DB2 functionality summary
Documentation updates
DB2 Connect
Licensing
DB2 Connect Version 9.7 features and functions by edition
Entitlement by processor or users
Licensing for replication
Release notes
DB2 Connect enhancements and changes summary
Data Studio products
Database fundamentals
Installing
Requirements for DB2 products
DB2 database product and packaging information
Database systems
Windows
An overview of installing your DB2 server product (Windows)
DB2 installation methods
Reducing the size of your DB2 product installation image
DB2 Setup Wizard national language support
Language identifiers for running the DB2 Setup wizard in another language
Changing the DB2 product interface language (Windows)
Disk and memory requirements
Java software support for DB2 products
Installation prerequisites (Windows)
Installation requirements (Windows)
Password rules
Additional Windows prerequisites
DB2 services running on your system (Windows)
Required user accounts for installation of DB2 server products (Windows)
Restricting operating system privileges of the db2fmp process (Windows)
Setting up elevated privileges (Windows)
Preparing the environment for a partitioned DB2 server (Windows)
Granting user rights (Windows)
Defining which users hold SYSADM authority
Fast communications manager (Windows)
Extending the Active Directory Schema for LDAP directory services (Windows)
Verifying port range availability on participating computers (Windows)
Installing DB2 servers (Windows)
Multiple DB2 copies on the same computer (Windows)
Setting up a partitioned database environment
Installing database partition servers on participating computers using a response file (Windows)
Verifying access to the registry on the instance-owning computer (Windows)
Verifying your installation (Windows)
Using First Steps to verify the installation of DB2 servers (Linux and Windows)
Using the command line processor (CLP) to verify the installation
Verifying a partitioned database environment installation (Windows)
Directory structure for your DB2 database product (Windows)
Post-installation tasks (Windows)
Deleting a Firefox browser profile
Applying DB2 licenses
Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)
Updating your 32-bit DB2 instances to 64-bit instances (Windows)
Format of the DB2 node configuration file
Verifying port range availability
Reducing the size of your DB2 fix pack installation image
Validating your DB2 copy
Setting up notification and contact lists
Changing the default DB2 and default IBM database client interface copy after installation (Windows)
IBM data server client connectivity using multiple copies
Working with existing DB2 copies
First Steps
Checking for DB2 updates
Applying fix packs
Linux and UNIX
DB2 installation methods
DB2 Setup Wizard national language support
Displaying the DB2 Setup wizard in your national language
Language identifiers for running the DB2 Setup wizard in another language
Changing the DB2 interface language
DB2 Servers
Disk and memory requirements
Java software support for DB2 products
Installation prerequisites (Linux and UNIX)
AIX
HP-UX
Linux
Solaris
Additional Linux and UNIX requirements
Multiple DB2 copies on one system
Fast communications manager
Password rules
DB2 users and groups
Centralized user-management considerations
Preparing to install DB2 for Linux on zSeries
Creating group and user IDs for a DB2 database installation
OS user limit requirements
DB2 products in a workload partition (AIX)
DB2 database product installation on an NFS-mounted directory
Kernel parameters (Linux and UNIX)
Modifying kernel parameters (HP-UX)
Recommended kernel configuration parameters (HP-UX)
Modifying kernel parameters (Linux)
Modifying kernel parameters (Solaris Operating System)
Additional partitioned database environment pre-installation tasks (Linux and UNIX)
Updating environment settings for a partitioned DB2 installation (AIX)
Setting up a working collective to distribute commands to ESE workstations (AIX)
Verifying port range availability on participating computers
Creating a DB2 home file system for a partitioned database environment
AIX
HP-UX
Linux
Solaris
Verifying that NFS is running
Mounting product CDs or DVDs
AIX
HP-UX
Linux
Solaris
Non-root installation (Linux and UNIX)
Differences between root installations and non-root installations
Limitations of non-root installations
Installing a DB2 product as a non-root user
Enabling root-based features in non-root installations with db2rfe
Applying fix packs to a non-root installation
Removing DB2 products installed by non-root users
Installing DB2 servers using the DB2 Setup wizard
Setting up a partitioned database environment
Installation methods that require manual configuration
Installing with the db2_install and doce_install command
Installing with payload files
Manually configuring DB2 servers after installation
Creating group and user IDs for a DB2 database installation
Creating group and user IDs in a partitioned database environment
AIX
HP-UX
Linux
Solaris
Creating the DB2 Administration Server (Linux and UNIX)
Creating an instance using db2icrt
Creating links for DB2 files
Configuring TCP/IP communications for a DB2 instance
Updating the services file
Updating the database manager configuration file
Configuring DB2 server communications
Using the CLP
Using the Control Center
Registering a license key using the License Center
Verifying your installation (Linux and UNIX)
First Steps
Using First Steps to verify the installation of DB2 servers (Linux and Windows)
Using the command line processor (CLP) to verify the installation
Verifying a partitioned database server installation
Directory structure for your DB2 database product (Linux)
Post-installation tasks (Linux and UNIX)
Deleting a Firefox browser profile
Applying DB2 licenses
Listing installed products
Verifying port range availability
Setting up notification and contact lists
Validating your DB2 copy
Main menu entries for DB2 tools (Linux)
IBM data server client connectivity using multiple copies
Working with existing DB2 copies
Checking for DB2 updates
Reducing the size of your DB2 fix pack installation image
Applying fix packs
Applying fix packs to a non-root installation
Partitioned database environment
Format of the DB2 node configuration file
Updating the node configuration file
Enabling communications between database partition servers
Enabling the execution of remote commands
Enabling Control Center administration (Linux)
Changing DB2 product editions
Moving between DB2 database products (Linux and UNIX)
Moving between DB2 database products (Windows)
Applying fix packs
Before installing a fix pack
Checking fix pack prerequisites
Getting fix packs
Uncompressing fix packs (Linux and UNIX)
Uncompressing fix packs (Windows)
Stopping all DB2 processes (Linux and UNIX)
Stopping all DB2 instances, services and applications (Windows)
Fix pack installation methods
Universal versus product-specific fix packs
Linux and UNIX
Installing a fix pack to update existing DB2 database products (Linux and UNIX)
Installing a fix pack to install new DB2 database products (Linux and UNIX)
Windows
Installing a fix pack for a single database product (Windows)
Installing a fix pack for multiple database products (Windows)
Installing a fix pack using a response file (Windows)
Installing a fix pack in a Microsoft Cluster Server environment (Windows)
After installing a fix pack
Post-installation tasks for fix packs (Windows)
Post-installation tasks for fix packs (Linux and UNIX)
Binding bind files after installing fix packs
Uninstalling fix packs
Response files
Response file install basics
Response file uninstall basics
Creating a response file using the DB2 Setup wizard
Linux and UNIX
Creating a response file using the sample response file
Installing DB2 using a response file
Installing database partition servers using a response file (UNIX)
Response file installation error codes
Uninstalling using a response file (Linux and UNIX)
Windows
Making the DB2 installation files available for a response file installation
Setting up shared access to a directory
Creating and editing a response file
Installing a DB2 product using a response file
Installing DB2 products using SMS
Importing the DB2 install file
Creating the SMS package on the SMS server
Distributing the DB2 installation package across your network
Distributing DB2 installation packages using SMS
Configuring remote access to a server database
Configuring db2cli.ini
Response file installation error codes
Installing with batch files
Uninstalling using a response file (Windows)
Response file generator
db2rspgn command
Available sample response files
Response file keywords
Embedding the DB2 installation image (Linux and UNIX)
Exporting and importing a profile
Stopping DB2 processes during an interactive installation (Windows)
Stopping DB2 processes during a response file installation
Installing the DB2 Information Center
Installing the DB2 Information Center using the DB2 Setup wizard (Linux)
Starting or stopping the Information Center (Linux and Windows)
Installing the DB2 Information Center using the DB2 Setup wizard (Windows)
DB2 Information Center installation options
Updating the DB2 Information Center installed on your computer or intranet server
Uninstalling
DB2 products installed as root (Linux and UNIX)
Stopping the DB2 administration server
Removing the DB2 administration server
Stopping root instances
Removing DB2 instances
Removing DB2 products using the db2_deinstall command
Uninstalling an IBM Data Server Client
DB2 products installed as non-root (Linux and UNIX)
Stopping non-root instances
Removing DB2 products installed by non-root users
DB2 (Windows)
Uninstalling DB2 copies and IBM database client interface copies
Uninstalling using a response file (Linux and UNIX)
Uninstalling using a response file (Windows)
Uninstalling IBM Data Server Driver for ODBC and CLI
Uninstalling fix packs
DB2 Homogeneous Replication Feature
Installing the integrated cluster manager
IBM Tivoli SA MP
Installing
Using the DB2 installer
Using installSAM
Upgrading
Using the DB2 installer
Using installSAM
Uninstalling
Using the DB2 installer
Using uninstallSAM
Installing HADR scripts
Using DB2 installer
Manually
Install and uninstall logs
License terms
Supported software and hardware
IBM Tivoli Monitoring for Databases: DB2 Agent
Installing IBM Tivoli Monitoring for Databases: DB2 Agent
Uninstalling IBM Tivoli Monitoring for Databases: DB2 Agent
IBM Data Server Clients and Drivers
Choosing an IBM Data Server Client or Driver
IBM Data Server Drivers
IBM Data Server Driver restrictions
db2dsdriver configuration file
db2dsdcfgfill - Create configuration file db2dsdriver.cfg
Copying existing database directory information into the db2dsdriver configuration file
IBM Data Server Driver configuration keywords
AllowDeferredPrepare
AllowedCursorTypes
AllowGetDataLobReaccess
AllowInterleavedGetData
AlternateZOSSysSchema
ArrayInputChain
Authentication
BigintDefaultCMapping
BiDiCCSID
ClientAccountingString
ClientApplicationName
ClientUserID
ClientWorkstationName
CLIPatch1
CLIPatch2
CommProtocol
ConcurrentAccessResolution
ConnectionLevelLoadBalancing
ConnectionLifetimeInPool
ConnectionTimeout
ConnectNodeNumber
CurrentFunctionPath
CurrentPackagePath
CurrentPackageSet
CurrentRefreshAge
CurrentSchema
CurrentSQLID
DateDefaultCMapping
DateDefaultDescribeMapping
DateTimeStringFormat
DecimalFloatDefaultDescribeMapping
DecimalFloatRoundingMode
DisableAliasesInMetadata
DisableAsyncQueryExecution
DisableAutoCommit
DisableBinaryDataSupport
DisableCursorHold
DisableDescribeParam
DisableDTCEnlist
DisablePooling
DisableSynonymSchemaReporting
DisableUnderscoreAsWildcard
DisableUnicode
EnableCharToWCharMapping
EnableConnectionReset
EnableDescribeCharAsWCharForOleDb
EnableKeepDynamic
EnableLobBlockingOnFetch
EnablePublicPrivelegeReporting
EnableSecurityInfoPersistence
EnableStaticSQLCapture
EnableZOSServerMsgSP
ForceDescribeBeforeCall
GranteeFilter
GrantorFilter
GraphicDefaultDescribeMapping
GraphicSupportMode
InterruptProcessingMode
IPCInstance
IsolationLevel
KeepAliveTimeout
LobAsLongDataMode
LobCacheSize
LobDataClientBufferLimit
LobMaxColumnSize
LockTimeout
MaxPoolSize
MinPoolSize
NumRowsOnFetch
ProgramName
QueryOptimizationLevel
QueryTimeoutInterval
ReceiveTimeout
SchemaFilter
SecurityTransportMode
ServerType
StaticSQLCaptureFile
TableTypeFilter
TimeDefaultCMapping
TimeDefaultDescribeMapping
TimestampDefaultCMapping
TimestampDefaultDescribeMapping
TrustedContextSystemPassword
TrustedContextSystemUserID
UserID
XMLDeclarationGenMode
XMLDefaultCMapping
XMLDefaultDescribeMapping
ZOSDBNameFilter
Installing IBM Data Server Driver Package (Windows)
Installing (Windows)
Command line options to install IBM Data Server Driver Package (Windows)
Network installation of IBM Data Server Driver Package (Windows)
Setting up a network installation
Making the code directory available
Mapping a network drive to the code server
Registering remote client workstations
Deploying
Non-DB2 instance merge modules (Windows)
Installing IBM Data Server Driver Package (Linux and UNIX)
Installing the IBM Data Server Driver for ODBC and CLI
Obtaining
Installing multiple copies
Installing with an existing client
IBM Data Server Clients
Options for connecting to DB2 databases
Supported DB2 interface languages
Language identifiers for running the DB2 Setup wizard in another language
Methods for installing IBM data server clients
Disk and memory requirements
Installing (Windows)
Installation requirements (Windows)
Alternative installation methods
Thin client topology
Thin client setup overview
Installing IBM Data Server Client or DB2 Connect Personal Edition on the code server
Making the code directory available to all thin client workstations
Creating a thin client response file
Mapping a network drive from each thin client to the code server
Setting up thin clients using the thnsetup command
DB2 instance merge modules (Windows)
Command-line options
Installing (UNIX and Linux)
AIX installation requirements
HP-UX installation requirements
Recommended kernel configuration parameters
Modifying kernel parameters
Linux installation requirements
Modifying kernel parameters
Solaris installation requirements
Modifying kernel parameters
Server requirements for client connections
Uninstalling an IBM data server client
Database connections for IBM data server clients
Database connections for clients
Supported combinations of client and server versions
Communication protocols supported
Adding database connections using the Configuration Assistant
Configuring client-to-server connections using the Configuration Assistant (CA)
Configuring a database connection manually
Configuring a database connection by searching the network
Creating a client profile
Using a client profile
Testing database connections
LDAP considerations
Adding database connections with the CLP
Named pipe connections
Named Pipes worksheet
Cataloging a Named Pipes node from a client
TCP/IP connections
TCP/IP worksheet
Updating hosts and services files for TCP/IP connections
Cataloging a TCP/IP node from a client
Cataloging the database using the CLP
Worksheet for cataloging a database
Testing the client-to-server connection using the CLP
Upgrading
Upgrading to DB2 Version 9.7
Planning your DB2 environment upgrade
DB2 servers
Clients
Database applications and routines
Upgrading DB2 servers
Upgrade essentials for DB2 servers
DB2 commands to upgrade instances and databases
Upgrade restrictions
Best practices for upgrading DB2 servers
Disk space requirements for DB2 database system upgrades
Support changes for 32-bit and 64-bit DB2 servers
DB2 server behavior changes
Deprecated or discontinued functionality that impacts upgrades
Migrating from non-DB2 relational database management systems
Pre-upgrade tasks
Converting type-1 indexes to type-2 indexes
Verifying that your databases are ready for upgrade
Backing up databases before upgrade
Backing up DB2 server configuration and diagnostic information
Increasing table space and log file sizes before upgrade
Changing raw devices to block devices (Linux)
Upgrading in a test environment
Creating database duplicates
Taking a DB2 database offline for upgrade
Upgrading a DB2 server (Windows)
Upgrading instances
Upgrading the DAS
Upgrading databases
Upgrading a DB2 server (Linux and UNIX)
Upgrading instances
Upgrading the DAS
Upgrading databases
Upgrading DB2 servers with specific characteristics
Upgrading DB2 32-bit servers to 64-bit systems (Windows)
Upgrading non-root installations
Upgrading a DB2 server with multiple DB2 copies
Upgrading to a new DB2 server
Upgrading a DB2 server using online database backups
Upgrading partitioned database environments
Upgrading DB2 Text Search
Upgrading from DB2 Data Links Manager
Upgrading a DB2 server with XML Extender to DB2 Version 9.7
Upgrading DB2 servers in MSCS environments
Post-upgrade tasks
Adjusting the log space size in upgraded databases
Activating a database after upgrade
Managing DB2 server behavior changes
Setting up security to manage database auditing.
Rebinding packages in upgraded databases
Migrating explain tables
Converting XML storage objects to Version 9.7
Ensuring system temporary table spaces page sizes meet requirements
Re-creating write-to-table event monitors
Verifying upgrade of DB2 servers
Adopting new functionality in upgraded databases
Migrating DB2 functionality to DB2 product features
Migrating from DB2 Governor to DB2 workload manager
Migrating from Query Patroller to DB2 workload manager
Migrating from XML Extender
Reversing DB2 server upgrade
Upgrading Clients
Upgrade essentials
Best practices for upgrading clients
Pre-upgrade tasks
Backing up client configuration information
Upgrading in a test environment
Upgrading to Data Server Client (Windows)
Upgrading to Data Server Runtime Client (Windows)
Upgrading clients (Linux and UNIX)
Upgrading to IBM Data Server Driver Package
Post-upgrade tasks
Recataloging nodes and databases using TCP/IP protocol
Verifying your client upgrade
Upgrading Database applications and routines
Upgrade essentials for database applications
DB2 API changes
DB2 command changes
SQL statement changes
System catalog changes
Upgrade essentials for routines
Pre-upgrade tasks
Upgrading database applications
Embedded SQL applications
CLI applications
Java applications that use IBM Data Server Driver for JDBC and SQLJ
Java applications that use DB2 JDBC Type 2 driver
ADO.NET applications
Scripts
32-bit database applications running on 64-bit instances
Upgrading routines
C, C++, and COBOL routines
Java routines
.NET CLR routines
SQL procedures
32-bit external routines running on 64-bit instances
Post-upgrade tasks
Adopting new DB2 Version 9.7 functionality in database applications and routines
Configuring
Database connections for IBM data server clients
Database connections for clients
Supported combinations of client and server versions
Communication protocols supported
Adding database connections using the Configuration Assistant
Configuring client-to-server connections using the Configuration Assistant (CA)
Configuring a database connection manually
Configuring a database connection by searching the network
Creating a client profile
Using a client profile
Testing database connections
LDAP considerations
Adding database connections with the CLP
Named pipe connections
Named Pipes worksheet
Cataloging a Named Pipes node from a client
TCP/IP connections
TCP/IP worksheet
Updating hosts and services files for TCP/IP connections
Cataloging a TCP/IP node from a client
Cataloging the database using the CLP
Worksheet for cataloging a database
Testing the client-to-server connection using the CLP
Configuration Assistant
Configuring communication protocols for a local DB2 instance
Configuring communication protocols for a remote DB2 instance
Setting communication protocols for a DB2 instance
Updating the database manager configuration file on the server for TCP/IP communications
DB2 server communications configuration using the Control Center
DB2 licenses
Applying DB2 licenses
Updating a Trial license
Registering a license key using the db2licm command
Registering a license key using the License Center
Checking DB2 license compliance
Options to manage licenses
License Center overview
Changing licenses and policies
Viewing licensing information
Viewing license policy information
Viewing and resetting compliance details
Removing licenses
db2licm - License management tool command
Configuring DB2 server communications
Configuring DB2 server communications using the Control Center
Configuring communication protocols for a remote DB2 instance
Configuring communication protocols for a local DB2 instance
DB2 server communications configuration using the Control Center
Setting communication protocols for a DB2 instance
Configuring DB2 server communications (TCP/IP)
Configuring TCP/IP communications for a DB2 instance
Updating the database manager configuration file on the server for TCP/IP communications
Updating the services file on the server for TCP/IP communications
Configuration parameters
Configuring the DB2 database manager with configuration parameters
Configuration parameters summary
Configuration parameters that affect the number of agents
Configuration parameters that affect query optimization
Restrictions and behavior when configuring max_coordagents and max_connections
Database Manager configuration parameters
agent_stack_sz - Agent stack size
agentpri - Priority of agents
alternate_auth_enc - Alternate encryption algorithm for incoming connections at server configuration parameter
aslheapsz - Application support layer heap size
audit_buf_sz - Audit buffer size
authentication - Authentication type
auto_reval - Automatic revalidation and invalidation.
catalog_noauth - Cataloging allowed without authority
clnt_krb_plugin - Client Kerberos plug-in
clnt_pw_plugin - Client userid-password plug-in
cluster_mgr - Cluster manager name
comm_bandwidth - Communications bandwidth
conn_elapse - Connection elapse time
cpuspeed - CPU speed
cur_commit - Currently committed
date_compat - Date compatibility database configuration parameter
dec_to_char_fmt - Decimal to character function configuration parameter
dft_account_str - Default charge-back account
dft_monswitches - Default database system monitor switches
dftdbpath - Default database path
diaglevel - Diagnostic error capture level
diagpath - Diagnostic data directory path
dir_cache - Directory cache support
discover - Discovery mode
discover_inst - Discover server instance
fcm_num_buffers - Number of FCM buffers
fcm_num_channels - Number of FCM channels
fed_noauth - Bypass federated authentication
federated - Federated database system support
federated_async - Maximum asynchronous TQs per query configuration parameter
fenced_pool - Maximum number of fenced processes
group_plugin - Group plug-in
health_mon - Health monitoring
indexrec - Index re-creation time
instance_memory - Instance memory
intra_parallel - Enable intra-partition parallelism
java_heap_sz - Maximum Java interpreter heap size
jdk_path - Software Developer
keepfenced - Keep fenced process
local_gssplugin - GSS API plug-in used for local instance level authorization
max_connections - Maximum number of client connections
max_connretries - Node connection retries
max_coordagents - Maximum number of coordinating agents
max_querydegree - Maximum query degree of parallelism
max_time_diff - Maximum time difference among nodes
maxagents - Maximum number of agents
maxcagents - Maximum number of concurrent agents
mon_heap_sz - Database system monitor heap size
nodetype - Machine node type
notifylevel - Notify level
num_initagents - Initial number of agents in pool
num_initfenced - Initial number of fenced processes
num_poolagents - Agent pool size
numdb - Maximum number of concurrently active databases including host and System i databases
query_heap_sz - Query heap size
release - Configuration file release level
resync_interval - Transaction resync interval
rqrioblk - Client I/O block size
sheapthres - Sort heap threshold
spm_log_file_sz - Sync point manager log file size
spm_log_path - Sync point manager log file path
spm_max_resync - Sync point manager resync agent limit
spm_name - Sync point manager name
srvcon_auth - Authentication type for incoming connections at the server
srvcon_gssplugin_list - List of GSS API plug-ins for incoming connections at the server
srvcon_pw_plugin - Userid-password plug-in for incoming connections at the server
srv_plugin_mode - Server plug-in mode
ssl_cipherspecs - Supported cipher specifications at the server configuration parameter
ssl_clnt_keydb - SSL key file path for outbound SSL connections at the client configuration parameter
ssl_clnt_stash - SSL stash file path for outbound SSL connections at the client configuration parameter
ssl_svr_keydb - SSL key file path for incoming SSL connections at the server configuration parameter
ssl_svr_label - Label in the key file for incoming SSL connections at the server configuration parameter
ssl_svr_stash - SSL stash file path for incoming SSL connections at the server configuration parameter
start_stop_time - Start and stop timeout
ssl_svcename - SSL service name configuration parameter
ssl_versions - Supported SSL versions at the server configuration parameter
stmt_conc - Statement concentrator
svcename - TCP/IP service name
sysadm_group - System administration authority group name
sysctrl_group - System control authority group name
sysmaint_group - System maintenance authority group name
sysmon_group - System monitor authority group name
tm_database - Transaction manager database name
tp_mon_name - Transaction processor monitor name
trust_allclnts - Trust all clients
trust_clntauth - Trusted clients authentication
util_impact_lim - Instance impact policy
Database configuration parameters
alt_collate - Alternate collating sequence
app_ctl_heap_sz - Application control heap size
appgroup_mem_sz - Maximum size of application group memory set
appl_memory - Application Memory
applheapsz - Application heap size
archretrydelay - Archive retry delay on error
auto_del_rec_obj - Automated deletion of recovery objects
auto_maint - Automatic maintenance (switches)
autorestart - Auto restart enable
avg_appls - Average number of active applications
backup_pending - Backup pending indicator
blk_log_dsk_ful - Block on log disk full
blocknonlogged - Block creation of tables that allow non-logged activity
catalogcache_sz - Catalog cache size
chngpgs_thresh - Changed pages threshold
codepage - Code page for the database
codeset - Codeset for the database
collate_info - Collating information
country/region - Database territory code
database_consistent - Database is consistent
database_level - Database release level
database_memory - Database shared memory size
dbheap - Database heap
db_mem_thresh - Database memory threshold
date_compat - Date compatibility database configuration parameter
decflt_rounding - Decimal floating point rounding
dft_degree - Default degree
dft_extent_sz - Default extent size of table spaces
dft_loadrec_ses - Default number of load recovery sessions
dft_mttb_types - Default maintained table types for optimization
dft_prefetch_sz - Default prefetch size
dft_queryopt - Default query optimization class
dft_refresh_age - Default refresh age
dft_sqlmathwarn - Continue upon arithmetic exceptions
diagsize - Rotating diagnostic and administration notification logs configuration parameter
discover_db - Discover database
dlchktime - Time interval for checking deadlock
dyn_query_mgmt - Dynamic SQL and XQuery query management
enable_xmlchar - Enable conversion to XML
failarchpath - Failover log archive path
groupheap_ratio - Percent of memory for application group heap
hadr_db_role - HADR database role
hadr_local_host - HADR local host name
hadr_local_svc - HADR local service name
hadr_peer_window - HADR peer window
hadr_remote_host - HADR remote host name
hadr_remote_inst - HADR instance name of the remote server
hadr_remote_svc - HADR remote service name
hadr_syncmode - HADR synchronization mode for log write in peer state
hadr_timeout - HADR timeout value
indexrec - Index re-creation time
jdk_64_path - 64-Bit Software Developer
locklist - Maximum storage for lock list
locktimeout - Lock timeout
log_retain_status - Log retain status indicator
logarchmeth1 - Primary log archive method
logarchmeth2 - Secondary log archive method
logarchopt1 - Primary log archive options
logarchopt2 - Secondary log archive options
logbufsz - Log buffer size
logfilsiz - Size of log files
loghead - First active log file
logindexbuild - Log index pages created
logpath - Location of log files
logprimary - Number of primary log files
logretain - Log retain enable
logsecond - Number of secondary log files
max_log - Maximum log per transaction
maxappls - Maximum number of active applications
maxfilop - Maximum database files open per application
maxlocks - Maximum percent of lock list before escalation
min_dec_div_3 - Decimal division scale to 3
mincommit - Number of commits to group
mirrorlogpath - Mirror log path
mon_act_metrics - Monitoring activity metrics configuration parameter
mon_deadlock - Monitoring deadlock configuration parameter
mon_locktimeout - Monitoring lock timeout configuration parameter
mon_lockwait - Monitoring lock wait configuration parameter
mon_lw_thresh - Monitoring lock wait threshold configuration parameter
mon_obj_metrics - Monitoring data object metrics configuration parameter
mon_req_metrics - Monitoring request metrics configuration parameter
mon_uow_data - Monitoring unit of work events configuration parameter
multipage_alloc - Multipage file allocation enabled
newlogpath - Change the database log path
num_db_backups - Number of database backups
num_freqvalues - Number of frequent values retained
num_iocleaners - Number of asynchronous page cleaners
num_ioservers - Number of I/O servers
num_log_span - Number log span
num_quantiles - Number of quantiles for columns
numarchretry - Number of retries on error
numsegs - Default number of SMS containers
number_compat - Number compatibility database configuration parameter
overflowlogpath - Overflow log path
pagesize - Database default page size
pckcachesz - Package cache size
priv_mem_thresh - Private memory threshold
rec_his_retentn - Recovery history retention period
restore_pending - Restore pending
restrict_access - Database has restricted access
rollfwd_pending - Roll forward pending indicator
self_tuning_mem - Self-tuning memory
seqdetect - Sequential detection flag
sheapthres_shr - Sort heap threshold for shared sorts
softmax - Recovery range and soft checkpoint interval
sortheap - Sort heap size
stat_heap_sz - Statistics heap size
stmtheap - Statement heap size
territory - Database territory
trackmod - Track modified pages enable
tsm_mgmtclass - Tivoli Storage Manager management class
tsm_nodename - Tivoli Storage Manager node name
tsm_owner - Tivoli Storage Manager owner name
tsm_password - Tivoli Storage Manager password
user_exit_status - User exit status indicator
userexit - User exit enable
util_heap_sz - Utility heap size
varchar2_compat - Varchar2 compatibility database configuration parameter
vendoropt - Vendor options
wlm_collect_int - Workload management collection interval
DB2 Administration Server (DAS) configuration parameters
authentication - Authentication type DAS
contact_host - Location of contact list
das_codepage - DAS code page
das_territory - DAS territory
dasadm_group - DAS administration authority group name
db2system - Name of the DB2 server system
diaglevel - Diagnostic error capture level
discover - DAS discovery mode
exec_exp_task - Execute expired tasks
jdk_path - Software Developer
sched_enable - Scheduler mode
sched_userid - Scheduler user ID
smtp_server - SMTP server
toolscat_db - Tools catalog database
toolscat_inst - Tools catalog database instance
toolscat_schema - Tools catalog database schema
Registry and environment variables
Setting environment variables and the profile registry
Declaring registry and environment variables
Setting environment variables (Windows)
Setting environment variables (Linux and UNIX)
Setting the current instance
Aggregate registry variables
Registry and environment variables
General
System environment
Communications
Command-line
Partitioned database environment
Query compiler
Performance
Miscellaneous
Registry and environment variables
Setting environment variables and the profile registry
Declaring registry and environment variables
Setting environment variables (Windows)
Setting environment variables (Linux and UNIX)
Setting the current instance
Aggregate registry variables
Registry and environment variables
General
System environment
Communications
Command-line
Partitioned database environment
Query compiler
Performance
Miscellaneous
Performance tuning
Performance tuning tools and methodology
Benchmark testing
Benchmark preparation
Benchmark test creation
Benchmark test execution
Benchmark test analysis example
Performance monitoring tools and methodology
Operational monitoring of system performance
Basic set of system performance monitor elements
Abnormal values in monitoring data
The governor utility
Starting the governor
The governor daemon
The governor configuration file
Governor rule clauses
Governor log files
Stopping the governor
Factors affecting performance
System architecture
DB2 architecture and process overview
The DB2 process model
Database agents
Database agent management
Client-server processing model
Connection-concentrator improvements for client connections
Agents in a partitioned database
Configuring for good performance
Instance configuration
Table space design
Disk-storage performance factors
Table space impact on query optimization
Database design
Tables
Table and index management for standard tables
Table and index management for MDC tables
Indexes
Index structure
Index cleanup and maintenance
Asynchronous index cleanup
Asynchronous index cleanup for MDC tables
Online index defragmentation
Using relational indexes to improve performance
Relational index planning tips
Relational index performance tips
Partitioning and clustering
Index behavior on partitioned tables
Clustering of nonpartitioned indexes on partitioned tables
Federated databases
Server options that affect federated databases
Resource utilization
Memory allocation
Database manager shared memory
The FCM buffer pool and memory requirements
Guidelines for tuning parameters that affect memory usage
Self-tuning memory overview
Self-tuning memory
Enabling self-tuning memory
Disabling self-tuning memory
Determining which memory consumers are enabled for self tuning
Self-tuning memory in partitioned database environments
Using self-tuning memory in partitioned database environments
Buffer pool management
Buffer pool management of data pages
Management of multiple database buffer pools
Proactive page cleaning
Improving update performance
Prefetching data into the buffer pool
Sequential prefetching
Block-based buffer pools for improved sequential prefetching
List prefetching
I/O server configuration for prefetching and parallelism
Illustration of prefetching with parallel I/O
Parallel I/O management
Configuring IOCP on AIX
Database deactivation behavior in first-user connection scenarios
Tuning sort performance
Data organization
Table reorganization
Choosing a table reorganization method
Classic (offline) table reorganization
Reorganizing tables offline
Recovery of an offline table reorganization
Improving the performance of offline table reorganization
Inplace (online) table reorganization
Reorganizing tables online
Recovery of an online table reorganization
Pausing and restarting an online table reorganization
Locking and concurrency considerations for online table reorganization
Monitoring a table reorganization
Index reorganization
Determining when to reorganize tables and indexes
Costs of table and index reorganization
Reducing the need to reorganize tables and indexes
Automatic reorganization
Enabling automatic table and index reorganization
Application design
Application processes, concurrency, and recovery
Concurrency issues
Isolation levels
Specifying the isolation level
Currently committed semantics improve concurrency
Option to disregard uncommitted insertions
Evaluate uncommitted data through lock deferral
Writing and tuning queries for optimal performance
Writing SQL statements
Avoiding complex expressions in search conditions
Avoiding join predicates on expressions
Avoiding expressions over columns in local predicates
Avoiding data type mismatches on join columns
Avoiding no-op expressions in predicates to change the optimizer estimate
Avoiding non-equality join predicates
Avoiding multiple aggregations with the DISTINCT keyword
Avoiding unnecessary outer joins
Using the OPTIMIZE FOR N ROWS clause with the FETCH FIRST N ROWS ONLY clause
Ensuring that queries fit the required criteria for the star schema join
Avoiding redundant predicates
Using constraints to improve query optimization
Using the REOPT bind option with input variables in complex queries
Using parameter markers to reduce compilation time for dynamic queries
Setting the DB2_REDUCED_OPTIMIZATION registry variable
Improving insert performance
Efficient SELECT statements
Guidelines for restricting SELECT statements
Specifying row blocking to reduce overhead
Data sampling in queries
Parallel processing for applications
Lock management
Locks and concurrency control
Lock granularity
Lock attributes
Factors that affect locking
Locks and types of application processing
Locks and data-access methods
Lock type compatibility
Next-key locking
Lock modes and access plans for standard tables
Lock modes for MDC table and RID index scans
Lock modes for MDC block index scans
Locking behavior on partitioned tables
Lock conversion
Lock waits and timeouts
Specifying a lock wait mode strategy
Deadlocks
Query optimization
The SQL and XQuery compiler process
Query rewriting methods and examples
Compiler rewrite example: View merges
Compiler rewrite example: DISTINCT elimination
Compiler rewrite example: Predicate pushdown for combined SQL/XQuery statements
Compiler rewrite example: Implied predicates
Predicate typology and access plans
Federated database query-compiler phases
Federated database pushdown analysis
Guidelines for determining where a federated query is evaluated
Remote SQL generation and global optimization in federated databases
Global analysis of federated database queries
Data-access methods
Data access through index scans
Types of index access
Index access and cluster ratios
Scan sharing
Joins
Join methods
Strategies for selecting optimal joins
Replicated materialized query tables in partitioned database environments
Join strategies for partitioned databases
Join methods for partitioned databases
Effects of sorting and grouping on query optimization
Optimization strategies
Optimization strategies for intra-partition parallelism
Optimization strategies for MDC tables
Optimization strategies for partitioned tables
Improving query optimization with materialized query tables
Explain facility
Tuning SQL statements using the explain facility
Guidelines for capturing explain information
Guidelines for using explain information
Guidelines for analyzing explain information
Using access plans to self-diagnose performance problems with REFRESH TABLE and SET INTEGRITY statements
Tools for collecting and analyzing explain information
The explain tables and organization of explain information
Explain information for data objects
Explain information for data operators
Explain information for instances
SQL and XQuery explain tool
Description of db2expln output
Table access information
Temporary table information
Join information
Data stream information
Insert, update, and delete information
Block and row identifier preparation information
Aggregation information
Parallel processing information
Federated query information
Miscellaneous explain information
Visual Explain Tutorial
About this tutorial
Creating explain snapshots
Creating the explain tables
Using explain snapshots
Creating explain snapshots for dynamic SQL or XQuery statements
Creating explain snapshots for static SQL or XQuery statements
Displaying and using an access plan graph
Displaying an access plan graph by choosing from a list of previously explained SQL or XQuery statements
Reading the symbols in an access plan graph
Using the zoom slider to magnify parts of a graph
Getting more details about the objects in a graph
Changing the appearance of a graph
Improving an access plan in a single-partition database environment
Running a query with no indexes and no statistics
Collecting current statistics for the tables and indexes using runstats
Creating indexes on columns used to join tables in a query
Creating additional indexes on table columns
Improving an access plan in a partitioned database environment
Running a query with no indexes and no statistics
Collecting current statistics for the tables and indexes using runstats
Creating indexes on columns used to join tables in a query
Creating additional indexes on table columns
Operators
CMPEXP operator
DELETE operator
EISCAN operator
FETCH operator
FILTER operator
GENROW operator
GRPBY operator
HSJOIN operator
INSERT operator
IXAND operator
IXSCAN operator
MSJOIN operator
NLJOIN operator
PIPE operator
RETURN operator
RIDSCN operator
RPD operator
SHIP operator
SORT operator
TBSCAN operator
TEMP operator
TQ operator
UNION operator
UNIQUE operator
UPDATE operator
XANDOR operator
XISCAN operator
XSCAN operator
Concepts
Access plan
Access plan graph
Access plan graph node
Clustering
Container
Cost
Cursor blocking
Database-managed table space
Dynamic SQL or XQuery
Explain information for data operators
Explain snapshot
Explainable statement
Explained statement concept
Operand
Operator
Optimizer
Package
Predicate
Query optimization class
Sample XML document fragment for Explain XML operators
Selectivity of predicates
Star join
Static SQL or XQuery
System-managed table spaces
Table spaces
Visual Explain
Tasks
Creating an access plan using the Command Editor
Viewing a graphical representation of an access plan
Viewing the history of previously explained SQL statements
Viewing explainable statements for a package
Reference
Guidelines for creating indexes
Out-of-date access plans
Retrieving the access plan when using LONGDATACOMPAT
Using RUNSTATS
Up-level and down-level support
Optimizing query access plans
Statement concentrator reduces compilation overhead
Access plan reuse
Optimization classes
Choosing an optimization class
Setting the optimization class
Using optimization profiles if other tuning options do not produce acceptable results
Optimization profiles and guidelines
Optimization profiles
Anatomy of an optimization profile
Creating an optimization profile
Configuring the data server to use an optimization profile
STMTKEY field in optimization profiles
Specifying which optimization profile the optimizer is to use
Setting an optimization profile within an application
Binding an optimization profile to a package
Modifying an optimization profile
Deleting an optimization profile
Optimization guidelines
Types of optimization guidelines
General optimization guidelines
Query rewrite optimization guidelines
Plan optimization guidelines
Creating statement-level optimization guidelines
Forming table references in optimization guidelines
Verifying that optimization guidelines have been used
XML schema for optimization profiles and guidelines
Current optimization profile schema
XML schema for the OPTPROFILE element
XML schema for the global OPTGUIDELINES element
MQT optimization choices
Computational partition group optimization choices
General optimization guidelines as global requests
XML schema for the STMTPROFILE element
XML schema for the STMTKEY element
Statement key and compilation key matching
XML schema for the statement-level OPTGUIDELINES element
XML schema for general optimization guidelines
DEGREE requests
DPFXMLMOVEMENT requests
QRYOPT requests
REOPT requests
RTS requests
XML schema for query rewrite optimization guidelines
IN-LIST-to-join query rewrite requests
NOT-EXISTS-to-anti-join query rewrite requests
NOT-IN-to-anti-join query rewrite requests
Subquery-to-join query rewrite requests
XML schema for plan optimization guidelines
Access requests
Access types
Any access requests
Index ANDing access requests
Index ORing access requests
Index scan access requests
List prefetch access requests
Table scan access requests
XML index ANDing and ORing access requests
XML index scan access requests
Join requests
Join types
Any join requests
Hash join requests
Merge join requests
Nested-loop join requests
SYSTOOLS.OPT_PROFILE table
Triggers to flush the optimization profile cache
Managing the SYSTOOLS.OPT_PROFILE table
Database partition group impact on query optimization
Collecting accurate catalog statistics, including advanced statistics features
Column group statistics
Correlation of simple equality predicates
Statistical views
Using statistical views
View statistics that are relevant to optimization
Scenario: Improving cardinality estimates using statistical views
Catalog statistics
Catalog statistics tables
Automatic statistics collection
Enabling automatic statistics collection
Collecting statistics using a statistics profile
Storage used by automatic statistics collection and profiling
Automatic statistics collection activity logging
Improving query performance for large statistics logs
Guidelines for collecting and updating statistics
Collecting catalog statistics
Collecting statistics on a sample of the table data
Sub-element statistics
Runstats statistics about sub-elements
General rules for updating catalog statistics manually
Rules for updating column statistics manually
Rules for updating table and nickname statistics manually
Detailed index statistics
Collecting index statistics
Rules for updating index statistics manually
Distribution statistics
Optimizer use of distribution statistics
Collecting distribution statistics for specific columns
Extended examples of the use of distribution statistics
Rules for updating distribution statistics manually
Statistics for user-defined functions
Catalog statistics for modeling and what-if planning
Statistics for modeling production databases
Avoiding manual updates to the catalog statistics
Minimizing runstats impact
Data compression and performance
Reducing logging overhead to improve DML performance
Inline LOBs improve performance
Establishing a performance tuning strategy
The Design Advisor
Using the Design Advisor
Defining a workload for the Design Advisor
Using the Design Advisor to convert from a single-partition to a multi-partition database
Design Advisor limitations and restrictions
Database monitoring
Monitoring interfaces
Monitor table functions
Monitoring system information using table functions
Monitoring activities using table functions
Monitoring data objects using table functions
Event monitors
Event monitors that write to an unformatted event table
Unformatted event table column definitions
db2evmonfmt tool for reading event monitor data
Monitoring database locking
Collecting lock event data and generating reports
Information written to XML for locking event monitor
Information written to relational table for locking event monitor
Monitoring unit of work events
Collecting unit of work event data and generating reports
Information written to XML for a unit of work event monitor
Information written to relational table for unit of work event monitor
Capturing system monitor elements using the statistics event monitor
XML schema for system_metrics monitor element
Capturing activity monitor elements using the activity event monitor
XML schema for activity_metrics monitor element
Event monitors that write to tables, files, and pipes
Collecting information about database system events
Creating an event monitor
Creating table event monitors
Event monitor table management
Creating a file event monitor
Event monitor file management
Write-to-table and file event monitor buffering
Creating a pipe event monitor
Event monitor named pipe management
Creating an event monitor for partitioned databases
Event monitor output
Formatting file or pipe event monitor output from a command line
Event records and their corresponding applications
Event monitor self-describing data stream
Transferring event monitor data between systems
Snapshot monitor
Access to system monitor data: SYSMON authority
Capturing database system snapshots using snapshot table functions in SQL queries (with direct access)
Capturing database system snapshot information to a file using the SNAP_WRITE_FILE stored procedure
Accessing database system snapshots using snapshot table functions in SQL queries (with file access)
Snapshot monitor SQL Administrative Views
SQL access to database system snapshots
Capturing a database snapshot from the CLP
Snapshot monitor CLP commands
Capturing a database snapshot from a client application
Snapshot monitor API request types
Snapshot monitor sample output
Subsection snapshots
Global snapshots on partitioned database systems
Snapshot monitor self-describing data stream
Monitoring with db2top (interactive mode)
db2top configuration file
Switch-based monitoring concepts
System monitor switches
Setting system monitor switches from the CLP
Setting system monitor switches from a client application
Monitor switches self-describing data stream
Database system monitor data organization
Counter status and visibility
System monitor output: the self-describing data stream
Memory requirements for monitor data
Monitoring buffer pool activity
Database system monitor interfaces
Deprecated monitoring tools
Health monitor
Monitoring database health
Health monitor overview
Health indicators
Health indicator process cycle
Enabling health alert notification
Monitoring with the Health Center
Investigating alert conditions
Monitoring database health
Health indicator data
Capturing database health snapshots
Using SQL table functions
Using the CLP
Using client applications
Health monitor sample output
Global health snapshots
Graphical tools for the health monitor
Retrieving health recommendations
Using SQL queries
Using the CLP
Using client applications
Resolving alerts using the Health Center
Configuring health indicators
Retrieving health indicator configuration using the CLP
Health indicator configuration updates using the CLP
Resetting health indicator configuration using the CLP
Configuring health indicators using a client application
Configuring health indicators using Health Center
Health monitor alert actions on combined states
Health indicators
Interface mappings to logical data groups
Health indicators
Health indicator format
Table space storage health indicators
Health indicators for DMS table spaces
db.auto_storage_util - Database automatic storage utilization
ts.ts_auto_resize_status - Table space automatic resize status
ts.ts_util_auto_resize - Automatic resize table space utilization
ts.ts_util - Table space utilization
tsc.tscont_util - Table space container utilization
ts.ts_op_status - Table space operational state
tsc.tscont_op_status - Table space container operational state
Sorting health indicators
db2.sort_privmem_util - Private sort memory utilization
db.sort_shrmem_util - Shared sort memory utilization
db.spilled_sorts - Percentage of sorts that overflowed
db.max_sort_shrmem_util - Long term shared sort memory utilization
Database manager (DBMS) health indicators
db2.db2_op_status - Instance operational state
db2.db2_alert_state - Instance highest severity alert state
Database health indicators
db.db_op_status - Database operational state
db.alert_state - Database highest severity alert state
Maintenance health indicators
db.tb_reorg_req - Reorganization required
db.tb_runstats_req - Statistics collection required
db.db_backup_req - Database backup required
High availability disaster recovery (HADR) health indicators
db.hadr_op_status - HADR operational status
db.hdr_delay - HADR log delay
Logging health indicators
db.log_util - Log utilization
db.log_fs_util - Log file system utilization
Application concurrency health indicators
db.deadlock_rate - Deadlock rate
db.locklist_util - Lock list utilization
db.lock_escal_rate - Lock escalation rate
db.apps_waiting_locks - Percentage of applications waiting on locks
Package cache, catalog cache, and workspace health indicators
db.catcache_hitratio - Catalog cache hit ratio
db.pkgcache_hitratio - Package cache hit ratio
db.shrworkspace_hitratio - Shared workspace hit ratio
Memory health indicators
db2.mon_heap_util - Monitor heap utilization
db.db_heap_util - Database heap utilization
Federated health indicators
db.fed_nicknames_op_status - Nickname status
db.fed_servers_op_status - Data source server status
Health monitor interfaces
SQL table functions
CLP commands
API request types
Memory Visualizer
Viewing memory performance using the Memory Visualizer
Activity Monitor
Monitoring scenarios
Identifying costly applications
Monitoring buffer pool efficiency
Setting up an activity monitor
Progress monitoring of the rollback process
Monitoring the reorganization of a partitioned table
Inactive statement tracking for DEADLOCK WITH DETAILS HISTORY event monitors
Windows Management Instrumentation (WMI)
DB2 integration with WMI
Monitoring performance with the Windows performance monitor
Registering DB2 with the Windows performance monitor
Enabling remote access to DB2 performance information
Displaying DB2 and DB2 Connect performance values
Windows performance objects
Accessing remote DB2 performance information
Resetting DB2 performance values
Monitoring indoubt transactions
Monitor elements
Monitor elements reported in monitor table functions
Request monitor elements
Activity monitor elements
Data object monitor elements
Monitor elements reported by the unit of work event monitor
Monitor elements reported by the locking event monitor
Wait time monitor elements
Logical data groups
Snapshot monitor interface mappings to logical data groups
Snapshot monitor logical data groups and monitor elements
Event type mappings to logical data groups
Event monitor logical data groups and monitor elements
Logical data groups affected by COLLECT ACTIVITY DATA settings
Monitor elements
acc_curs_blk - Accepted block cursor requests
act_aborted_total - Total aborted activities
act_completed_total - Total completed activities
act_cpu_time_top – Activity CPU time top monitor element
act_exec_time - Activity execution time
act_rejected_total - Total rejected activities
act_remapped_in – Activities remapped in
act_remapped_out – Activities remapped out
act_rows_read_top – Activity rows read top monitor element
act_total - Activities total
activate_timestamp - Activate timestamp
active_hash_joins - Active hash joins
active_olap_funcs - Active OLAP functions
active_sorts - Active sorts
activity_collected - Activity collected
activity_id - Activity ID
activity_secondary_id - Activity secondary ID
activity_state - Activity state
activity_type - Activity type
activitytotaltime_threshold_id - Activity total time threshold ID
activitytotaltime_threshold_value - Activity total time threshold value
activitytotaltime_threshold_violated - Activity total time threshold violated
address - IP address from which the connection was initiated
agent_id - Application handle (agent ID)
agent_id_holding_lock - Agent ID holding lock
agent_pid - Engine dispatchable unit (EDU) identifier
agent_status - DCS application agents
agent_sys_cpu_time - System CPU time used by agent
agent_usr_cpu_time - User CPU time used by agent
agent_wait_time - Agent wait time
agent_waits_total - Total agent waits
agents_created_empty_pool - Agents created due to empty agent pool
agents_from_pool - Agents assigned from pool
agents_registered - Agents registered
agents_registered_top - Maximum number of agents registered
agents_stolen - Stolen agents
agents_top - Number of agents created
agents_waiting_on_token - Agents waiting for a token
agents_waiting_top - Maximum number of agents waiting
agg_temp_tablespace_top - Aggregate temporary table space top
aggsqltempspace_threshold_id - Aggregate SQL temporary space threshold ID
aggsqltempspace_threshold_value - AggSQL temporary space threshold value
aggsqltempspace_threshold_violated - AggSQL temporary space threshold violated
app_rqsts_completed_total - Total application requests completed
appl_con_time - Connection request start timestamp
appl_id - Application ID
appl_id_holding_lk - Application ID holding lock
appl_id_oldest_xact - Application with oldest transaction
appl_idle_time - Application idle time
appl_name - Application name
appl_priority - Application agent priority
appl_priority_type - Application priority type
appl_section_inserts - Section inserts
appl_section_lookups - Section lookups
appl_status - Application status
application_handle - Application handle
appls_cur_cons - Applications connected currently
appls_in_db2 - Applications executing in the database currently
arm_correlator - Application response measurement correlator
associated_agents_top - Maximum number of associated agents
async_runstats – Total number of asynchronous RUNSTATS requests
audit_events_total - Total audit events
audit_file_write_wait_time - Audit file write wait time
audit_file_writes_total - Total audit files written
audit_subsystem_wait_time - Audit subsystem wait time
audit_subsystem_waits_total - Total audit subsystem waits
auth_id - Authorization ID
authority_bitmap - User authorization level
authority_lvl - User authorization level
auto_storage_hybrid - Hybrid automatic storage table space indicator
automatic - Buffer pool automatic
bin_id - Histogram bin identifier
binds_precompiles - Binds/precompiles attempted
block_ios - Number of block I/O requests
blocking_cursor - Blocking cursor
blocks_pending_cleanup - Pending cleanup rolled-out blocks
bottom - Histogram bin bottom
boundary_leaf_node_splits - Boundary leaf node splits
bp_cur_buffsz - Current size of buffer pool
bp_id - Buffer pool identifier
bp_name - Buffer pool name
bp_new_buffsz - New buffer pool size
bp_pages_left_to_remove - Number of pages left to remove
bp_tbsp_use_count - Number of table spaces mapped to buffer pool
buff_free - FCM buffers currently free
buff_free_bottom - Minimum FCM Buffers Free
byte_order - Byte order of event data
cat_cache_inserts - Catalog cache inserts
cat_cache_lookups - Catalog cache lookups
cat_cache_overflows - Catalog cache overflows
cat_cache_size_top - Catalog cache high watermark
catalog_node - Catalog node number
catalog_node_name - Catalog node network name
ch_free - Channels Currently Free
ch_free_bottom - Minimum Channels Free
client_acctng - Client accounting string
client_applname - Client application name
client_db_alias - Database alias used by application
client_idle_wait_time - Client idle wait time
client_pid - Client process ID
client_platform - Client operating platform
client_prdid - Client product and version ID
client_protocol - Client communication protocol
client_userid - Client user ID
client_wrkstnname - Client workstation name
codepage_id - ID of code page used by application
comm_private_mem - Committed private memory
commit_sql_stmts - Commit statements attempted
comp_env_desc - Compilation environment
completion_status - Completion status
con_elapsed_time - Most recent connection elapsed time
con_local_dbases - Local databases with current connects
con_response_time - Most recent response time for connect
concurrent_act_top - Concurrent activity top
concurrent_connection_top - Concurrent connection top
concurrent_wlo_act_top - Concurrent WLO activity top
concurrent_wlo_top - Concurrent workload occurrences top
concurrentdbcoordactivities_db_threshold_id - Concurrent database coordinator activities database threshold ID
concurrentdbcoordactivities_db_threshold_queued - Concurrent database coordinator activities database threshold queued
concurrentdbcoordactivities_db_threshold_value - Concurrent database coordinator activities database threshold value
concurrentdbcoordactivities_db_threshold_violated - Concurrent database coordinator activities database threshold violated
concurrentdbcoordactivities_subclass_threshold_id - Concurrent database coordinator activities service subclass threshold ID
concurrentdbcoordactivities_subclass_threshold_queued - Concurrent database coordinator activities service subclass threshold queued
concurrentdbcoordactivities_subclass_threshold_value - Concurrent database coordinator activities service subclass threshold value
concurrentdbcoordactivities_subclass_threshold_violated - Concurrent database coordinator activities service subclass threshold violated
concurrentdbcoordactivities_superclass_threshold_id - Concurrent database coordinator activities service superclass threshold ID
concurrentdbcoordactivities_superclass_threshold_queued - Concurrent database coordinator activities service superclass threshold queued
concurrentdbcoordactivities_superclass_threshold_value - Concurrent database coordinator activities service superclass threshold value
concurrentdbcoordactivities_superclass_threshold_violated - Concurrent database coordinator activities service superclass threshold violated
concurrentdbcoordactivities_work_action_set_threshold_id - Concurrent database coordinator activities work action set threshold ID
concurrentdbcoordactivities_work_action_set_threshold_queued - Concurrent database coordinator activities work action set threshold queued
concurrentdbcoordactivities_work_action_set_threshold_value - Concurrent database coordinator activities work action set threshold value
concurrentdbcoordactivities_work_action_set_threshold_violated - Concurrent database coordinator activities work action set threshold violated
conn_complete_time - Connection request completion timestamp
conn_time - Time of database connection
connection_status - Connection status
connections_top - Maximum number of concurrent connections
consistency_token - Package consistency token
container_accessible - Accessibility of container
container_id - Container identification
container_name - Container name
container_stripe_set - Container stripe set
container_total_pages - Total pages in container
container_type - Container type
container_usable_pages - Usable pages in container
coord_act_aborted_total - Coordinator activities aborted total
coord_act_completed_total - Coordinator activities completed total
coord_act_est_cost_avg - Coordinator activity estimated cost average
coord_act_exec_time_avg - Coordinator activities execution time average
coord_act_interarrival_time_avg - Coordinator activity arrival time average
coord_act_lifetime_avg - Coordinator activity lifetime average
coord_act_lifetime_top - Coordinator activity lifetime top
coord_member - Coordinator member
coord_act_queue_time_avg - Coordinator activity queue time average
coord_act_rejected_total - Coordinator activities rejected total
coord_agent_pid - Coordinator agent identifier
coord_agents_top - Maximum number of coordinating agents
coord_node - Coordinating node
coord_partition_num - Coordinator partition number
corr_token - DRDA correlation token
cost_estimate_top - Cost estimate top
count - Number of event monitor overflows
cputime_threshold_id - CPU time threshold ID
cputime_threshold_value - CPU time threshold value
cputime_threshold_violated - CPU time threshold violated
cputimeinsc_threshold_id - CPU time in service class threshold ID
cputimeinsc_threshold_value - CPU time in service class threshold value
cputimeinsc_threshold_violated - CPU time in service class threshold violated
create_nickname - Create nicknames
create_nickname_time - Create nickname response time
creator - Application creator
current_active_log - Current active log file number
current_archive_log - Current archive log file number
current_extent - Extent currently being moved
cursor_name - Cursor name
data_object_pages - Data object pages
data_partition_id - Data partition identifier
datasource_name - Data source name
db2_status - Status of DB2 instance
db2start_time - Start database manager timestamp
db_conn_time - Database activation timestamp
db_heap_top - Maximum database heap allocated
db_location - Database location
db_name - Database name
db_path - Database path
db_status - Status of database
db_storage_path - Automatic storage path
db_storage_path_state - Storage path state
db_storage_path_with_dpe - Storage path including database partition expression
db_work_action_set_id - Database work action set ID
db_work_class_id - Database work class ID
dcs_appl_status - DCS application status
dcs_db_name - DCS database name
ddl_sql_stmts - Data definition language (DDL) SQL statements
deadlock_id - Deadlock event identifier
deadlock_node - Partition number where deadlock occurred
deadlocks - Deadlocks detected
degree_parallelism - Degree of parallelism
del_keys_cleaned - Pseudo deleted keys cleaned
delete_sql_stmts - Deletes
delete_time - Delete response time
destination_service_class_id – Destination service class ID
diaglog_write_wait_time - Diagnostic log file write wait time
diaglog_writes_total - Total diagnostic log file writes
direct_read_reqs - Direct read requests
direct_read_time - Direct read time
direct_reads - Direct reads from database
direct_write_reqs - Direct write requests
direct_write_time - Direct write time
direct_writes - Direct writes to database
disconn_time - Database deactivation timestamp
disconnects - Disconnects
dl_conns - Connections involved in deadlock
dynamic_sql_stmts - Dynamic SQL statements attempted
eff_stmt_text - Effective statement text
effective_isolation - Effective isolation
effective_lock_timeout - Effective lock timeout
effective_query_degree - Effective query degree
elapsed_exec_time - Statement execution elapsed time
empty_pages_deleted - Empty pages deleted
empty_pages_reused - Empty pages reused
entry_time - Entry time
estimatedsqlcost_threshold_id - Estimated SQL cost threshold ID
estimatedsqlcost_threshold_value - Estimated SQL cost threshold value
estimatedsqlcost_threshold_violated - Estimated SQL cost threshold violated
event_monitor_name - Event monitor name
event_time - Event time
evmon_activates - Number of event monitor activations
executable_id - Executable ID
evmon_flushes - Number of event monitor flushes
execution_id - User login ID
failed_sql_stmts - Failed statement operations
fcm_message_recv_volume - FCM message received volume
fcm_message_recv_wait_time - FCM message received wait time
fcm_message_recvs_total - Total FCM message receives
fcm_message_send_volume - FCM message send volume
fcm_message_send_wait_time - FCM message send wait time
fcm_message_sends_total - Total FCM message sends
fcm_recv_volume - FCM received volume
fcm_recv_wait_time - FCM received wait time
fcm_recvs_total - FCM receives total
fcm_send_volume - FCM send volume
fcm_send_wait_time - FCM send wait time
fcm_sends_total - FCM sends total
fcm_tq_recv_volume - FCM table queue received volume
fcm_tq_recv_wait_time - FCM table queue received wait time
fcm_tq_recvs_total - FCM table queue receives total
fcm_tq_send_volume - FCM table queue send volume
fcm_tq_send_wait_time - FCM table queue send wait time
fcm_tq_sends_total - FCM table queue send total
fetch_count - Number of successful fetches
files_closed - Database files closed
first_active_log - First active log file number
first_overflow_time - Time of first event overflow
fs_caching - File system caching
fs_id - Unique file system identification number
fs_total_size - Total size of a file system
fs_type - File system type
fs_used_size - Amount of space used on a file system
gw_comm_error_time - Communication error time
gw_comm_errors - Communication errors
gw_con_time - DB2 Connect gateway first connect initiated
gw_connections_top - Maximum number of concurrent connections to host database
gw_cons_wait_client - Number of connections waiting for the client to send request
gw_cons_wait_host - Number of connections waiting for the host to reply
gw_cur_cons - Current number of connections for DB2 Connect
gw_db_alias - Database alias at the gateway
gw_exec_time - Elapsed time spent on DB2 Connect gateway processing
gw_total_cons - Total number of attempted connections for DB2 Connect
hadr_connect_status - HADR connection status
hadr_connect_time - HADR connection time
hadr_heartbeat - HADR heartbeat
hadr_local_host - HADR local host
hadr_local_service - HADR local service
hadr_log_gap - HADR log gap
hadr_peer_window - HADR peer window
hadr_peer_window_end - HADR peer window end
hadr_primary_log_file - HADR primary log file
hadr_primary_log_lsn - HADR primary log LSN
hadr_primary_log_page - HADR primary log page
hadr_remote_host - HADR remote host
hadr_remote_instance - HADR remote instance
hadr_remote_service - HADR remote service
hadr_role - HADR role
hadr_standby_log_file - HADR standby log file
hadr_standby_log_lsn - HADR standby log LSN
hadr_standby_log_page - HADR standby log page
hadr_state - HADR state
hadr_syncmode - HADR synchronization mode
hadr_timeout - HADR timeout
hash_join_overflows - Hash join overflows
hash_join_small_overflows - Hash join small overflows
histogram_type - Histogram type
host_ccsid - Host coded character set ID
host_db_name - Host database name
host_prdid - Host product/version ID
host_response_time - Host response time
idle_agents - Number of idle agents
iid - Index identifier
inbound_bytes_received - Inbound number of bytes received
inbound_bytes_sent - Inbound number of bytes sent
inbound_comm_address - Inbound communication address
include_col_updates - Include column updates
index_object_pages - Index object pages
index_only_scans - Index-only scans
index_scans - Index scans
index_tbsp_id - Index table space ID
input_db_alias - Input database alias
insert_sql_stmts - Inserts
insert_time - Insert response time
insert_timestamp - Statement insert timestamp
int_auto_rebinds - Internal automatic rebinds
int_commits - Internal commits
int_deadlock_rollbacks - Internal rollbacks due to deadlock
int_node_splits - Intermediate node splits
int_rollbacks - Internal rollbacks
int_rows_deleted - Internal rows deleted
int_rows_inserted - Internal rows inserted
int_rows_updated - Internal rows updated
invocation_id - Invocation ID
ipc_recv_volume - Interprocess communication received volume
ipc_recv_wait_time - Interprocess communication received wait time
ipc_recvs_total - Interprocess communication receives total
ipc_send_volume - Interprocess communication send volume
ipc_send_wait_time - Interprocess communication send wait time
ipc_sends_total - Interprocess communication send total
is_system_appl - Is System Application
key_updates - Key updates
last_active_log - Last active log file number
last_backup - Last backup timestamp
last_extent - Last extent moved
last_overflow_time - Time of last event overflow
last_reference_time - Last reference time
last_reset - Last reset timestamp
last_wlm_reset - Time of last reset
lob_object_pages - LOB object pages
local_cons - Local connections
local_cons_in_exec - Local connections executing in the database manager
local_start_time - Local start time
lock_attributes - Lock attributes
lock_count - Lock count
lock_current_mode - Original lock mode before conversion
lock_escalation - Lock escalation
lock_escals - Number of lock escalations
lock_hold_count - Lock hold count
lock_list_in_use - Total lock list memory in use
lock_mode - Lock mode
lock_mode_requested - Lock mode requested
lock_name - Lock name
lock_node - Lock node
lock_object_name - Lock object name
lock_object_type - Lock object type waited on
lock_release_flags - Lock release flags
lock_status - Lock status
lock_timeout_val - Lock timeout value
lock_timeouts - Number of lock timeouts
lock_wait_start_time - Lock wait start timestamp
lock_wait_time - Time waited on locks
lock_wait_time_top – Lock wait time top monitor element
lock_waits - Lock waits
locks_held - Locks held
locks_held_top - Maximum number of locks held
locks_in_list - Number of locks reported
locks_waiting - Current agents waiting on locks
log_buffer_wait_time - Log buffer wait time
log_disk_wait_time - Log disk wait time
log_disk_waits_total - Total log disk waits
log_held_by_dirty_pages - Amount of log space accounted for by dirty pages
log_read_time - Log read time
log_reads - Number of log pages read
log_to_redo_for_recovery - Amount of log to be redone for recovery
log_write_time - Log write time
log_writes - Number of log pages written
long_object_pages - Long object pages
long_tbsp_id - Long table space ID
max_agent_overflows - Maximum agent overflows
max_data_received_1024 - Number of statements with outbound bytes received between 513 and 1024 bytes
max_data_received_128 - Number of statements with outbound bytes received between 1 and 128 bytes
max_data_received_16384 - Number of statements with outbound bytes received between 8193 and 16384 bytes
max_data_received_2048 - Number of statements with outbound bytes received between 1025 and 2048 bytes
max_data_received_256 - Number of statements with outbound bytes received between 129 and 256 bytes
max_data_received_31999 - Number of statements with outbound bytes received between 16385 and 31999 bytes
max_data_received_4096 - Number of statements with outbound bytes received between 2049 and 4096 bytes
max_data_received_512 - Number of statements with outbound bytes received between 257 and 512 bytes
max_data_received_64000 - Number of statements with outbound bytes received between 32000 and 64000 bytes
max_data_received_8192 - Number of statements with outbound bytes received between 4097 and 8192 bytes
max_data_received_gt64000 - Number of statements with outbound bytes received greater than 64000 bytes
max_data_sent_1024 - Number of statements with outbound bytes sent between 513 and 1024 bytes
max_data_sent_128 - Number of statements with outbound bytes sent between 1 and 128 bytes
max_data_sent_16384 - Number of statements with outbound bytes sent between 8193 and 16384 bytes
max_data_sent_2048 - Number of statements with outbound bytes sent between 1025 and 2048 bytes
max_data_sent_256 - Number of statements with outbound bytes sent between 129 and 256 bytes
max_data_sent_31999 - Number of statements with outbound bytes sent between 16385 and 31999 bytes
max_data_sent_4096 - Number of statements with outbound bytes sent between 2049 and 4096 bytes
max_data_sent_512 - Number of statements with outbound bytes sent between 257 and 512 bytes
max_data_sent_64000 - Number of statements with outbound bytes sent between 32000 and 64000 bytes
max_data_sent_8192 - Number of statements with outbound bytes sent between 4097 and 8192 bytes
max_data_sent_gt64000 - Number of statements with outbound bytes sent greater than 64000 bytes
max_network_time_100_ms - Number of statements with network time between 16 and 100 ms
max_network_time_16_ms - Number of statements with network time between 4 and 16 ms
max_network_time_1_ms - Number of statements with network time of up to 1 ms
max_network_time_4_ms - Number of statements with network time between 1 and 4 ms
max_network_time_500_ms - Number of statements with network time between 100 and 500 ms
max_network_time_gt500_ms - Number of statements with network time greater than 500 ms
member - Database member
message - Control table message
message_time - Timestamp control table message
nesting_level - Nesting level
network_time_bottom - Minimum network time for statement
network_time_top - Maximum network time for statement
nleaf - Number of leaf pages
nlevels - Number of index levels
node_number - Node number
nonboundary_leaf_node_splits - Non-boundary leaf node splits
num_agents - Number of agents working on a statement
num_assoc_agents - Number of associated agents
num_compilations - Statement compilations
num_db_storage_paths - Number of automatic storage paths
num_executions - Statement executions
num_exec_with_metrics - Number of executions with metrics collected
num_extents_left - Number of extents left to process
num_extents_moved - Number of extents moved
num_gw_conn_switches - Connection switches
num_indoubt_trans - Number of indoubt transactions
num_log_buffer_full - Number of full log buffers
num_log_data_found_in_buffer - Number of log data found in buffer
num_log_part_page_io - Number of partial log page writes
num_log_read_io - Number of log reads
num_log_write_io - Number of log writes
num_nodes_in_db2_instance - Number of nodes in database partition
num_remaps - Number of remaps
num_threshold_violations - Number of threshold violations
num_transmissions - Number of transmissions
num_transmissions_group - Number of transmissions group
number_in_bin - Number in bin
olap_func_overflows - OLAP function overflows
open_cursors - Number of open cursors
open_loc_curs - Open local cursors
open_loc_curs_blk - Open local cursors with blocking
open_rem_curs - Open remote cursors
open_rem_curs_blk - Open remote cursors with blocking
outbound_appl_id - Outbound application ID
outbound_bytes_received - Outbound number of bytes received
outbound_bytes_received_bottom - Minimum outbound number of bytes received
outbound_bytes_received_top - Maximum outbound number of bytes received
outbound_bytes_sent - Outbound number of bytes sent
outbound_bytes_sent_bottom - Minimum outbound number of bytes sent
outbound_bytes_sent_top - Maximum outbound number of bytes sent
outbound_comm_address - Outbound communication address
outbound_comm_protocol - Outbound communication protocol
outbound_sequence_no - Outbound sequence number
overflow_accesses - Accesses to overflowed records
overflow_creates - Overflow creates
package_name - Package name
package_schema - Package schema
package_version_id - Package version
page_allocations - Page allocations
page_reorgs - Page reorganizations
pages_from_block_ios - Total number of pages read by block I/O
pages_from_vectored_ios - Total pages read by vectored I/O
pages_merged - Pages merged
pages_read - Number of pages read
pages_written - Number of pages written
parent_activity_id - Parent activity ID
parent_uow_id - Parent unit of work ID
partial_record - Partial record
participant_no - Participant within deadlock
participant_no_holding_lk - Participant holding a lock on the object required by application
partition_number - Partition number
passthru_time - Pass-through time
passthrus - Pass-through
piped_sorts_accepted - Piped sorts accepted
piped_sorts_requested - Piped sorts requested
pkg_cache_inserts - Package cache inserts
pkg_cache_lookups - Package cache lookups
pkg_cache_num_overflows - Package cache overflows
pkg_cache_size_top - Package cache high watermark
pool_async_data_read_reqs - Buffer pool asynchronous read requests
pool_async_data_reads - Buffer pool asynchronous data reads
pool_async_data_writes - Buffer pool asynchronous data writes
pool_async_index_read_reqs - Buffer pool asynchronous index read requests
pool_async_index_reads - Buffer pool asynchronous index reads
pool_async_index_writes - Buffer pool asynchronous index writes
pool_async_read_time - Buffer pool asynchronous read time
pool_async_write_time - Buffer pool asynchronous write time
pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests
pool_async_xda_reads - Buffer pool asynchronous XDA data reads
pool_async_xda_writes - Buffer pool asynchronous XDA data writes
pool_config_size - Configured size of memory pool
pool_cur_size - Current size of memory pool
pool_data_l_reads - Buffer pool data logical reads
pool_data_p_reads - Buffer pool data physical reads
pool_data_writes - Buffer pool data writes
pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered
pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered
pool_id - Memory pool identifier
pool_index_l_reads - Buffer pool index logical reads
pool_index_p_reads - Buffer pool index physical reads
pool_index_writes - Buffer pool index writes
pool_lsn_gap_clns - Buffer pool log space cleaners triggered
pool_no_victim_buffer - Buffer pool no victim buffers
pool_read_time - Total buffer pool physical read time
pool_secondary_id - Memory pool secondary identifier
pool_temp_data_l_reads - Buffer pool temporary data logical reads
pool_temp_data_p_reads - Buffer pool temporary data physical reads
pool_temp_index_l_reads - Buffer pool temporary index logical reads
pool_temp_index_p_reads - Buffer pool temporary index physical reads
pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads
pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads
pool_watermark - Memory pool watermark
pool_write_time - Total buffer pool physical write time
pool_xda_l_reads - Buffer pool XDA data logical reads
pool_xda_p_reads - Buffer pool XDA data physical reads
pool_xda_writes - Buffer pool XDA data writes
post_shrthreshold_hash_joins - Post threshold hash joins
post_shrthreshold_sorts - Post shared threshold sorts
post_threshold_hash_joins - Hash join threshold
post_threshold_olap_funcs - OLAP function threshold
post_threshold_sorts - Post threshold sorts
prefetch_wait_time - Time waited for prefetch
prep_time - Preparation time
prep_time_best - Statement best preparation time
prep_time_worst - Statement worst preparation time
prev_uow_stop_time - Previous unit of work completion timestamp
priv_workspace_num_overflows - Private workspace overflows
priv_workspace_section_inserts - Private workspace section inserts
priv_workspace_section_lookups - Private workspace section lookups
priv_workspace_size_top - Maximum private workspace size
product_name - Product name
progress_completed_units - Completed progress work units
progress_description - Progress description
progress_list_attr - Current progress list attributes
progress_list_current_seq_num - Current progress list sequence number
progress_seq_num - Progress sequence number
progress_start_time - Progress start time
progress_total_units - Total progress work units
progress_work_metric - Progress work metric
pseudo_deletes - Pseudo deletes
pseudo_empty_pages - Pseudo empty pages
qp_query_id - Query patroller query ID
query_card_estimate - Query number of rows estimate
query_cost_estimate - Query cost estimate
queue_assignments_total - Queue assignments total
queue_size_top - Queue size top
queue_time_total - Queue time total
quiescer_agent_id - Quiescer agent identification
quiescer_auth_id - Quiescer user authorization identification
quiescer_obj_id - Quiescer object identification
quiescer_state - Quiescer state
quiescer_ts_id - Quiescer table space identification
range_adjustment - Range adjustment
range_container_id - Range container
range_end_stripe - End stripe
range_max_extent - Maximum extent in range
range_max_page_number - Maximum page in range
range_num_containers - Number of containers in range
range_number - Range number
range_offset - Range offset
range_start_stripe - Start stripe
range_stripe_set_number - Stripe set number
reclaimable_space_enabled - Reclaimable space enabled indicator
rej_curs_blk - Rejected block cursor requests
rem_cons_in - Remote connections to database manager
rem_cons_in_exec - Remote connections executing in the database manager
remote_lock_time - Remote lock time
remote_locks - Remote locks
reorg_completion - Table reorganization completion flag
reorg_current_counter - Table reorganize progress
reorg_end - Table reorganize end time
reorg_index_id - Index used to reorganize the table
reorg_long_tbspc_id - Table space where long objects are reorganized
reorg_max_counter - Total amount of table reorganization
reorg_max_phase - Maximum table reorganize phase
reorg_phase - Table reorganization phase
reorg_phase_start - Table reorganize phase start time
reorg_rows_compressed - Rows compressed
reorg_rows_rejected_for_compression - Rows rejected for compression
reorg_start - Table reorganize start time
reorg_status - Table reorganize status
reorg_tbspc_id - Table space where table is reorganized
reorg_type - Table reorganize attributes
reorg_xml_regions_compressed – XML regions compressed
reorg_xml_regions_rejected_for_compression – XML regions rejected for compression
request_exec_time_avg - Request execution time average
rf_log_num - Log being rolled forward
rf_status - Log phase
rf_timestamp - Rollforward timestamp
rf_type - Rollforward type
rollback_sql_stmts - Rollback statements attempted
rolled_back_agent_id - Rolled back agent
rolled_back_appl_id - Rolled back application
rolled_back_participant_no - Rolled back application participant
rolled_back_sequence_no - Rolled back sequence number
root_node_splits - Root node splits
routine_id - Routine ID
rows_deleted - Rows deleted
rows_fetched - Rows fetched
rows_inserted - Rows inserted
rows_modified - Rows modified
rows_read - Rows read
rows_returned - Rows returned
rows_returned_top - Actual rows returned top
rows_selected - Rows selected
rows_updated - Rows updated
rows_written - Rows written
rqsts_completed_total - Total requests completed
sc_work_action_set_id - Service class work action set ID
sc_work_class_id - Service class work class ID
sec_log_used_top - Maximum secondary log space used
sec_logs_allocated - Secondary logs allocated currently
section_env - Section environment
section_number - Section number
section_type - Section type indicator
select_sql_stmts - Select SQL statements executed
select_time - Query response time
sequence_no - Sequence number
sequence_no_holding_lk - Sequence number holding lock
server_db2_type - Database manager type at monitored (server) node
server_instance_name - Server instance name
server_platform - Server operating system
server_prdid - Server product/version ID
server_version - Server version
service_class_id - Service class ID
service_level - Service level
service_subclass_name - Service subclass name
service_superclass_name - Service superclass name
session_auth_id - Session authorization ID
shr_workspace_num_overflows - Shared workspace overflows
shr_workspace_section_inserts - Shared workspace section inserts
shr_workspace_section_lookups - Shared workspace section lookups
shr_workspace_size_top - Maximum shared workspace size
smallest_log_avail_node - Node with least available log space
sort_heap_allocated - Total sort heap allocated
sort_heap_top - Sort private heap high watermark
sort_overflows - Sort overflows
sort_shrheap_allocated - Sort share heap currently allocated
sort_shrheap_top - Sort share heap high watermark
source_service_class_id - Source service class ID
sp_rows_selected - Rows returned by stored procedures
sql_chains - Number of SQL chains attempted
sql_req_id - Request identifier for SQL statement
sql_reqs_since_commit - SQL requests since last commit
sql_stmts - Number of SQL statements attempted
sqlca - SQL Communications Area (SQLCA)
sqlrowsread_threshold_id - SQL rows read threshold ID
sqlrowsread_threshold_value - SQL rows read threshold value
sqlrowsread_threshold_violated - SQL rows read threshold violated
sqlrowsreadinsc_threshold_id - SQL rows read in service class threshold ID
sqlrowsreadinsc_threshold_value - SQL rows read in service class threshold value
sqlrowsreadinsc_threshold_violated - SQL rows read in service class threshold violated
sqlrowsreturned_threshold_id - SQL rows read returned threshold ID
sqlrowsreturned_threshold_value - SQL rows read returned threshold value
sqlrowsreturned_threshold_violated - SQL rows read returned threshold violated
sqltempspace_threshold_id - SQL temporary space threshold ID
sqltempspace_threshold_value - SQL temporary space threshold value
sqltempspace_threshold_violated - SQL temporary space threshold violated
ss_exec_time - Subsection execution elapsed time
ss_node_number - Subsection node number
ss_number - Subsection number
ss_status - Subsection status
ss_sys_cpu_time - System CPU time used by subsection
ss_usr_cpu_time - User CPU time used by subsection
start_time - Event start time
static_sql_stmts - Static SQL statements attempted
statistics_timestamp - Statistics timestamp
stats_cache_size – Size of statistics cache
stats_fabricate_time – Total time spent on statistics fabrication activities
stats_fabrications – Total number of statistics fabrications
status_change_time - Application status change time
stmt_elapsed_time - Most recent statement elapsed time
stmt_first_use_time - Statement first use time
stmt_history_id - Statement history identifier
stmt_history_list_size - Statement history list size
stmt_invocation_id - Statement invocation identifier
stmt_isolation - Statement isolation
stmt_last_use_time - Statement last use time
stmt_lock_timeout - Statement lock timeout
stmt_nest_level - Statement nesting level
stmt_node_number - Statement node
stmt_operation/operation - Statement operation
stmt_pkgcache_id - Statement package cache identifier
stmt_query_id - Statement query identifier
stmt_sorts - Statement sorts
stmt_source_id - Statement source identifier
stmt_start - Statement operation start timestamp
stmt_stop - Statement operation stop timestamp
stmt_sys_cpu_time - System CPU time used by statement
stmt_text - SQL statement text
stmt_type - Statement type
stmt_usr_cpu_time - User CPU time used by statement
stmt_value_data - Value data
stmt_value_index - Value index
stmt_value_isnull - Value has null value
stmt_value_isreopt - Variable used for statement reoptimization
stmt_value_type - Value type
sto_path_free_sz - Automatic storage path free space
stop_time - Event stop time
stored_proc_time - Stored procedure time
stored_procs - Stored procedures
sync_runstats – Total number of synchronous RUNSTATS activities
sync_runstats_time – Total time spent on synchronous RUNSTATS activities
system_cpu_time - System CPU time
tab_file_id - Table file ID
tab_type - Table type
table_file_id - Table file identification
table_name - Table name
table_scans - Table scans
table_schema - Table schema name
table_type - Table type
tablespace_auto_resize_enabled - Table space automatic resizing enabled
tablespace_content_type - Table space content type
tablespace_cur_pool_id - Buffer pool currently being used
tablespace_current_size - Current table space size
tablespace_extent_size - Table space extent size
tablespace_free_pages - Free pages in table space
tablespace_id - Table space identification
tablespace_increase_size - Increase size in bytes
tablespace_increase_size_percent - Increase size by percent
tablespace_initial_size - Initial table space size
tablespace_last_resize_failed - Last resize attempt failed
tablespace_last_resize_time - Time of last successful resize
tablespace_max_size - Maximum table space size
tablespace_min_recovery_time - Minimum recovery time for rollforward
tablespace_name - Table space name
tablespace_next_pool_id - Buffer pool that will be used at next startup
tablespace_num_containers - Number of containers in table space
tablespace_num_quiescers - Number of quiescers
tablespace_num_ranges - Number of ranges in the table space map
tablespace_page_size - Table space page size
tablespace_page_top - Table space high watermark
tablespace_paths_dropped - Table space using dropped path
tablespace_pending_free_pages - Pending free pages in table space
tablespace_prefetch_size - Table space prefetch size
tablespace_rebalancer_extents_processed - Number of extents the rebalancer has processed
tablespace_rebalancer_extents_remaining - Total number of extents to be processed by the rebalancer
tablespace_rebalancer_last_extent_moved - Last extent moved by the rebalancer
tablespace_rebalancer_mode - Rebalancer mode
tablespace_rebalancer_priority - Current rebalancer priority
tablespace_rebalancer_restart_time - Rebalancer restart time
tablespace_rebalancer_start_time - Rebalancer start time
tablespace_state - Table space state
tablespace_state_change_object_id - State change object identification
tablespace_state_change_ts_id - State change table space identification
tablespace_total_pages - Total pages in table space
tablespace_type - Table space type
tablespace_usable_pages - Usable pages in table space
tablespace_used_pages - Used pages in table space
tablespace_using_auto_storage - Table space enabled for automatic storage
tbsp_max_page_top - Maximum table space page high watermark
tcpip_recv_volume - TCP/IP received volume
tcpip_recv_wait_time - TCP/IP received wait time
tcpip_recvs_total - TCP/IP receives total
tcpip_send_volume - TCP/IP send volume
tcpip_send_wait_time - TCP/IP send wait time
tcpip_sends_total - TCP/IP sends total
temp_tablespace_top - Temporary table space top
territory_code - Database territory code
threshold_action - Threshold action
threshold_domain - Threshold domain
threshold_maxvalue - Threshold maximum value
threshold_name - Threshold name
threshold_predicate - Threshold predicate
threshold_queuesize - Threshold queue size
thresholdid - Threshold ID
time_completed - Time completed
time_created - Time created
time_of_violation - Time of violation
time_stamp - Snapshot time
time_started - Time started
time_zone_disp - Time zone displacement
top - Histogram bin top
tot_log_used_top - Maximum total log space used
total_act_time - Total activity time
total_act_wait_time - Total activity wait time
total_app_rqst_time - Total application request time
total_buffers_rcvd - Total FCM buffers received
total_buffers_sent - Total FCM buffers sent
total_cons - Connects since database activation
total_cpu_time - Total CPU time
total_exec_time - Elapsed statement execution time
total_move_time - Total extent move time
total_hash_joins - Total hash joins
total_hash_loops - Total hash loops
total_log_available - Total log available
total_log_used - Total log space used
total_olap_funcs - Total OLAP functions
total_rqst_mapped_in - Total request mapped-in
total_rqst_mapped_out - Total request mapped-out
total_rqst_time - Total request time
total_sec_cons - Secondary connections
total_section_sorts - Total section sorts
total_section_sort_proc_time - Total section sort processing time
total_section_sort_time - Total section sort time
total_sort_time - Total sort time
total_sorts - Total sorts
total_sys_cpu_time - Total system CPU time for a statement
total_sorts - Total sorts
total_usr_cpu_time - Total user CPU time for a statement
total_wait_time - Total wait time
tpmon_acc_str - TP monitor client accounting string
tpmon_client_app - TP monitor client application name
tpmon_client_userid - TP monitor client user ID
tpmon_client_wkstn - TP monitor client workstation name
tq_cur_send_spills - Current number of table queue buffers overflowed
tq_id_waiting_on - Waited on node on a table queue
tq_max_send_spills - Maximum number of table queue buffers overflows
tq_node_waited_for - Waited for node on a table queue
tq_rows_read - Number of rows read from table queues
tq_rows_written - Number of rows written to table queues
tq_tot_send_spills - Total number of table queue buffers overflowed
tq_wait_for_any - Waiting for any node to send on a table queue
ts_name - Table space being rolled forward
uid_sql_stmts - UPDATE/INSERT/DELETE SQL statements executed
unread_prefetch_pages - Unread prefetch pages
uow_comp_status - Unit of work completion status
uow_elapsed_time - Most recent unit of work elapsed time
uow_id - Unit of work ID
uow_lock_wait_time - Total time unit of work waited on locks
uow_log_space_used - Unit of work log space used
uow_start_time - Unit of work start timestamp
uow_status - Unit of work status
uow_stop_time - Unit of work stop timestamp
uow_total_time_top - UOW total time top monitor element
update_sql_stmts - Updates
update_time - Update response time
user_cpu_time - User CPU time
utility_dbname - Database operated on by utility
utility_description - Utility description
utility_id - Utility ID
utility_invoker_type - Utility invoker type
utility_priority - Utility priority
utility_start_time - Utility start time
utility_state - Utility state
valid - Section validity indicator
utility_type - Utility type
vectored_ios - Number of vectored I/O requests
version - Version of monitor data
wlm_queue_assignments_total - Workload manager total queue assignments
wlm_queue_time_total - Workload manager total queue time
wlo_completed_total - Workload occurrences completed total
work_action_set_id - Work action set ID
work_action_set_name - Work action set name
work_class_id - Work class ID
work_class_name - Work class name
workload_id - Workload ID
workload_name - Workload name
workload_occurrence_id - Workload occurrence identifier
workload_occurrence_state - Workload occurrence state
x_lock_escals - Exclusive lock escalations
xda_object_pages - XDA Object Pages
xid - Transaction ID
xquery_stmts - XQuery Statements Attempted
Troubleshooting and support
Troubleshooting a problem
Tools for troubleshooting
db2dart
Comparison of INSPECT and db2dart
db2diag
db2greg
db2level
db2look
db2ls
db2pd
db2support
Traces
DB2 traces
Obtaining a DB2 trace using db2trc
Dumping a DB2 trace
Formatting a DB2 trace
DRDA traces
Obtaining a DRDA trace using db2drdat
DRDA trace output
DRDA trace output file analysis
DRDA trace output file samples
Subsequent buffer information for DRDA
Control Center traces
JDBC trace files
DB2 JDBC Type 2 Driver
DB2 Universal JDBC Driver
CLI traces
Obtaining CLI traces
Analyzing input and output parameters in CLI trace files
Analyzing Dynamic SQL in CLI traces
Analyzing timing information in CLI traces
Analyzing unknown values in CLI traces
Analyzing multi-threaded CLI trace output
Platform-specific tools
Diagnostic tools (Windows)
Diagnostic tools (Linux and UNIX)
Troubleshooting DB2 database
Collecting data
Collecting data for data movement problems
Collecting data for DAS and instance management problems
Analyzing data
Recovering from sustained traps
Troubleshooting administrative task scheduler
Troubleshooting compression
Data compression dictionary is not automatically created
Row compression not reducing disk storage space for temporary tables
Data replication process cannot decompress a compressed row image
Troubleshooting global variables
Troubleshooting global variable problems
Troubleshooting high availability
Tivoli SA MP Base Component is not installed by DB2 Version 9.5 GA on AIX 6.1
Troubleshooting inconsistencies
Troubleshooting data inconsistencies
Troubleshooting index to data inconsistencies
Troubleshooting installation
Collecting data for installation problems
Analyzing data for installation problems
Known problems and solutions
Errors when installing a DB2 database product as a non-root user to the default path on a system WPAR (AIX)
Beta and non-beta versions of DB2 database products cannot coexist
Resolving service name errors when you install DB2 database products
Troubleshooting license issues
Analyzing DB2 license compliance reports
Troubleshooting locking problems
Diagnosing and resolving locking problems
Diagnosing a lock wait problem
Resolving lock wait problems
Diagnosing a deadlock problem
Resolving deadlock problems
Diagnosing a lock timeout problem
Resolving lock timeout problems
Diagnosing a lock escalation problem
Resolving lock escalation problems
Troubleshooting optimization
Troubleshooting optimization guidelines and profiles
Troubleshooting partitioned database environments
FCM problems related to 127.0.0.2 (Linux and UNIX)
Creating a database partition on an encrypted file system (AIX)
Troubleshooting scripts
Troubleshooting scripts
Troubleshooting storage key support
Troubleshooting storage key support
Troubleshooting DB2 Connect
Diagnostic tools
Gathering relevant information
Initial connection is not successful
Problems encountered after an initial connection
Unsupported DDM commands
Common DB2 Connect problems
Searching knowledge bases
Troubleshooting resources
Getting fixes
Applying fix packs
Fix packs, interim fix packs and test fixes
Applying test fixes
Learning more
About administration notification log files
Interpreting administration notification log file entries
Setting the error capture level for the administration notification log file
About DB2 diagnostic (db2diag) log files
Interpreting diagnostic log file entries
Interpreting the informational record of the db2diag log files
Setting the error capture level of the diagnostic log files
About combining DB2 and OS diagnostics
About db2cos output files
About dump files
About first occurrence data capture (FODC)
Collecting diagnosis information based on common outage problems
Configuring for automatic collection of diagnostic information
Data collected as part of FODC and its placement
Automatic FODC data generation
DB2 Query Patroller and First Occurrence Data Capture (FODC)
Monitor and audit facilities using First Occurrence Data Capture (FODC)
Graphical tools using First Occurrence Data Capture (FODC)
About internal return codes
About platform-specific error logs
System core files (Linux and UNIX)
Accessing system core file information (Linux and UNIX)
Accessing event logs (Windows)
Exporting event logs (Windows)
Accessing the Dr. Watson log file (Windows)
About trap files
Formatting trap files (Windows)
Contacting IBM Software Support
Submitting data to IBM Software Support
Messages
Introduction to messages
Communication errors
SPM protocol violation records
SQLSTATE Messages
ADM Messages
ADM0001C
ADM0500E
ADM0501C
ADM0502C
ADM0503C
ADM0504C
ADM0505E
ADM0506I
ADM0507W
ADM0508E
ADM0509E
ADM0510E
ADM0511E
ADM0512W
ADM0513W
ADM1010I
ADM1011I
ADM1012W
ADM1013W
ADM1014E
ADM1022W
ADM1023W
ADM1024W
ADM1500W
ADM1510W
ADM1511W
ADM1512E
ADM1513W
ADM1514W
ADM1530E
ADM1531E
ADM1532E
ADM1533W
ADM1534W
ADM1540W
ADM1541W
ADM1542W
ADM1550W
ADM1551W
ADM1552E
ADM1600W
ADM1601W
ADM1602W
ADM1603I
ADM1604I
ADM1605I
ADM1606I
ADM1607I
ADM1608I
ADM1609W
ADM1610W
ADM1611W
ADM1612W
ADM1613W
ADM1614W
ADM1615W
ADM1616E
ADM1617W
ADM1618W
ADM1619W
ADM1620W
ADM1700W
ADM1701W
ADM1710C
ADM1711W
ADM1712C
ADM1713C
ADM1800E
ADM1801W
ADM1802W
ADM1803W
ADM1804W
ADM1805E
ADM1806E
ADM1807E
ADM1810E
ADM1811E
ADM1812E
ADM1813E
ADM1814E
ADM1815E
ADM1817E
ADM1818E
ADM1819C
ADM1820W
ADM1821E
ADM1822W
ADM1823E
ADM1824W
ADM1825W
ADM1826E
ADM1827E
ADM1828C
ADM1829E
ADM1830E
ADM1831E
ADM1832E
ADM1833E
ADM1834E
ADM1835E
ADM1836W
ADM1837W
ADM1838W
ADM1839W
ADM1840W
ADM1841W
ADM1842W
ADM1843I
ADM1844I
ADM1845I
ADM1846I
ADM1847W
ADM1848W
ADM1849C
ADM1850C
ADM2000E
ADM2001W
ADM2002E
ADM2003W
ADM2004E
ADM2005W
ADM2006W
ADM2007W
ADM2009C
ADM2010C
ADM2011C
ADM2012C
ADM2013C
ADM2014W
ADM2015W
ADM2016W
ADM2017C
ADM2018W
ADM2500E
ADM2501C
ADM2502C
ADM2503C
ADM2504C
ADM2505E
ADM2506W
ADM2507I
ADM2508I
ADM2509I
ADM3000C
ADM3001C
ADM3003C
ADM3006C
ADM3008C
ADM3019C
ADM3020C
ADM3021W
ADM3500W
ADM4000W
ADM4001I
ADM4002W
ADM4014N
ADM4015I
ADM4016I
ADM4100W
ADM4101W
ADM4102W
ADM4103W
ADM4104E
ADM4105W
ADM4106W
ADM4200N
ADM4201N
ADM4500W
ADM5500W
ADM5501I
ADM5502W
ADM5503E
ADM5504W
ADM5505E
ADM5506I
ADM5507I
ADM5508I
ADM5509I
ADM5510E
ADM5511E
ADM5512N
ADM5513I
ADM5514I
ADM5515I
ADM5520E
ADM5521C
ADM5530W
ADM5540W
ADM5541W
ADM5542W
ADM5543E
ADM5550C
ADM5560C
ADM5561C
ADM5562C
ADM5570W
ADM5571W
ADM5572I
ADM5580W
ADM5581W
ADM5582C
ADM5583W
ADM5590E
ADM5591W
ADM5592I
ADM5593I
ADM5594I
ADM5595E
ADM5600I
ADM6000E
ADM6001I
ADM6002E
ADM6003I
ADM6006E
ADM6007C
ADM6008I
ADM6012W
ADM6013W
ADM6017E
ADM6018I
ADM6019E
ADM6020I
ADM6021I
ADM6022W
ADM6023I
ADM6024C
ADM6025I
ADM6028W
ADM6029W