DB2 solution Information Center home
Overview of the DB2 technical information
DB2 troubleshooting information
DB2 PDF and printed documentation
Documentation updates
Updates available for download
Updating the DB2 Information Center
Updating Non-Administrative and Non-Root DB2 Information Centers
Installing DB2 Information Center updates from CD
Mirroring the update site
Features of the DB2 Information Center
DB2 Information Center installation options
Starting the DB2 Information Center
Starting and stopping the Non-Administrative or Non-Root 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
Servers
DB2 Version 9.5 features and functions by edition
DB2 Express-C
Clients and drivers
Common licensing questions
DB2 Version 9.5 features and functions by edition
DB2 data server product purchasing and licensing
Development licenses
Entitlement by processor or user
Processor Value Unit pricing
Memory usage restrictions for DB2 Express Edition
Licensing for high availability
Licensing DB2 features for IBM InfoSphere Warehouse
End of marketing and end of support dates
Release notes
What's New overview
Fix pack summary
New features and functionality
Highlights of Version 9.5
Manage your business, not your database
Increased performance and scalability
Information as a service
Improved security and resilience
High availability and data recovery
More agile development
Product packaging enhancements
New DB2 driver simplifies deployment
Database partitioning is supported on additional Linux distributions
Component names have changed
FP1: DB2 Text Search supports searching SQL and XML data
FP3b: Fewer licenses are required for DB2 features
FP3: JDBC license file added to DB2 Connect and DB2 Database Enterprise Developer Edition Activation CDs
Manageability enhancements
Data server tools have been added
Real-time statistics gathering ensures that latest statistics are used for optimization
Simplified multithreaded architecture reduces the Total Cost of Ownership (TCO)
Database configuration across multiple partitions has been simplified
Memory configuration has been simplified
Data compression has been enhanced
More configuration parameters can be set to AUTOMATIC and configured dynamically
FP1: Data redistribution enhancements reduce capacity growth costs and load-balancing tasks
db2look command generates DDL for more database objects
Enhanced access to DB2 administration commands through SQL
Monitoring capabilities have been extended
FP2: Database monitoring enhanced with the db2top utility (AIX, Linux, and Solaris)
Licensing monitoring is more flexible and efficient
Table spaces use space more efficiently
FP1: db2pd command output provides more information
Lock timeout diagnosis has been enhanced
RUNSTATS utility option has been added to reset statistics profiles
FP2: License enforcement policies prevent unlicensed use of DB2 pureXML and Storage Optimization Features
FP2: Enhanced automation of scheduled tasks with the administrative task scheduler
Workload management enhancements
Workload management improvements provide better control
Security enhancements
Trusted contexts enhance security
Audit facility performance and administration have been enhanced
Roles simplify privilege administration and management
Label-based access control (LBAC) enhancements provide better security
FP2: SSL protocol and AES encryption are supported by some database clients
FP4: LDAP-based authentication and group lookup support has been enhanced
FP3: AES encryption support extended to the database server and all clients
FP4: Passwords can be the maximum length supported by the operating system
Performance enhancements
Queries that reference LOB columns run faster
Optimistic concurrency control and update detection enhancements provide a scalable locking alternative
MDC rollout deletions are faster with the deferred index cleanup option
Index build parallelism is enabled by default
OLAP functions have been enhanced
Query optimizer has been enhanced
NO FILE SYSTEM CACHING default reduces file system cache memory
DB2 Spatial Extender query performance has improved
Additional statements can be explained
FP2: TCP socket buffer size for HADR connections can be tuned
FP2: New db2advis command parameters
FP4: Some FCM memory resources can be automatically managed and allocated (Linux)
pureXML enhancements
XQuery updating expressions allow portions of XML documents to be modified
Load utility support has been added
pureXML application processing performance has been improved
Check constraints functionality has been extended
Trigger processing supports automatic validation of XML documents
XSLT support enables transforming XML data into other formats
SQL/XML and XQuery parameter passing is more flexible
Non-Unicode databases can store XML data
Small XML documents can be stored in base table row for improved performance
XML schemas can be updated without requiring re-validation of XML documents
XQuery upper-case and lower-case functions support locales
XQuery functions extract components from and adjust dates and times
XQuery castable expression supports testing the casting of values
Publishing functions are easier to use
Annotated XML schema decomposition supports order of insertion and registration of recursive schemas
FP3: Annotated XML schema decomposition supports larger XML documents
FP3: XML parsing and validation can return more detailed messages
Application development enhancements
Identifier length limits have increased
IBM Database Add-Ins for Visual Studio 2005 support has been enhanced
Global variables improve data sharing between SQL statements
SET variable is now an executable statement that can be dynamically prepared
Array support enhances application portability
Decimal floating-point data type improves the accuracy and performance of decimal data
New DB2 sample programs have been added
CLIENT APPLNAME special register is automatically set by the CLP
Developer Workbench has been renamed and enhanced
New scalar functions simplify application porting
New bitwise scalar functions added
FP2: .NET 64-bit common language runtime (CLR) routines are supported
FP2: Mutating table conflicts can be eliminated when calling procedures from SQL table functions
FP3: Common SQL API available for developing portable administrative applications
Python application development support has been added
IBM data server client and driver enhancements
JDBC and SQLJ support has been enhanced
JDBC 2.0 and JDBC 3.0 support has been enhanced
JDBC 4.0 support has been added
PHP extensions have been integrated into DB2 installation (Linux, AIX, and Windows)
Ruby on Rails framework support has been integrated into DB2 installation
Perl driver supports pureXML and multibyte characters
IBM Data Server Provider for .NET has been enhanced
FP1: IBM Data Server Provider for .NET supports trusted contexts
FP3: IBM_DB Ruby driver supports trusted contexts
FP3: IBM PHP extensions support trusted context
FP3: Sysplex support extended to IBM data server clients and non-Java data server drivers
FP3: IBM data server drivers have been enhanced
FP3: CLI applications can request accurate row count prior to fetching
FP3: CLI dynamic packages can be bound on demand
FP3: CLI ping capabilities have been enhanced
FP3: IBM data server drivers have been enhanced
High availability, backup, logging, and recovery enhancements
Automated maintenance configuration simplified
Storage integration enabled
Recovery object management automated
Cluster configuration simplified
Recovery more resilient
Failover more robust
Back up and restore multiple database partitions at once with single system view backup
Rollforward to minimum recovery time enabled
Backing up and restoring data is faster with snapshot backups
Cluster management software integration enabled
FP4: Non-logged activity in tables can be prevented
Installation, migration, and fix pack enhancements
IBM Tivoli SA MP Base Component integrated into DB2 installation (Linux and AIX)
Common fix pack simplifies server product updates
Fix pack post-installation tasks are automated (Linux and UNIX)
Live Partition Mobility is now supported
Non-root users can install and configure DB2 products (Linux and UNIX)
New response file keywords have been added
Non-DB2 instance merge modules have been added
Standalone instance type is more consistent across supported platforms (Linux and UNIX)
Windows Vista deployment and usage is easier
FP1: Solaris x64 support has been added
Windows Server 2008 support added
FP3: Partitioned database environments support Windows Server 2008 Failover Clustering
FP3: Databases should be updated using the db2updv95 command
Virtualization environments are supported
Federation enhancements
Application development has been enhanced
Security has been enhanced
Configuration has been enhanced
Replication enhancements
New CCD target type avoids join of UOW and CD tables
DECFLOAT data type is supported
National language enhancements
Language-aware collation provides more options for ordering data
Unicode string literal enables specifying any Unicode character
Character-based processing for scalar functions supports variable character sizes
Big5-HKSCS–Unicode conversion tables increase support for storing HKSCS data in Unicode databases
UPPER (UCASE) and LOWER (LCASE) scalar functions support locales
FP1: Locale-sensitive UCA-based collations provides more options for ordering data
Troubleshooting and problem determination enhancements
Data collection tool tracks unexpected errors
SQL administrative routine has been added for logging facilities
Storage keys detect memory access problems
Online data consistency checking is improved
Index data consistency problem toleration is higher
Database resilience is improved during unexpected errors
FP3: Transaction and deadlock event monitors include additional client information
FP3: New db2fodc command parameters capture data on index errors and performance issues
FP3: db2pd and db2pdcfg commands can be run by more users
What's changed
Changed functionality
Administration changes summary
Default code page for new databases is Unicode
Some database manager configuration parameters have changed
Some registry and environment variables have changed
Database audits now require SECADM authority
Data compression dictionary is created automatically
Target tables for write-to-table event monitors have changed
Some system catalog views and built-in routines have been added and changed
Memory Visualizer displays maximum memory consumption
Backup image read and write privileges have been changed
Migrate button on the DB2 Launchpad has been moved
Table index size has increased
Table truncation invalidates dynamic statement cache
Concurrency is improved for the ALLOW NO ACCESS option of the REFRESH TABLE and SET INTEGRITY statements
Automatic statistics collection ignores tables with manually updated statistics
Backup operation includes database logs in backup images by default
Database setup changes summary
Some database configuration parameters have changed
Concurrent I/O and Direct I/O are enabled by default (AIX, Linux, Solaris and Windows)
Extended security requires users to belong to the DB2ADMNS or DB2USERS group (Windows Vista)
Configuration and runtime data file default locations have changed (Windows)
Fix pack installations do not require subsequent manual steps (Linux and UNIX)
Some configuration parameters are impacted by simplified memory configuration
Information Integrator product identifier values have changed
Database partitioning is now available only through InfoSphere Warehouse
Catalogs collate using IDENTITY sequence in Unicode databases
FP4: DB2 Express and DB2 Workgroup Editions licensing control has been changed
Application development changes summary
FP4: Merge modules for .NET, ODBC, and CLI have been combined (Windows)
Header files are no longer installed by default
Default JDBC driver has changed for Java routines
ResultSetMetaData returns different values for the IBM Data Server Driver for JDBC and SQLJ Version 4.0
Batch updates with automatically generated keys cause an SQLException
Unfenced routines, unfenced wrapper libraries, and security plug-ins must be threadsafe (Linux and UNIX)
Identifier length limits have increased
Columns and application buffers require larger default values
Some CLI/ODBC applications can consume more memory
db2Load and db2Import parameters have been changed to support longer identifiers
Identifiers that are too long result in errors and warnings being returned earlier
Downlevel utilities and APIs might not handle longer identifiers
Unqualified SYSFUN functions might return SYSIBM error messages
Special registers are longer
UNIQUE as a column name in a subselect clause might produce unexpected results
CLP and system command changes summary
Command Line Processor (CLP) output has changed
BACKUP DATABASE command changed to simultaneously back up multiple database partitions
db2audit command has changed
db2ckmig command has changed
db2mtrk command has changed
Customized callout scripts are searched for on Linux and UNIX
Listing of OS processes and threads has changed (Linux and UNIX)
Deprecated functionality
Some registry and environment variables are deprecated
GET AUTHORIZATIONS command is deprecated
sqluadau API is deprecated
Some monitor elements are deprecated
Log control file SQLOGCTL.LFH has been renamed and copied
IMPORT command options CREATE and REPLACE_CREATE are deprecated
XML Extender is deprecated
Static data stream snapshot output is deprecated
Web Object Runtime Framework (WORF) is deprecated
piActionString data structure of the db2Import and db2Load APIs is deprecated
Network Information Services support is deprecated
FP1: LONG VARCHAR and LONG VARGRAPHIC data types are deprecated
Discontinued functionality
Extended storage (ESTORE) feature support is discontinued
Address Windowing Extensions (AWE) feature support is discontinued
-w option for db2icrt, db2ilist, and db2iupdt is discontinued (Linux and UNIX)
DB2 Web Tools support is discontinued
Some registry and environment variables are discontinued
db2undgp command is discontinued
-n option of the db2licm command is discontinued
CLISchema keyword is discontinued
FP3b: The DB2 Query Optimization Feature is no longer available
DB2 Version 9.1 fix pack changes that affect DB2 Version 9.5 usage
Documentation updates
DB2 Connect
Licensing
DB2 Connect Version 9.5 features and functions by edition
Entitlement by processor or user
Common licensing questions
Replication
Release notes
What's new overview
Fix pack summary
FP1: DB2 Connect products added (Solaris x64)
DB2 V9.1 fix pack changes that affect DB2 Connect V9.5 usage
Information integration products
Database fundamentals
Installing
Requirements for DB2 products
DB2 Version 9.5 product and packaging information
Servers
DB2 Express-C
Database systems
DB2 Database for Windows
An overview of installing your DB2 server product (Windows)
DB2 installation methods
Reducing the size of your DB2 product installation image (Windows)
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)
Setting up elevated privileges (Windows)
Preparing the environment for a partitioned DB2 server (Windows)
Granting user rights (Windows)
DB2 system administrator group (Windows)
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 or Netscape browser profile
Applying DB2 licenses
Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)
Upgrading your 32-bit DB2 instances to 64-bit instances (Windows)
Format of the DB2 node configuration file
Verifying port range availability
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
Applying fix packs
DB2 Database for 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
C++ application compilation troubleshooting
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
Installing a DB2 product on 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 or Netscape browser profile
Applying DB2 licenses
Listing installed products
Applying fix packs to a non-root installation
Verifying port range availability
Setting up notification and contact lists
IBM data server client connectivity using multiple copies
Working with existing DB2 copies
Applying fix packs
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
Prior to 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 file installation
Response file considerations
Creating a response file using the DB2 Setup wizard
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
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
Uninstalling 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 generator
db2rspgn command (Windows)
Response file installation error codes
Installing with batch files
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
DB2 Web applications
DB2WebServices application
Deploying
Undeploying
DB2 Embedded Application Server
Installing
Starting or stopping
Uninstalling the DB2 Embedded Application Server
Installing the DB2 Information Center
Installing the DB2 Information Center using the DB2 Setup wizard (Linux)
Starting or stopping the Information Center daemon (Linux)
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 the DB2 Embedded Application Server
Uninstalling the IBM Data Server Driver for ODBC and CLI
Uninstalling fix packs
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
AlternateZOSSysSchema
ArrayInputChain
Authentication
BigintDefaultCMapping
BiDiCCSID
ClientAccountingString
ClientApplicationName
ClientUserID
ClientWorkstationName
CLIPatch1
CLIPatch2
CommProtocol
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
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 the IBM Data Server Driver for ODBC, CLI, and .NET (Windows)
Installing (Windows)
Command line options to install IBM Data Server Driver for ODBC, CLI, and .NET (Windows)
Deploying
Non-DB2 instance merge modules (Windows)
Installing the IBM Data Server Driver for ODBC, CLI and Open Source (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)
Non-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
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
Server requirements for client connections
Uninstalling an IBM data server client
Configuring database connections
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
Migrating
Migrating to DB2 Version 9.5
Planning migration for your environment
DB2 servers
Clients
Database applications and routines
Migrating DB2 servers
Migration essentials for DB2 servers
What gets migrated
Migration restrictions
Migration best practices
Disk space requirements for DB2 database system migration
Support changes for 32-bit and 64-bit DB2 servers
DB2 server behavior changes
Deprecated or discontinued functionality that impacts migration
Migrating from non-DB2 relational database management systems
Pre-migration tasks
Verifying that your databases are ready for migration
Revoking the EXECUTE privilege on migrated routines
Backing up databases before migration
Backing up DB2 server configuration and diagnostic information
Increasing table space and log file sizes before migration
Changing raw devices to block devices (Linux)
Migrating in a test environment
Creating database duplicates
Taking a DB2 database offline for migration
Migrating a DB2 server (Windows)
Migrating instances
Migrating the DAS
Migrating databases
Migrating a DB2 server (Linux and UNIX)
Migrating instances
Migrating the DAS
Migrating databases
Migrating environments with specific characteristics
Migrating DB2 32-bit servers to 64-bit systems (Windows)
Migrating to a new DB2 server
Migrating a DB2 server using online database backups
Migrating partitioned database environments
Migrating from a DB2 server with multiple DB2 copies
Migrating DB2 servers in MSCS environments
Migrating from DB2 Data Links Manager
Migrating XML Extender
Migrating from XML Extender to native XML data store
Post-migration tasks
Adjusting the log space size in migrated databases
Activating a database after migration
Managing DB2 server behavior changes
Setting up security to manage database auditing.
Converting type-1 indexes to type-2 indexes in migrated databases
Rebinding packages in migrated databases
Migrating explain tables
Ensuring system temporary table spaces page sizes meet requirements
Re-creating write-to-table event monitors
Verifying migration of DB2 servers
Enabling new functionality in migrated databases
Reversing DB2 server migration
Migrating clients
Migration essentials
Migration best practices
Pre-migration tasks
Backing up client configuration information
Migrating in a test environment
Migrating to Data Server Client (Windows)
Migrating to Data Server Runtime Client (Windows)
Migrating clients (Linux and UNIX)
Post-migration tasks
Recataloging nodes and databases using TCP/IP protocol
Verifying migration of clients
Migrating database applications and routines
Migration essentials for database applications
APIs and data structures changes
DB2 command changes
SQL statement changes
System catalog changes
Migration essentials for routines
Pre-migration tasks
Migrating 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
Migrating routines
C, C++, and COBOL routines
Java routines
.NET CLR routines
SQL procedures
32-bit external routines running on 64-bit instances
Post-migration tasks
Enabling new DB2 Version 9.5 functionality in database applications and routines
Migrating to DB2 Connect Version 9.5
Migration essentials for DB2 Connect
Pre-migration tasks
Migrating DB2 Connect servers
Post-migration tasks
Configuring
Application development environment
Configuring database connections
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 license files
Applying DB2 licenses
Registering a license key using the License Center
Registering a license key using the db2licm command
Managing licenses
Checking DB2 license compliance
License Center overview
Changing licenses and policies
Viewing licensing information
Viewing license policy information
Viewing and resetting compliance details
Removing licenses
Upgrading a Trial license
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
aslheapsz - Application support layer heap size
audit_buf_sz - Audit buffer size
authentication - Authentication type
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
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
start_stop_time - Start and stop timeout
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
db_mem_thresh - Database memory threshold
dbheap - Database heap
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
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
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
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
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
Performance tuning
Database tuning overview
Guidelines
Developing a performance-improvement process
Performance information that users can provide
Performance-tuning limits
Architecture and processes
The DB2 Process Model
Deadlocks between applications
Disk storage overview
Disk-storage performance factors
Database directories and files
Tables and indexes
Table and index management for standard tables
Table and index management for MDC tables
Asynchronous index cleanup for MDC tables
Index structure
Processes
Logging process
Insert process
Update process
Client-server processing model
Tuning database performance
Operational performance
Memory usage
Database manager shared memory
The FCM buffer pool and memory requirements
Guidelines for tuning parameters that affect memory usage
Enabling large page support (AIX)
Pinning DB2 database shared memory (AIX)
Self-tuning memory overview
Self-tuning memory
Enabling self-tuning memory
Disabling self-tuning memory
Determining which memory consumers are enabled for self tuning
Operational details and limitations
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
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
Tuning sort performance
Configuring IOCP on AIX
Maintaining the organization of your tables and indexes
Reorganizing tables
Choosing a table reorganization method
Offline table reorganization
Reorganizing tables offline
Recovery of an offline table reorganization
Improving the performance of offline table reorganization
Online table reorganization
Reorganizing tables online
Recovery of a failed 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
Advantages and disadvantages of relational indexes
Relational index planning tips
Relational index performance tips
Index cleanup and maintenance
Index behavior on partitioned tables
Asynchronous index cleanup
Online index defragmentation
Understanding clustering index behavior on partitioned tables
SMS and DMS device considerations
Database agents
Database agent management
Configuration parameters that affect the number of agents
Connection-concentrator improvements for client connections
Agents in a partitioned database
The database system-monitor information
Efficient SELECT statements
Governing database activity
Starting the governor utility
Governor daemon
Configuring the governor
The governor configuration file
Governor rule elements
Example of a governor configuration file
Governor log files
Governor log file queries
Stopping the governor utility
Management of data server capacity
Adding database partitions in partitioned database environments
Adding a database partition to a running database system
Adding a database partition to a stopped database system (Windows)
Adding a database partition to a stopped database system (UNIX)
Error recovery when adding database partitions
Dropping database partitions
Redistributing data in partitioned database environments
Data redistribution
Determining when to redistribute data
Prerequisites for data redistribution
Log space requirements for data redistribution
Restrictions on redistribute utility
Best practices for data redistribution
Redistributing data across database partitions using the REDISTRIBUTE DATABASE PARTITION GROUP command
Redistributing data using the STEPWISE_REDISTRIBUTE_DBPG procedure
Redistribution event log file
Recovery from errors related to data redistribution
Examples of redistribute event log entries
Scenario: Redistributing data across database partitions
Benchmark testing
Benchmark preparation
Benchmark test creation
Benchmark test execution
Benchmark test analysis example
Design Advisor
Using the Design Advisor
Defining a workload for the Design Advisor
Using the Design Advisor to migrate from a single-partitioned to a multi-partition database
Design Advisor limitations and restrictions
Tuning database application performance
Application considerations
Concurrency control and isolation levels
Isolation levels and performance
Specifying isolation levels
Concurrency control and locking
Lock attributes
Lock granularity
Lock waits and timeouts
Lock timeout reporting
Lock timeout report files
Lock conversion
Preventing lock-related performance issues
Creating a detailed deadlock event monitor
Correcting lock escalation problems
Evaluate uncommitted data via lock deferral
Option to disregard uncommitted insertions
Lock type compatibility
Lock modes and access paths for standard tables
Lock modes for table and RID index scans of MDC tables
Locking for block index scans for MDC tables
Locking behavior on partitioned tables
Factors that affect locking
Locks and types of application processing
Locks and data-access methods
Index types and next-key locking
Specifying a lock wait mode strategy
Tuning applications
Guidelines for restricting select statements
Specifying row blocking to reduce overhead
Query tuning guidelines
Query optimization using the REOPT bind option
REOPT bind options
Data sampling in SQL and XQuery queries
Character conversion guidelines
Parallel processing for applications
Environmental considerations
Table space impact on query optimization
Server options affecting federated databases
System catalog statistics
Automatic statistics collection
Enabling automatic statistics collection
Storage used by automatic statistics collection and profiling
Automatic statistics collection activity logging
Improving query performance for large statistics logs
Collecting and analyzing catalog statistics
Collecting catalog statistics
Collecting distribution statistics for specific columns
Collecting index statistics
Collecting statistics on a sample of the table data
Collecting statistics using a statistics profile
Catalog statistics tables
Distribution statistics
Optimizer use of distribution statistics
Extended examples of distribution-statistics use
Detailed index statistics
Sub-element statistics
Catalog statistics that users can update
Statistics for user-defined functions
Catalog statistics for modeling and what-if planning
Statistics for modeling production databases
General rules for updating catalog statistics manually
Rules for updating column statistics manually
Rules for updating distribution statistics manually
Rules for updating table and nickname statistics manually
Rules for updating index statistics manually
Routines
Stored procedures
SQL procedures
Query access plans
SQL and XQuery compiler process
Query rewriting
Example: view merges
Example: DISTINCT elimination
Example: implied predicates
Predicate terminology
Federated database query-compiler phases
Federated database pushdown analysis
Guidelines for analyzing where a federated query is evaluated
Remote SQL generation and global optimization in federated databases
Global analysis of federated database queries
Data access methods
Index scans
Types of index access
Index access and cluster ratios
Join methods and strategies
Join methods
Strategies for selecting optimal joins
Replicated materialized-query tables in partitioned database environments
Join strategies in partitioned database environments
Join methods in partitioned database environments
Effects of sorting and grouping
Optimization strategies
Optimization strategies for intra-partition parallelism
Optimization strategies for MDC tables
Optimization strategies for partitioned tables
Materialized Query Tables
Explain facility
Using explain information
Capturing explain information
Analyzing explain information
Using access plans to self-diagnose performance problems from REFRESH TABLE and SET INTEGRITY statements
Tools for collecting and analyzing explain information
Query explain tools
db2expln - SQL and XQuery Explain
Usage notes for db2expln
dynexpln
Usage notes for dynexpln
Output description
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 information
Output examples
Example one: no parallelism
Example two: single-partition plan with intra-partition parallelism
Example three: multipartition plan with inter-partition parallelism
Example four: multipartition plan with inter-partition and intra-partition parallelism
Example five: federated database plan
Example six: XANDOR and XISCAN operators
Example seven: XSCAN operator
Example eight: XISCAN operator
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
Explain tables and organization of explain information
Explain information for data objects
Explain information for data operators
Explain information for instances
db2exfmt - Explain table format
Optimizing query access plans
Optimization classes
Choosing an optimization class
Setting the optimization class
Optimization guidelines and profiles
Optimization guidelines
Types of optimization guidelines
General optimization guidelines
Query rewrite optimization guidelines
Plan optimization guidelines
Forming table references
Verifying that optimization guidelines have been used
Optimization profiles
Anatomy of an optimization profile
Creating an optimization profile
Creating statement optimization guidelines
Configuring DB2 to use an optimization profile
STMTKEY field in optimization profiles
Specifying which optimization profile the optimizer is to use
Binding an optimization profile to a package
Setting an optimization profile within an application
Modifying an optimization profile
Deleting an optimization profile
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
QRYOPT requests
REOPT requests
RTS requests
XML schema for query rewrite guidelines
IN-LIST-to-join rewrite requests
NOT-EXISTS-anti-join rewrite requests
NOT-IN-to-anti-join rewrite request
Subquery-to-join 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
Join requests
Any join requests
Hash join requests
Merge join requests
Nested-loop join requests
Types of join requests
SYSTOOLS.OPT_PROFILE table
Triggers to flush the optimization profile cache
Managing the SYSTOOLS.OPT_PROFILE table
Configuration parameters that affect query optimization
Database partition group impact on query optimization
Column correlation for multiple predicates
Using index and column group statistics to compute grouping keycard
Statistical views
Using statistical views
View statistics relevant to optimization
Scenario: Improving cardinality estimation
Database monitoring
Monitoring database systems
Monitoring database systems
Comparison of DB2 Monitors
Setting monitor switches from a client application
Setting monitor switches from the CLP
Database system monitor data organization
Counter status and visibility
System monitor output: the self-describing data stream
Database system monitor memory requirements
Monitoring indoubt transactions
Monitoring with db2top (interactive mode)
db2top configuration file
System monitor switches
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 events
Event types
Collecting information about database system events
Creating event monitors
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
Client identification within transaction and deadlock event monitors: Feature adoption reference
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
Monitoring database activity
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
Working with the Memory Visualizer
Viewing memory performance using the Memory Visualizer
Monitoring database systems (Windows)
Introduction to 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 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
System 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
Server identification and status
db2start_time - Start database manager timestamp
server_instance_name - Server instance name
server_db2_type - Database manager type at monitored (server) node
server_prdid - Server product/version ID
server_version - Server version
service_level - Service level
server_platform - Server operating system
product_name - Product name
db2_status - Status of DB2 instance
time_zone_disp - Time zone displacement
Database identification and status
db_name - Database name
db_path - Database path
db_conn_time - Database activation timestamp
conn_time - Time of database connection
disconn_time - Database deactivation timestamp
db_status - Status of database
catalog_node_name - Catalog node network name
db_location - Database location
catalog_node - Catalog node number
last_backup - Last backup timestamp
db_storage_path - Automatic storage path
num_db_storage_paths - Number of automatic storage paths
sto_path_free_sz - Automatic storage path free space
fs_used_size - Amount of space used on a file system
fs_total_size - Total size of a file system
fs_id - Unique file system identification number
fs_type - File system type
Application identification and status
agent_id - Application handle (agent ID)
appl_status - Application status
codepage_id - ID of code page used by application
status_change_time - Application status change time
appl_id_oldest_xact - Application with oldest transaction
smallest_log_avail_node - Node with least available log space
appl_name - Application name
appl_id - Application ID
sequence_no - Sequence number
auth_id - Authorization ID
session_auth_id - Session authorization ID
client_prdid - Client product/version ID
client_db_alias - Database alias used by application
host_prdid - Host product/version ID
is_system_appl - Is System Application
outbound_appl_id - Outbound application ID
outbound_sequence_no - Outbound sequence number
execution_id - User login ID
corr_token - DRDA correlation token
client_pid - Client process ID
client_platform - Client operating platform
client_protocol - Client communication protocol
territory_code - Database territory code
appl_priority - Application agent priority
appl_priority_type - Application priority type
authority_lvl - User authorization level
authority_bitmap - User authorization level
node_number - Node number
coord_node - Coordinating node
appl_con_time - Connection request start timestamp
connections_top - Maximum number of concurrent connections
conn_complete_time - Connection request completion timestamp
prev_uow_stop_time - Previous unit of work completion timestamp
uow_start_time - Unit of work start timestamp
uow_stop_time - Unit of work stop timestamp
uow_elapsed_time - Most recent unit of work elapsed time
uow_comp_status - Unit of work completion status
uow_status - Unit of work status
appl_idle_time - Application idle time
DB2 agent information
agent_pid - Engine dispatchable unit (EDU)
coord_agent_pid - Coordinator agent
Database manager configuration
Agents and connections
rem_cons_in - Remote connections to database manager
rem_cons_in_exec - Remote connections executing in the database manager
local_cons - Local connections
local_cons_in_exec - Local connections executing in the database manager
con_local_dbases - Local databases with current connects
total_cons - Connects since database activation
appls_cur_cons - Applications connected currently
appls_in_db2 - Applications executing in the database currently
agents_registered - Agents registered
agents_waiting_on_token - Agents waiting for a token
agents_registered_top - Maximum number of agents registered
agents_waiting_top - Maximum number of agents waiting
idle_agents - Number of idle agents
agents_from_pool - Agents assigned from pool
agents_created_empty_pool - Agents created due to empty agent pool
coord_agents_top - Maximum number of coordinating agents
agents_stolen - Stolen agents
associated_agents_top - Maximum number of associated agents
comm_private_mem - Committed private memory
total_sec_cons - Secondary connections
num_assoc_agents - Number of associated agents
max_agent_overflows - Maximum agent overflows
num_gw_conn_switches - Connection switches
Memory pool
pool_id - Memory pool identifier
pool_secondary_id - Memory pool secondary identifier
pool_cur_size - Current size of memory pool
pool_config_size - Configured size of memory pool
pool_watermark - Memory pool watermark
Sort
sort_heap_allocated - Total sort heap allocated
post_threshold_sorts - Post threshold sorts
post_shrthreshold_sorts - Post shared threshold sorts
piped_sorts_requested - Piped sorts requested
piped_sorts_accepted - Piped sorts accepted
total_sorts - Total sorts
total_sort_time - Total sort time
sort_overflows - Sort overflows
active_sorts - Active sorts
sort_heap_top - Sort private heap high watermark
sort_shrheap_allocated - Sort share heap currently allocated
sort_shrheap_top - Sort share heap high watermark
Hash join
total_hash_joins - Total hash joins
post_threshold_hash_joins - Hash join threshold
post_shrthreshold_hash_joins - Post threshold hash joins
active_hash_joins - Active hash joins
total_hash_loops - Total hash loops
hash_join_overflows - Hash join overflows
hash_join_small_overflows - Hash join small overflows
On-Line Analytical Processing (OLAP)
total_olap_funcs - Total OLAP functions
olap_func_overflows - OLAP function overflows
post_threshold_olap_funcs - OLAP function threshold
active_olap_funcs - Active OLAP functions
Fast communications manager (FCM)
buff_free - FCM buffers currently free
buff_free_bottom - Minimum FCM Buffers Free
connection_status - Connection status
total_buffers_sent - Total FCM buffers sent
total_buffers_rcvd - Total FCM buffers received
ch_free - Channels Currently Free
ch_free_bottom - Minimum Channels Free
Database configuration
Buffer pool activity
bp_id - Buffer pool identifier
pool_data_l_reads - Buffer pool data logical reads
pool_temp_data_l_reads - Buffer pool temporary data logical reads
pool_data_p_reads - Buffer pool data physical reads
pool_temp_data_p_reads - Buffer pool temporary data physical reads
pool_data_writes - Buffer pool data writes
pool_index_l_reads - Buffer pool index logical reads
pool_temp_index_l_reads - Buffer pool temporary index logical reads
pool_index_p_reads - Buffer pool index physical reads
pool_temp_index_p_reads - Buffer pool temporary index physical reads
pool_index_writes - Buffer pool index writes
pool_xda_l_reads - Buffer Pool XDA Data Logical Reads
pool_temp_xda_l_reads - Buffer Pool Temporary XDA Data Logical Reads
pool_xda_p_reads - Buffer Pool XDA Data Physical Reads
pool_temp_xda_p_reads - Buffer Pool Temporary XDA Data Physical Reads
pool_xda_writes - Buffer Pool XDA Data Writes
pool_read_time - Total buffer pool physical read time
pool_write_time - Total buffer pool physical write time
files_closed - Database files closed
pool_async_data_reads - Buffer pool asynchronous data reads
pool_async_data_writes - Buffer pool asynchronous data writes
pool_async_index_writes - Buffer pool asynchronous index writes
pool_async_index_reads - Buffer pool asynchronous index reads
pool_async_xda_reads - Buffer Pool Asynchronous XDA Data Reads
pool_async_xda_writes - Buffer Pool Asynchronous XDA Data Writes
pool_async_read_time - Buffer pool asynchronous read time
pool_async_write_time - Buffer pool asynchronous write time
pool_async_data_read_reqs - Buffer pool asynchronous read requests
pool_async_index_read_reqs - Buffer pool asynchronous index read requests
pool_async_xda_read_reqs - Buffer Pool Asynchronous XDA Read Requests
pool_lsn_gap_clns - Buffer pool log space cleaners triggered
pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered
pool_no_victim_buffer - Buffer pool no victim buffers
pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered
bp_name - Buffer pool name
prefetch_wait_time - Time waited for prefetch
unread_prefetch_pages - Unread prefetch pages
vectored_ios - Number of vectored I/O requests
pages_from_vectored_ios - Total pages read by vectored I/O
block_ios - Number of block I/O requests
pages_from_block_ios - Total number of pages read by block I/O
Dynamic buffer pool
bp_cur_buffsz - Current size of buffer pool
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
Non-buffered I/O activity
direct_reads - Direct reads from database
direct_writes - Direct writes to database
direct_read_reqs - Direct read requests
direct_write_reqs - Direct write requests
direct_read_time - Direct read time
direct_write_time - Direct write time
Catalog cache
cat_cache_lookups - Catalog cache lookups
cat_cache_inserts - Catalog cache inserts
cat_cache_overflows - Catalog cache overflows
cat_cache_size_top - Catalog cache high watermark
Package cache
pkg_cache_lookups - Package cache lookups
pkg_cache_inserts - Package cache inserts
pkg_cache_num_overflows - Package cache overflows
pkg_cache_size_top - Package cache high watermark
SQL workspaces
shr_workspace_size_top - Maximum shared workspace size
shr_workspace_num_overflows - Shared workspace overflows
shr_workspace_section_lookups - Shared workspace section lookups
shr_workspace_section_inserts - Shared workspace section inserts
priv_workspace_size_top - Maximum private workspace size
priv_workspace_num_overflows - Private workspace overflows
priv_workspace_section_lookups - Private workspace section lookups
priv_workspace_section_inserts - Private workspace section inserts
appl_section_lookups - Section lookups
appl_section_inserts - Section inserts
Database heap
db_heap_top - Maximum database heap allocated
Logging
sec_log_used_top - Maximum secondary log space used
tot_log_used_top - Maximum total log space used
sec_logs_allocated - Secondary logs allocated currently
log_reads - Number of log pages read
log_writes - Number of log pages written
uow_log_space_used - Unit of work log space used
total_log_used - Total log space used
total_log_available - Total log available
log_held_by_dirty_pages - Amount of log space accounted for by dirty pages
log_to_redo_for_recovery - Amount of log to be redone for recovery
log_write_time - Log write time
log_read_time - Log read time
num_log_write_io - Number of log writes
num_log_read_io - Number of log reads
num_log_part_page_io - Number of partial log page writes
num_log_buffer_full - Number of full log buffers
num_log_data_found_in_buffer - Number of log data found in buffer
first_active_log - First active log file number
last_active_log - Last active log file number
current_active_log - Current active log file number
current_archive_log - Current archive log file number
Database and application activity
blocks_pending_cleanup - Pending cleanup rolled-out blocks
Locks and deadlocks
locks_held - Locks held
lock_list_in_use - Total lock list memory in use
data_partition_id - Data partition identifier
deadlocks - Deadlocks detected
lock_escals - Number of lock escalations
x_lock_escals - Exclusive lock escalations
lock_mode - Lock mode
lock_status - Lock status
lock_object_type - Lock object type waited on
lock_object_name - Lock object name
lock_node - Lock node
lock_timeouts - Number of lock timeouts
locks_held_top - Maximum number of locks held
dl_conns - Connections involved in deadlock
lock_escalation - Lock escalation
lock_mode_requested - Lock mode requested
deadlock_id - Deadlock event identifier
deadlock_node - Partition number where deadlock occurred
participant_no - Participant within deadlock
participant_no_holding_lk - Participant holding a lock on the object required by application
rolled_back_participant_no - Rolled back application participant
locks_in_list - Number of locks reported
lock_name - Lock name
lock_attributes - Lock attributes
lock_release_flags - Lock release flags
lock_count - Lock count
lock_hold_count - Lock hold count
lock_current_mode - Original lock mode before conversion
num_indoubt_trans - Number of indoubt transactions
Lock wait information
lock_waits - Lock waits
lock_wait_time - Time waited on locks
locks_waiting - Current agents waiting on locks
uow_lock_wait_time - Total time unit of work waited on locks
lock_wait_start_time - Lock wait start timestamp
lock_timeout_val - Lock timeout (seconds)
agent_id_holding_lock - Agent ID holding lock
appl_id_holding_lk - Application ID holding lock
sequence_no_holding_lk - Sequence number holding lock
rolled_back_appl_id - Rolled back application
rolled_back_agent_id - Rolled back agent
rolled_back_sequence_no - Rolled back sequence number
Rollforward monitoring
rf_timestamp - Rollforward timestamp
ts_name - Table space being rolled forward
rf_type - Rollforward type
rf_log_num - Log being rolled forward
rf_status - Log phase
Table space activity
tablespace_id - Table space identification
tablespace_name - Table space name
tablespace_type - Table space type
tablespace_content_type - Table space contents type
tablespace_state - Table space state
tablespace_page_size - Table space page size
tablespace_extent_size - Table space extent size
tablespace_prefetch_size - Table space prefetch size
tablespace_cur_pool_id - Buffer pool currently being used
tablespace_next_pool_id - Buffer pool that will be used at next startup
tablespace_total_pages - Total pages in table space
tablespace_usable_pages - Usable pages in table space
tablespace_used_pages - Used pages in table space
tablespace_free_pages - Free pages in table space
tablespace_pending_free_pages - Pending free pages in table space
tablespace_page_top - Table space high watermark
tablespace_rebalancer_mode - Rebalancer mode
tablespace_rebalancer_start_time - Rebalancer start time
tablespace_rebalancer_restart_time - Rebalancer restart time
tablespace_rebalancer_extents_remaining - Total number of extents to be processed by the rebalancer
tablespace_rebalancer_extents_processed - Number of extents the rebalancer has processed
tablespace_rebalancer_last_extent_moved - Last extent moved by the rebalancer
tablespace_rebalancer_priority - Current rebalancer priority
tablespace_num_quiescers - Number of quiescers
tablespace_state_change_object_id - State change object identification
tablespace_state_change_ts_id - State change table space identification
tablespace_min_recovery_time - Minimum recovery time for rollforward
tablespace_num_containers - Number of containers in table space
tablespace_num_ranges - Number of ranges in the table space map
fs_caching - File system caching
tablespace_using_auto_storage - Using automatic storage
tablespace_auto_resize_enabled - Auto-resize enabled
tablespace_initial_size - Initial table space size
tablespace_current_size - Current table space size
tablespace_max_size - Maximum table space size
tablespace_increase_size - Increase size in bytes
tablespace_increase_size_percent - Increase size by percent
tablespace_last_resize_time - Time of last successful resize
tablespace_last_resize_failed - Last resize attempt failed
Table space quiescer activity
quiescer_auth_id - Quiescer user authorization identification
quiescer_agent_id - Quiescer agent identification
quiescer_ts_id - Quiescer table space identification
quiescer_obj_id - Quiescer object identification
quiescer_state - Quiescer state
Container status
container_id - Container identification
container_name - Container name
container_type - Container type
container_total_pages - Total pages in container
container_usable_pages - Usable pages in container
container_stripe_set - Stripe set
container_accessible - Accessibility of container
Table space range status
range_stripe_set_number - Stripe set number
range_number - Range number
range_max_page_number - Maximum page in range
range_max_extent - Maximum extent in range
range_start_stripe - Start stripe
range_end_stripe - End stripe
range_adjustment - Range adjustment
range_num_containers - Number of containers in range
range_container_id - Range container
range_offset - Range offset
Table activity
table_type - Table type
table_name - Table name
table_schema - Table schema name
rows_deleted - Rows deleted
rows_inserted - Rows inserted
rows_updated - Rows updated
rows_selected - Rows selected
rows_written - Rows written
rows_read - Rows read
overflow_accesses - Accesses to overflowed records
int_rows_deleted - Internal rows deleted
int_rows_updated - Internal rows updated
int_rows_inserted - Internal rows inserted
table_file_id - Table file identification
page_reorgs - Page reorganizations
data_object_pages - Data object pages
index_object_pages - Index object pages
lob_object_pages - LOB object pages
long_object_pages - Long object pages
xda_object_pages - XDA Object Pages
Table reorganization
reorg_type - Table reorganize attributes
reorg_status - Table reorganize status
reorg_phase - Table reorganize phase
reorg_phase_start - Table reorganize phase start time
reorg_max_phase - Maximum table reorganize phase
reorg_current_counter - Table reorganize progress
reorg_max_counter - Total amount of table reorganization
reorg_completion - Table reorganization completion flag
reorg_start - Table reorganize start time
reorg_end - Table reorganize end time
reorg_index_id - Index used to reorganize the table
reorg_tbspc_id - Table space where table is reorganized
reorg_long_tbspc_id - Table space where long objects are reorganized
reorg_rows_compressed - Rows compressed
reorg_rows_rejected_for_compression - Rows rejected for compression
SQL cursors
open_rem_curs - Open remote cursors
open_rem_curs_blk - Open remote cursors with blocking
rej_curs_blk - Rejected block cursor requests
acc_curs_blk - Accepted block cursor requests
open_loc_curs - Open local cursors
open_loc_curs_blk - Open local cursors with blocking
SQL and XQuery statement activity
static_sql_stmts - Static SQL statements attempted
dynamic_sql_stmts - Dynamic SQL statements attempted
failed_sql_stmts - Failed statement operations
commit_sql_stmts - Commit statements attempted
rollback_sql_stmts - Rollback statements attempted
select_sql_stmts - Select SQL statements executed
uid_sql_stmts - UPDATE/INSERT/DELETE SQL statements executed
ddl_sql_stmts - Data definition language (DDL) SQL statements
int_auto_rebinds - Internal automatic rebinds
int_commits - Internal commits
int_rollbacks - Internal rollbacks
int_deadlock_rollbacks - Internal rollbacks due to deadlock
sql_reqs_since_commit - SQL requests since last commit
stmt_node_number - Statement node
binds_precompiles - Binds/precompiles attempted
xquery_stmts - XQuery Statements Attempted
SQL statement details
stmt_type - Statement type
stmt_operation/operation - Statement operation
package_name - Package name
consistency_token - Package consistency token
package_version_id - Package version
section_number - Section number
cursor_name - Cursor name
creator - Application creator
stmt_start - Statement operation start timestamp
stmt_stop - Statement operation stop timestamp
stop_time - Event stop time
start_time - Event start time
stmt_elapsed_time - Most recent statement elapsed time
insert_timestamp - Statement insert timestamp
stmt_text - SQL statement text
stmt_sorts - Statement sorts
fetch_count - Number of successful fetches
sqlca - SQL Communications Area (SQLCA)
query_card_estimate - Query number of rows estimate
query_cost_estimate - Query cost estimate
stmt_history_id - Statement history identifier
stmt_first_use_time - Statement first use time
stmt_last_use_time - Statement last use time
stmt_lock_timeout - Statement lock timeout
stmt_isolation - Statement isolation
stmt_nest_level - Statement nesting level
stmt_invocation_id - Statement invocation identifier
stmt_query_id - Statement query identifier
stmt_source_id - Statement source identifier
stmt_pkgcache_id - Statement package cache identifier
comp_env_desc - Compilation environment handle
stmt_value_type - Value type
stmt_value_isnull - Value has null value
stmt_value_data - Value data
stmt_value_index - Value index
stmt_history_list_size - Statement history list size
stmt_value_isreopt - Variable used for statement reoptimization
Subsection details
ss_number - Subsection number
ss_node_number - Subsection node number
ss_status - Subsection status
ss_exec_time - Subsection execution elapsed time
tq_wait_for_any - Waiting for any node to send on a table queue
tq_node_waited_for - Waited for node on a table queue
tq_tot_send_spills - Total number of table queue buffers overflowed
tq_cur_send_spills - Current number of table queue buffers overflowed
tq_rows_read - Number of rows read from table queues
tq_rows_written - Number of rows written to table queues
tq_max_send_spills - Maximum number of table queue buffers overflows
tq_id_waiting_on - Waited on node on a table queue
Dynamic SQL
num_executions - Statement executions
num_compilations - Statement compilations
prep_time_worst - Statement worst preparation time
prep_time_best - Statement best preparation time
total_exec_time - Elapsed statement execution time
Intra-query parallelism
num_agents - Number of agents working on a statement
agents_top - Number of agents created
degree_parallelism - Degree of parallelism
CPU usage
agent_usr_cpu_time - User CPU time used by agent
agent_sys_cpu_time - System CPU time used by agent
stmt_usr_cpu_time - User CPU time used by statement
stmt_sys_cpu_time - System CPU time used by statement
user_cpu_time - User CPU time
system_cpu_time - System CPU time
ss_usr_cpu_time - User CPU time used by subsection
ss_sys_cpu_time - System CPU time used by subsection
total_sys_cpu_time - Total system CPU for a statement
total_usr_cpu_time - Total user CPU for a statement
Snapshot monitoring
last_reset - Last reset timestamp
input_db_alias - Input database alias
time_stamp - Snapshot time
num_nodes_in_db2_instance - Number of nodes in database partition
Event monitoring
count - Number of event monitor overflows
first_overflow_time - Time of first event overflow
last_overflow_time - Time of last event overflow
byte_order - Byte order of event data
version - Version of monitor data
event_monitor_name - Event monitor name
partial_record - Partial record
event_time - Event time
evmon_flushes - Number of event monitor flushes
evmon_activates - Number of event monitor activations
sql_req_id - Request identifier for SQL statement
message - Control table message
message_time - Timestamp control table message
partition_number - Partition number
Utilities
utility_dbname - Database operated on by utility
utility_id - Utility ID
utility_type - Utility type
utility_priority - Utility priority
utility_start_time - Utility start time
utility_description - Utility description
utility_state - Utility state
utility_invoker_type - Utility invoker type
progress_list_current_seq_num - Current progress list sequence number
progress_seq_num - Progress sequence number
progress_description - Progress description
progress_start_time - Progress start time
progress_work_metric - Progress work metric
progress_total_units - Total progress work units
progress_completed_units - Completed progress work units
progress_list_attr - Current progress list attributes
High availability disaster recovery (HADR)
hadr_role - HADR role
hadr_state - HADR state
hadr_syncmode - HADR synchronization mode
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_remote_host - HADR remote host
hadr_remote_service - HADR remote service
hadr_remote_instance - HADR remote instance
hadr_timeout - HADR timeout
hadr_primary_log_file - HADR primary log file
hadr_primary_log_page - HADR primary log page
hadr_primary_log_lsn - HADR primary log LSN
hadr_standby_log_file - HADR standby log file
hadr_standby_log_page - HADR standby log page
hadr_standby_log_lsn - HADR standby log LSN
hadr_log_gap - HADR log gap
hadr_peer_window - HADR peer window
hadr_peer_window_end - HADR peer window end
DB2 Connect
dcs_db_name - DCS database name
host_db_name - Host database name
gw_db_alias - Database alias at the gateway
gw_con_time - DB2 Connect gateway first connect initiated
gw_connections_top - Maximum number of concurrent connections to host database
gw_total_cons - Total number of attempted connections for DB2 Connect
gw_cur_cons - Current number of connections for DB2 Connect
gw_cons_wait_host - Number of connections waiting for the host to reply
gw_cons_wait_client - Number of connections waiting for the client to send request
gw_exec_time - Elapsed time spent on DB2 Connect gateway processing
sql_stmts - Number of SQL statements attempted
sql_chains - Number of SQL chains attempted
open_cursors - Number of open cursors
dcs_appl_status - DCS application status
agent_status - DCS application agents
host_ccsid - Host coded character set ID
outbound_comm_protocol - Outbound communication protocol
outbound_comm_address - Outbound communication address
inbound_comm_address - Inbound communication address
inbound_bytes_received - Inbound number of bytes received
outbound_bytes_sent - Outbound number of bytes sent
outbound_bytes_received - Outbound number of bytes received
inbound_bytes_sent - Inbound number of bytes sent
outbound_bytes_sent_top - Maximum outbound number of bytes sent
outbound_bytes_received_top - Maximum outbound number of bytes received
outbound_bytes_sent_bottom - Minimum outbound number of bytes sent
outbound_bytes_received_bottom - Minimum outbound number of bytes received
max_data_sent_128 - Number of statements with outbound bytes sent between 1 and 128 bytes
max_data_received_128 - Number of statements with outbound bytes received between 1 and 128 bytes
max_data_sent_256 - Number of statements with outbound bytes sent between 129 and 256 bytes
max_data_received_256 - Number of statements with outbound bytes received between 129 and 256 bytes
max_data_sent_512 - Number of statements with outbound bytes sent between 257 and 512 bytes
max_data_received_512 - Number of statements with outbound bytes received between 257 and 512 bytes
max_data_sent_1024 - Number of statements with outbound bytes sent between 513 and 1024 bytes
max_data_received_1024 - Number of statements with outbound bytes received between 513 and 1024 bytes
max_data_sent_2048 - Number of statements with outbound bytes sent between 1025 and 2048 bytes
max_data_received_2048 - Number of statements with outbound bytes received between 1025 and 2048 bytes
max_data_sent_4096 - Number of statements with outbound bytes sent between 2049 and 4096 bytes
max_data_received_4096 - Number of statements with outbound bytes received between 2049 and 4096 bytes
max_data_sent_8192 - Number of statements with outbound bytes sent between 4097 and 8192 bytes
max_data_received_8192 - Number of statements with outbound bytes received between 4097 and 8192 bytes
max_data_sent_16384 - Number of statements with outbound bytes sent between 8193 and 16384 bytes
max_data_received_16384 - Number of statements with outbound bytes received between 8193 and 16384 bytes
max_data_sent_31999 - Number of statements with outbound bytes sent between 16385 and 31999 bytes
max_data_received_31999 - Number of statements with outbound bytes received between 16385 and 31999 bytes
max_data_sent_64000 - Number of statements with outbound bytes sent between 32000 and 64000 bytes
max_data_received_64000 - Number of statements with outbound bytes received between 32000 and 64000 bytes
max_data_sent_gt64000 - Number of statements with outbound bytes sent greater than 64000 bytes
max_data_received_gt64000 - Number of statements with outbound bytes received greater than 64000 bytes
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_16_ms - Number of statements with network time between 4 and 16 ms
max_network_time_100_ms - Number of statements with network time between 16 and 100 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
network_time_top - Maximum network time for statement
network_time_bottom - Minimum network time for statement
xid - Transaction ID
elapsed_exec_time - Statement execution elapsed time
host_response_time - Host response time
num_transmissions - Number of transmissions
num_transmissions_group - Number of transmissions group
con_response_time - Most recent response time for connect
con_elapsed_time - Most recent connection elapsed time
gw_comm_errors - Communication errors
gw_comm_error_time - Communication error time
blocking_cursor - Blocking cursor
Transaction processor (TP) monitoring
tpmon_client_userid - TP monitor client user ID
tpmon_client_wkstn - TP monitor client workstation name
tpmon_client_app - TP monitor client application name
tpmon_acc_str - TP monitor client accounting string
Federated database systems
datasource_name - Data source name
disconnects - Disconnects
insert_sql_stmts - Inserts
update_sql_stmts - Updates
delete_sql_stmts - Deletes
create_nickname - Create nicknames
passthrus - Pass-through
stored_procs - Stored procedures
remote_locks - Remote locks
sp_rows_selected - Rows returned by stored procedures
select_time - Query response time
insert_time - Insert response time
update_time - Update response time
delete_time - Delete response time
create_nickname_time - Create nickname response time
passthru_time - Pass-through time
stored_proc_time - Stored procedure time
remote_lock_time - Remote lock time
Workload management
activate_timestamp - Activate timestamp
activity_collected - Activity collected
activity_id - Activity ID
activity_secondary_id - Activity secondary ID
activity_type - Activity type
act_exec_time - Activity execution time
act_total - Activities total
arm_correlator - Application response measurement correlator
bin_id - Histogram bin identifier
bottom - Histogram bin bottom
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
coord_act_aborted_total - Coordinator activities aborted total
coord_act_completed_total - Coordinator activities completed total
coord_act_lifetime_top - Coordinator activity lifetime top
coord_act_rejected_total - Coordinator activities rejected total
coord_partition_num - Coordinator partition number
cost_estimate_top - Cost estimate top
coord_act_lifetime_avg - Coordinator activity lifetime average
coord_act_queue_time_avg - Coordinator activity queue time average
coord_act_exec_time_avg - Coordinator activities execution time average
request_exec_time_avg - Request execution time average
coord_act_est_cost_avg - Coordinator activity estimated cost average
coord_act_interarrival_time_avg - Coordinator activity arrival time average
db_work_action_set_id - Database work action set ID
db_work_class_id - Database work class ID
histogram_type - Histogram type
last_wlm_reset - Time of last reset
num_threshold_violations - Number of threshold violations
number_in_bin - Number in bin
parent_activity_id - Parent activity ID
parent_uow_id - Parent unit of work ID
prep_time - Preparation time
queue_assignments_total - Queue assignments total
queue_size_top - Queue size top
queue_time_total - Queue time total
rows_fetched - Rows fetched
rows_modified - Rows modified
rows_returned - Rows returned
rows_returned_top - Actual rows returned top
sc_work_action_set_id - Service class work action set ID
sc_work_class_id - Service class work class ID
section_env - Section environment
service_class_id - Service class ID
service_subclass_name - Service subclass name
service_superclass_name - Service superclass name
statistics_timestamp - Statistics timestamp
temp_tablespace_top - Temporary table space top
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_started - Time started
top - Histogram bin top
uow_id - Unit of work ID
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
Real-time statistics
stats_cache_size – Size of statistics cache
stats_fabrications – Total number of statistics fabrications
sync_runstats – Total number of synchronous RUNSTATS activities
async_runstats – Total number of asynchronous RUNSTATS requests
stats_fabricate_time – Total time spent on statistics fabrication activities
sync_runstats_time – Total time spent on synchronous RUNSTATS activities
Database system monitor interfaces
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
Troubleshooting and support
Learning more
About troubleshooting
About first occurrence data capture
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
About first occurrence data capture (FODC)
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 administration notification log files
Administration notification log
Setting the error capture level for the administration notification log file
Interpreting administration notification log file entries
About DB2 diagnostic log (db2diag.log) files
Setting the diagnostic log file error capture level
Interpreting the db2diag.log file informational record
Interpreting diagnostic log file entries
About db2cos output files
About dump files
About trap files
Formatting trap files (Windows)
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 combining DB2 and O/S diagnostics
Troubleshooting DB2 Database
Troubleshooting DB2
Troubleshooting the administrative task scheduler
Troubleshooting data inconsistencies
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 index to data inconsistencies
Troubleshooting installation
Errors when installing a DB2 database product 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
Installing DB2 UDB Version 8 after DB2 Version 9.5 (Windows)
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 optimization guidelines and profiles
Troubleshooting scripts
Troubleshooting the storage key support
Data compression dictionary is not automatically created
Collecting data
Collecting data for installation problems
Collecting data for data movement problems
Collecting data for DAS and instance management problems
Analyzing data
Analyzing data for installation problems
Analyzing DB2 license compliance reports
Submitting data to IBM Software Support
Troubleshooting DB2 Connect
Gathering relevant information
Initial connection is not successful
Problems encountered after an initial connection
Unsupported DDM commands
Collecting data
Tools for troubleshooting
Learning more about internal return codes
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)
Searching knowledge bases
Troubleshooting resources
Getting fixes
Applying fix packs
Fix packs, interim fix packs and test fixes
Applying test fixes
Messages
Introduction to messages
Communication errors
Error codes issued by the IBM Data Server Driver for JDBC and SQLJ
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
ADM2500E
ADM2501C
ADM2502C
ADM2503C
ADM2504C
ADM2505E
ADM2506W
ADM2507I
ADM2508I
ADM2509I
ADM3000C
ADM3001C
ADM3003C
ADM3006C
ADM3008C
ADM3019C
ADM3020C
ADM3021W
ADM3500W
ADM4000W
ADM4001I
ADM4002W
ADM4500W
ADM5500W
ADM5501I
ADM5502W
ADM5503E
ADM5504W
ADM5505E
ADM5510E
ADM5511E
ADM5520E
ADM5521C
ADM5530W
ADM5540W
ADM5541W
ADM5542W
ADM5543E
ADM5550C
ADM5560C
ADM5561C
ADM5562C
ADM5570W
ADM5571W
ADM5572I
ADM5580W
ADM5581W
ADM5582C
ADM5583W
ADM5590E
ADM5591W
ADM5592I
ADM5593I
ADM5594I
ADM5595E
ADM6000E
ADM6001I
ADM6002E
ADM6003I
ADM6012W
ADM6013W
ADM6017E
ADM6018I
ADM6019E
ADM6020I
ADM6021I
ADM6022W
ADM6023I
ADM6024C
ADM6025I
ADM6028W
ADM6029W
ADM6031W
ADM6034W
ADM6035W
ADM6036W
ADM6037W
ADM6038E
ADM6039E
ADM6040E
ADM6041E
ADM6042E
ADM6043W
ADM6044E
ADM6045I
ADM6046I
ADM6047W
ADM6048I
ADM6049E
ADM6050W
ADM6051E
ADM6052E
ADM6053W
ADM6054I
ADM6055I
ADM6056I
ADM6057I
ADM6058I
ADM6059I
ADM6060I
ADM6061I
ADM6062I
ADM6063I
ADM6064I
ADM6065I
ADM6066I
ADM6069W
ADM6070W
ADM6071I
ADM6072W
ADM6073W
ADM6074I
ADM6075W
ADM6076W
ADM6077I
ADM6078W
ADM6079E
ADM6080E
ADM6081W
ADM6082W
ADM6083E
ADM6084E
ADM6085I
ADM6086W
ADM6087I
ADM6088W
ADM6089I
ADM6090W
ADM6091W
ADM6092W
ADM6093W
ADM6094W
ADM6095W
ADM6096W
ADM6097I
ADM6098W
ADM6099W
ADM6100W
ADM6101W
ADM6102I
ADM6103W
ADM6104W
ADM6105E
ADM6106E
ADM6107E
ADM6500W
ADM6501W
ADM6502W
ADM6510W
ADM6511W
ADM6512W
ADM6513W
ADM6514W
ADM6515W
ADM6516W
ADM6517W
ADM7000W
ADM7001E
ADM7004E
ADM7005W
ADM7006E
ADM7007E
ADM7008W
ADM7009E
ADM7011E
ADM7500W
ADM7501W
ADM7502E
ADM7503W
ADM7504W
ADM7505E
ADM7506W
ADM7507W
ADM7508E
ADM7509W
ADM7510W
ADM7511E
ADM7512E
ADM7513W
ADM7514W
ADM7515W
ADM7517W
ADM7518C
ADM7519W
ADM7520E
ADM7521E
ADM7522E
ADM7523E
ADM8000C
ADM8001W
ADM8002W
ADM8003C
ADM8004W
ADM8005W
ADM8006W
ADM8007W
ADM8008W
ADM8009W
ADM8010E
ADM8011W
ADM8012W
ADM8500W
ADM8501W
ADM8502W
ADM8503W
ADM8504I
ADM8505I
ADM8506I
ADM8507N
ADM8508N
ADM8509N
ADM9000W
ADM9500W
ADM9501W
ADM9502W
ADM9503W
ADM9504W
ADM9505W
ADM9506W
ADM9507W
ADM9508W
ADM9509W
ADM9510W
ADM9511W
ADM9512W
ADM9513W
ADM9514I
ADM9515I
ADM10000W
ADM10500E
ADM10501W
ADM10502W
ADM10503I
ADM10504E
ADM10505E
ADM10506E
ADM10507E
ADM10508E
ADM10509E
ADM10510E
ADM10511E
ADM10512W
ADM10513I
ADM10514I
ADM10515I
ADM10516I
ADM11000E
ADM11001E
ADM11002E
ADM11003E
ADM11500W
ADM12000C
ADM12001C
ADM12002C
ADM12006E
ADM12007E
ADM12008C
ADM12009E
ADM12010E
ADM12011C
ADM12012E
ADM12013E
ADM12014C
ADM12015C
ADM12016E
ADM12017E
ADM12018E
ADM12020E
ADM12022E
ADM12023E
ADM12024E
ADM12025E
ADM12026W
ADM12027E
ADM12500E
ADM12501E
ADM12502E
ADM12503E
ADM12504E
ADM12505E
ADM12506E
ADM12507E
ADM13000E
ADM13001E
ADM13002E
ADM13003E
ADM13004E
ADM13005E
ADM13006E
ADM13500E
ADM14000E
ADM14001C
ADM14002C
ADM14003W
ADM14004C
ADM14005E
ADM14011C
ADM14012C
ADM14500E
ADM15000E
ADM15001E
ADM15500E
ADM15501W
ADM15502W
ADM15503E
ADM15510E
AMI Messages
AMI0016E
AMI0018E
AMI0019E
AMI0020E
AMI0035E
AMI0049E
AMI0109E
AMI0110E
AMI0402E
AMI0405E
AMI0406E
AMI0407E
AMI0409E
AMI0410E
AMI0416E
AMI0418E
AMI0419E
AMI0424E
ASN Messages
ASN0004E
ASN0005E
ASN0006E
ASN0008I
ASN0009E
ASN0011E
ASN0013E
ASN0019E
ASN0020I
ASN0021I
ASN0023I
ASN0028I
ASN0029I
ASN0031E
ASN0035E
ASN0049I
ASN0055E
ASN0057E
ASN0058W
ASN0059W
ASN0060E
ASN0061E
ASN0062E
ASN0063E
ASN0064E
ASN0065E
ASN0066E
ASN0067E
ASN0068E
ASN0069E
ASN0070E
ASN0071E
ASN0072E
ASN0073E
ASN0074E
ASN0075W
ASN0076I
ASN0077E
ASN0078E
ASN0079E
ASN0080E
ASN0082W
ASN0083E
ASN0084E
ASN0100I
ASN0101W
ASN0102W
ASN0104I
ASN0105I
ASN0109I
ASN0111I
ASN0112I
ASN0113W
ASN0114E
ASN0121E
ASN0122E
ASN0123I
ASN0133I
ASN0142E
ASN0143W
ASN0144E
ASN0180W
ASN0181W
ASN0182W
ASN0183E
ASN0184I
ASN0185I
ASN0186W
ASN0187W
ASN0188I
ASN0189I
ASN0190I
ASN0191E
ASN0192E
ASN0193W
ASN0195I
ASN0196W
ASN0197W
ASN0198E
ASN0199E
ASN0200E
ASN0500E
ASN0501E
ASN0502E
ASN0503E
ASN0504E
ASN0505E
ASN0506E
ASN0507E
ASN0508E
ASN0509E
ASN0510E
ASN0511E
ASN0512E
ASN0513E
ASN0514E
ASN0515E
ASN0516E
ASN0517E
ASN0518E
ASN0519E
ASN0520I
ASN0521I
ASN0522I
ASN0523I
ASN0524E
ASN0525E
ASN0526E
ASN0527E
ASN0528E
ASN0529I
ASN0530E
ASN0531E
ASN0532E
ASN0533E
ASN0534E
ASN0535E
ASN0536E
ASN0537E
ASN0538I
ASN0539E
ASN0540E
ASN0541E
ASN0542E
ASN0543E
ASN0544E
ASN0545E
ASN0546W
ASN0547I
ASN0548I
ASN0552E
ASN0553E
ASN0554E
ASN0555W
ASN0556E
ASN0557E
ASN0558E
ASN0559W
ASN0560E
ASN0561W
ASN0562E
ASN0563W
ASN0564I
ASN0565E
ASN0566E
ASN0567I
ASN0568E
ASN0569E
ASN0571E
ASN0572I
ASN0573I
ASN0574E
ASN0575E
ASN0576E
ASN0580E
ASN0581W
ASN0582I
ASN0583I
ASN0584E
ASN0585I
ASN0586E
ASN0587I
ASN0588I
ASN0589I
ASN0590I
ASN0591I
ASN0592I
ASN0593I
ASN0594I
ASN0595I
ASN0596I
ASN0597I
ASN0598W
ASN0599E
ASN0600I
ASN0601I
ASN0602I
ASN0603E
ASN0604E
ASN0605E
ASN0606I
ASN0607E
ASN0608I
ASN0609W
ASN0610W
ASN0612E
ASN0613E
ASN0614E
ASN0615E
ASN0616E
ASN0617E
ASN0618W
ASN0619W
ASN0620E
ASN0621E
ASN0622E
ASN0623E
ASN0624E
ASN0625W
ASN0626E
ASN0627E
ASN0628E
ASN0629E
ASN0630E
ASN0631E
ASN0632E
ASN0633W
ASN0634W
ASN0635I
ASN0636E
ASN0638W
ASN0639W
ASN0777I
ASN0888E
ASN0999E
ASN1001E
ASN1002E
ASN1003E
ASN1006E
ASN1008E
ASN1009E
ASN1010E
ASN1011E
ASN1012E
ASN1013E
ASN1014E
ASN1015I
ASN1016I
ASN1017E
ASN1018I
ASN1019E
ASN1020E
ASN1021E
ASN1022E
ASN1023E
ASN1024E
ASN1025I
ASN1026I
ASN1027E
ASN1028I
ASN1029E
ASN1031E
ASN1032E
ASN1033E
ASN1034I
ASN1035E
ASN1036E
ASN1038E
ASN1039E
ASN1040E
ASN1041I
ASN1042W
ASN1043E
ASN1044I
ASN1045I
ASN1047I
ASN1048E
ASN1049E
ASN1050E
ASN1051W
ASN1052E
ASN1053E
ASN1054E
ASN1055E
ASN1056E
ASN1057E
ASN1058E
ASN1059E
ASN1060E
ASN1061