SS6NHC - Documentation Index

Table of Contents

• IBM Db2 Warehouse as a Service documentation
• 概觀
  • MPP 架構及部署的變更
  • 開始使用
  • 的常見問題
• 協助工具特性
• 聯合
  • Supported data sources
  • Federated systems
    • The federated server
    • What is a data source?
    • The federated database
    • Wrappers and wrapper modules
    • How you interact with a federated system
      • IBM Data Studio
      • Command line processor (CLP)
      • Application programs
      • Database family tools
    • The federated database system catalog
    • The SQL compiler
    • The query optimizer
    • Compensation
    • Pass-through sessions
    • Server definitions and server options
    • User mappings
    • Nicknames and data source objects
    • Valid data source objects
    • Nickname column options
    • Data type mappings
    • Function mappings
    • Index specifications
    • Federated stored procedures
    • Collating sequences
      • How collating sequences determine sort orders
      • Setting the local collating sequence to optimize queries
  • Configuring federation and data sources
    • Creating federated objects: Administration Explorer
    • Creating individual federated objects
    • Creating and managing multiple federated objects
    • Creating and managing federated objects: SQL and XQuery editor
  • Configuring data sources
    • Configuring access to Db2 data sources
      • Registering the Db2 wrapper
        • Db2 wrapper library files
      • Registering server definitions for Db2 data sources
        • CREATE SERVER statement - Examples for the Db2 wrapper
      • Creating user mappings for Db2 data sources
        • CREATE USER MAPPING statement - Examples for the Db2 wrapper
      • Testing the connection to the Db2 data source server
        • Troubleshooting data source connection errors
      • Registering nicknames for Db2 tables and views
        • CREATE NICKNAME statement - Examples for Db2 data sources
    • Configuring access to BigSQL data sources
    • Configuring ODBC access to Hive data sources
    • Configuring ODBC access to Impala data sources
    • Configuring JDBC access to Spark data sources
    • Configuring ODBC access to PostgreSQL data sources
    • Configuring ODBC access to MySQL data sources
    • Configuring access to ODBC data sources
      • Registering the ODBC wrapper
        • ODBC wrapper library files
        • CREATE WRAPPER statement - Examples for the ODBC wrapper
      • Registering the server definitions for an ODBC data source
        • CREATE SERVER statement - Examples of the ODBC wrapper
      • Creating a user mapping for an ODBC data source
        • CREATE USER MAPPING statement - Examples for the ODBC wrapper
      • Testing the connection to the ODBC data source server
        • Troubleshooting data source connection errors
      • Registering nicknames for ODBC data source tables and views
        • CREATE NICKNAME statement - Examples for the ODBC wrapper
      • Optimizing ODBC wrapper performance with the ODBC tuning utility (db2fedsvrcfg)
        • db2fedsvrcfg command syntax - ODBC tuning utility
        • Test table definitions for the ODBC tuning utility (db2fedsvrcfg)
  • Administering federation
    • Modifying data source configurations
      • Altering a wrapper
      • Altering server definitions and server options
        • Restrictions on altering server definitions
        • Altering a server definition
        • Altering all of the server definitions for a specific data source type
      • Creating a server definition
      • Using server options in server definitions
        • Changing server options temporarily for relational data sources
        • The hierarchy of server option settings
      • Altering a user mapping
      • Altering a nickname
        • Restrictions on altering nicknames
        • Altering nickname column names
        • Altering nickname options
        • Altering nickname column options
      • Dropping a wrapper
      • Dropping a server definition
      • Dropping a user mapping
      • Dropping a nickname
    • Data types and data type mappings
      • Mapping to the federated server
        • Mappings and the global catalog
        • When to create alternative data type mappings
        • Mapping non-relational data sources
        • Forward and reverse data type mappings
      • Creating data type mappings
        • Creating a type mapping for a data source data type - example
        • Creating a type mapping for a data source data type and version - example
        • Creating a type mapping for all data source objects on a server - example
        • Casting between data types
        • TIMESTAMP data type support
      • Altering local data types
        • Altering a local type for a data source object
          • Altering a local type for a data source object - examples
      • Altering LONG data types to VARCHAR data types
    • Mapping functions and user-defined functions
      • Function mappings in a federated system
        • How function mappings work in a federated system
        • Why function mappings are important
        • When to create function mappings
      • User-defined functions in applications
        • Requirements for mapping user-defined functions
      • Creating function mappings
        • Specifying function names
          • Mapping functions with the same name
          • Mapping functions with different names
        • Specific data source type
        • Specific data source type and version
        • All data source objects on a specific server
      • Function templates
        • Creating function templates
      • Disabling a default function mapping
      • Dropping a function mapping
    • Creating index specifications
      • Index specifications in a federated system
      • Creating index specifications for data source objects
      • Creating index specifications on tables that acquire new indexes
      • Creating index specifications on views
      • Creating index specifications on Informix synonyms
    • Developing federated procedures
      • Federated procedures
      • Creating federated procedures
      • Data sources and federated procedures
        • Federated procedures for data sources
        • Federated procedures and Microsoft SQL Server
        • Federated procedures and Oracle
          • Overloaded procedures in federated systems
        • Federated procedures and Sybase
      • Granting or revoking authorizations to call federated procedures
      • Displaying parameter information and calling federated procedures
      • Altering or dropping federated procedures
      • Joining result sets
        • DB2FEDGENTF command
      • Federated procedure troubleshooting
    • Creating and modifying remote tables by using transparent DDL
      • What is transparent DDL
      • Remote LOB columns and transparent DDL
      • Creating remote tables and transparent DDL
        • Creating new remote tables using transparent DDL
        • Creating new remote tables using transparent DDL - examples
      • Altering remote tables using transparent DDL
      • Dropping remote tables using transparent DDL
    • Managing transactions in a federated system
      • Understanding federated system transaction support
      • What is an update in a federated system?
        • What is an update transaction in a pass-through session?
        • Data sources that automatically commit DDL statements
        • User-defined functions that are pushed down to the data source for processing
      • Performing two-phase commit transactions
        • Two-phase commit for federated transactions
          • Planning for federated two-phase commit
          • Federated architecture for two-phase commit
          • Two-phase commit for federated transactions - examples
          • How federated two-phase commit transactions are processed
        • Enabling two-phase commit for federated transactions
        • Data source requirements and configuration for federated two-phase commit transactions
          • Configuring DRDA data sources
          • Configuring Oracle data sources
          • Configuring Informix data sources
          • Configuring Microsoft SQL Server data sources
          • Configuring Sybase data sources
        • Recovering from federated two-phase commit problems
          • Resynchronization for federated systems
          • Manually recovering indoubt transactions
          • Tracing distributed unit of work transaction states across data sources
        • Troubleshooting federated two-phase commit issues
        • Federated two-phase commit performance
          • Improving federated two-phase commit performance
    • Inserting, updating, and deleting data in a federated system
    • Authorization privileges for INSERT, UPDATE, and DELETE statements
    • Federated system INSERT, UPDATE, and DELETE restrictions
      • Unsupported data sources
    • Referential integrity in a federated system
    • INSERT, UPDATE, and DELETE statements and large objects (LOBs)
    • Preserving statement atomicity in a federated system
    • Modifying data in a federated system
      • Inserting data into data source objects
      • Updating data in data source objects
      • Deleting data from data source objects
    • Assignment semantics in a federated system
      • Assignment semantics in a federated system - examples
    • Data source restrictions on data type values
    • Federated updates with application savepoints
    • Federated updates with application savepoints - examples
    • Restrictions on federated updates with application savepoints
    • Importing and exporting data for nicknames
      • Restrictions for importing data into nicknames
      • IMPORT command with nicknames - examples
      • Restrictions for exporting data using nicknames
    • Working with nicknames
      • Nicknames in a federated system
        • Cursors declared WITH HOLD
        • Triggers
      • Restrictions on nicknames
        • Accessing data with nicknames
        • The SQL statements you can use with nicknames
      • Creating nicknames over temporal tables
      • Creating nicknames
        • Creating nicknames for relational and non-relational data sources
        • Nickname column and index names
      • Accessing data sources using pass-through sessions
      • Accessing heterogeneous data through federated views
        • Creating federated views - examples
      • Creating a nickname for a nickname
      • Selecting data in a federated system
        • Selecting data in a federated system - examples
      • Specifying informational constraints on nicknames
      • Informational constraints on nicknames
      • Specifying informational constraints on nicknames
      • Specifying informational constraints on nicknames - examples
      • Updating nickname statistics
      • Nickname statistics update facility - overview
      • Methods of retrieving nickname statistics
      • Retrieving nickname statistics
        • Retrieving nickname statistics - examples
      • Restrictions on HIGH2KEY and LOW2KEY statistics
      • Creating a tools catalog
      • Viewing the status of the updates to nickname statistics
      • SYSPROC.NNSTAT stored procedure
      • Automatic update of nickname statistics
    • Federated three-part names
      • Support and considerations for federated three-part names
      • Federated cache for federated three-part names
      • Specifying federated three-part names
      • Restrictions on federated three-part names
    • Error tolerance in nested table expressions
      • Specifying nested table expressions for error tolerance
      • Nested table expressions for error tolerance - example
      • Data source support for nested-table-expressions for error tolerance
      • Restrictions on nested-table-expressions for error tolerance
  • Developing for federation
    • Federated applications
    • How client applications interact with data sources
    • Nicknames in your applications
      • Nicknames in DDL statements
      • Data source statistics impact applications
      • Defining column options on nicknames
        • Setting the NUMERIC_STRING column option
        • Setting the VARCHAR_NO_TRAILING_BLANKS column option
    • Creating and using federated views
      • Creating federated views - examples
    • Application isolation levels for data integrity
      • Statement level isolation in a federated system
      • Connection level isolation in a federated system
    • Federated large object support
      • LOB locators
      • Restrictions on LOBs
      • Performance considerations for LOB processing
    • Federated external tables
    • Distributed requests
      • Distributed requests for querying data sources - examples
      • Optimizing distributed requests with server options
      • Canceling a federated query
    • Using pass-through sessions within applications
      • Federated pass-through considerations and restrictions
      • Pass-through sessions to Oracle data sources
    • Developing J2EE applications for federation
      • Developing federated application with Java technology
        • Advantages of enterprise beans in a federated system
        • Enterprise beans in a federated system
        • Creating and deploying a container-managed persistence bean
      • Examples of federated applications
        • Customer bid requests
        • Supplier quote requests
  • Performance for federation
    • Tuning query processing
      • Publications about federated performance
      • Query analysis
      • Pushdown analysis
      • Server characteristics affecting pushdown opportunities
        • SQL differences
          • VARCHAR2 data type in federated systems
        • Collating sequence
        • Federated server options
        • Creating statement-level optimization guidelines
        • Type and function mapping factors
      • Nickname characteristics affecting pushdown opportunities
        • Local data type of a nickname column
        • Federated column options
      • Query characteristics affecting pushdown opportunities
        • Analyzing where a query is evaluated with the DB2_MAXIMAL_PUSHDOWN server option
      • Analyzing where a query is evaluated
      • Understanding access plan evaluation decisions
        • Why isn't this predicate being evaluated remotely?
        • Why isn't the GROUP BY operator evaluated remotely?
        • Why isn't the SET operator evaluated remotely?
        • Why isn't the ORDER BY operation evaluated remotely?
        • Why is a remote INSERT with a fullselect statement not completely evaluated remotely?
        • Why is a remote INSERT with VALUES clause statement not completely evaluated remotely?
        • Why is a remote, searched UPDATE statement not completely evaluated remotely?
        • Why is a positioned UPDATE statement not completely evaluated remotely?
        • Why is a remote, searched DELETE statement not completely evaluated remotely?
      • Data source upgrades and customization
      • Pushdown of predicates with function templates
    • Asynchronous processing of federated queries
      • Asynchronous processing of federated queries - examples
      • Asynchrony optimization
        • Access plans without asynchrony
        • Access plans optimized for asynchrony
        • Access plans - examples
        • Controlling resource consumption
      • Enabling asynchrony optimization
      • Tuning considerations for asynchrony optimization
      • Restrictions on asynchrony optimization
      • Determining if asynchrony optimization is applied to a query
    • Global optimization
      • Server characteristics affecting global optimization
        • Relative ratio of CPU speed
        • Relative ratio of I/O speed
        • Communication rate between the federated server and the data source
        • Data source collating sequence
        • Remote plan hints
      • Nickname characteristics affecting global optimization
        • Index specifications
        • Global catalog statistics
        • Updating row changes
        • Updating statistics when columns change
      • Analyzing global optimization
      • Understanding access plan optimization decisions
        • Why isn't a join between two nicknames of the same data source being evaluated remotely?
        • Why isn't the GROUP BY operator being evaluated remotely?
        • Why is the statement not being completely evaluated remotely?
        • Why does a plan generated by the optimizer and completely evaluated remotely, have much worse performance than the original query executed directly at the remote data source?
    • Materialized query tables
      • Materialized query tables and federated systems - overview
      • Creating a federated materialized query table
      • Data source specific restrictions for materialized query tables
      • Restrictions on using materialized query tables with nicknames
    • Caching data
      • Cache tables
      • Creating sample cache tables
    • Bulk insert
  • Security for federation
    • Security for federated servers
    • Public user mappings
    • Federated trusted contexts and trusted connections
      • Benefits of federated trusted connections
      • Types of federated trusted connections
      • APIs for federated trusted connections
      • Scenarios for implementing federated trusted connections
        • Scenario: End-to-end federated trusted connections, without user mappings
        • Sample code for end-to-end federated trusted connection scenarios
        • Scenario: End-to-end federated trusted connections, with user mappings
        • Scenario: Federated outbound trusted connections
      • User mappings and federated trusted connections
    • Label-based access control (LBAC) and federated systems
    • External user mapping repositories
      • User mapping plug-in (C programming language)
      • Supported platforms for the user mapping plug-in (C programming language)
      • Restrictions for developing a user mapping plug-in (C programming language)
      • Header file (fsumplugin.h) for the user mapping plug-in (C programming language)
        • FSUMPluginInit function (C programming language)
        • FSUMconnect function (C programming language)
        • FSUMfetchUM function (C programming language)
        • FSUMdisconnect function (C programming language)
        • FSUMPluginTerm function (C programming language)
      • Developing a user mapping plug-in (C programming language)
        • Declaring external functions for the user mapping plug-in (C programming language)
        • Declaring utility functions for the user mapping plug-in (C programming language)
        • Setting function pointers for the user-mapping plug-in (C programming language)
        • Error handling in the user mapping plug-in (C programming language)
        • Building the user mapping plug-in (C)
        • Testing the user mapping plug-in (C programming language)
        • Deploying the user mapping plug-in (C programming language)
        • Enabling access to the external user mapping repository
        • Updating the user mapping plug-in (C programming language)
      • Sample user mapping plug-in (C programming language)
      • User mapping plug-in (Java programming language)
        • Classes for the user mapping plug-in (Java programming language)
          • UserMappingRepository class (Java programming language)
          • UserMappingCrypto class (Java programming language)
          • UserMappingEntry class (Java programming language)
          • UserMappingOption class (Java programming language)
          • UserMappingException class (Java programming language)
        • Sample user mapping plug-in (Java programming language)
        • Developing a user mapping plug-in (Java programming language)
          • Modifying the sample user mapping plug-in files (Java programming language)
          • Modifying the UserMappingCryptoLDAP sample file (Java programming language)
          • Modifying the UserMappingRepositoryLDAP sample file (Java programming language)
          • Compiling the files for the user mapping plug-in (Java programming language)
          • Creating the configuration file for the user mapping plug-in (Java programming language)
          • Testing the user mapping plug-in (Java programming language)
          • Deploying the user mapping plug-in files (Java programming language)
          • Configuring access to the user mapping plug-in (Java programming language)
    • Oracle security in a federated system
    • Oracle label security
    • Oracle proxy authentication and federated trusted contexts
  • Troubleshooting
    • Troubleshooting data source connection errors
    • Troubleshooting federated trusted connections
    • Troubleshooting the user mapping plug-in
    • Troubleshooting Microsoft SQL Server nickname errors
  • Reference
    • Data source support for federated features
    • Data source options
      • IBM database options
      • JDBC options
      • Microsoft SQL Server options
      • ODBC options
    • Views in the global catalog table containing federated information
    • Function mapping options for federated systems
    • Valid server types in SQL statements
    • Data type mappings
      • Default forward data type mappings
        • Db2 data sources
        • Db2 for IBM i data sources
        • Db2 for VM and VSE data sources
        • Db2 for z/OS data sources
        • Informix data sources
        • JDBC data sources
        • Microsoft SQL Server data sources
        • BigSQL data sources
        • Hive data sources
        • Impala data sources
        • Spark data sources
        • ODBC data sources
        • Oracle NET8 data sources
        • Sybase data sources
        • Teradata data sources
        • Sample forward data type mappings
          • Forward data type mappings - Informix example
          • Forward data type mappings - Microsoft SQL Server example
          • Forward data type mappings - Oracle example
          • Forward data type mappings - Sybase example
          • Forward data type mappings - Teradata example
      • Default reverse data type mappings
        • Db2 data sources
        • Db2 for IBM i data sources
        • Db2 for VM and VSE data sources
        • Db2 for z/OS data sources
        • Informix data sources
        • JDBC data sources
        • Microsoft SQL Server data sources
        • ODBC data sources
        • Oracle NET8 data sources
        • Sybase data sources
        • Teradata data sources
      • Unicode default data type mappings
        • JDBC data sources - Forward type mappings
        • JDBC data sources - Reverse type mappings
        • Microsoft SQL Server data sources - Forward type mappings
        • Microsoft SQL Server data sources - Reverse type mappings
        • NET8 data sources - Forward type mappings
        • NET8 data sources - Reverse type mappings
        • ODBC data sources - Forward type mappings
        • ODBC data sources - Reverse type mappings
        • Sybase data sources - Forward type mappings
        • Sybase data sources - Reverse type mappings
      • Data types supported for nonrelational data sources
• Federation
  • Supported data sources
• Using Datalake tables
  • Terminology
  • Table Properties (TBLPROPERTIES)
  • Architecture
    • Big SQL Hive metastore
    • Big SQL scheduler
    • Big SQL I/O engine
    • Big SQL logs
  • Accessing watsonx.data
    • Configuring Db2 for watsonx.data integration
      • Connecting to watsonx.data on IBM Cloud or Amazon Web Services
      • Connecting to watsonx.data on OpenShift
    • Importing tables from watsonx.data
    • Creating Hive tables in watsonx.data
    • Creating Iceberg tables in watsonx.data
    • Disconnecting Db2 from watsonx.data
  • Supported object storage services
  • Remote storage connectivity
  • Identifier handling
  • Transaction handling
  • Supported data types
  • Supported file formats
  • Schema evolution support
  • Datalake Table Trash Bin support
  • Oracle compatibility for Datalake tables
  • Query runtime performance
    • Gathering statistics
      • Enabling or disabling cumulative statistics collection
      • Internal tables that are used by the ANALYZE TABLE statement
      • Auto-analyze
    • Informational constraints for Datalake tables
    • Data Partitioning
  • Restrictions and limitations
  • Troubleshooting Datalake table problems
    • SELECT or INSERT might fail when run in same logical unit of work as DCL statement
    • SELECT or INSERT fails when run concurrently with DROP PARTITION
    • Incorrect results when querying recently refreshed or loaded partitioned tables
    • Db2 Big SQL log files
    • Concurrent INSERTs might fail on an Iceberg table
    • SELECT might fail when run with INSERT on a Datalake table
    • OOM due to concurrent INSERTs and SELECTs on Datalake tables
    • SQL5105N error returned on INSERT when using IBM Cloud Object Store (COS)
    • SQL statement referencing Datalake table returns error failing to initiate an instance of HiveMetaStoreClient
    • ALTER Datalake TABLE statement results in SQL0104N
    • EXT_METASTORE_SYNC fails when using REPLACE as an exist-action
    • INSERT into a Datalake table which is partitioned on an expression results in an unexpected error
    • SQL0601N error when creating a Datalake table after a drop schema from a non-catalog node
    • SQL30081N error when creating a DATALAKE Table
• Native Cloud Object Storage support
  • Introduction to Object Storage
  • User Experience
  • Storage Architecture with Native Cloud Object Support
  • Local caching for overcoming the different IO characteristics of Object Storage
  • Exploring the remote table spaces
  • Working with database objects in remote table spaces
  • Implicit table space selection when creating a table
  • Creating and dropping remote table spaces
  • Restrictions and Limitations
• Q Replication for Continuous Availability
  • Use cases
  • Getting started
  • Planning for Q Replication
    • Choosing the replication key
    • Considerations for RI constraints
    • Replicating column-organized tables
    • Workload and database considerations
    • Data type restrictions
    • Supported DDL operations
  • Creating tables at the target database
  • Initial loading of replication targets
  • Administering Q Replication
    • Administering replication using the console
      • Activating replication using the console
      • Creating a replication set using the console
      • Editing a replication set using the console
      • Removing a table from a replication set using the console
      • Deleting a replication set using the console
      • Deleting targets using the console
      • Deactivating replication using the console
    • Administering Replication using Q Replication REST APIs
      • Accessing the Q Replication REST API for Db2 Warehouse SaaS
      • Activating Q Replication by using the REST APIs
      • Configuring targets and replication sets with the Db2 Q Replication REST API
        • Trusting targets and exchanging Db2 TLS certificates
        • Initializing the replication target on the replication source
        • Creating a replication set by using REST APIs
        • Adding a table to a replication set by using REST APIs
        • Deleting one or more tables from a replication set by using REST APIs
        • Deleting a Replication Set by using REST APIs
        • Deleting replication targets from a Q Replication configuration by using REST APIs
  • Managing Q Replication
    • Starting replication
    • Stopping replication
  • Monitoring Q Replication
    • Monitoring replication in the console
    • Monitoring by using SQL queries
  • Troubleshooting Q Replication
• Security features
  • Database user management
    • Identity and access management (IAM) on IBM Cloud
      • Setting Up App ID for Db2 Warehouse SaaS
      • Authentication methods for servers
    • Password policy
    • Updating your Db2 Warehouse SaaS instance password
    • User-defined user roles
    • Row and column access control (RCAC)
      • Row and column access control (RCAC) rules
        • SQL statements for managing RCAC rules
        • Built-in functions for managing RCAC permissions and masks
      • Scenario: ExampleHMO using row and column access control
        • Security policies
        • Database users and roles
        • Database tables
        • Security administration
        • Row permissions
        • Column masks
        • Data insertion
        • Data updates
        • Data queries
        • View creation
        • Secure functions
        • Secure triggers
        • Revoke authority
      • Scenario: ExampleBANK using row and column access control
        • Security policies
        • Database users and roles
        • Database tables
        • Row permissions
        • Column masks
        • Data queries
  • Auditing Db2 Activities
    • Introduction to the Db2 audit facility for
      • Audit policies
      • Audit facility record layouts
        • Audit events
        • Audit record object types
        • Audit record layout for AUDIT events
        • Audit record layout for CHECKING events
        • CHECKING access approval reasons
        • CHECKING access attempted types
        • Audit record layout for CONTEXT events
        • Audit record layout for EXECUTE events
        • Audit record layout for OBJMAINT events
        • Audit record layout for SECMAINT events
        • SECMAINT privileges or authorities
        • Audit record layout for SYSADMIN events
        • Audit record layout for VALIDATE events
    • Getting Started with Auditing
      • Before you start auditing
      • Policy and data migration
      • Policy configuration
    • Audit facility management
      • Audit facility behavior
      • Audit facility tips and techniques
      • Audit log format configuration
    • Viewing archived audit records
  • Security compliances
    • Details about security compliance
• Data source compatibility
  • Compatibility features for Oracle
    • DATE data type based on TIMESTAMP(0)
    • NUMBER
    • VARCHAR2 and NVARCHAR2
    • Implicit casting for character and graphic constants
    • SQL data-access-level enforcement
    • Outer join operator
    • Hierarchical queries
      • CONNECT_BY_ROOT
      • PRIOR
      • SYS_CONNECT_BY_PATH
    • ROWNUM pseudocolumn
    • DUAL table
    • Changed syntax for the TRUNCATE statement
    • INOUT parameters
    • Oracle data dictionary-compatible views
    • Use of collection methods to perform operations on arrays, such as FIRST, LAST, NEXT, and PREVIOUS
    • Oracle database link syntax
    • Synonym usage
  • Terminology mapping: Oracle to IBM Db2 as a Service, IBM Db2 Warehouse as a Service, and IBM Db2 Warehouse
  • Netezza to Db2 migration
    • Migrating from a Netezza system to a Db2 system
      • Planning to migrate
      • Databases, tables, and schemas
      • Data loading
      • Security
        • Migrating users, groups, and privileges
        • Privileges
      • System views
      • Migrating queries
        • Query compatibility
      • SQL functions
      • Migrating routines
      • User-defined extensions
        • Migrating user-defined extensions based on C++ and Lua
        • Migrating user-defined extensions based on R and Python
        • Migrating user-defined shared libraries
      • Migrating workload management settings
      • Validating migration
    • Netezza and Db2 compatibility
      • Data types
        • Unsupported non-internal data types
        • Differences in non-internal data types
        • Support for internal data types
      • Backups and restores
      • Commands
      • ODBC, JDBC, OLE DB, and .NET
      • Query history and workload monitoring
      • Netezza configuration choices that impact migration
      • In-database analytics compatibility
      • SQL summary
  • Compatibility features for Netezza Platform Software (NPS)
    • Data type aliases
    • DATASLICEID pseudocolumn
    • Routines written in NZPLSQL
      • Limitations for routines written in NZPLSQL
      • NZPLSQL procedures as functions
      • Records in NZPLSQL
      • Records in a FOR...IN EXECUTE statement
      • Returning a result set
    • Using column aliases in a HAVING clause
    • Double-dot notation
    • TRANSLATE scalar function syntax
    • Operators
    • Grouping by SELECT clause columns
    • Expressions refer to column aliases
    • CREATE TABLE statement can use CTAS syntax
    • SUBSTR allows non-positive start values
    • AGE returns a decimal duration
    • Precision and scale for DECIMAL and NUMERIC scalar functions
    • Installing the DB SQL Extension Toolkit
    • Using DB2_REVERSE_NULL_ORDER
  • IBM Database Conversion Workbench (DCW)
  • Db2 support tools
    • Db2 support tools overview
      • db_build_dictionary command
      • db_migrate command
        • db_migrate command options
        • Copying data by using the db_migrate command
          • Migrating data from a Netezza backup
          • Migrating from a multiple schema database
          • Canceling the migration process
      • db_migrate_iias command
        • Migrating data with db_migrate_iias command - examples
      • dbsql interactive command interpreter
        • dbsql command
          • dbsql internal slash commands
          • dbsql user session variables
        • dbsql command inputs
        • dbsql query buffer
        • dbsql scripts
        • dbsql command miscellaneous options
        • dbsql command feedback
        • Exit codes for dbsql on UNIX systems
        • dbsql limitations
      • dsmtop command
        • Using dsmtop to replace nz_responders
      • dbload command
        • Privileges
        • Concurrency and transactions
        • Command syntax
        • Examples
        • Log files
        • Error reporting
        • dbload control file
        • Session variables
        • Streaming data with named pipes
        • dbload compared with nzload
        • Loading data files with dbload command
      • dbunload command
        • Privileges
        • Command syntax
        • Error reporting
        • Control file
        • Session variables
        • Unloading data with dbunload
      • db_ddl_comment
      • db_ddl_diff
      • db_ddl_grant_group
      • db_ddl_grant_user
      • db_ddl_object
      • db_ddl_ext_table
      • db_plan
      • db_skew
      • REORG replacing the nz_groom script
      • dbpassword
        • Stored passwords
        • Encrypted passwords
        • Encrypting passwords
      • db_table_restruct
      • db_table_sort_order
      • db_get_table_info
      • db_check_views
      • db_query_history
      • db_table_skew
      • db_tables_row_count
      • db_ddl_compare
      • db_get_exfmt
        • analyse_plan
• Analyzing your data
  • Esri ArcGIS
    • Tutorial 1: Working with base maps
    • Tutorial 2: Creating new maps
    • Tutorial 3: Using your own geospatial data
  • Python
    • Python, SQLAlchemy, and Django Framework
      • Python downloads and related resources
      • Setting up the Python environment
      • Verifying the Python driver, SQLAlchemy adapter, and Django adapter installation
      • Application development with ibm_db
        • Connecting to an IBM database server
        • Executing SQL statements
          • Preparing and executing a single SQL statement
          • Preparing and executing SQL statements with variable input
        • Fetching rows or columns from result sets
        • Calling stored procedures
        • Retrieving multiple result sets from a stored procedure
        • Commit modes
        • Error-handling functions
        • Database metadata retrieval functions
  • R
    • Developing and running R scripts
    • In-database analytics using R
    • R packages
      • The ibmdbR package
      • The RODBC package
  • SQL
  • Spatial data
    • Db2 Spatial Extender
      • How data represents geographic features
        • The nature of spatial data
        • Where spatial data comes from
          • Using business data as source data
          • Using functions to generate spatial data
          • Importing spatial data
      • How features, spatial information, spatial data, and geometries fit together
      • Geometries
        • Geometry types
        • Geometry coordinates
        • X and Y coordinates
        • Z coordinates
        • M coordinates
        • Interior, boundary, and exterior
        • Simple or non-simple
        • Closed
        • Empty or not empty
        • Minimum bounding rectangle
        • Dimension
        • Spatial reference system identifier
      • How to use Db2 Spatial Extender
        • Interfaces to Db2 Spatial Extender and associated functionality
        • Creating projects that use spatial data
      • Setting up spatial resources for a project
        • Inventory of resources supplied for your database
        • How to use coordinate systems
          • Coordinate systems
          • Geographic coordinate systems
          • Projected coordinate systems
          • Determine what coordinate system to use
        • How to set up spatial reference systems
          • Spatial reference systems
          • Deciding whether to use an existing spatial reference system or create a new system
          • Spatial reference systems
          • Conversion factors that transform coordinate data into integers
            • Offset values
            • Scale factors
            • Units for offset values and scale factors
          • Creating a spatial reference system
          • Calculating scale factors
          • Determining minimum and maximum coordinates and measures
          • Calculating offset values
      • Setting up spatial columns
        • Spatial columns visualization
        • Spatial data types
          • Data types for single-unit features
          • Data types for multi-unit features
          • A data type for all features
        • Creating spatial columns
        • Registering spatial columns
      • Populating spatial columns
        • Inserting spatial data with constructor functions
      • Using indexes and views to access spatial data
        • Spatial grid indexes
          • Generation of spatial grid indexes
          • Use of spatial functions in a query
          • How a query uses a spatial grid index
        • Considerations for number of index levels and grid sizes
          • Number of grid levels
          • Grid cell sizes
        • Creating spatial grid indexes
        • CREATE INDEX statement for a spatial grid index
        • Using views to access spatial columns
      • Analyzing and generating spatial information
        • Examples of how spatial functions operate
        • Functions that use indexes to optimize queries
      • Identifying Db2 Spatial Extender problems
        • How to interpret Db2 Spatial Extender messages
        • Spatial Extender stored procedure output parameters
        • Db2 Spatial Extender function messages
      • Catalog views
        • DB2GSE.ST_COORDINATE_SYSTEMS
        • DB2GSE.ST_GEOMETRY_COLUMNS
        • DB2GSE.ST_SIZINGS
        • DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS
        • DB2GSE.ST_UNITS_OF_MEASURE
      • Stored procedures
        • ST_ALTER_COORDSYS
        • ST_ALTER_SRS
        • ST_CREATE_COORDSYS
        • ST_CREATE_SRS
        • ST_DROP_COORDSYS
        • ST_DROP_SRS
        • ST_REGISTER_SPATIAL_COLUMN
        • ST_UNREGISTER_SPATIAL_COLUMN
      • Spatial functions
        • Considerations and associated data types
          • Treating values of ST_Geometry as values of a subtype
          • Spatial functions by input type
          • Comparison functions for geographic features
          • Geometries with the DE-9IM pattern matrix string
          • Distance between geometries
          • Examples for querying spatial data
          • Examples of inserting spatial data with constructor functions
        • EnvelopesIntersect
        • ST_BuildMBRAggr and ST_GetAggrResult functions
        • ST_AppendPoint
        • ST_Area
        • ST_AsBinary
        • ST_AsGML
        • ST_AsKML
        • ST_AsSdeBinary
        • ST_AsShape
        • ST_AsText
        • ST_Boundary
        • ST_Buffer
        • ST_BuildUnionAggr and ST_GetAggrResult
        • ST_Centroid
        • ST_ChangePoint
        • ST_Contains
        • ST_ConvexHull
        • ST_CoordDim
        • ST_Crosses
        • ST_Difference
        • ST_Dimension
        • ST_Disjoint
        • ST_Distance
        • ST_DistanceToPoint
        • ST_DWithin
        • ST_Endpoint
        • ST_Envelope
        • ST_EnvIntersects
        • ST_EqualCoordsys
        • ST_Equals
        • ST_EqualSRS
        • ST_Expand
        • ST_ExteriorRing
        • ST_FindMeasure or ST_LocateAlong
        • ST_Generalize
        • ST_GeomCollection
        • ST_GeomCollFromTxt
        • ST_GeomCollFromWKB
        • ST_Geometry
        • ST_GeometryN
        • ST_GeometryType
        • ST_GeometryTypeID
        • ST_GeomFromSDE
        • ST_GeomFromText
        • ST_GeomFromWKB
        • ST_GetIndexParms
        • ST_InteriorRingN
        • ST_Intersection
        • ST_Intersects
        • ST_Is3d
        • ST_IsClosed
        • ST_IsEmpty
        • ST_IsMeasured
        • ST_IsRing
        • ST_IsSimple
        • ST_IsValid
        • ST_Length
        • ST_LineFromMultiPoint
        • ST_LineFromText
        • ST_LineFromWKB
        • ST_LineString
        • ST_LineStringN
        • ST_M
        • ST_MaxM
        • ST_MaxX
        • ST_MaxY
        • ST_MaxZ
        • ST_MBR
        • ST_MBRIntersects
        • ST_LocateBetween and ST_MeasureBetween
        • ST_MidPoint
        • ST_MinM
        • ST_MinX
        • ST_MinY
        • ST_MinZ
        • ST_MLineFromText
        • ST_MLineFromWKB
        • ST_MPointFromText
        • ST_MPointFromWKB
        • ST_MPolyFromText
        • ST_MPolyFromWKB
        • ST_MultiLineString
        • ST_MultiPoint
        • ST_MultiPolygon
        • ST_NearestPoints
        • ST_NumGeometries
        • ST_NumInteriorRing
        • ST_NumLineStrings
        • ST_NumPoints
        • ST_NumPolygons
        • ST_Overlaps
        • ST_Perimeter
        • ST_PerpPoints
        • ST_Point
        • ST_PointAtDistance
        • ST_PointFromText
        • ST_PointFromWKB
        • ST_PointN
        • ST_PointOnSurface
        • ST_PolyFromText
        • ST_PolyFromWKB
        • ST_Polygon
        • ST_PolygonN
        • ST_Relate
        • ST_RemovePoint
        • ST_SDEtoSQL
        • ST_SRID and ST_SrsId
        • ST_SrsName
        • ST_StartPoint
        • ST_SymDifference
        • ST_ToGeomColl
        • ST_ToLineString
        • ST_ToMultiLine
        • ST_ToMultiPoint
        • ST_ToMultiPolygon
        • ST_ToPoint
        • ST_ToPolygon
        • ST_Touches
        • ST_Transform
        • ST_Union
        • ST_Version
        • ST_Within
        • ST_WKBToSQL
        • ST_WKBtoWKT
        • ST_WKTToSQL
        • ST_WKTtoWKB
        • ST_X
        • ST_Y
        • ST_Z
      • Transform groups
        • ST_WellKnownText
        • ST_WellKnownBinary
        • ST_Shape
        • ST_GML transform group
      • Supported data formats
        • Well-known text (WKT) representation
        • Well-known binary (WKB) representation
        • Shape representation
        • GML representation
      • Supported coordinate systems
        • Coordinate systems syntax
        • Supported linear units
        • Supported angular units
        • Supported spheroids
        • Supported prime meridians
        • Supported map projections
    • Db2 Spatial Analytics
      • How data represents geographic features
        • The nature of spatial data
        • Where spatial data comes from
        • How features, spatial information, spatial data, and geometries fit together
      • Key concepts
        • Geometries
          • Geometry types
          • Geometry coordinates
          • Interior, boundary, and exterior
          • Empty, simple or closed geometries
          • Minimum bounding rectangle
          • Dimension
          • Spatial reference system identifier
        • Spatial data types
          • Data types for single-unit features
          • Data types for multi-unit features
          • A data type for all features
        • Coordinate systems
          • Geographic coordinate systems
          • Projected coordinate systems
          • Coordinate systems syntax
          • Supported coordinate systems and units
            • Supported linear units
            • Supported angular units
            • Supported spheroids
            • Supported prime meridians
            • Supported map projections
        • Spatial reference systems
          • Conversion factors that transform coordinate data into integers
          • Predefined spatial reference systems
        • Geohashes and geohash covers
        • Supported data formats
          • Well-known text (WKT) format
          • Well-known binary (WKB) format
          • Shapefile representation
          • GeoJSON format
          • GML format
        • Examples of how spatial functions operate
      • Using Spatial Analytics
        • Enabling the Spatial Analytics component
        • Creating projects that use spatial data
        • Determine what coordinate system to use
        • Deciding whether to use an existing spatial reference system or create a new system
        • Creating a spatial reference system
          • Calculating scale factors
          • Determining minimum and maximum coordinates and measures
          • Calculating offset values
        • Creating spatial columns
        • Importing spatial data
          • Importing spatial data from a data exchange format
          • Importing spatial data from a shapefile
          • Importing coordinate spatial data
          • Handling invalid spatial geometry data
        • Exporting spatial data to a shapefile
        • Using views to access spatial columns
      • Performance tuning
        • Specifying inline lengths for geospatial columns
        • Registering spatial columns
        • Filtering
          • Filtering using a bounding box
          • Filtering using geohash covers
      • Migrating to Spatial Analytics
        • Migrating from Db2 Spatial Extender
        • Migrating from PureData System for Analytics (Netezza)
          • Data migration
          • Application migration
      • Troubleshooting spatial routines and procedures
        • How to interpret spatial messages
        • Spatial function messages
      • Catalog views
        • SYSGEO.ST_COORDINATE_SYSTEMS
        • SYSGEO.ST_GEOMETRY_COLUMNS
        • SYSGEO.ST_SIZINGS
        • SYSGEO.ST_SPATIAL_REFERENCE_SYSTEMS
        • SYSGEO.ST_UNITS_OF_MEASURE
      • Spatial Analytics commands
        • Issuing db2se commands
        • db2se drop_srs command
        • db2se export_shape command
        • db2se import_shape command
        • db2se shape_info command
      • Stored procedures
        • ST_ALTER_SRS
        • ST_CREATE_SRS
        • ST_DROP_SRS
        • ST_EXPORT_SHAPE
        • ST_IMPORT_SHAPE
        • ST_REGISTER_SPATIAL_COLUMN
        • ST_SHAPEFILE_INFO
        • ST_UNREGISTER_SPATIAL_COLUMN
      • Spatial functions
        • Categories, uses and examples for spatial functions
          • Using ST_Geometry to store subtype geometries
          • Spatial functions by input type
          • Comparison functions for geographic features
          • Geometries with the DE-9IM pattern matrix string
          • Distance between geometries
          • Examples for querying spatial data
          • Examples of inserting spatial data with constructor functions
        • ST_AppendPoint
        • ST_Area
        • ST_AsBinary
        • ST_AsGeoJSON
        • ST_AsGML
        • ST_AsKML
        • ST_AsShape
        • ST_AsText
        • ST_Boundary
        • ST_Buffer
        • ST_Centroid
        • ST_ChangePoint
        • ST_Contains
        • ST_ConvexHull
        • ST_CoordDim
        • ST_Crosses
        • ST_Difference
        • ST_Dimension
        • ST_Disjoint
        • ST_Distance
        • ST_DistanceToPoint
        • ST_DWithin
        • ST_Ellipse
        • ST_Endpoint
        • ST_Envelope
        • ST_EnvIntersects
        • ST_EqualCoordsys
        • ST_Equals
        • ST_EqualSRS
        • ST_Expand
        • ST_ExteriorRing
        • ST_FindMeasure or ST_LocateAlong
        • ST_Generalize
        • ST_Geohash
        • ST_GeohashCover
        • ST_GeohashCoverExtend
        • ST_GeomCollection
        • ST_GeomCollFromTxt
        • ST_GeomCollFromWKB
        • ST_Geometry
        • ST_GeometryN
        • ST_GeometryType
        • ST_GeometryTypeID
        • ST_GeomFromText
        • ST_GeomFromWKB
        • ST_GrandMBR aggregation
        • ST_InteriorRingN
        • ST_Intersection
        • ST_Intersects
        • ST_Is3d
        • ST_IsClosed
        • ST_IsEmpty
        • ST_IsFormat
        • ST_IsMeasured
        • ST_IsRing
        • ST_IsSimple
        • ST_IsValid
        • ST_Length
        • ST_LineFromMultiPoint
        • ST_LineFromText
        • ST_LineFromWKB
        • ST_LineString
        • ST_LineStringN
        • ST_M
        • ST_MaxM
        • ST_MaxX
        • ST_MaxY
        • ST_MaxZ
        • ST_MBR
        • ST_MBRIntersects
        • ST_LocateBetween and ST_MeasureBetween
        • ST_MidPoint
        • ST_MinM
        • ST_MinX
        • ST_MinY
        • ST_MinZ
        • ST_MLineFromText
        • ST_MLineFromWKB
        • ST_MPointFromText
        • ST_MPointFromWKB
        • ST_MPolyFromText
        • ST_MPolyFromWKB
        • ST_MultiLineString
        • ST_MultiPoint
        • ST_MultiPolygon
        • ST_NearestPoints
        • ST_NumGeometries
        • ST_NumInteriorRing
        • ST_NumLineStrings
        • ST_NumPoints
        • ST_NumPolygons
        • ST_Overlaps
        • ST_Perimeter
        • ST_PerpPoints
        • ST_Point
        • ST_PointAtDistance
        • ST_PointFromText
        • ST_PointFromWKB
        • ST_PointN
        • ST_PointOnSurface
        • ST_PolyFromText
        • ST_PolyFromWKB
        • ST_Polygon
        • ST_PolygonN
        • ST_Relate
        • ST_RemovePoint
        • ST_SRID and ST_SrsId
        • ST_SrsName
        • ST_StartPoint
        • ST_SymDifference
        • ST_ToGeomColl
        • ST_ToLineString
        • ST_ToMultiLine
        • ST_ToMultiPoint
        • ST_ToMultiPolygon
        • ST_ToPoint
        • ST_ToPolygon
        • ST_Touches
        • ST_Transform
        • ST_Union and ST_Union aggregation
        • ST_Within
        • ST_WKBToSQL
        • ST_WKBtoWKT
        • ST_WKTToSQL
        • ST_WKTtoWKB
        • ST_X
        • ST_Y
        • ST_Z
  • SPSS
    • Tutorial: Analyzing with SPSS Statistics
• 管理資料庫
  • 連接至 Db2
    • 必要條件
      • Db2 驅動程式套件
        • 安裝
          • Windows
          • 在 Linux 或 PowerLinux 上安裝
          • 在 Mac OS X 上安裝
        • 配置
      • Secure Sockets Layer (SSL)
      • 資料庫詳細資料及連接認證
    • 連接 CLPPlus
    • REST API
    • 以程式設計方式連接
      • JDBC
      • .Net
      • PHP
      • ODBC 或 CLI
      • ODBC 資料來源管理員
    • 連接 IBM 或協力廠商工具
      • Aginity Workbench
      • Cognos
      • Data Server Manager
      • IBM Data Studio
      • DataStage
      • Esri ArcGIS for Desktop
      • Excel
      • InfoSphere Data Architect
      • InfoSphere Data Replication
      • R 開發環境
      • SAS
      • SPSS Statistics
      • 將 Tableau 連接至 Db2 資料庫
  • 載入資料
    • 將資料載入至 IBM Cloud
    • 從 PureData System for Analytics (Netezza) 進行移轉
    • 從本端或主機檔案載入資料
    • 從 Swift 物件儲存庫載入資料
    • 從 Amazon S3 載入資料
      • 從 Amazon S3 上的檔案載入資料
      • 針對 IBM Db2 Warehouse 從 Amazon S3 載入公用資料集
    • 從郵寄磁碟機載入資料
    • 從 DataStage 載入資料
    • 從 InfoSphere Data Replication 載入資料
    • 載入地理空間資料
  • 設計資料庫
    • 建立新的資料庫設計
    • 複製現有資料庫設計
  • 在 MPP 資料庫中建立表格
    • 選擇雜湊分佈索引鍵
  • 調適性工作量管理程式
    • 影響查詢許可的資源
    • 查詢略過
    • 監視
    • 最佳作法
• 資料庫參考資料
  • 標準相符性
  • SQL reference
    • How to read the syntax diagrams
    • Error conditions
    • Highlighting conventions
    • Conventions describing Unicode data
    • Characters
    • Tokens
    • Identifiers
    • Data types
      • Numbers
      • Character strings
      • Graphic strings
      • National character strings
      • Binary strings
      • Large objects (LOBs)
      • Datetime values
      • Boolean values
      • Cursor values
      • XML values
      • Array values
      • Anchored types
      • User-defined types
      • Promotion of data types
      • Casting between data types
      • Assignments and comparisons
      • Rules for result data types
      • Rules for string conversions
      • String comparisons in a Unicode database
      • Resolving the anchor object for an anchored type
      • Resolving the anchor object for an anchored row type
      • Database partition-compatible data types
    • Constants
    • Special registers
      • CURRENT CLIENT_ACCTNG
      • CURRENT CLIENT_APPLNAME
      • CURRENT CLIENT_USERID
      • CURRENT CLIENT_WRKSTNNAME
      • CURRENT DATE
      • CURRENT DBPARTITIONNUM
      • CURRENT DECFLOAT ROUNDING MODE
      • CURRENT DEFAULT TRANSFORM GROUP
      • CURRENT DEGREE
      • CURRENT EXPLAIN MODE
      • CURRENT EXPLAIN SNAPSHOT
      • CURRENT FEDERATED ASYNCHRONY
      • CURRENT IMPLICIT XMLPARSE OPTION
      • CURRENT ISOLATION
      • CURRENT LOCALE LC_MESSAGES
      • CURRENT LOCALE LC_TIME
      • CURRENT LOCK TIMEOUT
      • CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION
      • CURRENT MDC ROLLOUT MODE
      • CURRENT MEMBER
      • CURRENT OPTIMIZATION PROFILE
      • CURRENT PACKAGE PATH
      • CURRENT PATH
      • CURRENT QUERY OPTIMIZATION
      • CURRENT REFRESH AGE
      • CURRENT SCHEMA
      • CURRENT SERVER
      • CURRENT SQL_CCFLAGS
      • CURRENT TEMPORAL BUSINESS_TIME
      • CURRENT TEMPORAL SYSTEM_TIME
      • CURRENT TIME
      • CURRENT TIMESTAMP
      • CURRENT TIMEZONE
      • CURRENT USER
      • SESSION_USER
      • SYSTEM_USER
      • USER
    • Global variables
      • Types of global variables
      • Authorization required for global variables
      • Resolution of global variable references
      • Using global variables
    • Functions
    • Methods
    • Conservative binding semantics
    • Expressions
      • Datetime operations and durations
      • CASE expression
      • CAST specification
      • Field reference
      • XMLCAST specification
      • ARRAY element specification
      • Array constructor
      • Dereference operation
      • Method invocation
      • OLAP specification
      • ROW CHANGE expression
      • Sequence reference
      • sql-json-path-expression
      • Subtype treatment
      • Determining data types of untyped expressions
    • Row expression
    • Predicates
      • Search conditions
      • Basic predicate
      • Boolean predicate
      • Quantified predicate
      • ARRAY_EXISTS predicate
      • BETWEEN predicate
      • Cursor predicates
      • DISTINCT predicate
      • EXISTS predicate
      • IN predicate
      • JSON_EXISTS predicate
      • LIKE predicate
      • NULL predicate
      • OVERLAPS predicate
      • REGEXP_LIKE predicate
      • Trigger event predicates
      • TYPE predicate
      • VALIDATED predicate
      • XMLEXISTS predicate
    • Built-in global variables
      • CLIENT_HOST global variable
      • CLIENT_IPADDR global variable
      • CLIENT_ORIGUSERID global variable
      • CLIENT_USRSECTOKEN global variable
      • CONNECTION_AUTHN_INFO global variable
      • CONNECTION_AUTHN_INFO_TYPE global variable
      • CONNECTION_AUTHN_SECURITY_PLUGIN global variable
    • Built-in global variables
      • MON_INTERVAL_ID global variable
      • NLS_STRING_UNITS global variable
      • PACKAGE_NAME global variable
      • PACKAGE_SCHEMA global variable
      • PACKAGE_VERSION global variable
      • ROUTINE_MODULE global variable
      • ROUTINE_SCHEMA global variable
      • ROUTINE_SPECIFIC_NAME global variable
      • ROUTINE_TYPE global variable
      • SQL_COMPAT global variable
      • TRUSTED_CONTEXT global variable
    • Built-in functions
      • Aggregate functions
        • ARRAY_AGG
        • AVG
        • CORRELATION
        • COUNT
        • COUNT_BIG
        • COVARIANCE
        • COVARIANCE_SAMP
        • CUME_DIST
        • GROUPING
        • LISTAGG
        • MAX
        • MEDIAN
        • MIN
        • PERCENTILE_CONT
        • PERCENTILE_DISC
        • PERCENT_RANK
        • Regression functions (REGR_AVGX, REGR_AVGY, REGR_COUNT, ...)
        • STDDEV
        • STDDEV_SAMP
        • SUM
        • VARIANCE
        • VARIANCE_SAMP
        • XMLAGG
        • XMLGROUP
      • Scalar functions
        • ABS or ABSVAL
        • ACOS
        • ADD_DAYS
        • ADD_HOURS
        • ADD_MINUTES
        • ADD_MONTHS
        • ADD_SECONDS
        • ADD_YEARS
        • AGE
        • ARRAY_DELETE
        • ARRAY_FIRST
        • ARRAY_LAST
        • ARRAY_NEXT
        • ARRAY_PRIOR
        • ASCII
        • ASCII_STR
        • ASIN
        • ATAN
        • ATAN2
        • ATANH
        • BIGINT
        • BINARY
        • BITAND, BITANDNOT, BITOR, BITXOR, and BITNOT
        • BLOB
        • BOOLEAN
        • BPCHAR
        • BSON_TO_JSON
        • BTRIM
        • CARDINALITY
        • CEILING or CEIL
        • CHAR
        • CHARACTER_LENGTH
        • CHR
        • CLOB
        • COALESCE
        • COLLATION_KEY
        • COLLATION_KEY_BIT
        • COMPARE_DECFLOAT
        • CONCAT
        • COS
        • COSH
        • COT
        • CURSOR_ROWCOUNT
        • DATAPARTITIONNUM
        • DATE
        • DATETIME
        • DATE_PART
        • DATE_TRUNC
        • DAY
        • DAYNAME
        • DAYOFMONTH
        • DAYOFWEEK
        • DAYOFWEEK_ISO
        • DAYOFYEAR
        • DAYS
        • DAYS_BETWEEN
        • DAYS_TO_END_OF_MONTH
        • DBCLOB
        • DBPARTITIONNUM
        • DECFLOAT
        • DECFLOAT_FORMAT
        • DECIMAL or DEC
        • DECODE
        • DECRYPT_BIN and DECRYPT_CHAR
        • DEGREES
        • DEREF
        • DIFFERENCE
        • DIGITS
        • DOUBLE_PRECISION or DOUBLE
        • EMPTY_BLOB, EMPTY_CLOB, EMPTY_DBCLOB, and EMPTY_NCLOB
        • ENCRYPT
        • EVENT_MON_STATE
        • EXP
        • EXTRACT
        • FIRST_DAY
        • FLOAT
        • FLOAT4
        • FLOAT8
        • FLOOR
        • FROM_UTC_TIMESTAMP
        • GENERATE_UNIQUE
        • GETHINT
        • GRAPHIC
        • GREATEST
        • HASH
        • HASH4
        • HASH8
        • HASHEDVALUE
        • HEX
        • HEXTORAW
        • HOUR
        • HOURS_BETWEEN
        • IDENTITY_VAL_LOCAL
        • IFNULL
        • INITCAP
        • INSERT
        • INSTR
        • INSTR2
        • INSTR4
        • INSTRB
        • INT
        • INTERVAL
        • INTEGER
        • INT2
        • INT4
        • INT8
        • INTNAND, INTNOR, INTNXOR, and INTNNOT
        • ISFALSE
        • ISNOTFALSE
        • ISNOTTRUE
        • ISNULL
        • ISTRUE
        • JSON_ARRAY
        • JSON_OBJECT
        • JSON_QUERY
        • JSON_TO_BSON
        • JSON_VALUE
        • JULIAN_DAY
        • LAST_DAY
        • LCASE
        • LCASE (locale sensitive)
        • LCASE (SYSFUN schema)
        • LEAST
        • LEFT
        • LENGTH
        • LENGTH2
        • LENGTH4
        • LENGTHB
        • LN
        • LOCATE
        • LOCATE_IN_STRING
        • LOG10
        • LONG_VARCHAR
        • LONG_VARGRAPHIC
        • LOWER
        • LOWER (locale sensitive)
        • LPAD
        • LTRIM
        • LTRIM (SYSFUN schema)
        • MAX
        • MAX_CARDINALITY
        • MICROSECOND
        • MIDNIGHT_SECONDS
        • MIN
        • MINUTE
        • MINUTES_BETWEEN
        • MOD
        • MOD (SYSFUN schema)
        • MONTH
        • MONTHNAME
        • MONTHS_BETWEEN
        • MULTIPLY_ALT
        • NCHAR
        • NCHR
        • NCLOB
        • NVARCHAR
        • NEXT_DAY
        • NEXT_MONTH
        • NEXT_QUARTER
        • NEXT_WEEK
        • NEXT_YEAR
        • NORMALIZE_DECFLOAT
        • NOW
        • NULLIF
        • NUMERIC
        • NVL
        • NVL2
        • OCTET_LENGTH
        • OVERLAY
        • PARAMETER
        • POSITION
        • POSSTR
        • POW
        • POWER
        • QUANTIZE
        • QUARTER
        • QUOTE_IDENT
        • QUOTE_LITERAL
        • RADIANS
        • RAISE_ERROR
        • RAND (SYSFUN schema)
        • RAND (SYSIBM schema)
        • RANDOM
        • RAWTOHEX
        • REAL
        • REC2XML
        • REGEXP_COUNT
        • REGEXP_EXTRACT
        • REGEXP_INSTR
        • REGEXP_LIKE
        • REGEXP_MATCH_COUNT
        • REGEXP_REPLACE
        • REGEXP_SUBSTR
        • REPEAT
        • REPEAT (SYSFUN schema)
        • REPLACE
        • REPLACE (SYSFUN schema)
        • RID and RID_BIT
        • RIGHT
        • ROUND
        • ROUND_TIMESTAMP
        • RPAD
        • RTRIM
        • RTRIM (SYSFUN schema)
        • SECLABEL
        • SECLABEL_BY_NAME
        • SECLABEL_TO_CHAR
        • SECOND
        • SECONDS_BETWEEN
        • SIGN
        • SIN
        • SINH
        • SMALLINT
        • SOUNDEX
        • SPACE
        • SQRT
        • STRIP
        • STRLEFT
        • STRPOS
        • STRRIGHT
        • SUBSTR
        • SUBSTR2
        • SUBSTR4
        • SUBSTRB
        • SUBSTRING
        • TABLE_NAME
        • TABLE_SCHEMA
        • TAN
        • TANH
        • THIS_MONTH
        • THIS_QUARTER
        • THIS_WEEK
        • THIS_YEAR
        • TIME
        • TIMESTAMP
        • TIMESTAMP_FORMAT
        • TIMESTAMP_ISO
        • TIMESTAMPDIFF
        • TIMEZONE
        • TO_CHAR
        • TO_CLOB
        • TO_DATE
        • TO_HEX
        • TO_MULTI_BYTE
        • TO_NCHAR
        • TO_NCLOB
        • TO_NUMBER
        • TO_SINGLE_BYTE
        • TO_TIMESTAMP
        • TO_UTC_TIMESTAMP
        • TOTALORDER
        • TRANSLATE
        • TRIM
        • TRIM_ARRAY
        • TRUNC_TIMESTAMP
        • TRUNCATE or TRUNC
        • TYPE_ID
        • TYPE_NAME
        • TYPE_SCHEMA
        • UCASE
        • UCASE (locale sensitive)
        • UNICODE_STR
        • UPPER
        • UPPER (locale sensitive)
        • VALUE
        • VARBINARY
        • VARCHAR
        • VARCHAR_BIT_FORMAT
        • VARCHAR_FORMAT
        • VARCHAR_FORMAT_BIT
        • VARGRAPHIC
        • VERIFY_GROUP_FOR_USER
        • VERIFY_ROLE_FOR_USER
        • VERIFY_TRUSTED_CONTEXT_ROLE_FOR_USER
        • WEEK
        • WEEK_ISO
        • WEEKS_BETWEEN
        • WIDTH_BUCKET
        • XMLATTRIBUTES
        • XMLCOMMENT
        • XMLCONCAT
        • XMLDOCUMENT
        • XMLELEMENT
        • XMLFOREST
        • XMLNAMESPACES
        • XMLPARSE
        • XMLPI
        • XMLQUERY
        • XMLROW
        • XMLSERIALIZE
        • XMLTEXT
        • XMLVALIDATE
        • XMLXSROBJECTID
        • XSLTRANSFORM
        • YEAR
        • YEARS_BETWEEN
        • YMD_BETWEEN
      • Table functions
        • BASE_TABLE
        • JSON_TABLE
        • MEMORY_TABLE
        • UNNEST
        • XMLTABLE
      • Datalake functions
        • GET_CACHE_FILE_INFO table function
        • GET_CACHE_TABLE_INFO table function
        • GET_DATALAKE_CONFIG table function
        • HCAT_DESCRIBESCHEMA function
        • HCAT_DESCRIBETAB function
        • LOG_ENTRY table function
      • User-defined functions
    • Built-in procedures
      • XSR_ADDSCHEMADOC
      • XSR_COMPLETE
      • XSR_DTD
      • XSR_EXTENTITY
      • XSR_REGISTER
      • XSR_UPDATE
      • Datalake procedures
        • BIGSQL_AUTO_ANALYZE_STATUS
        • EXT_METASTORE_SYNC
        • EXT_METASTORE_PROPERTIES
        • HCAT_CACHE_SYNC
        • REGISTER_EXT_METASTORE
        • ROLLBACK_TO_SNAPSHOT
        • ROLLBACK_TO TIMESTAMP
        • SET_DATALAKE_CONFIG
        • SET_EXT_METASTORE_PROPERTY
        • SET_TO_SNAPSHOT
        • SET_TO_TIMESTAMP
        • UNREGISTER_EXT_METASTORE
    • Queries
      • Queries and table expressions
      • subselect
        • select-clause
        • from-clause
          • table-reference
          • joined-table
            • Examples of subselect queries with joins
        • where-clause
        • group-by-clause
          • Examples of grouping sets, cube, and rollup
        • having-clause
        • order-by-clause
        • fetch-clause
        • offset-clause
        • isolation-clause
        • Examples of subselect queries
      • fullselect
        • Examples of fullselect queries
      • select-statement
        • common-table-expression
          • Recursion example: bill of materials
        • update-clause
        • read-only-clause
        • optimize-for-clause
        • isolation-clause
        • lock-request-clause
        • concurrent-access-resolution-clause
        • Examples of select-statement queries
        • Result sets from SQL data changes
    • Statements
      • How SQL statements are invoked
        • Embedding a statement in an application program
        • Dynamic preparation and execution
        • Static invocation of a select-statement
        • Dynamic invocation of a select-statement
        • Interactive invocation
        • SQL use with other host systems
      • Detecting and processing error and warning conditions in host language applications
      • SQL comments
      • Conditional compilation in SQL
      • About SQL control statements
        • References to SQL parameters, SQL variables, and global variables
        • References to SQL labels
        • References to SQL condition names
        • References to SQL statement names
        • References to SQL cursor names
      • Function, method, and procedure designators
      • ALLOCATE CURSOR
      • ALTER AUDIT POLICY
      • ALTER EVENT MONITOR
      • ALTER FUNCTION
      • ALTER HISTOGRAM TEMPLATE
      • ALTER INDEX
      • ALTER MASK
      • ALTER METHOD
      • ALTER MODULE
      • ALTER NICKNAME
      • ALTER PACKAGE
      • ALTER PERMISSION
      • ALTER PROCEDURE (external)
      • ALTER PROCEDURE (sourced)
      • ALTER PROCEDURE (SQL)
      • ALTER SCHEMA
      • ALTER SECURITY LABEL COMPONENT
      • ALTER SECURITY POLICY
      • ALTER SEQUENCE
      • ALTER SERVER
      • ALTER SERVICE CLASS
      • ALTER TABLE
      • ALTER TABLE (DATALAKE)
      • ALTER THRESHOLD
      • ALTER TRIGGER
      • ALTER TRUSTED CONTEXT
      • ALTER TYPE (structured)
      • ALTER USAGE LIST
      • ALTER USER MAPPING
      • ALTER VIEW
      • ALTER WORK ACTION SET
      • ALTER WORK CLASS SET
      • ALTER WORKLOAD
      • ALTER WRAPPER
      • ALTER XSROBJECT
      • ANALYZE TABLE
      • ASSOCIATE LOCATORS
      • AUDIT
      • BEGIN DECLARE SECTION
      • CALL
      • CASE
      • CLOSE
      • COMMENT
      • COMMIT
      • Compound SQL
      • Compound SQL (inlined)
      • Compound SQL (embedded)
      • Compound SQL (compiled)
      • CONNECT (type 1)
      • CONNECT (type 2)
      • CREATE ALIAS
      • CREATE AUDIT POLICY
      • CREATE EVENT MONITOR
      • CREATE EVENT MONITOR (activities)
      • CREATE EVENT MONITOR (change history)
      • CREATE EVENT MONITOR (locking)
      • CREATE EVENT MONITOR (package cache)
      • CREATE EVENT MONITOR (statistics)
      • CREATE EVENT MONITOR (threshold violations)
      • CREATE EVENT MONITOR (unit of work)
      • CREATE FUNCTION
      • CREATE FUNCTION (aggregate interface)
      • CREATE FUNCTION (external scalar)
      • CREATE FUNCTION (external table)
      • CREATE FUNCTION (sourced or template)
      • CREATE FUNCTION (SQL scalar, table, or row)
      • CREATE FUNCTION MAPPING
      • CREATE GLOBAL TEMPORARY TABLE
      • CREATE HISTOGRAM TEMPLATE
      • CREATE INDEX
      • CREATE INDEX EXTENSION
      • CREATE MASK
      • CREATE METHOD
      • CREATE MODULE
      • CREATE NICKNAME
      • CREATE PERMISSION
      • CREATE PROCEDURE
      • CREATE PROCEDURE (external)
      • CREATE PROCEDURE (sourced)
      • CREATE PROCEDURE (SQL)
      • CREATE ROLE
      • CREATE SCHEMA
      • CREATE SECURITY LABEL COMPONENT
      • CREATE SECURITY LABEL
      • CREATE SECURITY POLICY
      • CREATE SEQUENCE
      • CREATE SERVICE CLASS
      • CREATE SERVER
      • CREATE SYNONYM
      • CREATE TABLE
      • CREATE TABLE (DATALAKE)
      • CREATE TABLE (EXTERNAL)
      • CREATE THRESHOLD
      • CREATE TRIGGER
      • CREATE TRUSTED CONTEXT
      • CREATE TYPE
      • CREATE TYPE (array)
      • CREATE TYPE (cursor)
      • CREATE TYPE (distinct)
      • CREATE TYPE (row)
      • CREATE TYPE MAPPING
      • CREATE USAGE LIST
      • CREATE USER MAPPING
      • CREATE VARIABLE
      • CREATE VIEW
      • CREATE WORK ACTION SET
      • CREATE WORK CLASS SET
      • CREATE WORKLOAD
      • CREATE WRAPPER
      • DECLARE CURSOR
      • DECLARE GLOBAL TEMPORARY TABLE
      • DELETE
      • DESCRIBE
      • DESCRIBE INPUT
      • DESCRIBE OUTPUT
      • DISCONNECT
      • DROP
      • DROP TABLE (DATALAKE)
      • END DECLARE SECTION
      • EXECUTE
      • EXECUTE IMMEDIATE
      • EXPLAIN
      • FETCH
      • FLUSH BUFFERPOOLS
      • FLUSH EVENT MONITOR
      • FLUSH FEDERATED CACHE
      • FLUSH OPTIMIZATION PROFILE CACHE
      • FLUSH PACKAGE CACHE
      • FOR
      • FREE LOCATOR
      • GET DIAGNOSTICS
      • GOTO
      • GRANT (database authorities)
      • GRANT (exemption)
      • GRANT (global variable privileges)
      • GRANT (index privileges)
      • GRANT (module privileges)
      • GRANT (package privileges)
      • GRANT (role)
      • GRANT (routine privileges)
      • GRANT (schema privileges and authorities)
      • GRANT (security label)
      • GRANT (sequence privileges)
      • GRANT (server privileges)
      • GRANT (SETSESSIONUSER privilege)
      • GRANT (table space privileges)
      • GRANT (table, view, or nickname privileges)
      • GRANT (workload privileges)
      • GRANT (XSR object privileges)
      • IF
      • INCLUDE
      • INSERT
      • ITERATE
      • LEAVE
      • LOCK TABLE
      • LOOP
      • MERGE
      • MSCK REPAIR TABLE (DATALAKE)
      • OPEN
      • PIPE
      • PREPARE
      • REFRESH TABLE
      • RELEASE (connection)
      • RELEASE SAVEPOINT
      • RENAME
      • RENAME DATALAKE TABLE
      • REPEAT
      • RESIGNAL
      • RETURN
      • REVOKE (database authorities)
      • REVOKE (exemption)
      • REVOKE (global variable privileges)
      • REVOKE (index privileges)
      • REVOKE (module privileges)
      • REVOKE (package privileges)
      • REVOKE (role)
      • REVOKE (routine privileges)
      • REVOKE (schema privileges and authorities)
      • REVOKE (security label)
      • REVOKE (sequence privileges)
      • REVOKE (server privileges)
      • REVOKE (SETSESSIONUSER privilege)
      • REVOKE (table space privileges)
      • REVOKE (table, view, or nickname privileges)
      • REVOKE (workload privileges)
      • REVOKE (XSR object privileges)
      • ROLLBACK
      • SAVEPOINT
      • SELECT
      • SELECT INTO
      • SET COMPILATION ENVIRONMENT
      • SET CONNECTION
      • SET CURRENT DECFLOAT ROUNDING MODE
      • SET CURRENT DEFAULT TRANSFORM GROUP
      • SET CURRENT DEGREE
      • SET CURRENT EXPLAIN MODE
      • SET CURRENT EXPLAIN SNAPSHOT
      • SET CURRENT FEDERATED ASYNCHRONY
      • SET CURRENT IMPLICIT XMLPARSE OPTION
      • SET CURRENT ISOLATION
      • SET CURRENT LOCALE LC_MESSAGES
      • SET CURRENT LOCALE LC_TIME
      • SET CURRENT LOCK TIMEOUT
      • SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION
      • SET CURRENT MDC ROLLOUT MODE
      • SET CURRENT OPTIMIZATION PROFILE
      • SET CURRENT PACKAGE PATH
      • SET CURRENT PACKAGESET
      • SET CURRENT QUERY OPTIMIZATION
      • SET CURRENT REFRESH AGE
      • SET CURRENT SQL_CCFLAGS
      • SET CURRENT TEMPORAL BUSINESS_TIME
      • SET CURRENT TEMPORAL SYSTEM_TIME
      • SET ENCRYPTION PASSWORD
      • SET EVENT MONITOR STATE
      • SET INTEGRITY
      • SET PATH
      • SET ROLE
      • SET SCHEMA
      • SET SERVER OPTION
      • SET SESSION AUTHORIZATION
      • SET USAGE LIST STATE
      • SET variable
      • SIGNAL
      • TRANSFER OWNERSHIP
      • TRUNCATE
      • UPDATE
      • VALUES
      • VALUES INTO
      • WHENEVER
      • WHILE
    • Catalog views
      • Road map to the catalog views
      • SYSCAT.ATTRIBUTES
      • SYSCAT.BUFFERPOOLDBPARTITIONS
      • SYSCAT.BUFFERPOOLEXCEPTIONS
      • SYSCAT.BUFFERPOOLS
      • SYSCAT.CASTFUNCTIONS
      • SYSCAT.CHECKS
      • SYSCAT.COLAUTH
      • SYSCAT.COLCHECKS
      • SYSCAT.COLDIST
      • SYSCAT.COLGROUPCOLS
      • SYSCAT.COLGROUPDIST
      • SYSCAT.COLGROUPDISTCOUNTS
      • SYSCAT.COLGROUPS
      • SYSCAT.COLIDENTATTRIBUTES
      • SYSCAT.COLOPTIONS
      • SYSCAT.COLUMNS
      • SYSCAT.COLUSE
      • SYSCAT.CONDITIONS
      • SYSCAT.CONSTDEP
      • SYSCAT.CONTEXTATTRIBUTES
      • SYSCAT.CONTEXTS
      • SYSCAT.CONTROLDEP
      • SYSCAT.CONTROLS
      • SYSCAT.DATAPARTITIONEXPRESSION
      • SYSCAT.DATAPARTITIONS
      • SYSCAT.DATATYPEDEP
      • SYSCAT.DATATYPES
      • SYSCAT.DBAUTH
      • SYSCAT.DBPARTITIONGROUPDEF
      • SYSCAT.DBPARTITIONGROUPS
      • SYSCAT.EVENTMONITORS
      • SYSCAT.EVENTS
      • SYSCAT.EVENTTABLES
      • SYSCAT.EXTERNALTABLEOPTIONS
      • SYSCAT.FULLHIERARCHIES
      • SYSCAT.FUNCMAPOPTIONS
      • SYSCAT.FUNCMAPPARMOPTIONS
      • SYSCAT.FUNCMAPPINGS
      • SYSCAT.HIERARCHIES
      • SYSCAT.HISTOGRAMTEMPLATEBINS
      • SYSCAT.HISTOGRAMTEMPLATES
      • SYSCAT.HISTOGRAMTEMPLATEUSE
      • SYSCAT.INDEXAUTH
      • SYSCAT.INDEXCOLUSE
      • SYSCAT.INDEXDEP
      • SYSCAT.INDEXES
      • SYSCAT.INDEXEXPLOITRULES
      • SYSCAT.INDEXEXTENSIONDEP
      • SYSCAT.INDEXEXTENSIONMETHODS
      • SYSCAT.INDEXEXTENSIONPARMS
      • SYSCAT.INDEXEXTENSIONS
      • SYSCAT.INDEXOPTIONS
      • SYSCAT.INDEXPARTITIONS
      • SYSCAT.INDEXXMLPATTERNS
      • SYSCAT.INVALIDOBJECTS
      • SYSCAT.KEYCOLUSE
      • SYSCAT.MEMBERSUBSETATTRS
      • SYSCAT.MEMBERSUBSETMEMBERS
      • SYSCAT.MEMBERSUBSETS
      • SYSCAT.MODULEAUTH
      • SYSCAT.MODULEOBJECTS
      • SYSCAT.MODULES
      • SYSCAT.NAMEMAPPINGS
      • SYSCAT.NICKNAMES
      • SYSCAT.PACKAGEAUTH
      • SYSCAT.PACKAGEDEP
      • SYSCAT.PACKAGES
      • SYSCAT.PARTITIONMAPS
      • SYSCAT.PASSTHRUAUTH
      • SYSCAT.PERIODS
      • SYSCAT.PREDICATESPECS
      • SYSCAT.REFERENCES
      • SYSCAT.ROLEAUTH
      • SYSCAT.ROLES
      • SYSCAT.ROUTINEAUTH
      • SYSCAT.ROUTINEDEP
      • SYSCAT.ROUTINEOPTIONS
      • SYSCAT.ROUTINEPARMOPTIONS
      • SYSCAT.ROUTINEPARMS
      • SYSCAT.ROUTINES
      • SYSCAT.ROUTINESFEDERATED
      • SYSCAT.ROWFIELDS
      • SYSCAT.SCHEMAAUTH
      • SYSCAT.SCHEMATA
      • SYSCAT.SCPREFTBSPACES
      • SYSCAT.SECURITYLABELACCESS
      • SYSCAT.SECURITYLABELCOMPONENTELEMENTS
      • SYSCAT.SECURITYLABELCOMPONENTS
      • SYSCAT.SECURITYLABELS
      • SYSCAT.SECURITYPOLICIES
      • SYSCAT.SECURITYPOLICYCOMPONENTRULES
      • SYSCAT.SECURITYPOLICYEXEMPTIONS
      • SYSCAT.SEQUENCEAUTH
      • SYSCAT.SEQUENCES
      • SYSCAT.SERVEROPTIONS
      • SYSCAT.SERVERS
      • SYSCAT.SERVICECLASSES
      • SYSCAT.STATEMENTS
      • SYSCAT.STOGROUPS
      • SYSCAT.STATEMENTTEXTS
      • SYSCAT.SURROGATEAUTHIDS
      • SYSCAT.TABAUTH
      • SYSCAT.TABCONST
      • SYSCAT.TABDEP
      • SYSCAT.TABDETACHEDDEP
      • SYSCAT.TABLES
      • SYSCAT.TABLESPACES
      • SYSCAT.TABOPTIONS
      • SYSCAT.TBSPACEAUTH
      • SYSCAT.THRESHOLDS
      • SYSCAT.TRANSFORMS
      • SYSCAT.TRIGDEP
      • SYSCAT.TRIGGERS
      • SYSCAT.TYPEMAPPINGS
      • SYSCAT.USAGELISTS
      • SYSCAT.USEROPTIONS
      • SYSCAT.VARIABLEAUTH
      • SYSCAT.VARIABLEDEP
      • SYSCAT.VARIABLES
      • SYSCAT.VIEWS
      • SYSCAT.WORKACTIONS
      • SYSCAT.WORKACTIONSETS
      • SYSCAT.WORKCLASSATTRIBUTES
      • SYSCAT.WORKCLASSES
      • SYSCAT.WORKCLASSSETS
      • SYSCAT.WORKLOADAUTH
      • SYSCAT.WORKLOADCONNATTR
      • SYSCAT.WORKLOADS
      • SYSCAT.WRAPOPTIONS
      • SYSCAT.WRAPPERS
      • SYSCAT.XDBMAPGRAPHS
      • SYSCAT.XDBMAPSHREDTREES
      • SYSCAT.XMLSTRINGS
      • SYSCAT.XSROBJECTAUTH
      • SYSCAT.XSROBJECTCOMPONENTS
      • SYSCAT.XSROBJECTDEP
      • SYSCAT.XSROBJECTDETAILS
      • SYSCAT.XSROBJECTHIERARCHIES
      • SYSCAT.XSROBJECTS
      • SYSIBM.SYSDUMMY1
      • SYSSTAT.COLDIST
      • SYSSTAT.COLGROUPDIST
      • SYSSTAT.COLGROUPDISTCOUNTS
      • SYSSTAT.COLGROUPS
      • SYSSTAT.COLUMNS
      • SYSSTAT.INDEXES
      • SYSSTAT.ROUTINES
      • SYSSTAT.TABLES
    • DATALAKE table catalog views
      • SYSHADOOP.APPLICATIONS
      • SYSHADOOP.BIGSQL_PROPERTIES
      • SYSHADOOP.HCAT_COLUMNS
      • SYSHADOOP.HCAT_SCHEMAS
      • SYSHADOOP.HCAT_SCHEMAPROPS
      • SYSHADOOP.HCAT_TABLES
      • SYSHADOOP.HCAT_TABLEPARTS
      • SYSHADOOP.HCAT_TABLEPROPS
      • SYSHADOOP.HCAT_TABLESERDEPROPS
    • SQL and XML limits
    • Reserved schema names and reserved words
    • SQLCA (SQL communications area)
    • SQLDA (SQL descriptor area)
    • Exception tables
    • Regular expression control characters
    • Explain tables
      • ADVISE_INDEX
      • ADVISE_INSTANCE
      • ADVISE_MQT
      • ADVISE_PARTITION
      • ADVISE_TABLE
      • ADVISE_WORKLOAD
      • EXPLAIN_ACTUALS
      • EXPLAIN_ARGUMENT
      • EXPLAIN_DIAGNOSTIC
      • EXPLAIN_DIAGNOSTIC_DATA
      • EXPLAIN_INSTANCE
      • EXPLAIN_OBJECT
      • EXPLAIN_OPERATOR
      • EXPLAIN_PREDICATE
      • EXPLAIN_STATEMENT
      • EXPLAIN_STREAM
      • OBJECT_METRICS
    • Explain register values
    • Commands
      • SET HADOOP PROPERTY
  • 訊息
    • 訊息處理導覽圖
    • SQL30081N 訊息的特定通訊協定專用錯誤碼
      • SOAP 錯誤
      • SOCKS 錯誤
      • TCP/IP 錯誤
    • SQLSTATE 訊息
    • CDFAA 訊息
      • CDFAA0000 - CDFAA0499
        • CDFAA0000I
        • CDFAA0020N
        • CDFAA0023N
        • CDFAA0024N
        • CDFAA0025N
        • CDFAA0026N
        • CDFAA0030N
        • CDFAA0031N
        • CDFAA0032N
        • CDFAA0033N
        • CDFAA0034N
        • CDFAA0035N
        • CDFAA0041N
        • CDFAA0043N
        • CDFAA0044N
        • CDFAA0045N
        • CDFAA0051N
        • CDFAA0052N
        • CDFAA0053N
        • CDFAA0054N
        • CDFAA0057N
        • CDFAA0058N
        • CDFAA0059N
        • CDFAA0060N
        • CDFAA0061N
        • CDFAA0062N
        • CDFAA0063N
        • CDFAA0064N
        • CDFAA0065N
        • CDFAA0066N
        • CDFAA0070N
        • CDFAA0071N
        • CDFAA0072N
        • CDFAA0073N
        • CDFAA0074N
        • CDFAA0075N
        • CDFAA0076N
        • CDFAA0080N
        • CDFAA0081N
        • CDFAA0082N
        • CDFAA0083N
        • CDFAA0084N
        • CDFAA0100N
        • CDFAA0101N
        • CDFAA0102N
        • CDFAA0110N
        • CDFAA0111N
        • CDFAA0112N
        • CDFAA0113N
        • CDFAA0114N
        • CDFAA0115N
        • CDFAA0116N
        • CDFAA0117N
        • CDFAA0118N
        • CDFAA0120N
        • CDFAA0121N
        • CDFAA0122N
        • CDFAA0123N
        • CDFAA0130N
        • CDFAA0150E
        • CDFAA0151E
        • CDFAA0152E
        • CDFAA0153E
        • CDFAA0154E
        • CDFAA0155E
        • CDFAA0201N
        • CDFAA0204N
        • CDFAA0205N
        • CDFAA0206N
        • CDFAA0207N
        • CDFAA0208N
        • CDFAA0220N
        • CDFAA0221N
        • CDFAA0222N
        • CDFAA0223N
        • CDFAA0224N
        • CDFAA0225N
        • CDFAA0240N
        • CDFAA0241N
        • CDFAA0242N
        • CDFAA0243N
        • CDFAA0244N
        • CDFAA0245N
        • CDFAA0246N
        • CDFAA00247N
        • CDFAA0248N
        • CDFAA0249N
        • CDFAA0280N
        • CDFAA0281N
        • CDFAA0283N
        • CDFAA0284N
        • CDFAA0285N
        • CDFAA0286N
        • CDFAA0300W
        • CDFAA0301N
      • CDFAA0500 - CDFAA0999
        • CDFAA0840N
        • CDFAA0841N
        • CDFAA0842N
        • CDFAA0843N
        • CDFAA0852N
        • CDFAA0854N
        • CDFAA0857N
        • CDFAA0858N
        • CDFAA0859N
        • CDFAA0860N
        • CDFAA0863N
        • CDFAA0865N
        • CDFAA0866N
        • CDFAA0871N
        • CDFAA0874N
        • CDFAA0879N
        • CDFAA0883N
        • CDFAA0884N
        • CDFAA0885N
        • CDFAA0886N
        • CDFAA0887N
        • CDFAA0888N
        • CDFAA0889N
        • CDFAA0890N
        • CDFAA0891N
        • CDFAA0892N
        • CDFAA0893N
        • CDFAA0894N
        • CDFAA0895N
        • CDFAA0897N
        • CDFAA0900N
        • CDFAA0901N
        • CDFAA0902N
        • CDFAA0903N
        • CDFAA0904N
        • CDFAA0905N
        • CDFAA0906N
        • CDFAA0907N
        • CDFAA0908N
        • CDFAA0909W
        • CDFAA0910N
        • CDFAA0912N
        • CDFAA0913N
        • CDFAA0914N
        • CDFAA0915W
        • CDFAA0916W
    • CDFAE 訊息
      • CDFAE0000 - CDFAE0499
        • CDFAE0000I
      • CDFAE1000 - CDFAE1499
        • CDFAE1001E
        • CDFAE1002E
        • CDFAE1003E
        • CDFAE1004E
        • CDFAE1005E
        • CDFAE1006E
        • CDFAE1007E
        • CDFAE1008E
        • CDFAE1009E
        • CDFAE1010E
        • CDFAE1012E
        • CDFAE1013E
        • CDFAE1014E
        • CDFAE1015E
        • CDFAE1016E
        • CDFAE1017E
        • CDFAE1018E
        • CDFAE1019E
        • CDFAE1020E
        • CDFAE1022E
        • CDFAE1023E
        • CDFAE1024E
        • CDFAE1025E
        • CDFAE1026I
        • CDFAE1027I
        • CDFAE1028E
        • CDFAE1029E
        • CDFAE1034E
        • CDFAE1035E
        • CDFAE1036E
        • CDFAE1095E
        • CDFAE1096E
        • CDFAE1097E
        • CDFAE1098E
        • CDFAE1099E
        • CDFAE1100E
        • CDFAE1301E
        • CDFAE1302E
        • CDFAE1303E
        • CDFAE1304E
        • CDFAE1305E
        • CDFAE1306E
        • CDFAE1307E
        • CDFAE1308E
        • CDFAE1309E
        • CDFAE1310E
        • CDFAE1311I
        • CDFAE1312I
        • CDFAE1313E
        • CDFAE1314E
        • CDFAE1315E
        • CDFAE1316E
        • CDFAE1317E
        • CDFAE1318I
        • CDFAE1319E
        • CDFAE1320E
        • CDFAE1321E
        • CDFAE1322E
        • CDFAE1323E
        • CDFAE1324I
        • CDFAE1325E
        • CDFAE1326E
        • CDFAE1327E
        • CDFAE1328E
        • CDFAE1329E
        • CDFAE1330E
        • CDFAE1331E
        • CDFAE1399E
        • CDFAE1400E
      • CDFAE1500 - CDFAE1999
        • CDFAE1500E
        • CDFAE1502E
        • CDFAE1503E
        • CDFAE1504E
        • CDFAE1505E
        • CDFAE1506E
        • CDFAE1507E
        • CDFAE1508E
      • CDFAE2000 - CDFAE2499
        • CDFAE2044E
        • CDFAE2045E
    • CDFAS 訊息
      • CDFAS0000 - CDFAS0499
        • CDFAS0000I
  • 指令行處理器 Plus (CLPPlus)
    • Starting a CLPPlus client session
    • Starting CLPPlus from the Db2 Warehouse host container
    • CLPPLUS command
    • Session Global Variables in CLPPlus
    • CLPPlus console types
      • Window mode CLPPlus console and UTF-8 character support
      • Setting the font in CLPPlus window mode
      • Setting the font color in CLPPlus window mode
      • Setting the background color in CLPPlus window mode
    • DSN aliases in CLPPlus
    • Supported IBM data server driver configuration keywords
    • The SSL protocol support in CLPPlus
    • Kerberos authentication in CLPPlus
    • SERVER_ENCRYPT authentication in CLPPlus
    • SERVER_ENCRYPT_AES authentication in CLPPlus
    • LDAP support in CLPPlus
    • Running a script file in the CLPPlus session
    • Skipping and interrupting CLPPlus commands
    • Comments in CLPPlus
    • Escape characters in CLPPlus
    • Bind variables in CLPPlus
    • Shell and environment variables in CLPPlus
    • CLPPlus restrictions
    • CLPPlus troubleshooting hints and tips
      • CLPPlus traces and record logging
    • CLPPlus commands
      • .
      • !
      • /
      • @
      • @@
      • ACCEPT
      • APPEND
      • BREAK
      • BTITLE
      • CALL
      • CHANGE
      • CLEAR
      • COLUMN
      • COMPUTE
      • CONNECT
      • COPY
      • DEFINE
      • DEFINE_EDITOR
      • DEL
      • DESCRIBE
      • DISCONNECT
      • EDIT
      • EXPORT (external table)
      • EXECUTE
      • EXIT
      • EXPLAIN PLAN
      • GET
      • HELP
      • HOST
      • IDA BUILDLIB
      • IDA CREATEPACKAGE
      • IDA DELETEPROJECT
      • IDA DEPLOYPACKAGE
      • IDA DEPLOYUDX
      • IDA DOWNLOADFILES
      • IDA DOWNLOADSAMPLES
      • IDA DROPUDXS
      • IDA LISTFILES
      • IDA LISTPROJECTS
      • IDA LISTUDXS
      • IDA LOADGEOSPATIALDATA
      • IDA REGISTERUDX
      • IMPORT
      • INPUT
      • LIST
      • LOAD (external table)
      • zLOAD
      • PAUSE
      • PRINT
      • PROMPT
      • QUIT
      • REMARK
      • REPFOOTER
      • REPHEADER
      • RUN
      • SAVE
      • SET
      • SPOOL
      • SHOW
      • START
      • TTITLE
      • UNDEFINE
      • WHENEVER OSERROR
      • WHENEVER SQLERROR
  • System commands
    • db2batch - Benchmark tool
    • db2cli - Db2 interactive CLI
    • db2drdat - DRDA trace
    • db2expln - SQL and XQuery Explain
    • db2level - Show Db2 service level
    • db2look - Db2 statistics and DDL extraction tool
    • db2trc - Trace
  • 分析儲存程序
    • 變異數分析 (ANOVA)
      • 背景
      • 用法
      • 函數
        • IDAX.ANOVA_CRD_TEST - 使用完全隨機化設計來分析變異數
        • IDAX.ANOVA_RBD_TEST - 使用隨機化區塊設計來分析變異數
    • 關聯規則
      • 背景
      • 用法
      • 函數
        • IDAX.ASSOCRULES - 建置關聯規則模型
        • IDAX.PRUNE_ASSOCRULES - 刪改規則及型樣
        • IDAX.PREDICT_ASSOCRULES - 套用規則及型樣
      • 範例
      • 模型表格資料格式
        • _ITEMS 表格
        • _ASSOCPATTERNS 表格
        • _ASSOCPATTERNS_STATISTICS 表格
        • _ASSOCRULES 表格
    • 資料轉換
      • 背景
      • 用法
      • 函數
        • IDAX.IMPUTE_DATA - 插補遺漏資料
        • IDAX.SPLIT_DATA - 分割資料
        • IDAX.STD_NORM - 將輸入表格的直欄標準化或正規化
    • 決策樹狀結構
      • 背景
        • 增長
        • 刪改
        • 預測
        • 支援遺漏值
      • 用法
      • 函數
        • IDAX.DECTREE - 建置及刪改決策樹狀結構模型
        • IDAX.GROW_DECTREE - 建置決策樹狀結構模型
        • IDAX.PRUNE_DECTREE - 刪改決策樹狀結構模型
        • IDAX.PREDICT_DECTREE - 套用決策樹狀結構模型
      • 範例
      • 模型表格資料格式
        • _MODEL 表格
        • _NODES 表格
        • _PREDICATES 表格
        • _COLUMNS 表格
        • _COLUMN_STATISTICS 表格
        • _DISCRETE_STATISTICS 表格
        • _NUMERIC_STATISTICS 表格
    • 診斷測量
      • 用法
      • 函數
        • IDAX.ACC - 計算分類精確度
        • IDAX.CERROR - 計算分類錯誤
        • IDAX.CMATRIX_ACC - 從混淆矩陣中計算分類精確度
        • IDAX.CMATRIX_STATS - 從混淆矩陣中計算分類品質因數
        • IDAX.CMATRIX_WACC - 從混淆矩陣中計算加權分類精確度
        • IDAX.CONFUSION_MATRIX - 建置混淆矩陣
        • IDAX.FMEASURE - 從混淆矩陣中計算 F 測量
        • IDAX.FPR - 從混淆矩陣中計算誤判率
        • IDAX.MAE - 計算迴歸預測的平均值絕對誤差
        • IDAX.MSE - 計算迴歸預測的均方誤差
        • IDAX.PPV - 從混淆矩陣中計算正預測值
        • IDAX.RAE - 計算迴歸預測的相對絕對誤差
        • IDAX.RSE - 計算迴歸預測的相對平方誤差
        • IDAX.TPR - 計算混淆矩陣的真肯定率
        • IDAX.WACC - 計算加權分類精確度
    • 離散化與動差
      • 背景
      • 用法
      • 適用於離散化的函數
        • IDAX.AGGDISC - 聚集離群值及 Bin 中的資料
        • IDAX.APPLY_DISC - 使用離散化 Bin 的限制將資料離散化
        • IDAX.EFDISC - 相等頻率的離散化 Bin
        • IDAX.EMDISC - 最小熵的離散化 Bin
        • IDAX.EWDISC - 等寬的離散化 Bin
        • IDAX.EWDISC_NICE - 具有人性化限制的等寬離散化 Bin
      • 適用於動差的函數
        • IDAX.DROP_SUMMARY1000 - 捨棄 SUMMARY1000 所建立的輸出表格
        • IDAX.KURTOSIS_AGG - 計算超額峰態值
        • IDAX.MOMENTS - 計算直欄的動差
        • IDAX.NUMERIC_SUMMARY - 計算摘要統計資料
        • IDAX.SKEWNESS_AGG - 計算偏斜度值
        • IDAX.SUMMARY1000 - 最多 1000 個直欄的摘要
        • IDAX.SUMMARY1000CHAR - 最多 1000 個字元直欄的摘要
        • IDAX.SUMMARY1000DATE - 最多 1000 個日期直欄的摘要
        • IDAX.SUMMARY1000NUM - 最多 1000 個數值直欄的摘要
        • IDAX.SUMMARY1000TIME - 最多 1000 個時間直欄的摘要
        • IDAX.SUMMARY1000TIMESTAMP - 最多 1000 個時間戳記直欄的摘要
    • K-means 叢集作業
      • 背景
        • 統計資料
      • 用法
      • 函數
        • IDAX.KMEANS - 建置 K-means 叢集作業模型
        • IDAX.PREDICT_KMEANS - 套用 K-means 叢集作業模型
      • 範例
      • 模型表格資料格式
        • _MODEL 表格
        • _CLUSTERS 表格
        • _COLUMNS 表格
        • _COLUMN_STATISTICS 表格
        • _DISCRETE_STATISTICS 表格
        • _NUMERIC_STATISTICS 表格
    • k-最近鄰法 (KNN)
      • 背景
      • 用法
      • 函數
        • IDAX.KNN - 建置 KNN 模型
        • IDAX.PREDICT_KNN - 套用 KNN 模型
      • 範例
      • 模型表格資料格式
        • _MODEL 表格
    • 線性迴歸
      • 背景
      • 用法
      • 函數
        • IDAX.LINEAR_REGRESSION - 建置線性迴歸模型
        • IDAX.PREDICT_LINEAR_REGRESSION - 套用線性迴歸
      • 模型表格資料格式
        • _MODEL 表格
        • _COVARIANCE_MATRIX 表格
    • meta 資料管理
      • 概觀
        • 所需的專用權
      • 模型的命名慣例
        • 模型名稱的長度
        • 模型名稱的唯一性
        • 模型名稱區分大小寫
      • 模型元件的命名慣例
      • 直欄內容
        • 參數中的直欄內容
        • 直欄內容表格中的直欄內容
          • 可用的函數
            • IDAX.COLUMN_PROPERTIES - 建立直欄內容表格
            • IDAX.SET_COLUMN_PROPERTIES - 設定或更新內容
            • IDAX.GET_COLUMN_LIST - 取得直欄清單
      • 函數
        • 模型 meta 資料物件的管理作業
          • 管理作業的儲存程序
            • IDAX.CLEANUP - 捨棄所有 meta 資料物件
            • IDAX.INITIALIZE - 建立資料庫物件
            • IDAX.IS_INITIALIZED - 判定是否建立資料庫物件
        • 基本作業
          • 基本作業的儲存程序
            • IDAX.ALTER_MODEL - 變更模型的內容
            • IDAX.COPY_MODEL - 複製模型
            • IDAX.DROP_MODEL - 捨棄模型
            • IDAX.DROP_ALL_MODELS - 捨棄已選取的模型或所有模型
            • IDAX.MODEL_EXISTS - 判定模型是否存在
            • IDAX.EXPORT_MODEL - 匯出模型
            • IDAX.EXPORT_PMML - 將分析模型匯出為 PMML
            • IDAX.IMPORT_MODEL - 匯入模型
            • IDAX.PMML_MODEL - 建立模型的 PMML 呈現
            • IDAX.PRINT_MODEL - 列印模型
        • 列出作業
          • 清單作業的儲存程序
            • IDAX.LIST_COLPROPS - 列出所選取模型或所有模型的直欄內容
            • IDAX.LIST_COMPONENTS - 列出所選取模型或所有模型的元件
            • IDAX.LIST_MODELS - 列出所選取模型或所有模型
            • IDAX.LIST_PARAMS - 列出所選取模型或所有模型的參數
        • 安全作業
          • 安全作業的儲存程序
            • IDAX.GRANT_MODEL - 授與模型的專用權
            • IDAX.LIST_PRIVILEGES - 列出所有模型的專用權
            • IDAX.REVOKE_MODEL - 撤銷模型的專用權
    • Naive Bayes
      • 背景
        • 支援遺漏值
      • 用法
      • 函數
        • IDAX.NAIVEBAYES - 建置 Naive Bayes 模型
        • IDAX.PREDICT_NAIVEBAYES - 套用 Naive Bayes 模型
      • 範例
      • 模型表格資料格式
        • _MODEL 表格
        • _DISCRANGES 表格
    • 主成分分析 (PCA)
      • 背景
      • 用法
      • 函數
        • IDAX.PCA - 建置 PCA 模型
        • IDAX.PROJECT_PCA - 套用 PCA 模型
      • 範例
      • 模型表格資料格式
        • _META 表格
        • _PCA 表格
        • _PCA_ATTMEAN 表格
        • _PCA_ATTSD 表格
        • _PCA_ATTSD_DIV 表格
        • _PCA_SDEV 表格
        • _PCA_SCORES 表格
    • 機率分佈
      • 背景
      • 用法
      • 函數
        • BERN - 白努利分佈
          • IDAX.DBERN - 白努利分佈的密度
          • IDAX.PBERN - 累積白努利分佈
          • IDAX.PBERN_H - 高尾累積白努利分佈
          • IDAX.QBERN - 反向白努利分佈
          • IDAX.QBERN_H - 高尾反向白努利分佈
        • BETA - beta 分佈
          • IDAX.DBETA - beta 分佈的密度
          • IDAX.PBETA - 累積 beta 分佈
          • IDAX.PBETA_H - 高尾累積 beta 分佈
          • IDAX.QBETA - 反向 beta 分佈
          • IDAX.QBETA_H - 高尾反向 beta 分佈
        • BINOMIAL - 二項式分佈
          • IDAX.DBINOM - 二項式分佈的密度
          • IDAX.PBINOM - 累積二項式分佈
          • IDAX.PBINOM_H - 高尾累積二項式分佈
          • IDAX.QBINOM - 反向二項式分佈
          • IDAX.QBINOM_H - 高尾反向二項式分佈
        • CAUCHY - 柯西分佈
          • IDAX.DCAUCHY - 柯西分佈的密度
          • IDAX.PCAUCHY - 累積柯西分佈
          • IDAX.PCAUCHY_H - 高尾累積柯西分佈
          • IDAX.QCAUCHY - 反向柯西分佈
          • IDAX.QCAUCHY_H - 高尾反向柯西分佈
        • CHISQ - 卡方分佈
          • IDAX.DCHISQ - 卡方分佈的密度
          • IDAX.PCHISQ - 累積卡方分佈
          • IDAX.PCHISQ_H - 高尾累積卡方分佈
          • IDAX.PCHISQ_S - 含有字串引數的累積卡方分佈
          • IDAX.QCHISQ - 反向卡方分佈
          • IDAX.QCHISQ_H - 高尾反向卡方分佈
        • IDAX.DENSITY - 分佈密度
        • EXP - 指數分佈
          • IDAX.DEXP - 指數分佈的密度
          • IDAX.PEXP - 累積指數分佈
          • IDAX.PEXP_H - 高尾累積指數分佈
          • IDAX.QEXP - 反向指數分佈
          • IDAX.QEXP_H - 高尾反向指數分佈
        • F - Fisher 分佈
          • IDAX.DF - Fisher 分佈的密度
          • IDAX.PF - 累積 Fisher 分佈
          • IDAX.PF_H - 高尾累積 Fisher 分佈
          • IDAX.QF - 反向 Fisher 分佈
          • IDAX.QF_H - 高尾反向 Fisher 分佈
        • FISK - Fisk 分佈
          • IDAX.DFISK - Fisk 分佈的密度
          • IDAX.PFISK - 累積 Fisk 分佈
          • IDAX.PFISK_H - 高尾累積 Fisk 分佈
          • IDAX.QFISK - 反向 Fisk 分佈
          • IDAX.QFISK_H - 高尾反向 Fisk 分佈
        • GAMMA - 伽瑪分佈
          • IDAX.DGAMMA - 伽瑪分佈的密度
          • IDAX.PGAMMA - 累積伽瑪分佈
          • IDAX.PGAMMA_H - 高尾累積伽瑪分佈
          • IDAX.QGAMMA - 反向伽瑪分佈
          • IDAX.QGAMMA_H - 高尾反向伽瑪分佈
        • GEOM - 幾何分佈
          • IDAX.DGEOM - 幾何分佈的密度
          • IDAX.PGEOM - 累積幾何分佈
          • IDAX.PGEOM_H - 高尾累積幾何分佈
          • IDAX.QGEOM - 反向幾何分佈
          • IDAX.QGEOM_H - 高尾反向幾何分佈
        • HYPER - 超幾何分佈
          • IDAX.DHYPER - 超幾何分佈的密度
          • IDAX.PHYPER - 累積超幾何分佈
          • IDAX.PHYPER_H - 高尾累積超幾何分佈
          • IDAX.QHYPER - 反向超幾何分佈
          • IDAX.QHYPER_H - 高尾反向超幾何分佈
        • LNORM - 對數常態分佈
          • IDAX.DLNORM - 對數常態分佈的密度
          • IDAX.PLNORM - 累積對數常態分佈
          • IDAX.PLNORM_H - 高尾累積對數常態分佈
          • IDAX.QLNORM - 反向對數常態分佈
          • IDAX.QLNORM_H - 高尾反向對數常態分佈
        • LOGIS - 邏輯分佈
          • IDAX.DLOGIS - 邏輯分佈的密度
          • IDAX.PLOGIS - 累積邏輯分佈
          • IDAX.PLOGIS_H - 高尾累積邏輯分佈
          • IDAX.QLOGIS - 反向邏輯分佈
          • IDAX.QLOGIS_H - 高尾反向邏輯分佈
        • MWW - Mann-Whitney-Wilcoxon 分佈
          • IDAX.DMWW - Mann-Whitney-Wilcoxon 分佈的密度
          • IDAX.PMWW - 累積 Mann-Whitney-Wilcoxon 分佈
          • IDAX.PMWW_H - 高尾累積 Mann-Whitney-Wilcoxon 分佈
          • IDAX.QMWW - 反向 Mann-Whitney-Wilcoxon 分佈
          • IDAX.QMWW_H - 高尾反向 Mann-Whitney-Wilcoxon 分佈
        • NBINOM - 負二項分佈
          • IDAX.DNBINOM - 負二項分佈的密度
          • IDAX.PNBINOM - 累積負二項分佈
          • IDAX.PNBINOM_H - 高尾累積負二項分佈
          • IDAX.QNBINOM - 反向負二項分佈
          • IDAX.QNBINOM_H - 高尾反向負二項分佈
        • NORM - 標準常態分佈
          • IDAX.DNORM - 標準常態分佈的密度
          • IDAX.PNORM - 累積標準常態分佈
          • IDAX.PNORM_H - 高尾累積標準常態分佈
          • IDAX.QNORM - 反向標準常態分佈
          • IDAX.QNORM_H - 高尾反向標準常態分佈
        • NORM3P - 常態分佈
          • IDAX.DNORM3P - 常態分佈的密度
          • IDAX.PNORM3P - 累積常態分佈
          • IDAX.QNORM3P - 反向常態分佈
        • IDAX.PPOINT - 百分比點分佈
        • POIS - 卜瓦松分佈
          • IDAX.DPOIS - 卜瓦松分佈的密度
          • IDAX.PPOIS - 累積卜瓦松分佈
          • IDAX.PPOIS_H - 高尾累積卜瓦松分佈
          • IDAX.QPOIS - 反向卜瓦松分佈
          • IDAX.QPOIS_H - 高尾反向卜瓦松分佈
        • T - t-student 分佈
          • IDAX.DT - t-student 分佈的密度
          • IDAX.PT - 累積 t-student 分佈
          • IDAX.PT_H - 高尾累積 t-student 分佈
          • IDAX.QT - 反向 t-student 分佈
          • IDAX.QT_H - 高尾反向 t-student 分佈
        • UNIF - 均勻分佈
          • IDAX.DUNIF - 均勻分佈的密度
          • IDAX.PUNIF - 累積均勻分佈
          • IDAX.PUNIF_H - 高尾累積均勻分佈
          • IDAX.QUNIF - 反向均勻分佈
          • IDAX.QUNIF_H - 高尾反向均勻分佈
        • WALD - Wald 分佈
          • IDAX.DWALD - Wald 分佈的密度
          • IDAX.PWALD - 累積 Wald 分佈
          • IDAX.PWALD_H - 高尾累積 Wald 分佈
          • IDAX.QWALD - 反向 Wald 分佈
          • IDAX.QWALD_H - 高尾反向 Wald 分佈
        • WEIBULL - Weibull 分佈
          • IDAX.DWEIBULL - Weibull 分佈的密度
          • IDAX.PWEIBULL - 累積 Weibull 分佈
          • IDAX.PWEIBULL_H - 高尾累積 Weibull 分佈
          • IDAX.QWEIBULL - 反向 Weibull 分佈
          • IDAX.QWEIBULL_H - 高尾反向 Weibull 分佈
        • WILCOX - Wilcoxon 分佈
          • IDAX.DWILCOX - Wilcoxon 分佈的密度
          • IDAX.PWILCOX - 累積 Wilcoxon 分佈
          • IDAX.PWILCOX_H - 高尾累積 Wilcoxon 分佈
          • IDAX.QWILCOX - 反向 Wilcoxon 分佈
          • IDAX.QWILCOX_H - 高尾反向 Wilcoxon 分佈
    • 隨機取樣
      • 背景
      • 用法
      • 函數
        • IDAX.RANDOM_SAMPLE - 隨機取樣
    • 迴歸樹
      • 背景
        • 增長
        • 刪改
        • 預測
        • 支援遺漏值
      • 用法
      • 函數
        • IDAX.REGTREE - 建置及刪改迴歸樹模型
        • IDAX.GROW_REGTREE - 建置迴歸樹模型
        • IDAX.PRUNE_REGTREE - 刪改迴歸樹模型
        • IDAX.PREDICT_REGTREE - 套用迴歸樹模型
      • 範例
      • 模型表格資料格式
        • _MODEL 表格
        • _NODES 表格
        • _PREDICATES 表格
        • _COLUMNS 表格
        • _COLUMN_STATISTICS 表格
        • _DISCRETE_STATISTICS 表格
        • _NUMERIC_STATISTICS 表格
    • 序列型樣
      • 背景
      • 用法
      • 函數
        • IDAX.SEQRULES - 建置序列型樣模型
        • IDAX.PRUNE_SEQRULES - 刪改序列型樣
        • IDAX.PREDICT_SEQRULES - 套用序列型樣
      • 範例
      • 模型表格資料格式
        • _ITEMS 表格
        • _ITEMSETS 表格
        • _SEQPATTERNS 表格
        • _SEQPATTERNS_STATISTICS 表格
        • _SEQRULES 表格
    • 統計資料 - 有母數與無母數
      • 背景
      • 用法
      • 函數
        • 有母數統計資料
          • IDAX.CHISQ_TEST_AGG - 皮爾森卡方
          • IDAX.CHISQ_TEST_S_AGG - 皮爾森卡方（具有自由度）
          • IDAX.SPLIT_TEST_S - 將特定傳回字串分割成輸出表格
          • IDAX.T_LS_TEST - 兩個直欄的線性關係的 t-Student 檢定
          • IDAX.T_LS_TEST_S_AGG - 線性相依樣本之間的 t-Student 檢定（字串形式）
          • IDAX.T_ME_TEST - 直欄的預期平均值的 t-Student 檢定
          • IDAX.T_ME_TEST_S_AGG - 變數的預期平均值的 t-Student 檢定（字串形式）
          • IDAX.T_PMD_TEST - 兩個配對直欄之間的預期平均值差異的 t-Student 檢定
          • IDAX.T_TEST_AGG - 分成兩個類別的變數的 t-Student 檢定
          • IDAX.T_TEST_S_AGG - 分成兩個類別的變數的 t-Student 檢定
          • IDAX.T_UMD_TEST - 直欄的類別值之間的預期平均值差異的 t-Student 檢定
        • 無母數統計資料
          • IDAX.CHISQ_TEST - 獨立性的皮爾森卡方檢定
          • IDAX.MWW_TEST - 獨立性的 Mann-Whitney-Wilcoxon 檢定
          • IDAX.SPEARMAN_CORR - Spearman 等級相關性
          • IDAX.WILCOXON_TEST - Wilcoxon 配對樣本差異檢定
  • SQL PL support
    • Inline SQL Procedural Language
    • SQL PL in SQL procedures
    • Inline SQL functions, triggers, and compound SQL statements
    • Error location in the SQLCA structure
    • Anchored data type
      • Features
      • Restrictions
      • Anchored variables
      • Declaring local variables
      • Examples: Anchored data type use
        • Example: Variable declarations of anchored data types
        • Example: Anchored data type use in SQL procedures
    • Row data types
      • Features
      • Restrictions
      • Row variables
      • Creating row variables
        • Creating a row data type
        • Declaring local variables
      • Assigning values to variables
        • Supported value assignments
        • Using the SET statement
        • Using SELECT INTO, VALUES, or FETCH statements
      • Comparing row variables and row field values
      • Referencing row values
        • Referencing row variables
        • Referencing row fields
        • Referencing row variables in INSERT statements
      • Passing rows as routine parameters
      • Dropping a row data type
      • Examples: Row data type use
        • Example: Row data type use in a CLP script
        • Example: Row data type use in an SQL procedure
        • Example: Row data type use in an SQL function
    • Array data types
      • Comparison of arrays and associative arrays
      • Ordinary array data type
        • Features
        • Restrictions
        • Array variables
        • Creating array variables
          • Creating an array data type (CREATE TYPE statement)
          • Declaring local variables
        • Assigning array values
          • Assigning array values using the subindex and literal values
        • Retrieving array values
          • Retrieving array values using an index
          • Retrieving the number of array elements
          • Retrieving the first and last array elements
          • Retrieving the next and previous array elements
        • Trimming the array (TRIM_ARRAY function)
        • Deleting an array element (ARRAY_DELETE)
        • Determining if an array element exists
        • Array support in SQL procedures
      • Associative array data type
        • Features of associative arrays
        • Restrictions on associative array data types
        • Creating an associative array data type
        • Declaring associative array data type variables
        • Assigning values to arrays using array indices and literal values
    • Cursor data types
      • Overview
        • Types
        • Restrictions on use
        • Privileges related to use
      • Cursor variables
      • Cursor attributes
      • Creating cursor variables
        • Creating cursor data types
        • Declaring local variables of type cursor
      • Assigning values to cursor variables
      • Referencing cursor variables
      • Determining the number of fetched rows for a cursor
      • Example: Cursor variable use
        • Cursor variable use within an SQL procedure
    • SQL routines
      • Overview of SQL routines
        • SQL routine CREATE statements
        • Determining when to use SQL routines or external routines
        • Determining when to use SQL procedures or SQL functions
        • Determining when to use SQL routines or dynamically prepared compound SQL statements
        • Rewriting SQL procedures as SQL functions
      • SQL procedures
        • Features of SQL procedures
        • Designing SQL procedures
          • Parts of SQL procedures
          • Structure of SQL procedures
          • Parameters
          • Parameter markers
          • Variables
          • SQLCODE and SQLSTATE variables
          • Compound statements and scope of variables in SQL procedures
          • Cursors
          • Control flow statements in SQL procedures
            • Variable related statements
            • Conditional statements
              • CASE statement in SQL procedures
              • IF statement in SQL procedures
            • Looping statements
              • FOR statement in SQL procedures
              • LOOP statement in SQL procedures
              • WHILE statement in SQL procedures
              • REPEAT statement in SQL procedures
            • Transfer of control statements in SQL procedures
              • GOTO statement in SQL procedures
              • ITERATE statement in SQL procedures
              • LEAVE statement in SQL procedures
              • RETURN statement in SQL procedures
            • Condition handlers
          • Returning result sets from SQL procedures
          • Receiving procedure result sets in SQL routines
        • Creating SQL procedures
          • Creating SQL procedures from the command line processor
          • Customizing precompile and bind options for compiled SQL objects
        • Improving the performance of SQL procedures
      • SQL functions
        • Features of SQL functions
        • Designing SQL functions
          • Inlined SQL functions and compiled SQL functions
          • Restrictions on SQL functions
        • Creating SQL scalar functions
        • Creating SQL table functions
    • Compound statements
      • Creating compound statements
  • PL/SQL support
    • PL/SQL features
    • Creating PL/SQL procedures and functions from a CLP script
    • Restrictions on PL/SQL support
    • PL/SQL sample schema
    • Obfuscation
    • Blocks (PL/SQL)
      • Anonymous block statement (PL/SQL)
    • Procedures (PL/SQL)
      • CREATE PROCEDURE statement (PL/SQL)
      • Procedure references (PL/SQL)
      • Function invocation syntax support (PL/SQL)
    • Functions (PL/SQL)
      • CREATE FUNCTION statement (PL/SQL)
      • Function references (PL/SQL)
    • Collection, record, and object types (PL/SQL)
      • VARRAY collection type declaration (PL/SQL)
      • CREATE TYPE (VARRAY) statement (PL/SQL)
      • CREATE TYPE (Nested table) statement (PL/SQL)
      • Records (PL/SQL)
      • CREATE TYPE (Object) statement (PL/SQL)
      • Associative arrays (PL/SQL)
      • Collection methods (PL/SQL)
    • Variables (PL/SQL)
      • Variable declarations (PL/SQL)
      • Parameter modes (PL/SQL)
      • Data types (PL/SQL)
      • %TYPE attribute in variable declarations (PL/SQL)
      • SUBTYPE definitions (PL/SQL)
      • %ROWTYPE attribute in record type declarations (PL/SQL)
    • Basic statements (PL/SQL)
      • NULL statement (PL/SQL)
      • Assignment statement (PL/SQL)
      • EXECUTE IMMEDIATE statement (PL/SQL)
      • SQL statements (PL/SQL)
      • BULK COLLECT INTO clause (PL/SQL)
      • RETURNING INTO clause (PL/SQL)
      • Statement attributes (PL/SQL)
    • Control statements (PL/SQL)
      • IF statement (PL/SQL)
      • CASE statement (PL/SQL)
        • Simple CASE statement (PL/SQL)
        • Searched CASE statement (PL/SQL)
      • Loops (PL/SQL)
        • FOR (cursor variant) statement (PL/SQL)
        • FOR (integer variant) statement (PL/SQL)
        • FORALL statement (PL/SQL)
        • EXIT statement (PL/SQL)
        • LOOP statement (PL/SQL)
        • WHILE statement (PL/SQL)
        • CONTINUE statement (PL/SQL)
      • Exception handling (PL/SQL)
      • Raise application error (PL/SQL)
      • RAISE statement (PL/SQL)
      • Oracle-IBM Db2 on Cloud, IBM Db2 Warehouse on Cloud, and IBM Db2 Warehouse error mapping (PL/SQL)
    • Cursors (PL/SQL)
      • Static cursors (PL/SQL)
        • Parameterized cursors (PL/SQL)
        • Opening a cursor (PL/SQL)
        • Fetching rows from a cursor (PL/SQL)
        • Closing a cursor (PL/SQL)
        • Using %ROWTYPE with cursors (PL/SQL)
        • Cursor attributes (PL/SQL)
      • Cursor variables (PL/SQL)
        • SYS_REFCURSOR cursor variables (PL/SQL)
        • User-defined REF CURSOR type variables (PL/SQL)
        • Dynamic queries with cursor variables (PL/SQL)
        • Example: Returning a REF CURSOR from a procedure (PL/SQL)
        • Example: Modularizing cursor operations (PL/SQL)
    • Triggers (PL/SQL)
      • Types of triggers (PL/SQL)
      • Trigger variables (PL/SQL)
      • Trigger event predicates (PL/SQL)
      • Transactions and exceptions (PL/SQL)
      • CREATE TRIGGER statement (PL/SQL)
      • Dropping triggers (PL/SQL)
      • Examples: Triggers (PL/SQL)
    • Packages (PL/SQL)
      • Package components (PL/SQL)
      • Creating packages (PL/SQL)
        • Creating package specifications (PL/SQL)
        • CREATE PACKAGE statement (PL/SQL)
        • Creating the package body (PL/SQL)
        • CREATE PACKAGE BODY statement (PL/SQL)
      • Referencing package objects (PL/SQL)
        • Packages with user-defined types (PL/SQL)
      • Dropping packages (PL/SQL)
  • Modules
    • Features of modules
    • Uses of modules
    • Restrictions on modules
    • Creating modules
      • Creating objects in modules
      • Adding implementations for routine prototypes in a module
      • Initialization of modules using the SYS_INIT procedure
    • Granting and revoking privileges on modules
    • Dropping modules
      • Dropping objects in a module
    • Referencing objects defined in modules
    • Built-in modules
      • DBMS_ALERT module
        • REGISTER procedure - register to receive a specified alert
        • REMOVE procedure - remove registration for a specified alert
        • REMOVEALL procedure - remove registration for all alerts
        • SET_DEFAULTS procedure - set the polling interval for WAITONE and WAITANY
        • SIGNAL procedure - signal occurrence of a specified alert
        • WAITANY procedure - wait for any registered alerts
        • WAITONE procedure - wait for a specified alert
      • DBMS_APPLICATION_INFO module
        • READ_CLIENT_INFO procedure - read and return client information
        • READ_MODULE procedure - read and return module name
        • SET_CLIENT_INFO procedure - set and register client information
        • SET_MODULE procedure - set and register module name
        • SET_ACTION procedure - set and register module action name
        • SET_SESSION_LONGOPS procedure - set and register progress of long operations
      • DBMS_DDL module
        • WRAP function
        • CREATE_WRAPPED procedure
      • DBMS_JOB module
        • BROKEN procedure - set the state of a job to either broken or not broken
        • CHANGE procedure - modify job attributes
        • INTERVAL procedure - set run frequency
        • NEXT_DATE procedure - set the date and time when a job is run
        • REMOVE procedure - delete the job definition from the database
        • RUN procedure - force a broken job to run
        • SUBMIT procedure - create a job definition and store it in the database
        • WHAT procedure - change the SQL statement run by a job
      • DBMS_LOB module
        • APPEND procedures - append one large object to another
        • CLOSE procedures - close an open large object
        • COMPARE function - compare two large objects
        • CONVERTTOBLOB procedure - convert character data to binary
        • CONVERTTOCLOB procedure - convert binary data to character
        • COPY procedures - copy one large object to another
        • ERASE procedures - erase a portion of a large object
        • GET_STORAGE_LIMIT function - return the limit on the largest allowable large object
        • GETLENGTH function - return the length of the large object
        • INSTR function - return the location of the nth occurrence of a given pattern
        • ISOPEN function - test if the large object is open
        • OPEN procedures - open a large object
        • READ procedures - read a portion of a large object
        • SUBSTR function - return a portion of a large object
        • TRIM procedures - truncate a large object to the specified length
        • WRITE procedures - write data to a large object
        • WRITEAPPEND procedures - append data to the end of a large object
      • DBMS_LOCK module
        • ALLOATE_UNIQUE procedure - allocates unique lock handle for specified lock name
        • CONVERT function - converts the lock mode of an acquired lock
        • RELEASE function - releases an acquired lock
        • REQUEST function - requests a lock based on the lock ID or lock handle
        • SLEEP procedure - suspends execution of current session for specified duration
      • DBMS_OUTPUT module
        • DISABLE procedure - disable the message buffer
        • ENABLE procedure - enable the message buffer
        • GET_LINE procedure - get a line from the message buffer
        • GET_LINES procedure - get multiple lines from the message buffer
        • NEW_LINE procedure - put an end-of-line character sequence in the message buffer
        • PUT procedure - put a partial line in the message buffer
        • PUT_LINE procedure - put a complete line in the message buffer
      • DBMS_PIPE module
        • CREATE_PIPE function - create a pipe
        • NEXT_ITEM_TYPE function - return the data type code of the next item
        • PACK_MESSAGE function - put a data item in the local message buffer
        • PACK_MESSAGE_RAW procedure - put a data item of type RAW in the local message buffer
        • PURGE procedure - remove unreceived messages from a pipe
        • RECEIVE_MESSAGE function - get a message from a specified pipe
        • REMOVE_PIPE function - delete a pipe
        • RESET_BUFFER procedure - reset the local message buffer
        • SEND_MESSAGE procedure - send a message to a specified pipe
        • UNIQUE_SESSION_NAME function - return a unique session name
        • UNPACK_MESSAGE procedures - get a data item from the local message buffer
      • DBMS_RANDOM module
        • SEED procedure
        • SEED_STRING procedure
        • INITIALIZE procedure
        • TERMINATE procedure
        • RANDOM function
        • VALUE function
        • STRING function
        • NORMAL function
      • DBMS_SQL module
        • BIND_VARIABLE_BLOB procedure - bind a BLOB value to a variable
        • BIND_VARIABLE_CHAR procedure - bind a CHAR value to a variable
        • BIND_VARIABLE_CLOB procedure - bind a CLOB value to a variable
        • BIND_VARIABLE_DATE procedure - bind a DATE value to a variable
        • BIND_VARIABLE_DOUBLE procedure - bind a DOUBLE value to a variable
        • BIND_VARIABLE_INT procedure - bind an INTEGER value to a variable
        • BIND_VARIABLE_NUMBER procedure - bind a NUMBER value to a variable
        • BIND_VARIABLE_RAW procedure - bind a RAW value to a variable
        • BIND_VARIABLE_TIMESTAMP procedure - bind a TIMESTAMP value to a variable
        • BIND_VARIABLE_VARCHAR procedure - bind a VARCHAR value to a variable
        • CLOSE_CURSOR procedure - close a cursor
        • COLUMN_VALUE_BLOB procedure - return a BLOB column value into a variable
        • COLUMN_VALUE_CHAR procedure - return a CHAR column value into a variable
        • COLUMN_VALUE_CLOB procedure - return a CLOB column value into a variable
        • COLUMN_VALUE_DATE procedure - return a DATE column value into a variable
        • COLUMN_VALUE_DOUBLE procedure - return a DOUBLE column value into a variable
        • COLUMN_VALUE_INT procedure - return an INTEGER column value into a variable
        • COLUMN_VALUE_LONG procedure - return a LONG column value into a variable
        • COLUMN_VALUE_NUMBER procedure - return a DECFLOAT column value into a variable
        • COLUMN_VALUE_RAW procedure - return a RAW column value into a variable
        • COLUMN_VALUE_TIMESTAMP procedure - return a TIMESTAMP column value into a variable
        • COLUMN_VALUE_VARCHAR procedure - return a VARCHAR column value into a variable
        • DEFINE_COLUMN_BLOB procedure - define a BLOB column in the SELECT list
        • DEFINE_COLUMN_CHAR procedure - define a CHAR column in the SELECT list
        • DEFINE_COLUMN_CLOB procedure - define a CLOB column in the SELECT list
        • DEFINE_COLUMN_DATE procedure - define a DATE column in the SELECT list
        • DEFINE_COLUMN_DOUBLE procedure - define a DOUBLE column in the SELECT list
        • DEFINE_COLUMN_INT procedure - define an INTEGER column in the SELECT list
        • DEFINE_COLUMN_LONG procedure - define a LONG column in the SELECT list
        • DEFINE_COLUMN_NUMBER procedure - define a DECFLOAT column in the SELECT list
        • DEFINE_COLUMN_RAW procedure - define a RAW column or expression in the SELECT list
        • DEFINE_COLUMN_TIMESTAMP procedure - define a TIMESTAMP column in the SELECT list
        • DEFINE_COLUMN_VARCHAR procedure - define a VARCHAR column in the SELECT list
        • DESCRIBE_COLUMNS procedure - retrieve a description of the columns in a SELECT list
        • DESCRIBE_COLUMNS2 procedure - retrieve a description of the columns in a SELECT list
        • EXECUTE procedure - run a parsed SQL statement
        • EXECUTE_AND_FETCH procedure - run a parsed SELECT command and fetch one row
        • FETCH_ROWS procedure - retrieve a row from a cursor
        • IS_OPEN function - Check whether a cursor is open
        • IS_OPEN procedure - Check whether a cursor is open
        • LAST_ROW_COUNT procedure - return the cumulative number of rows fetched
        • OPEN_CURSOR procedure - open a cursor
        • PARSE procedure - parse an SQL statement
        • VARIABLE_VALUE_BLOB procedure - return the value of a BLOB INOUT or OUT parameter.
        • VARIABLE_VALUE_CHAR procedure - return the value of a CHAR INOUT or OUT parameter
        • VARIABLE_VALUE_CLOB procedure - return the value of a CLOB INOUT or OUT parameter
        • VARIABLE_VALUE_DATE procedure - return the value of a DATE INOUT or OUT parameter
        • VARIABLE_VALUE_DOUBLE procedure - return the value of a DOUBLE INOUT or OUT parameter
        • VARIABLE_VALUE_INT procedure - return the value of an INTEGER INOUT or OUT parameter
        • VARIABLE_VALUE_NUMBER procedure - return the value of a DECFLOAT INOUT or OUT parameter
        • VARIABLE_VALUE_RAW procedure - return the value of a BLOB(32767) INOUT or OUT parameter
        • VARIABLE_VALUE_TIMESTAMP procedure - return the value of a TIMESTAMP INOUT or OUT parameter
        • VARIABLE_VALUE_VARCHAR procedure - return the value of a VARCHAR INOUT or OUT parameter
      • DBMS_UTILITY module
        • ANALYZE_DATABASE procedure - gather statistics on tables, clusters, and indexes
        • ANALYZE_PART_OBJECT procedure - gather statistics on a partitioned table or partitioned index
        • ANALYZE_SCHEMA procedure - gather statistics on schema tables, clusters, and indexes
        • CANONICALIZE procedure - canonicalize a string
        • COMMA_TO_TABLE procedures - convert a comma-delimited list of names into a table of names
        • COMPILE_SCHEMA procedure - compile all functions, procedures, triggers, and packages in a schema
        • DB_VERSION procedure - retrieve the database version
        • EXEC_DDL_STATEMENT procedure - run a DDL statement
        • FORMAT_CALL_STACK function - return a description of the current call stack
        • FORMAT_ERROR_BACKTRACE function - return a description of the call stack at time of most recent error
        • GET_CPU_TIME function - retrieve the current CPU time
        • GET_DEPENDENCY procedure - list objects dependent on the specified object
        • GET_HASH_VALUE function - compute a hash value for a given string
        • GET_TIME function - return the current time
        • NAME_RESOLVE procedure - obtain the schema and other membership information for a database object
        • NAME_TOKENIZE procedure - parse the given name into its component parts
        • TABLE_TO_COMMA procedures - convert a table of names into a comma-delimited list of names
        • VALIDATE procedure - change an invalid routine into a valid routine
      • MONREPORT module
        • CONNECTION procedure - Generate a report on connection metrics
        • CURRENTAPPS procedure- Generate a report of point-in-time application processing metrics
        • CURRENTSQL procedure - Generate a report that summarizes activities
        • DBSUMMARY procedure - Generate a summary report of system and application performance metrics
        • LOCKWAIT procedure - Generate a report of current lock waits
        • PKGCACHE procedure - Generate a summary report of package cache metrics
      • UTL_DIR module
        • CREATE_DIRECTORY procedure - create a directory alias
        • CREATE_OR_REPLACE_DIRECTORY procedure - create or replace a directory alias
        • DROP_DIRECTORY procedure - drop a directory alias
        • GET_DIRECTORY_PATH procedure - get the path for a directory alias
      • UTL_FILE module
        • FCLOSE procedure - close an open file
        • FCLOSE_ALL procedure - close all open files
        • FCOPY procedure - copy text from one file to another
        • FFLUSH procedure - flush unwritten data to a file
        • FOPEN function - open a file
        • FREMOVE procedure - remove a file
        • FRENAME procedure - rename a file
        • GET_LINE procedure
        • IS_OPEN function - determine whether a specified file is open
        • NEW_LINE procedure - write an end-of-line character sequence to a file
        • PUT procedure - write a string to a file
        • PUT_LINE procedure - write a single line to a file
        • PUTF procedure - write a formatted string to a file
        • UTL_FILE.FILE_TYPE
      • UTL_MAIL module
        • SEND procedure - send an e-mail to an SMTP server
        • SEND_ATTACH_RAW procedure - send an e-mail with a BLOB attachment
        • SEND_ATTACH_VARCHAR2 procedure - send an e-mail with a VARCHAR attachment
      • UTL_SMTP module
        • CLOSE_DATA procedure - end an e-mail message
        • COMMAND procedure - run an SMTP command
        • COMMAND_REPLIES procedure - run an SMTP command with multiple reply lines
        • DATA procedure - specify the body of an e-mail message
        • EHLO procedure - perform initial handshaking with an SMTP server and return extended information
        • HELO procedure - perform initial handshaking with an SMTP server
        • HELP procedure - send the HELP command
        • MAIL procedure - start a mail transaction
        • NOOP procedure - send the null command
        • OPEN_CONNECTION function - return a connection handle to an SMTP server
        • OPEN_CONNECTION procedure - open a connection to an SMTP server
        • OPEN_DATA procedure - send the DATA command to the SMTP server
        • QUIT procedure - close the session with the SMTP server
        • RCPT procedure - provide the e-mail address of the recipient
        • RSET procedure - end the current mail transaction
        • VRFY procedure - validate and verify the recipient's e-mail address
        • WRITE_DATA procedure - write a portion of an e-mail message
        • WRITE_RAW_DATA procedure - add RAW data to an e-mail message
  • Database monitoring
    • Interfaces for database monitoring
      • Built-in administrative routines and views for monitoring
        • Monitoring request information using table functions
        • Monitoring activities using table functions
        • Monitoring data objects using table functions
          • Object usage
            • Identifying statements that affect a table
            • Identifying how a statement affects database objects
        • Monitoring locking using table functions
        • Monitoring the overall system by using table functions
        • Monitoring routines using table functions
          • Example: Identifying the most expensive routines by CPU consumption
          • Example: Listing the time taken by statements executed by a routine
          • Example: Investigating high CPU consumption by a routine
          • Example: Listing aggregate routine metrics for an anonymous block
          • Example: Retrieving statement text for a routine
        • Other monitoring table functions
        • Interfaces that return monitor data in XML documents
          • Interfaces for viewing XML monitor information as formatted text
            • Viewing metrics monitor elements from XML documents as rows in a table
        • Identifying costly applications
        • Monitoring buffer pool efficiency
      • Event monitors
        • Types of events for which event monitors capture data
        • Working with event monitors
          • Creating event monitors
            • Output options for event monitors
            • Event monitors that write to tables
              • Creating event monitors that write to tables
              • Event monitor logical data groups and monitor elements
              • Target tables, control tables, and event monitor table management
              • Logical data groups and event monitor output tables
            • Event monitors that write to unformatted event tables
              • Unformatted event table column definitions
              • Differences between regular and UE table output
            • Creating a file event monitor
              • Event monitor file management
            • Creating a pipe event monitor
              • Event monitor named pipe management
            • Write-to-table and file event monitor buffering
            • Event monitor self-describing data stream
            • Event type mappings to logical data groups
          • Displaying a list of event monitors created in your database
          • Displaying a list of active event monitors in your database
          • Event monitors for partitioned databases
          • Enabling event monitor data collection
          • Methods for accessing event monitor information
            • Accessing event monitor data in regular tables
            • Methods for accessing information in unformatted event tables
              • db2evmonfmt tool for reading event monitor data
              • Routines for extracting data from unformatted event tables
              • Pruning data from UE tables
            • Formatting file or pipe event monitor output from a command line
          • Altering an event monitor
        • Lock and deadlock event monitoring
          • Data generated by locking event monitors
            • Information written to tables for a locking event monitor
            • Information written to relational tables by EVMON_FORMAT_UE_TO_TABLES for a locking event monitor
            • Information written to XML by EVMON_FORMAT_UE_TO_XML for a locking event monitor
          • Collecting lock event data and generating reports
        • Unit of work event monitoring
          • Data generated by unit of work event monitors
            • Information written to tables for a unit of work event monitor
            • Information written to relational tables by EVMON_FORMAT_UE_TO_TABLES for a unit of work event monitor
            • Information written to XML by EVMON_FORMAT_UE_TO_XML for a unit of work event monitor
            • Package listing information
            • Executable list information
          • Collecting unit of work event data and generating reports
            • Example: Calculating the CPU time used by different workloads or applications
        • Package cache statement eviction event monitoring
          • Data generated by package cache event monitors
            • Information written to tables for a package cache event monitor
            • Information written to relational tables by EVMON_FORMAT_UE_TO_TABLES for a package cache event monitor
            • Information written to XML for a package cache event monitor
          • Collecting package cache event data and generating reports
            • Example: Using package cache information to identify statements that are candidates for performance tuning
        • Activity event monitoring
          • Creating an activity event monitor
          • Configuring data collection for an activities event monitor
          • Data generated by activities event monitors
            • Information written to tables for an activities event monitor
          • Accessing event information written by an activity event monitor to a table
          • Example: Capturing activity information related to the execution of a specific statement
        • Statistics event monitoring
          • Data generated by statistics event monitors
            • Information written to tables for a statistics event monitor
            • Information written to XML for system_metrics and activity_metrics monitor elements
        • Data generated by database event monitors
          • Information written to tables for a database event monitor
        • Data generated by threshold violation event monitors
          • Information written to tables for a threshold violation event monitor
        • Data generated by statement event monitors
          • Information written to tables for a statement event monitor
        • Data generated by table event monitors
          • Information written to tables for a table event monitor
        • Data generated by buffer pool event monitors
          • Information written to tables for a buffer pool event monitor
        • Data generated by table space event monitors
          • Information written to tables for a table space event monitor
        • Data generated by connections event monitors
          • Information written to tables for a connections event monitor
        • Data generated by transaction event monitors
          • Information written to tables for a transaction event monitor
        • Data generated by deadlock event monitors
          • Information written to tables for a deadlock event monitor
        • Change history event monitoring
          • Data generated by change history event monitors
            • CHANGESUMMARY
            • DBDBMCFG
            • REGVAR
            • DDLSTMTEXEC
            • TXNCOMPLETION
            • EVMONSTART
            • UTILSTART
            • UTILLOCATION
            • UTILSTOP
            • UTILPHASE
          • Monitoring utility history
          • Collecting change history event data
            • Example: Investigating an increase in lock escalations
            • Example: Identifying configuration changes and utility executions
            • Example: Listing LOAD operations
            • Example: Reporting the history of utility execution
            • Example: Listing all committed DDL statements
            • Example: Listing changes performed by the STMM using the change history event monitor
        • Event monitor data retention from release to release
      • Reports generated using the MONREPORT module
      • Determining the date a database object was last used
    • Monitor elements
      • Request monitor elements
        • Activity monitor elements
      • Data object monitor elements
      • Monitor element collection levels
      • Time-spent monitor elements
        • Time-spent monitor element hierarchy
        • Wait times for FCM communications
        • Retrieving and working with time-spent monitor element data
          • Seeing where time is spent across the system
          • Determining where time is spent during SQL statement execution
      • Logical data groups overview
        • Event monitor logical data groups and monitor elements
        • Event type mappings to logical data groups
        • Logical data groups affected by COLLECT ACTIVITY DATA settings
        • Snapshot monitor interface mappings to logical data groups
        • Snapshot monitor logical data groups and monitor elements
      • Monitor element reference
        • A
          • acc_curs_blk - Accepted block cursor requests
          • act_aborted_total - Total aborted activities
          • act_completed_total - Total completed activities
          • act_cpu_time_top - Activity CPU time top
          • act_exec_time - Activity execution time
          • act_rejected_total - Total rejected activities
          • act_remapped_in - Activities remapped in
          • act_remapped_out - Activities remapped out
          • act_rows_read_top - Activity rows read top
          • act_rqsts_total - Total activity requests
          • act_throughput - Activity throughput
          • act_top - The peak activity count
          • act_total - Activities total
          • activate_timestamp - Activate timestamp
          • active_col_vector_consumers - Active columnar vector consumers
          • active_col_vector_consumers_top - Active columnar vector memory consumers high watermark
          • active_hash_grpbys - Active hash GROUP BY operations
          • active_hash_grpbys_top - Active hash GROUP BY operations high watermark
          • active_hash_joins - Active hash joins
          • active_hash_joins_top - Active hash join operations high watermark
          • active_olap_funcs - Active OLAP functions
          • active_olap_funcs_top - Active OLAP function operations high watermark
          • active_peas - Active partial early aggregation operations
          • active_peas_top - Active partial early aggregation operations high watermark
          • active_peds - Active partial early distinct operations
          • active_peds_top - Active partial early distinct operations high watermark
          • active_sort_consumers - Active sort memory consumers
          • active_sort_consumers_top - Active sort consumers high watermark
          • active_sorts - Active sorts
          • active_sorts_top - Active sorts high watermark
          • activity_collected - Activity collected
          • activity_id - Activity ID
          • activity_secondary_id - Activity secondary ID
          • activity_state - Activity state
          • activity_type - Activity type
          • activitytotalruntime_threshold_id - Activity total runtime threshold ID
          • activitytotalruntime_threshold_value - Activity total runtime threshold value
          • activitytotalruntime_threshold_violated - Activity total runtime threshold violated
          • activitytotalruntimeinallsc_threshold_id - Activity total runtime in all service classes threshold ID
          • activitytotalruntimeinallsc_threshold_value - Activity total runtime in all service classes threshold value
          • activitytotalruntimeinallsc_threshold_violated - Activity total runtime in all service classes threshold violated
          • activitytotaltime_threshold_id - Activity total time threshold ID
          • activitytotaltime_threshold_value - Activity total time threshold value
          • actual_parallelism - The actual parallelism
          • actual_parallelism_avg - The average parallelism
          • actual_parallelism_top - The peak parallelism
          • adapter_name - Adapter name
          • address - IP address from which the connection was initiated
          • adm_resource_actuals - Query uses WLM admission control resource actuals
          • adm_resource_actuals - admission control resource actuals monitor element
          • adm_bypassed - Admission control bypassed
          • adm_bypass_act_total - Number of times admission control was bypassed
          • adm_bypassed_act_load - Load of activities that bypass the adaptive workload manager monitor element
          • adm_bypassed_act_time - Total time spent running activities that bypass adaptive workload manager monitor element
          • adm_overflows - Number of times an activity fit as an overflow
          • adm_queue_position - Admission queue position monitor element
          • adm_queue_entry_time - Admission queue entry time monitor element
          • adm_queued_act_load - Load of queued activities controlled by adaptive workload management monitor element
          • adm_queued_act_time - Total time spent queued activities controlled by adaptive workload manager monitor element
          • adm_running_act_load - Load of running activities controlled by adaptive workload management monitor element
          • adm_running_act_time - Total time spent running activities controlled by the adaptive workload manager monitor element
          • agent_id - Application handle (agent ID)
          • agent_id_holding_lock - Agent ID holding lock
          • agent_load_trgt_demand - Estimated agent load target demand monitor element
          • agent_load_trgt_demand_avg - Average estimated agent load target demand monitor element
          • agent_load_trgt_demand_top - Peak estimated agent load target demand monitor element
          • agent_load_trgt_utilization_avg - The average load utilization
          • agent_load_trgt_utilization_top - The peak load utilization
          • agent_load_trgt_utilization - Agent load utilization
          • agent_pid - Engine dispatchable unit (EDU) identifier
          • agent_status - DCS application agents
          • agent_sys_cpu_time - System CPU time used by agent
          • agent_tid - Agent thread ID
          • agent_usr_cpu_time - User CPU time used by agent
          • agent_wait_time - Agent wait time
          • agent_waits_total - Total agent waits
          • agents_created_empty_pool - Agents created due to empty agent pool
          • agents_from_pool - Agents assigned from pool
          • agents_registered - Agents registered
          • agents_registered_top - Maximum number of agents registered
          • agents_stolen - Stolen agents
          • agents_top - Number of agents created
          • agents_waiting_on_token - Agents waiting for a token
          • agents_waiting_top - Maximum number of agents waiting
          • agg_temp_tablespace_top - Aggregate temporary table space top
          • aggsqltempspace_threshold_id - Aggregate SQL temporary space threshold ID
          • aggsqltempspace_threshold_value - AggSQL temporary space threshold value
          • aggsqltempspace_threshold_violated - AggSQL temporary space threshold violated
          • app_act_aborted_total - Total failed external coordinator activities
          • app_act_completed_total - Total successful external coordinator activities
          • app_act_rejected_total - Total rejected external coordinator activities
          • app_rqsts_completed_total - Total application requests completed
          • appl_action - Application action
          • appl_con_time - Connection request start timestamp
          • appl_id - Application ID
          • appl_id_holding_lk - Application ID holding lock
          • appl_id_oldest_xact - Application with oldest transaction
          • appl_idle_time - Application idle time
          • appl_name - Application name
          • appl_priority - Application agent priority
          • appl_priority_type - Application priority type
          • appl_section_inserts - Section inserts
          • appl_section_lookups - Section lookups
          • appl_status - Application status
          • application_handle - Application handle
          • appls_cur_cons - Applications connected currently
          • appls_in_db2 - Applications executing in the database currently
          • arm_correlator - Application response measurement correlator
          • associated_agents_top - Maximum number of associated agents
          • async_runstats - Total number of asynchronous RUNSTATS requests
          • audit_events_total - Total audit events
          • audit_file_write_wait_time - Audit file write wait time
          • audit_file_writes_total - Total audit files written
          • audit_subsystem_wait_time - Audit subsystem wait time
          • audit_subsystem_waits_total - Total audit subsystem waits
          • auth_id - Authorization ID
          • authority_bitmap - User authorization level
          • authority_lvl - User authorization level
          • auto_storage_hybrid - Hybrid automatic storage table space indicator
          • automatic - Buffer pool automatic
        • B
          • backup_timestamp - Backup timestamp
          • bin_id - Histogram bin identifier
          • binds_precompiles - Binds/precompiles attempted
          • block_ios - Number of block I/O requests
          • blocking_cursor - Blocking cursor
          • blocks_pending_cleanup - Pending cleanup rolled-out blocks
          • bottom - Histogram bin bottom
          • boundary_leaf_node_splits - Boundary leaf node splits
          • bp_cur_buffsz - Current size of buffer pool
          • bp_id - Buffer pool identifier
          • bp_name - Buffer pool name
          • bp_new_buffsz - New buffer pool size
          • bp_pages_left_to_remove - Number of pages left to remove
          • bp_tbsp_use_count - Number of table spaces mapped to buffer pool
          • buff_auto_tuning - FCM buffer auto-tuning indicator
          • buff_free - FCM buffers currently free
          • buff_free_bottom - Minimum FCM Buffers Free
          • buff_max - Maximum possible number of FCM buffers
          • buff_total - Number of currently allocated FCM buffers
          • byte_order - Byte order of event data
          • bytes_total - Total number of bytes
        • C
          • cached_timestamp - Cached timestamp
          • caching_tier - Caching tier enabled
          • caching_tier_direct_reads - Direct reads from caching tier
          • caching_tier_direct_read_reqs - Direct read requests from caching tier
          • caching_tier_direct_read_time - Direct read time from caching tier
          • caching_tier_page_read_time - Caching tier page read time
          • caching_tier_write_bytes - Bytes for write requests to local cache
          • caching_tier_write_reqs - Write requests to local cache
          • caching_tier_write_time - Elapsed time for writes to local cache
          • call_sql_stmts - CALL SQL statements executed monitor element
          • call_stmt_routine_id - Call statement routine identifier
          • call_stmt_subroutine_id - Call statement subroutine identifier
          • cat_cache_heap_full - Catalog cache heap full
          • cat_cache_inserts - Catalog cache inserts
          • cat_cache_lookups - Catalog cache lookups
          • cat_cache_overflows - Catalog cache overflows
          • cat_cache_size_top - Catalog cache high watermark
          • catalog_node - Catalog node number
          • catalog_node_name - Catalog node network name
          • cf_wait_time - cluster caching facility wait time
          • cf_waits - Number of cluster caching facility waits
          • cfg_collection_type - Configuration collection type
          • cfg_name - Configuration name
          • cfg_old_value - Configuration old value
          • cfg_old_value_flags - Configuration old value flags
          • cfg_value - Configuration value
          • cfg_value_flags - Configuration value flags
          • ch_auto_tuning - FCM channel auto-tuning indicator
          • ch_free - Channels Currently Free
          • ch_free_bottom - Minimum Channels Free
          • ch_max - Maximum possible number of FCM channels
          • ch_total - Number of currently allocated FCM channels
          • client_acctng - Client accounting string
          • client_applname - Client application name
          • client_db_alias - Database alias used by application
          • client_hostname - Client hostname
          • client_idle_wait_time - Client idle wait time
          • client_ipaddr - Client IP address
          • client_nname - Client name
          • client_pid - Client process ID
          • client_platform - Client operating platform
          • client_port_number - Client port number
          • client_prdid - Client product and version ID
          • client_protocol - Client communication protocol
          • client_userid - Client user ID
          • client_wrkstnname - Client workstation name
          • codepage_id - ID of code page used by application
          • col_object_l_pages - Column-organized logical pages
          • col_object_l_size - Column-organized data object logical size
          • col_object_p_size - Column-organized data object physical size
          • col_synopsis_rows_inserted - Column-organized synopsis table rows inserted
          • col_vector_consumer_overflows - Columnar vector consumer overflows
          • comm_exit_wait_time - Communication exit wait time
          • comm_exit_waits - Communication exit number of waits
          • comm_private_mem - Committed private memory
          • commit_sql_stmts - Commit statements attempted
          • comp_env_desc - Compilation environment
          • compaction_read_reqs - Read requests for compaction
          • compaction_read_time - Elapsed time to read during compaction
          • compaction_read_bytes - Bytes read during compaction
          • compaction_write_bytes - Bytes written during compaction
          • compaction_write_reqs - Write request during compaction
          • compaction_write_time - Elapsed time to write during compaction
          • completion_status - Completion status
          • concurrent_connection_top - Concurrent connection peak.
          • con_elapsed_time - Most recent connection elapsed time
          • con_local_dbases - Local databases with current connects
          • con_response_time - Most recent response time for connect
          • concurrent_act_top - Concurrent activity top
          • concurrent_connection_top - Concurrent connection top
          • concurrent_wlo_act_top - Concurrent WLO activity top
          • concurrent_wlo_top - Concurrent workload occurrences top
          • concurrentdbcoordactivities_db_threshold_id - Concurrent database coordinator activities database threshold ID
          • concurrentdbcoordactivities_db_threshold_queued - Concurrent database coordinator activities database threshold queued
          • concurrentdbcoordactivities_db_threshold_value - Concurrent database coordinator activities database threshold value
          • concurrentdbcoordactivities_db_threshold_violated - Concurrent database coordinator activities database threshold violated
          • concurrentdbcoordactivities_subclass_threshold_id - Concurrent database coordinator activities service subclass threshold ID
          • concurrentdbcoordactivities_subclass_threshold_queued - Concurrent database coordinator activities service subclass threshold queued
          • concurrentdbcoordactivities_subclass_threshold_value - Concurrent database coordinator activities service subclass threshold value
          • concurrentdbcoordactivities_subclass_threshold_violated - Concurrent database coordinator activities service subclass threshold violated
          • concurrentdbcoordactivities_superclass_threshold_id - Concurrent database coordinator activities service superclass threshold ID
          • concurrentdbcoordactivities_superclass_threshold_queued - Concurrent database coordinator activities service superclass threshold queued
          • concurrentdbcoordactivities_superclass_threshold_value - Concurrent database coordinator activities service superclass threshold value
          • concurrentdbcoordactivities_superclass_threshold_violated - Concurrent database coordinator activities service superclass threshold violated
          • concurrentdbcoordactivities_wl_was_threshold_id - Concurrent database coordinator activities workload work action set threshold ID
          • concurrentdbcoordactivities_wl_was_threshold_queued - Concurrent database coordinator activities workload work action set threshold queued
          • concurrentdbcoordactivities_wl_was_threshold_value - Concurrent database coordinator activities workload work action set threshold value
          • concurrentdbcoordactivities_wl_was_threshold_violated - Concurrent database coordinator activities workload work action set threshold violated
          • concurrentdbcoordactivities_work_action_set_threshold_id - Concurrent database coordinator activities work action set threshold ID
          • concurrentdbcoordactivities_work_action_set_threshold_queued - Concurrent database coordinator activities work action set threshold queued
          • concurrentdbcoordactivities_work_action_set_threshold_value - Concurrent database coordinator activities work action set threshold value
          • concurrentdbcoordactivities_work_action_set_threshold_violated - Concurrent database coordinator activities work action set threshold violated
          • concurrentworkloadactivities_threshold_id - Concurrent workload activities threshold ID
          • concurrentworkloadactivities_threshold_value - Concurrent workload activities threshold value
          • concurrentworkloadactivities_threshold_violated - Concurrent workload activities threshold violated
          • configured_cf_gbp_size - Configured cluster caching facility group buffer pool size
          • configured_cf_lock_size - Configured cluster caching facility lock size
          • configured_cf_sca_size - Configured cluster caching facility shared communications area size
          • configured_cf_mem_size - Configured cluster caching facility memory size
          • conn_complete_time - Connection request completion timestamp
          • conn_time - Time of database connection
          • connect_cipher_spec - Cipher specification used on the connection
          • connect_sec_type - SSL/TLS level
          • connection_reusability_status - Connection reusability status
          • connection_start_time - Connection start time
          • connection_status - Connection status
          • connections_top - Maximum number of concurrent connections
          • consistency_token - Package consistency token
          • container_accessible - Accessibility of container
          • container_id - Container identification
          • container_name - Container name
          • container_stripe_set - Container stripe set
          • container_total_pages - Total pages in container
          • container_type - Container type
          • container_usable_pages - Usable pages in container
          • coord_act_aborted_total - Coordinator activities aborted total
          • coord_act_completed_total - Coordinator activities completed total
          • coord_act_est_cost_avg - Coordinator activity estimated cost average
          • coord_act_est_cost_stddev - Coordinator activity estimated cost standard deviation.
          • coord_act_exec_time_avg - Coordinator activities execution time average
          • coord_act_interarrival_time_avg - Coordinator activity arrival time average
          • coord_act_interarrival_time_stddev - Coordinator activity inter-arrival time standard deviation.
          • coord_act_lifetime_avg - Coordinator activity lifetime average
          • coord_act_lifetime_top - Coordinator activity lifetime top
          • coord_act_queue_time_avg - Coordinator activity queue time average
          • coord_act_rejected_total - Coordinator activities rejected total
          • coord_agent_pid - Coordinator agent identifier
          • coord_agent_tid - Coordinator agent engine dispatchable unit ID
          • coord_agents_top - Maximum number of coordinating agents
          • coord_member - Coordinator member
          • coord_node - Coordinating node
          • coord_partition_num - Coordinator partition number
          • coord_stmt_exec_time - Execution time for statement by coordinator agent
          • coord_time_created - Timestamp activity event monitor element
          • corr_token - DRDA correlation token
          • cost_estimate_top - Cost estimate top
          • count - Number of event monitor overflows
          • cpu_configured - Number of configured CPUs
          • cpu_cores_per_socket - Number of CPU cores per socket
          • cpu_entitlement - CPU entitlement
          • cpu_hmt_degree - Number of logical CPUs
          • cpu_idle - Processor idle time
          • cpu_iowait - IO Wait time
          • cpu_limit - WLM dispatcher CPU limit
          • cpu_load_long - Processor load (long timeframe)
          • cpu_load_medium - Processor load (medium timeframe)
          • cpu_load_short - Processor load (short timeframe)
          • cpu_online - Number of CPUs online
          • cpu_share_type - CPU share type
          • cpu_shares - WLM dispatcher CPU shares
          • cpu_speed - CPU clock speed
          • cpu_system - Kernel time
          • cpu_timebase - Frequency of timebase register increment
          • cpu_total - Number of CPUs
          • cpu_usage_total - Processor usage
          • cpu_user - Non-kernel processing time
          • cpu_utilization - CPU utilization
          • cpu_velocity - CPU velocity
          • cputime_threshold_id - CPU time threshold ID
          • cputime_threshold_value - CPU time threshold value
          • cputime_threshold_violated - CPU time threshold violated
          • cputimeinsc_threshold_id - CPU time in service class threshold ID
          • cputimeinsc_threshold_value - CPU time in service class threshold value
          • cputimeinsc_threshold_violated - CPU time in service class threshold violated
          • create_nickname - Create nicknames
          • create_nickname_time - Create nickname response time
          • creator - Application creator
          • critical_priority_act_total - Total number of critical priority activities
          • current_active_log - Current active log file number
          • current_archive_log - Current archive log file number
          • current_cf_gbp_size - Current cluster caching facility group buffer pool size
          • current_cf_lock_size - Current cluster caching facility lock size
          • current_cf_mem_size - Current cluster caching facility memory size
          • current_cf_sca_size - Current cluster caching facility shared communications area size
          • current_extent - Extent currently being moved
          • current_isolation - Current isolation level
          • current_request - Current operation request
          • cursor_name - Cursor name
        • D
          • data_object_l_pages - Table data logical pages
          • data_object_pages - Data object pages
          • data_partition_id - Data partition identifier
          • data_sharing_remote_lockwait_count - Data sharing remote lock wait count
          • data_sharing_remote_lockwait_time - Data sharing remote lock wait time
          • data_sharing_state - Data sharing state
          • data_sharing_state_change_time - Data sharing state change time
          • datasource_name - Data source name
          • datataginsc_threshold_id - Data tag in service class threshold (IN condition) ID
          • datataginsc_threshold_value - Data tag in service class threshold (IN condition) value
          • datataginsc_threshold_violated - Data tag in service class threshold (IN condition) violated
          • datatagnotinsc_threshold_id - Data tag in service class threshold (NOT IN condition) ID
          • datatagnotinsc_threshold_value - Data tag in service class threshold (NOT IN condition) value
          • datatagnotinsc_threshold_violated - Data tag in service class threshold (NOT IN condition) violated
          • db_activation_state - Database activation state
          • db_conn_time - Database activation timestamp
          • db_heap_top - Maximum database heap allocated
          • db_location - Database location
          • db_name - Database name
          • db_path - Database path
          • db_status - Status of database
          • db_storage_path - Automatic storage path
          • db_storage_path_id - Storage path identifier
          • db_storage_path_state - Storage path state
          • db_storage_path_with_dpe - Storage path including database partition expression
          • db_work_action_set_id - Database work action set ID
          • db_work_class_id - Database work class ID
          • db2_process_ID - Db2 process ID
          • db2_process_name - process name
          • db2_status - Status of Db2 instance
          • db2start_time - Start database manager timestamp
          • dbpartitionnum - Database partition number
          • dcs_appl_status - DCS application status
          • dcs_db_name - DCS database name
          • ddl_classification - DDL classification
          • ddl_sql_stmts - Data definition language (DDL) SQL statements
          • deadlock_id - Deadlock event identifier
          • deadlock_member - Deadlock member
          • deadlock_node - Partition number where deadlock occurred
          • deadlock_type - Deadlock type
          • deadlocks - Deadlocks detected
          • deferred - Deferred
          • degree_parallelism - Degree of parallelism
          • del_keys_cleaned - Pseudo deleted keys cleaned
          • delete_sql_stmts - Deletes
          • delete_time - Delete response time
          • destination_service_class_id - Destination service class ID
          • details_xml - Details XML
          • device_type - Device type
          • diaglog_write_wait_time - Diagnostic log file write wait time
          • diaglog_writes_total - Total diagnostic log file writes
          • direct_read_reqs - Direct read requests
          • direct_read_time - Direct read time
          • direct_reads - Direct reads from database
          • direct_write_reqs - Direct write requests
          • direct_write_time - Direct write time
          • direct_writes - Direct writes to database
          • disabled_peds - Disabled partial early distincts
          • disconn_time - Database deactivation timestamp
          • disconnects - Disconnects
          • dl_conns - Connections involved in deadlock
          • dyn_compound_exec_id - Dynamic compound statement executable identifier
          • dynamic_sql_stmts - Dynamic SQL statements attempted
        • E
          • edu_ID - Engine dispatchable unit ID
          • edu_name - Engine dispatchable unit name
          • eff_parallelism - The effective parallelism
          • eff_parallelism_avg - The average effective parallelism
          • eff_parallelism_top - The top effective parallelism
          • eff_stmt_text - Effective statement text
          • effective_isolation - Effective isolation
          • effective_lock_timeout - Effective lock timeout
          • effective_query_degree - Effective query degree
          • ehl_lockwait_time - Total time for EHL object lock wait
          • elapsed_exec_time - Statement execution elapsed time
          • empty_pages_deleted - Empty pages deleted
          • empty_pages_reused - Empty pages reused
          • entry_time - Entry time
          • estimated_cpu_entitlement - Estimated CPU entitlement
          • estimated_util_heap_top - estimated peak utility heap monitor element
          • estimated_runtime - Estimated execution time for a DML statement
          • estimated_sort_consumers_top - Estimated concurrently executing sort memory consumers
          • estimated_sort_shrheap_top - Estimated shared sort heap consumption
          • estimatedsqlcost_threshold_id - Estimated SQL cost threshold ID
          • estimatedsqlcost_threshold_value - Estimated SQL cost threshold value
          • estimatedsqlcost_threshold_violated - Estimated SQL cost threshold violated
          • event_id - Event ID monitor element
          • event_monitor_name - Event monitor name
          • event_time - Event time
          • event_timestamp - Event timestamp monitor element
          • event_type - Event Type
          • evmon_activates - Number of event monitor activations
          • evmon_flushes - Number of event monitor flushes
          • evmon_wait_time - Event monitor wait time
          • evmon_waits_total - Event monitor total waits
          • exec_list_cleanup_time - Execution list cleanup time
          • exec_list_mem_exceeded - Execution list memory exceeded
          • executable_id - Executable ID
          • executable_list_size - Size of executable list
          • executable_list_truncated - Executable list truncated
          • execution_id - User login ID
          • ext_table_read_volume - Total data read by external table readers
          • ext_table_recv_volume - Total data received from external table readers
          • ext_table_recv_wait_time - Total agent wait time for external table readers
          • ext_table_recvs_total - Total row batches received from external table readers
          • ext_table_send_volume - Total data sent to external table writers
          • ext_table_send_wait_time - Total agent wait time for external table writers
          • ext_table_sends_total - Total row batches sent to external table writers
          • ext_table_write_volume - Total data written by external table writers
        • F
          • failed_sql_stmts - Failed statement operations
          • fcm_congested_sends - FCM congested sends
          • fcm_congestion_time - FCM congestion time
          • fcm_message_recv_volume - FCM message received volume
          • fcm_message_recv_wait_time - FCM message received wait time
          • fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message
          • fcm_message_recvs_total - Total FCM message receives
          • fcm_message_send_volume - FCM message send volume
          • fcm_message_send_wait_time - FCM message send wait time
          • fcm_message_send_waits_total - Number of times spent blocking on an FCM message send
          • fcm_message_sends_total - Total FCM message sends
          • fcm_num_congestion_timeouts - FCM congestion timeouts
          • fcm_num_conn_lost - FCM lost connections
          • fcm_num_conn_timeouts - FCM connection timeouts
          • fcm_recv_volume - FCM received volume
          • fcm_recv_wait_time - FCM received wait time
          • fcm_recv_waits_total - Number of times spent waiting to receive data through FCM
          • fcm_recvs_total - FCM receives total
          • fcm_send_volume - FCM send volume
          • fcm_send_wait_time - FCM send wait time
          • fcm_send_waits_total - Number of times spent blocking on an FCM send operation
          • fcm_sends_total - FCM sends total
          • fcm_tq_recv_volume - FCM table queue received volume
          • fcm_tq_recv_wait_time - FCM table queue received wait time
          • fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer
          • fcm_tq_recvs_total - FCM table queue receives total
          • fcm_tq_send_volume - FCM table queue send volume
          • fcm_tq_send_wait_time - FCM table queue send wait time
          • fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer
          • fcm_tq_sends_total - FCM table queue send total
          • fetch_count - Number of successful fetches
          • files_closed - Database files closed
          • first_active_log - First active log file number
          • first_overflow_time - Time of first event overflow
          • fs_caching - File system caching
          • fs_id - Unique file system identification number
          • fs_total_size - Total size of a file system
          • fs_used_size - Amount of space used on a file system
        • G
          • gbp_update_time - Group puffer pool update time
          • global_transaction_id - Global transaction identifier
          • gw_comm_error_time - Communication error time
          • gw_comm_errors - Communication errors
          • gw_con_time - Db2 Connect gateway first connect initiated
          • gw_connections_top - Maximum number of concurrent connections to host database
          • gw_cons_wait_client - Number of connections waiting for the client to send request
          • gw_cons_wait_host - Number of connections waiting for the host to reply
          • gw_cur_cons - Current number of connections for Db2 Connect
          • gw_db_alias - Database alias at the gateway
          • gw_exec_time - Elapsed time spent on Db2 Connect gateway processing
          • gw_total_cons - Total number of attempted connections for Db2 Connect
        • H
          • hadr_connect_status - HADR connection status
          • hadr_connect_status_time - HADR connect status time
          • hadr_connect_time - HADR connection time
          • hadr_flags - HADR flags
          • hadr_heartbeat - HADR heartbeat
          • hadr_last_takeover_time - HADR last takeover time monitor element
          • hadr_local_host - HADR local host
          • hadr_local_service - HADR local service
          • hadr_log_gap - HADR log gap
          • hadr_peer_window - HADR peer window
          • hadr_peer_window_end - HADR peer window end
          • hadr_primary_log_file - HADR primary log file
          • hadr_primary_log_lsn - HADR primary log LSN
          • hadr_primary_log_page - HADR primary log page
          • hadr_remote_host - HADR remote host
          • hadr_remote_instance - HADR remote instance
          • hadr_remote_service - HADR remote service
          • hadr_role - HADR role
          • hadr_standby_log_file - HADR standby log file
          • hadr_standby_log_lsn - HADR standby log LSN
          • hadr_standby_log_page - HADR standby log page
          • hadr_state - HADR state
          • hadr_syncmode - HADR synchronization mode
          • hadr_timeout - HADR timeout
          • hash_grpby_overflows - Hash GROUP BY overflows
          • hash_join_overflows - Hash join overflows
          • hash_join_small_overflows - Hash join small overflows
          • heartbeat_expected - Heartbeats expected
          • heartbeat_interval - Heartbeat interval
          • heartbeat_missed - Heartbeats missed
          • high_priority_act_total - total number of high priority activities
          • histogram_type - Histogram type
          • hld_application_handle - Identifier for the application holding the lock
          • hld_member - Database member for application holding lock
          • host_ccsid - Host coded character set ID
          • host_db_name - Host database name
          • host_name - Host name
          • host_prdid - Host product/version ID
          • host_response_time - Host response time
          • hostname - Host name
        • I
          • ida_recv_volume - Total data volume received
          • ida_recv_wait_time - Time spent waiting to receive data
          • ida_recvs_total - Number of times data received
          • ida_send_volume - Total data volume sent
          • ida_send_wait_time - Time spent waiting to send data
          • ida_sends_total - Number of times data sent
          • idle_agents - Number of idle agents
          • iid - Index identifier
          • implicit_rebinds - number of implicit rebinds monitor element
          • inact_stmthist_sz - Statement history list size
          • inbound_bytes_received - Inbound number of bytes received
          • inbound_bytes_sent - Inbound number of bytes sent
          • inbound_comm_address - Inbound communication address
          • include_col_updates - Include column updates
          • incremental_bind - Incremental bind
          • index_jump_scans - Index jump scans
          • index_name - Index name
          • index_object_l_pages - Index data logical pages
          • index_object_pages - Index object pages
          • index_only_scans - Index-only scans
          • index_scans - Index scans
          • index_schema - Index schema
          • index_tbsp_id - Index table space ID
          • input_db_alias - Input database alias
          • insert_sql_stmts - Inserts
          • insert_time - Insert response time
          • insert_timestamp - Insert timestamp
          • int_auto_rebinds - Internal automatic rebinds
          • int_commits - Internal commits
          • int_deadlock_rollbacks - Internal rollbacks due to deadlock
          • int_node_splits - Intermediate node splits
          • int_rollbacks - Internal rollbacks
          • int_rows_deleted - Internal rows deleted
          • int_rows_inserted - Internal rows inserted
          • int_rows_updated - Internal rows updated
          • intra_parallel_state - Current state of intrapartition parallelism
          • invocation_id - Invocation ID
          • ipc_recv_volume - Interprocess communication received volume
          • ipc_recv_wait_time - Interprocess communication received wait time
          • ipc_recvs_total - Interprocess communication receives total
          • ipc_send_volume - Interprocess communication send volume
          • ipc_send_wait_time - Interprocess communication send wait time
          • ipc_sends_total - Interprocess communication send total
          • is_system_appl - Is System Application
        • K
          • key_updates - Key updates
          • ktid - Kernel thread ID
        • L
          • last_active_log - Last active log file number
          • last_backup - Last backup timestamp
          • last_executable_id - Last executable identifier
          • last_exec_error - Last error of the statement
          • last_exec_error_sqlerrmc - Tokens for last statement error
          • last_exec_error_timestamp - Time of last statement error
          • last_exec_warning- last statement warning
          • last_exec_warning_sqlerrmc - Tokens for last statement warning
          • last_exec_warning_timestamp - Time of last statement warning
          • last_extent - Last extent moved
          • last_metrics_update - Metrics last update timestamp
          • last_overflow_time - Time of last event overflow
          • last_reference_time - Last reference time
          • last_request_type - Last request type
          • last_reset - Last reset timestamp
          • last_updated - Last update time stamp
          • last_wlm_reset - Time of last reset
          • latch_name - Latch name
          • latch_status - Latch status
          • latch_wait_time - Latch wait time
          • lbp_update_time - Local buffer pool update time
          • lib_id - Library identifier
          • lob_object_l_pages - LOB data logical pages
          • lob_object_pages - LOB object pages
          • lob_prefetch_reqs - LOB prefetcher request count
          • lob_prefetch_wait_time - Wait time for prefetcher for LOB read or write
          • local_cons - Local connections
          • local_cons_in_exec - Local connections executing in the database manager
          • local_start_time - Local start time
          • local_tier_write_bytes - Bytes to write to local tier
          • local_tier_write_reqs - Write request for local tier
          • local_tier_write_time - Elapsed time to write
          • local_transaction_id - Local transaction identifier
          • location - Location
          • location_type - Location type
          • lock_attributes - Lock attributes
          • lock_count - Lock count
          • lock_current_mode - Original lock mode before conversion
          • lock_escalation - Lock escalation
          • lock_escals - Number of lock escalations
          • lock_escals_global - Number of global lock escalations
          • lock_escals_locklist - Number of locklist lock escalations
          • lock_escals_maxlocks - Number of maxlocks lock escalations
          • lock_hold_count - Lock hold count
          • lock_list_in_use - Total lock list memory in use
          • lock_mode - Lock mode
          • lock_mode_requested - Lock mode requested
          • lock_name - Lock name
          • lock_node - Lock node
          • lock_object_name - Lock object name
          • lock_object_type - Lock object type waited on
          • lock_object_type_id - Internal lock object type waited on
          • lock_release_flags - Lock release flags
          • lock_status - Lock status
          • lock_timeout_val - Lock timeout value
          • lock_timeouts - Number of lock timeouts
          • lock_timeouts_global - Lock timeouts global
          • lock_wait_end_time - Lock wait end timestamp
          • lock_wait_start_time - Lock wait start timestamp
          • lock_wait_time - Time waited on locks
          • lock_wait_time_global - Lock wait time global
          • lock_wait_time_global_top - Top global lock wait time
          • lock_wait_time_top - Lock wait time top
          • lock_wait_val - Lock wait value
          • lock_waits - Lock waits
          • lock_waits_global - Lock waits global
          • locks_held - Locks held
          • locks_held_top - Maximum number of locks held
          • locks_in_list - Number of locks reported
          • locks_waiting - Current agents waiting on locks
          • log_buffer_wait_time - Log buffer wait time
          • log_disk_wait_time - Log disk wait time
          • log_disk_waits_total - Total log disk waits
          • log_extraction_disk_space_used - Number of bytes for extraction logs
          • log_hadr_wait_cur - Current logger wait time
          • log_hadr_wait_time - Total logger wait time
          • log_hadr_waits_total - Total logger wait events
          • log_held_by_dirty_pages - Amount of log space accounted for by dirty pages
          • log_read_time - Log read time
          • log_reads - Number of log pages read
          • log_to_redo_for_recovery - Amount of log to be redone for recovery
          • log_write_time - Log write time
          • log_writes - Number of log pages written
          • log_stream_id - Log stream ID
          • long_object_l_pages - Long object data logical pages
          • long_object_pages - Long object pages
          • long_tbsp_id - Long table space ID
          • low_priority_act_total - The total number of low priority activities
        • M
          • machine_identification - Host hardware identification
          • max_agent_overflows - Maximum agent overflows
          • max_coord_stmt_exec_time - Maximum coordinator statement execution time
          • max_coord_stmt_exec_time_args - Maximum coordinator statement execution time arguments
          • max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp
          • max_data_received_1024 - Number of statements with outbound bytes received between 513 and 1024 bytes
          • max_data_received_128 - Number of statements with outbound bytes received between 1 and 128 bytes
          • max_data_received_16384 - Number of statements with outbound bytes received between 8193 and 16384 bytes
          • max_data_received_2048 - Number of statements with outbound bytes received between 1025 and 2048 bytes
          • max_data_received_256 - Number of statements with outbound bytes received between 129 and 256 bytes
          • max_data_received_31999 - Number of statements with outbound bytes received between 16385 and 31999 bytes
          • max_data_received_4096 - Number of statements with outbound bytes received between 2049 and 4096 bytes
          • max_data_received_512 - Number of statements with outbound bytes received between 257 and 512 bytes
          • max_data_received_64000 - Number of statements with outbound bytes received between 32000 and 64000 bytes
          • max_data_received_8192 - Number of statements with outbound bytes received between 4097 and 8192 bytes
          • max_data_received_gt64000 - Number of statements with outbound bytes received greater than 64000 bytes
          • max_data_sent_1024 - Number of statements with outbound bytes sent between 513 and 1024 bytes
          • max_data_sent_128 - Number of statements with outbound bytes sent between 1 and 128 bytes
          • max_data_sent_16384 - Number of statements with outbound bytes sent between 8193 and 16384 bytes
          • max_data_sent_2048 - Number of statements with outbound bytes sent between 1025 and 2048 bytes
          • max_data_sent_256 - Number of statements with outbound bytes sent between 129 and 256 bytes
          • max_data_sent_31999 - Number of statements with outbound bytes sent between 16385 and 31999 bytes
          • max_data_sent_4096 - Number of statements with outbound bytes sent between 2049 and 4096 bytes
          • max_data_sent_512 - Number of statements with outbound bytes sent between 257 and 512 bytes
          • max_data_sent_64000 - Number of statements with outbound bytes sent between 32000 and 64000 bytes
          • max_data_sent_8192 - Number of statements with outbound bytes sent between 4097 and 8192 bytes
          • max_data_sent_gt64000 - Number of statements with outbound bytes sent greater than 64000 bytes
          • max_network_time_1_ms - Number of statements with network time of up to 1 ms
          • max_network_time_100_ms - Number of statements with network time between 16 and 100 ms
          • max_network_time_16_ms - Number of statements with network time between 4 and 16 ms
          • max_network_time_4_ms - Number of statements with network time between 1 and 4 ms
          • max_network_time_500_ms - Number of statements with network time between 100 and 500 ms
          • max_network_time_gt500_ms - Number of statements with network time greater than 500 ms
          • medium_priority_act_total - The total number of medium priority activities
          • member - Database member
          • member_subset_id - Member subset ID
          • memory_address - Memory address
          • memory_free - Amount of free physical memory
          • memory_pool_id - Memory pool identifier
          • memory_pool_type - Memory pool name monitor element
          • memory_pool_used - Amount of memory pool in use
          • memory_pool_used_hwm - Memory pool high water mark
          • memory_set_committed - Memory currently committed
          • memory_set_id - Memory set identifier
          • memory_set_size - Memory set size
          • memory_set_type - Memory set type
          • memory_set_used - Memory in use by this set
          • memory_set_used_hwm - Memory set high water mark
          • memory_swap_free - Total free swap space
          • memory_swap_total - Total swap space
          • memory_total - Total physical memory
          • merge_sql_stmts - Merge SQL statements executed monitor element
          • message - Control table message
          • message_time - Timestamp control table message
          • metrics - Metrics
          • mon_interval_id - Monitor interval identifier
        • N
          • nesting_level - Nesting level
          • network_interface_bound - Network interface hostname or IP address for remote client and server communications
          • network_time_bottom - Minimum network time for statement
          • network_time_top - Maximum network time for statement
          • nleaf - Number of leaf pages
          • nlevels - Number of index levels
          • no_change_updates - Number of no change row updates
          • node_number - Node number
          • nonboundary_leaf_node_splits - Non-boundary leaf node splits
          • num_agents - Number of agents working on a statement
          • num_assoc_agents - Number of associated agents
          • num_columns_referenced - Number of columns referenced
          • num_compilations - Statement compilations
          • num_coord_agents - Number of coordinator agents
          • num_coord_exec - Number of executions by coordinator agent
          • num_coord_exec_with_metrics - Number of executions by coordinator agent with metrics
          • num_db_storage_paths - Number of automatic storage paths
          • num_exec_with_metrics - Number of executions with metrics collected
          • num_executions - Statement executions
          • num_exec_with_error - Number of executions with errors
          • num_exec_with_warning - Number of executions with warnings
          • num_extents_left - Number of extents left to process
          • num_extents_moved - Number of extents moved
          • num_gw_conn_switches - Connection switches
          • num_indoubt_trans - Number of indoubt transactions
          • num_log_buffer_full - Number of times full log buffer caused agents to wait
          • num_log_data_found_in_buffer - Number of log data found in buffer
          • num_log_part_page_io - Number of partial log page writes
          • num_log_read_io - Number of log reads
          • num_log_write_io - Number of log writes
          • num_lw_thresh_exceeded - Number of lock wait thresholds exceeded
          • num_nodes_in_db2_instance - Number of nodes in database partition
          • num_page_dict_built - Number of page-level compression dictionaries created or recreated
          • num_pooled_agents - Number of pooled agents
          • num_ref_with_metrics - Number of references with metrics
          • num_references - Number of references
          • num_remaps - Number of remaps
          • num_routines - Number of routines
          • num_tbsps - Number of table spaces
          • num_threshold_violations - Number of threshold violations
          • num_transmissions - Number of transmissions
          • num_transmissions_group - Number of transmissions group
          • number_in_bin - Number in bin
        • O
          • object_col_caching_tier_l_reads - Total logical reads of column-organized pages from the caching tier
          • object_col_caching_tier_pages found - Table column-organized pages found in caching tier
          • object_col_gbp_indep_pages_found_in_lbp - Group buffer pool column-organized independent data pages found in local buffer pool
          • object_col_gbp_invalid_pages - Group buffer pool column-organized invalid data pages
          • object_col_gbp_l_reads - Group buffer pool column-organized logical reads
          • object_col_gbp_p_reads - Group buffer pool column-organized physical reads
          • object_col_l_reads - Column-organized logical reads
          • object_col_lbp_pages_found - Local buffer pool column-organized pages found
          • object_col_p_reads - Column-organized physical reads
          • object_data_caching_tier_l_reads - Total logical reads of data pages from the caching tier
          • object_data_caching_tier_pages_found - Table data pages found in caching tier
          • object_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool
          • object_data_gbp_invalid_pages - GBP invalid data pages for a table
          • object_data_gbp_l_reads - GBP data logical reads for a table
          • object_data_gbp_p_reads - GBP data physical reads for a table
          • object_data_lbp_pages_found - LBP data pages found for a table
          • object_data_l_reads - Buffer pool data logical reads for a table
          • object_data_p_reads - Buffer pool physical data reads for a table
          • object_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool
          • object_index_gbp_invalid_pages - GBP invalid index pages for an index
          • object_index_gbp_l_reads - GBP index logical reads for an index
          • object_index_gbp_p_reads - GBP index physical reads for an index
          • object_index_lbp_pages_found - LBP index pages found for an index
          • object_index_l_reads - Buffer pool index logical reads for an index
          • object_index_p_reads - Buffer pool index physical reads for an index
          • object_module - Object module
          • object_name - Object name
          • object_requested - Requested object
          • object_schema - Object schema
          • object_xda_caching_tier_l_reads - Total logical reads of XDA data pages from the caching tier
          • object_xda_caching_tier_pages_found - Table XDA data pages found in caching tier
          • object_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool
          • object_xda_gbp_invalid_pages - GBP invalid XDA data pages for a table
          • object_xda_gbp_l_reads - GBP XDA data logical read requests for a table
          • object_xda_gbp_p_reads - GBP XDA data physical read requests for a table
          • object_xda_lbp_pages_found - LBP XDA data pages found for a table
          • object_xda_l_reads - Buffer pool XDA data logical reads for a table
          • object_xda_p_reads - Buffer pool XDA data physical reads for a table
          • objtype - Object type
          • olap_func_overflows - OLAP function overflows
          • open_cursors - Number of open cursors
          • open_loc_curs - Open local cursors
          • open_loc_curs_blk - Open local cursors with blocking
          • open_rem_curs - Open remote cursors
          • open_rem_curs_blk - Open remote cursors with blocking
          • os_arch_type - Operating system architecture type
          • os_full_version - Operating system full version
          • os_kernel_version - Operating system kernel identifier
          • os_level - Operating system level
          • os_name - Operating system name
          • os_release - Operating system release
          • os_version - Operating system version
          • outbound_appl_id - Outbound application ID
          • outbound_bytes_received - Outbound number of bytes received
          • outbound_bytes_received_bottom - Minimum outbound number of bytes received
          • outbound_bytes_received_top - Maximum outbound number of bytes received
          • outbound_bytes_sent - Outbound number of bytes sent
          • outbound_bytes_sent_bottom - Minimum outbound number of bytes sent
          • outbound_bytes_sent_top - Maximum outbound number of bytes sent
          • outbound_comm_address - Outbound communication address
          • outbound_comm_protocol - Outbound communication protocol
          • outbound_sequence_no - Outbound sequence number
          • overflow_accesses - Accesses to overflowed records
          • overflow_creates - Overflow creates
        • P
          • package_id - Package identifier
          • package_elapsed_time - Package elapsed time
          • package_list_count - Package list count
          • package_list_exceeded - Package list exceeded
          • package_list_size - Size of package list
          • package_name - Package name
          • package_schema - Package schema
          • package_version_id - Package version
          • packet_receive_errors - Packet receive errors
          • packets_received - Packets received
          • packet_send_errors - Packet send errors
          • packets_sent - Packets sent
          • page_allocations - Page allocations
          • page_reorgs - Page reorganizations
          • page_reclaims_x - Page reclaims exclusive access
          • page_reclaims_s - Page reclaims shared access
          • page_reclaims_initiated_x - Page reclaims initiated exclusive access
          • page_reclaims_initiated_s - Page reclaims initiated shared access
          • pages_from_block_ios - Total number of pages read by block I/O
          • pages_from_vectored_ios - Total pages read by vectored I/O
          • pages_merged - Pages merged
          • pages_read - Number of pages read
          • pages_written - Number of pages written
          • parent_activity_id - Parent activity ID
          • parent_uow_id - Parent unit of work ID
          • partial_record - Partial record
          • participant_no - Participant within deadlock
          • participant_no_holding_lk - Participant holding a lock on the object required by application
          • participant_type - Participant type
          • partition_key - Partitioning key
          • partition_number - Partition number
          • passthru_time - Pass-through time
          • passthrus - Pass-through
          • past_activities_wrapped - Past activities list wrapped
          • peer_wait_limit - Peer wait limit
          • peer_window - Peer window
          • peer_window_end - Peer window end
          • phase_start_event_id - Phase start event ID
          • phase_start_event_timestamp - Phase start event timestamp
          • physical_move_time - Physical extent move time
          • piped_sorts_accepted - Piped sorts accepted
          • piped_sorts_requested - Piped sorts requested
          • pkg_cache_inserts - Package cache inserts
          • pkg_cache_lookups - Package cache lookups
          • pkg_cache_num_overflows - Package cache overflows
          • pkg_cache_size_top - Package cache high watermark
          • planid - Query plan ID
          • pool_async_caching_tier_page_read_time - Buffer pool caching tier page read time
          • pool_async_col_caching_tier_pages_found - Buffer pool asynchronous column-organized pages found in caching tier
          • pool_async_data_caching_tier_pages_found - Buffer pool asynchronous data pages found in caching tier
          • pool_async_index_caching_tier_pages_found - Buffer pool asynchronous index pages found in caching tier
          • pool_async_xda_caching_tier_pages_found - Buffer pool asynchronous XDA data pages found in caching tier
          • pool_async_col_caching_tier_reads - Buffer pool asynchronous column-organized caching tier page reads
          • pool_async_data_caching_tier_reads - Buffer pool asynchronous data caching tier page reads
          • pool_async_index_caching_tier_reads - Buffer pool asynchronous index caching tier page reads
          • pool_async_xda_caching_tier_reads - Buffer pool asynchronous XML caching tier page reads
          • pool_async_col_gbp_indep_pages_found_in_lbp - Asynchronous group buffer pool column-organized independent data pages found in local buffer pool
          • pool_async_col_gbp_invalid_pages - Asynchronous group buffer pool invalid data pages
          • pool_async_col_gbp_l_reads - Asynchronous group buffer pool column-organized logical reads
          • pool_async_col_gbp_p_reads - Asynchronous group buffer pool column-organized physical reads
          • pool_async_col_lbp_pages_found - Asynchronous local buffer pool column-organized pages found
          • pool_async_col_read_reqs - Buffer pool asynchronous column-organized read requests
          • pool_async_col_reads - Buffer pool asynchronous column-organized reads
          • pool_async_col_writes - Buffer pool asynchronous column-organized writes
          • pool_async_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found by asynchronous EDUs in a local buffer pool
          • pool_async_data_gbp_invalid_pages - Asynchronous group buffer pool invalid data pages
          • pool_async_data_gbp_l_reads - Asynchronous group buffer pool data logical reads
          • pool_async_data_gbp_p_reads - Asynchronous group buffer pool data physical reads
          • pool_async_data_lbp_pages_found - Asynchronous local buffer pool data pages found
          • pool_async_data_read_reqs - Buffer pool asynchronous read requests
          • pool_async_data_reads - Buffer pool asynchronous data reads
          • pool_async_data_writes - Buffer pool asynchronous data writes
          • pool_async_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found by asynchronous EDUs in a local buffer pool
          • pool_async_index_gbp_invalid_pages - Asynchronous group buffer pool invalid index pages
          • pool_async_index_gbp_l_reads - Asynchronous group buffer pool index logical reads
          • pool_async_index_gbp_p_reads - Asynchronous group buffer pool index physical reads
          • pool_async_index_lbp_pages_found - Asynchronous local buffer pool index pages found
          • pool_async_index_read_reqs - Buffer pool asynchronous index read requests
          • pool_async_index_reads - Buffer pool asynchronous index reads
          • pool_async_index_writes - Buffer pool asynchronous index writes
          • pool_async_read_time - Buffer pool asynchronous read time
          • pool_async_write_time - Buffer pool asynchronous write time
          • pool_async_xda_gbp_indep_pages_found_in_lbp - Group buffer pool independent XML storage object (XDA) pages found by asynchronous EDUs in a local buffer pool
          • pool_async_xda_gbp_invalid_pages - Asynchronous group buffer pool invalid XDA data pages
          • pool_async_xda_gbp_l_reads - Group buffer pool XDA data asynchronous logical read requests
          • pool_async_xda_gbp_p_reads - Group buffer pool XDA data asynchronous physical read requests
          • pool_async_xda_lbp_pages_found - Asynchronous local buffer pool XDA data pages found
          • pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests
          • pool_async_xda_reads - Buffer pool asynchronous XDA data reads
          • pool_async_xda_writes - Buffer pool asynchronous XDA data writes
          • pool_caching_tier_page_read_time - Buffer pool caching tier page read time
          • pool_col_caching_tier_l_reads - Buffer pool column-organized caching tier logical reads
          • pool_col_caching_tier_pages_found - Buffer pool column-organized pages found in caching tier
          • pool_col_gbp_indep_pages_found_in_lbp - Buffer pool column-organized GBP independent pages found in local buffer pool
          • pool_col_gbp_invalid_pages - Buffer pool column-organized GBP invalid data pages
          • pool_col_gbp_l_reads - Buffer pool column-organized GBP logical reads
          • pool_col_gbp_p_reads - Buffer pool column-organized GBP physical reads
          • pool_col_l_reads - Buffer pool column-organized logical reads
          • pool_col_lbp_pages_found - Buffer pool column-organized LBP pages found
          • pool_col_p_reads - Buffer pool column-organized physical reads
          • pool_col_writes - Buffer pool column-organized writes
          • pool_config_size - Configured size of memory pool
          • pool_cur_size - Current size of memory pool
          • pool_data_caching_tier_l_reads - Buffer pool data caching tier logical reads
          • pool_data_caching_tier_pages_found - Buffer pool data pages found in caching tier
          • pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool
          • pool_data_gbp_invalid_pages - Group buffer pool invalid data pages
          • pool_data_gbp_l_reads - Group buffer pool data logical reads
          • pool_data_gbp_p_reads - Group buffer pool data physical reads
          • pool_data_lbp_pages_found - Local buffer pool found data pages
          • pool_data_l_reads - Buffer pool data logical reads
          • pool_data_p_reads - Buffer pool data physical reads
          • pool_data_writes - Buffer pool data writes
          • pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered
          • pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered
          • pool_failed_async_col_reqs - Failed column-organized prefetch requests
          • pool_failed_async_data_reqs - Failed data prefetch requests
          • pool_failed_async_index_reqs - Failed index prefetch requests
          • pool_failed_async_temp_col_reqs - Failed column-organized temporary prefetch requests
          • pool_failed_async_other_reqs - Failed non-prefetch requests
          • pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces
          • pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces
          • pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces
          • pool_failed_async_xda_reqs - Failed XDA prefetch requests
          • pool_id - Memory pool identifier
          • pool_index_caching_tier_l_reads - Buffer pool index caching tier logical reads
          • pool_index_caching_tier_pages_found - Buffer pool index pages found in caching tier
          • pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool
          • pool_index_gbp_invalid_pages - Group buffer pool invalid index pages
          • pool_index_gbp_l_reads - Group buffer pool index logical reads
          • pool_index_gbp_p_reads - Group buffer pool index physical reads
          • pool_index_lbp_pages_found - Local buffer pool index pages found
          • pool_index_l_reads - Buffer pool index logical reads
          • pool_index_p_reads - Buffer pool index physical reads
          • pool_index_writes - Buffer pool index writes
          • pool_lsn_gap_clns - Buffer pool log space cleaners triggered
          • pool_no_victim_buffer - Buffer pool no victim buffers
          • pool_queued_async_col_pages - Column-organized page prefetch requests
          • pool_queued_async_col_reqs - Column-organized prefetch requests
          • pool_queued_async_data_pages - Data pages prefetch requests
          • pool_queued_async_data_reqs - Data prefetch requests
          • pool_queued_async_index_pages - Index pages prefetch requests
          • pool_queued_async_index_reqs - Index prefetch requests
          • pool_queued_async_other_reqs - Other requests handled by prefetchers
          • pool_queued_async_temp_col_pages - Column-organized page temporary prefetch requests
          • pool_queued_async_temp_col_reqs - Column-organized temporary prefetch requests
          • pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces
          • pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces
          • pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces
          • pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces
          • pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces
          • pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces
          • pool_queued_async_xda_pages - XDA pages prefetch requests
          • pool_queued_async_xda_reqs - XDA prefetch requests
          • pool_read_time - Total buffer pool physical read time
          • pool_secondary_id - Memory pool secondary identifier
          • pool_sync_data_gbp_reads - Synchronous group buffer pool data reads
          • pool_sync_data_reads - Synchronous buffer pool data reads
          • pool_sync_index_gbp_reads - Synchronous group buffer pool index reads
          • pool_sync_index_reads - Synchronous buffer pool index reads
          • pool_sync_xda_gbp_reads - Synchronous group buffer pool XDA data reads
          • pool_sync_xda_reads - Synchronous buffer pool XDA data reads
          • pool_temp_col_caching_tier_l_reads - Buffer pool temporary column-organized caching tier logical reads
          • pool_temp_col_caching_tier_pages_found - Buffer pool temporary column-organized pages found in caching tier
          • pool_temp_col_l_reads - Buffer pool column-organized temporary logical reads
          • pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads
          • pool_temp_data_caching_tier_l_reads - Buffer pool temporary data caching tier logical reads
          • pool_temp_data_caching_tier_pages_found - Buffer pool temporary data pages found in caching tier
          • pool_temp_data_l_reads - Buffer pool temporary data logical reads
          • pool_temp_data_p_reads - Buffer pool temporary data physical reads
          • pool_temp_index_caching_tier_l_reads - Buffer pool temporary index caching tier logical reads
          • pool_temp_index_caching_tier_pages_found - Buffer pool temporary index pages found in caching tier
          • pool_temp_index_l_reads - Buffer pool temporary index logical reads
          • pool_temp_index_p_reads - Buffer pool temporary index physical reads
          • pool_xda_caching_tier_l_reads - Buffer pool temporary XML data caching tier logical reads
          • pool_temp_xda_caching_tier_pages_found - Buffer pool temporary XDA data pages found in caching tier
          • pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads
          • pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads
          • pool_watermark - Memory pool watermark
          • pool_write_time - Total buffer pool physical write time
          • pool_xda_caching_tier_l_reads - Buffer pool XML data caching tier logical reads
          • pool_xda_caching_tier_pages_found - Buffer pool XDA data pages found in caching tier
          • pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool
          • pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages
          • pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests
          • pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests
          • pool_xda_l_reads - Buffer pool XDA data logical reads
          • pool_xda_lbp_pages_found - Local buffer pool XDA data pages found
          • pool_xda_p_reads - Buffer pool XDA data physical reads
          • pool_xda_writes - Buffer pool XDA data writes
          • port_number - Port number
          • post_shrthreshold_hash_joins - Post threshold hash joins
          • post_shrthreshold_sorts - Post shared threshold sorts
          • post_threshold_col_vector_consumers - Post-threshold columnar vector consumers
          • post_threshold_hash_grpbys - Hash GROUP BY threshold
          • post_threshold_hash_joins - Hash join threshold
          • post_threshold_olap_funcs - OLAP function threshold
          • post_threshold_peas - Partial early aggregation threshold
          • post_threshold_peds - Partial early distincts threshold
          • post_threshold_sorts - Post threshold sorts
          • prefetch_wait_time - Time waited for prefetch
          • prefetch_waits - Prefetcher wait count
          • prep_time - Preparation time
          • prep_time_best - Statement best preparation time
          • prep_time_worst - Statement worst preparation time
          • prep_warning - Prepare warning SQLCODE
          • prep_warning_reason - Prepare warning SQLCODE reason identifier
          • prev_uow_stop_time - Previous unit of work completion timestamp
          • primary_instance - Primary instance
          • primary_log_file - Primary log file
          • primary_log_page - Primary log page
          • primary_log_pos - Primary log position
          • primary_log_time - Primary log time
          • primary_member - Primary member
          • primary_member_host - Primary member host
          • priority - Priority value
          • priv_workspace_num_overflows - Private workspace overflows
          • priv_workspace_section_inserts - Private workspace section inserts
          • priv_workspace_section_lookups - Private workspace section lookups
          • priv_workspace_size_top - Maximum private workspace size
          • product_name - Product name
          • progress_completed_units - Completed progress work units
          • progress_description - Progress description
          • progress_list_attr - Current progress list attributes
          • progress_list_current_seq_num - Current progress list sequence number
          • progress_seq_num - Progress sequence number
          • progress_start_time - Progress start time
          • progress_total_units - Total progress work units
          • progress_work_metric - Progress work metric
          • pseudo_deletes - Pseudo deletes
          • pseudo_empty_pages - Pseudo empty pages
        • Q
          • query_actual_degree - Actual runtime degree of intrapartition parallelism
          • query_card_estimate - Query number of rows estimate
          • query_cost_estimate - Query cost estimate
          • query_data_tag_list - Estimated query data tag list
          • queue_assignments_total - Queue assignments total
          • queue_start_time - Queue start timestamp
          • queue_size_top - Queue size top
          • queue_time_total - Queue time total
          • queued_agents - Queued threshold agents
          • quiescer_agent_id - Quiescer agent identification
          • quiescer_application_handle - Quiescer application handle
          • quiescer_auth_id - Quiescer user authorization identification
          • quiescer_obj_id - Quiescer object identification
          • quiescer_state - Quiescer state
          • quiescer_ts_id - Quiescer table space identification
        • R
          • range_adjustment - Range adjustment
          • range_container_id - Range container
          • range_end_stripe - End stripe
          • range_max_extent - Maximum extent in range
          • range_max_page_number - Maximum page in range
          • range_num_container - Number of containers in range
          • range_number - Range number
          • range_offset - Range offset
          • range_start_stripe - Start stripe
          • range_stripe_set_number - Stripe set number
          • reads_on_standby_enabled - reads on standby enabled
          • reusability_status_reason - Reusability status reason
          • rebalancer_extents_processed - Number of extents the rebalancer has processed
          • rebalancer_extents_remaining - Total number of extents to be processed by the rebalancer
          • rebalancer_last_extent_moved - Last extent moved by the rebalancer
          • rebalancer_mode - Rebalancer mode
          • rebalancer_priority - Current rebalancer priority
          • rebalancer_restart_time - Rebalancer restart time
          • rebalancer_source_storage_group_id - Rebalancer source storage group identifier
          • rebalancer_source_storage_group_name - Rebalancer source storage group name
          • rebalancer_start_time - Rebalancer start time
          • rebalancer_status - Rebalancer status
          • rebalancer_target_storage_group_id - Rebalancer target storage group identifier
          • rebalancer_target_storage_group_name - Rebalancer target storage group name
          • reclaim_wait_time - Reclaim wait time
          • reclaimable_space_enabled - Reclaimable space enabled indicator
          • regvar_collection_type - Registry variable collection type
          • regvar_level - Registry variable level
          • regvar_name - Registry variable name
          • regvar_old_value - Registry variable old value
          • regvar_value - Registry variable value
          • rej_curs_blk - Rejected block cursor requests
          • rem_cons_in - Remote connections to database manager
          • rem_cons_in_exec - Remote connections executing in the database manager
          • remote_lock_time - Remote lock time
          • remote_locks - Remote locks
          • remote_member - Remote member
          • remote_storage_tier_write_bytes - Bytes to write to remote storage tier
          • remote_storage_tier_write_reqs - Write requests to remote storage
          • remote_storage_tier_write_time - Elapsed time to write to remote storage
          • remote_update_time - Remote member update time
          • reopt - Reopt bind option
          • reorg_completion - Table reorganization completion flag
          • reorg_current_counter - Table reorganize progress
          • reorg_end - Table reorganize end time
          • reorg_index_id - Index used to reorganize the table
          • reorg_long_tbspc_id - Table space where long objects are reorganized
          • reorg_max_counter - Total amount of table reorganization
          • reorg_max_phase - Maximum Reorganize Phase monitor element
          • reorg_phase - Table reorganization phase
          • reorg_phase_start - Table reorganize phase start time
          • reorg_rows_compressed - Rows compressed
          • reorg_rows_rejected_for_compression - Rows rejected for compression
          • reorg_start - Table reorganize start time
          • reorg_status - Table reorganize status
          • reorg_tbspc_id - Table space where table is reorganized
          • reorg_type - Table reorganize attributes
          • reorg_xml_regions_compressed - XML regions compressed
          • reorg_xml_regions_rejected_for_compression - XML regions rejected for compression
          • replay_type - HADR replication type
          • req_agent_tid - Thread identifier for agent waiting to acquire lock
          • req_application_handle - Identifier for application waiting to acquire lock
          • req_executable_id - Identifier for statement section waiting to acquire lock
          • req_member - Member of application waiting to acquire lock
          • request_exec_time_avg - Request execution time average
          • req_tenant_id - Requestor tenant identifier
          • req_tenant_name - Requestor tenant name
          • resource_entitlement - Resource entitlement
          • resource_shares - Resource shares
          • resource_share_type - Resource share type
          • rf_log_num - Log being rolled forward
          • rf_status - Log phase
          • rf_timestamp - Rollforward timestamp
          • rf_type - Rollforward type
          • rollback_sql_stmts - Rollback statements attempted
          • rolled_back_agent_id - Rolled back agent
          • rolled_back_appl_id - Rolled back application
          • rolled_back_participant_no - Rolled back application participant
          • rolled_back_sequence_no - Rolled back sequence number
          • root_node_splits - Root node splits
          • routine_id - Routine ID
          • routine_module_name - Routine module name
          • routine_name - Routine name
          • routine_schema - Routine schema
          • routine_type - Routine type
          • rows_deleted - Rows deleted
          • rows_fetched - Rows fetched
          • rows_inserted - Rows inserted
          • rows_modified - Rows modified
          • rows_read - Rows read
          • rows_returned - Rows returned
          • rows_returned_top - Actual rows returned top
          • rows_selected - Rows selected
          • rows_updated - Rows updated
          • rows_written - Rows written
          • rqsts_completed_total - Total requests completed
          • rts_rows_modified - Rows modified since last real time statistics
        • S
          • savepoint_id - Savepoint ID
          • sc_work_action_set_id - Service class work action set ID
          • sc_work_class_id - Service class work class ID
          • sec_log_used_top - Maximum secondary log space used
          • sec_logs_allocated - Secondary logs allocated currently
          • section_actuals - Section actuals
          • section_env - Section environment
          • section_exec_with_col_references - Section execution with column-organized references
          • section_number - Section number
          • section_type - Section type indicator
          • select_sql_stmts - Select SQL statements executed
          • select_time - Query response time
          • semantic_env_id - Query semantic compilation environment ID
          • sequence_no - Sequence number
          • sequence_no_holding_lk - Sequence number holding lock
          • server_db2_type - Database manager type at monitored (server) node
          • server_instance_name - Server instance name
          • server_list_entry_member - Member ID for the member in the server list
          • server_platform - Server operating system
          • server_prdid - Server product/version ID
          • server_version - Server version
          • service_class_id - Service class ID
          • service_class_work_action_set_id - Service class work action set ID
          • service_class_work_class_id - Service class work class ID
          • service_level - Service level
          • service_subclass_name - Service subclass name
          • service_superclass_name - Service superclass name
          • session_auth_id - Session authorization ID
          • session_priority - Session priority monitor element
          • shr_workspace_active - Shared workspace
          • shr_workspace_inactive - Shared workspace
          • shr_workspace_num_overflows - Shared workspace overflows
          • shr_workspace_section_inserts - Shared workspace section inserts
          • shr_workspace_section_lookups - Shared workspace section lookups
          • shr_workspace_size_top - Maximum shared workspace size
          • skipped_prefetch_col_p_reads - Skipped prefetch column-organized physical reads
          • skipped_prefetch_data_p_reads - Skipped prefetch data physical reads
          • skipped_prefetch_index_p_reads - Skipped prefetch index physical reads
          • skipped_prefetch_temp_col_p_reads - Skipped prefetch column-organized temporary physical reads
          • skipped_prefetch_temp_data_p_reads - Skipped prefetch temporary data physical reads
          • skipped_prefetch_temp_index_p_reads - Skipped prefetch temporary index physical reads
          • skipped_prefetch_temp_xda_p_reads - Skipped prefetch temporary XDA data physical reads
          • skipped_prefetch_uow_col_p_reads - Skipped prefetch unit of work column-organized physical reads
          • skipped_prefetch_uow_data_p_reads - Skipped prefetch unit of work data physical reads
          • skipped_prefetch_uow_index_p_reads - Skipped prefetch unit of work index physical reads
          • skipped_prefetch_uow_temp_col_p_reads - Skipped prefetch unit of work column-organized temporary physical reads
          • skipped_prefetch_uow_temp_data_p_reads - Skipped prefetch unit of work temporary data physical reads
          • skipped_prefetch_uow_temp_index_p_reads - Skipped prefetch unit of work temporary index physical reads
          • skipped_prefetch_uow_temp_xda_p_reads - Skipped prefetch unit of work temporary XDA data physical reads
          • skipped_prefetch_uow_xda_p_reads - Skipped prefetch unit of work XDA data physical reads
          • skipped_prefetch_xda_p_reads - Skipped prefetch XDA physical reads
          • smallest_log_avail_node - Node with least available log space
          • snapshot_timestamp - Snapshot timestamp
          • sock_recv_buf_actual - Actual socket receive buffer size
          • sock_recv_buf_requested - Requested socket receive buffer size
          • sock_send_buf_actual - Actual socket send buffer size
          • sock_send_buf_requested - Requested socket send buffer size
          • sort_consumer_heap_top - Individual private sort heap consumer high watermark
          • sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark
          • sort_heap_allocated - Total sort heap allocated
          • sort_heap_top - Sort private heap high watermark
          • sort_overflows - Sort overflows
          • sort_shrheap_allocated - Sort share heap currently allocated
          • sort_shrheap_avg - The average amount of used sort shared heap
          • sort_shrheap_demand - Estimated sort memory resources demand monitor element
          • sort_shrheap_demand_avg - Average estimated sort memory demand monitor element
          • sort_shrheap_demand_top - Peak estimated sort memory demand monitor element
          • sort_shrheap_top - Sort share heap high watermark
          • sort_shrheap_utilization - Sort shared heap utilization
          • sort_shrheap_utilization_avg - The average sort shared heap utilization.
          • sort_shrheap_utilization_top - The peak sort shared heap utilization
          • sortshrheaputil_threshold_id - shared sortheap utilization threshold ID
          • sortshrheaputil_threshold_value - Shared sortheap utilization threshold value
          • sortshrheaputil_threshold_violated - Shared sortheap utilization threshold violated
          • source_service_class_id - Source service class ID
          • sp_rows_selected - Rows returned by stored procedures
          • spacemappage_page_reclaims_x - Space map page reclaims exclusive access
          • spacemappage_page_reclaims_s - Space map page reclaims shared access
          • spacemappage_page_reclaims_initiated_x - Space map page reclaims initiated exclusive access
          • spacemappage_page_reclaims_initiated_s - Space map page reclaims initiated shared access
          • spacemappage_reclaim_wait_time - Space map page reclaim wait time
          • specific_name - Specific name
          • sql_chains - Number of SQL chains attempted
          • sql_req_id - Request identifier for SQL statement
          • sql_reqs_since_commit - SQL requests since last commit
          • sql_stmts - Number of SQL statements attempted
          • sqlca - SQL Communications Area (SQLCA)
          • sqlrowsread_threshold_id - SQL rows read threshold ID
          • sqlrowsread_threshold_value - SQL rows read threshold value
          • sqlrowsread_threshold_violated - SQL rows read threshold violated
          • sqlrowsreadinsc_threshold_id - SQL rows read in service class threshold ID
          • sqlrowsreadinsc_threshold_value - SQL rows read in service class threshold value
          • sqlrowsreadinsc_threshold_violated - SQL rows read in service class threshold violated
          • sqlrowsreturned_threshold_id - SQL rows read returned threshold ID
          • sqlrowsreturned_threshold_value - SQL rows read returned threshold value
          • sqlrowsreturned_threshold_violated - SQL rows read returned threshold violated
          • sqltempspace_threshold_id - SQL temporary space threshold ID
          • sqltempspace_threshold_value - SQL temporary space threshold value
          • sqltempspace_threshold_violated - SQL temporary space threshold violated
          • ss_exec_time - Subsection execution elapsed time
          • ss_node_number - Subsection node number
          • ss_number - Subsection number
          • ss_status - Subsection status
          • ss_sys_cpu_time - System CPU time used by subsection
          • ss_usr_cpu_time - User CPU time used by subsection
          • ssl_port_number - SSL port number
          • ssl_srv_cert_fingerprint - Server certificate label of the connection
          • ssl_srv_cert_label - Server certificate label of the connection
          • standby_error_time - Standby error time
          • standby_id - Standby id
          • standby_instance - Standby instance
          • standby_log_file - Standby log file
          • standby_log_page - Standby log page
          • standby_log_pos - Standby log position
          • standby_log_time - Standby log time
          • standby_member - Standby member
          • standby_member_host - Standby member hostname
          • standby_replay_log_file - Standby replay log file
          • standby_replay_log_page - Standby replay log page
          • standby_replay_log_pos - Standby replay log position
          • standby_replay_log_time - Standby replay log time
          • standby_recv_replay_gap - Standby receive replay gap
          • standby_replay_delay - Standby replay delay
          • standby_replay_only_window_active - Standby replay only window active
          • standby_replay_only_window_start - Replay only window start time
          • standby_replay_only_window_tran_count - Replay only window transactions
          • standby_recv_buf_size - Standby receive buffer size
          • standby_recv_buf_percent - Standby receive buffer percentage
          • standby_spool_limit - Standby spool limit
          • standby_spool_percent - Standby spool percentage
          • start_event_id - Start event ID
          • start_event_timestamp - Start event timestamp
          • start_time - Event start time
          • static_sql_stmts - Static SQL statements attempted
          • statistics_timestamp - Statistics timestamp
          • stats_cache_size - Size of statistics cache
          • stats_dbpartition - Automatics statistics collection indicator
          • stats_fabricate_time - Total time spent on statistics fabrication activities
          • stats_fabrications - Total number of statistics fabrications
          • stats_rows_modified - Rows modified since last RUNSTATS
          • status_change_time - Application status change time
          • stmt_comments - Comments in SQL statement text
          • stmt_elapsed_time - Most recent statement elapsed time
          • stmt_exec_time - Statement execution time
          • stmt_first_use_time - Statement first use timestamp
          • stmt_history_id - Statement history identifier
          • stmt_invocation_id - Statement invocation identifier
          • stmt_isolation - Statement isolation
          • stmt_last_use_time - Statement last use timestamp
          • stmt_lock_timeout - Statement lock timeout
          • stmt_nest_level - Statement nesting level
          • stmt_node_number - Statement node
          • stmt_operation/operation - Statement operation
          • stmt_pkg_cache_id - Statement package cache identifier
          • stmt_query_id - Statement query identifier
          • stmt_sorts - Statement sorts
          • stmt_source_id - Statement source identifier
          • stmt_start - Statement operation start timestamp
          • stmt_stop - Statement operation stop timestamp
          • stmt_sys_cpu_time - System CPU time used by statement
          • stmt_text - SQL statement text
          • stmt_type - Statement type
          • stmt_type_id - Statement type identifier
          • stmt_unicode - Statement unicode flag
          • stmt_usr_cpu_time - User CPU time used by statement
          • stmt_value_data - Value data
          • stmt_value_index - Value index
          • stmt_value_isnull - Value has null value
          • stmt_value_isreopt - Variable used for statement reoptimization
          • stmt_value_type - Value type
          • stmtid - Query statement ID
          • stmtno - Statement number
          • sto_path_free_size - Automatic storage path free space
          • stop_time - Event stop time
          • storage_group_id - Storage group identifier
          • storage_group_name - Storage group name
          • stored_proc_time - Stored procedure time
          • stored_procs - Stored procedures
          • subroutine_id - Subroutine identifier
          • swap_pages_in - Pages swapped in from disk
          • swap_pages_out - Pages swapped out to disk
          • swap_page_size - Swap page size
          • sync_runstats - Total number of synchronous RUNSTATS activities
          • sync_runstats_time - Total time spent on synchronous RUNSTATS activities
          • system_auth_id - System authorization identifier
          • system_cpu_time - System CPU time
        • T
          • tab_organization - Data organization in table
          • table_file_id - Table file identification
          • table_name - Table name
          • table_scans - Table scans
          • table_schema - Table schema name
          • table_type - Table type
          • tablespace_auto_resize_enabled - Table space automatic resizing enabled
          • tablespace_content_type - Table space content type
          • tablespace_cur_pool_id - Buffer pool currently being used
          • tablespace_current_size - Current table space size
          • tablespace_extent_size - Table space extent size
          • tablespace_free_pages - Free pages in table space
          • tablespace_id - Table space identification
          • tablespace_increase_size - Increase size in bytes
          • tablespace_increase_size_percent - Increase size by percent
          • tablespace_initial_size - Initial table space size
          • tablespace_last_resize_failed - Last resize attempt failed
          • tablespace_last_resize_time - Time of last successful resize
          • tablespace_max_size - Maximum table space size
          • tablespace_min_recovery_time - Minimum recovery time for rollforward
          • tablespace_name - Table space name
          • tablespace_next_pool_id - Buffer pool that will be used at next startup
          • tablespace_num_containers - Number of containers in table space
          • tablespace_num_quiescers - Number of quiescers
          • tablespace_num_ranges - Number of ranges in the table space map
          • tablespace_page_size - Table space page size
          • tablespace_page_top - Table space high watermark
          • tablespace_paths_dropped - Table space using dropped path
          • tablespace_pending_free_pages - Pending free pages in table space
          • tablespace_prefetch_size - Table space prefetch size
          • tablespace_state - Table space state
          • tablespace_state_change_object_id - State change object identification
          • tablespace_state_change_ts_id - State change table space identification
          • tablespace_total_pages - Total pages in table space
          • tablespace_type - Table space type
          • tablespace_usable_pages - Usable pages in table space
          • tablespace_used_pages - Used pages in table space
          • tablespace_using_auto_storage - Table space enabled for automatic storage
          • takeover_app_remaining_primary - Applications remaining on primary
          • takeover_app_remaining_standby - Applications remaining on standby
          • target_cf_gbp_size - Target cluster caching facility group buffer pool size
          • target_cf_lock_size - Target cluster caching facility lock size
          • target_cf_sca_size - Target cluster caching facility shared communications area size
          • tbsp_datatag - Table space data tag
          • tbsp_last_consec_page - Last consecutive object table page
          • tbsp_max_page_top - Maximum table space page high watermark
          • tbsp_names - Table space names
          • tbsp_trackmod_state - Table space trackmod state
          • tcpip_recv_volume - TCP/IP received volume
          • tcpip_recv_wait_time - TCP/IP received wait time
          • tcpip_recvs_total - TCP/IP receives total
          • tcpip_send_volume - TCP/IP send volume
          • tcpip_send_wait_time - TCP/IP send wait time
          • tcpip_sends_total - TCP/IP sends total
          • temp_tablespace_top - Temporary table space top
          • tenant_id - Tenant identifier
          • tenant_name - Tenant name
          • territory_code - Database territory code
          • thresh_violations - Number of threshold violations
          • 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_since_last_recv - Time since last message received
          • time_stamp - Snapshot time
          • time_started - Time started
          • time_zone_disp - Time zone displacement
          • timezoneid - Time zone identifier
          • timezoneoffset - Time difference from UCT
          • top - Histogram bin top
          • tot_log_used_top - Maximum total log space used
          • total_act_time - Total activity time
          • total_act_wait_time - Total activity wait time
          • total_app_commits - Total application commits
          • total_app_rollbacks - Total application rollbacks
          • total_app_rqst_time - Total application request time
          • total_app_section_executions - Total application section executions
          • total_async_runstats - Total number of asynchronous RUNSTATS requests
          • total_backup_proc_time - Total non-wait time for online backups
          • total_backup_time - Total elapsed time for doing online backups
          • total_backups - Total backups
          • total_buffers_rcvd - Total FCM buffers received
          • total_buffers_sent - Total FCM buffers sent
          • total_bytes_received - Bytes received
          • total_bytes_sent - Bytes sent
          • total_col_executions - Total column-organized executions
          • total_col_proc_time - Total column-organized processing time
          • total_col_synopsis_executions - Total column-organized synopsis table executions
          • total_col_synopsis_proc_time - Total column-organized synopsis table processing time
          • total_col_synopsis_time - Total column-organized synopsis table time
          • total_col_time - Total column-organized time
          • total_col_vector_consumers - Total columnar vector memory consumers
          • total_commit_proc_time - Total commits processing time
          • total_commit_time - Total commit time
          • total_compilations - Total compilations
          • total_compile_proc_time - Total compile processing time
          • total_compile_time - Total compile time
          • total_connect_authentication_proc_time - Total connection authentication processing time
          • total_connect_authentications - Connections or switch user authentications performed
          • total_connect_authentication_time - Total connection or switch user authentication request time
          • total_connect_request_proc_time - Total connection or switch user request processing time
          • total_connect_requests - Connection or switch user requests
          • total_connect_request_time - Total connection or switch user request time
          • total_connections - Total connections
          • total_cons - Connects since database activation
          • total_cpu_time - Total CPU time
          • total_disp_run_queue_time - Total dispatcher run queue time
          • total_exec_time - Elapsed statement execution time
          • total_extended_latch_wait_time - Total extended latch wait time
          • total_extended_latch_waits - Total extended latch waits
          • total_hash_grpbys - Total hash GROUP BY operations
          • total_hash_joins - Total hash joins
          • total_hash_loops - Total hash loops
          • total_implicit_compilations - Total implicit complications
          • total_implicit_compile_proc_time - Total implicit compile processing time
          • total_implicit_compile_time - Total implicit compile time
          • total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation
          • total_index_build_time - Total time spent building indexes due to index creation or re-creation
          • total_indexes_built - Total number of indexes built
          • total_load_proc_time - Total load processing time
          • total_load_time - Total load time
          • total_loads - Total loads
          • total_log_available - Total log available
          • total_log_used - Total log space used
          • total_metadata_update_time - Total time for metadata update for extent movement
          • total_move_time - Total extent move time
          • total_nested_invocations - Total nested invocations
          • total_olap_funcs - Total OLAP functions
          • total_peas - Total partial early aggregations
          • total_peds - Total partial early distincts
          • total_reorg_proc_time - Total reorganization processing time
          • total_reorg_time - Total reorganization time
          • total_reorgs - Total reorganizations
          • total_rollback_proc_time - Total rollback processing time
          • total_rollback_time - Total rollback time
          • total_routine_coord_time - Total routine coordinator time
          • total_routine_invocations - Total routine invocations
          • total_routine_non_sect_proc_time - Non-section processing time
          • total_routine_non_sect_time - Non-section routine execution time
          • total_routine_time - Total routine time
          • total_routine_user_code_proc_time - Total routine user code processing time
          • total_routine_user_code_time - Total routine user code time
          • total_rqst_mapped_in - Total request mapped-in
          • total_rqst_mapped_out - Total request mapped-out
          • total_rqst_time - Total request time
          • total_runstats - Total runtime statistics
          • total_runstats_proc_time - Total runtime statistics processing time
          • total_runstats_time - Total runtime statistics time
          • total_sec_cons - Secondary connections
          • total_section_proc_time - Total section processing time
          • total_section_sort_proc_time - Total section sort processing time
          • total_section_sort_time - Total section sort time
          • total_section_sorts - Total section sorts
          • total_section_time - Total section time
          • total_sort_time - Total sort time
          • total_sorts - Total sorts
          • total_stats_fabrication_proc_time - Total statistics fabrication processing time
          • total_stats_fabrication_time - Total statistics fabrication time
          • total_stats_fabrications - Total statistics fabrications
          • total_sync_runstats_time - Total synchronous RUNSTATS time
          • total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time
          • total_sync_runstats - Total synchronous RUNSTATS activities
          • total_sys_cpu_time - Total system CPU time for a statement
          • total_times_routine_invoked - Total routine invoked occurrences
          • total_usr_cpu_time - Total user CPU time for a statement
          • total_wait_time - Total wait time
          • tpmon_acc_str - TP monitor client accounting string
          • tpmon_client_app - TP monitor client application name
          • tpmon_client_userid - TP monitor client user ID
          • tpmon_client_wkstn - TP monitor client workstation name
          • tq_cur_send_spills - Current number of table queue buffers overflowed
          • tq_id_waiting_on - Waited on node on a table queue
          • tq_max_send_spills - Maximum number of table queue buffers overflows
          • tq_node_waited_for - Waited for node on a table queue
          • tq_rows_read - Number of rows read from table queues
          • tq_rows_written - Number of rows written to table queues
          • tq_sort_heap_rejections - Table queue sort heap rejections
          • tq_sort_heap_requests - Table queue sort heap requests
          • tq_tot_send_spills - Total number of table queue buffers overflowed
          • tq_wait_for_any - Waiting for any node to send on a table queue
          • ts_name - Table space being rolled forward
          • txn_completion_status - Transaction completion status
          • trusted_conn_type - Trusted connection type
          • trusted_ctx_name - Trusted context used for trusted connection
          • trusted_ctx_role - Inherited role from a trusted connection
        • U
          • uid_sql_stmts - UPDATE/INSERT/MERGE/DELETE SQL statements executed
          • unread_prefetch_pages - Unread prefetch pages
          • uow_client_idle_wait_time - Client idle time within a unit of work
          • uow_comp_status - Unit of work completion status
          • uow_completed_total - Total completed units of work
          • uow_elapsed_time - Most recent unit of work elapsed time
          • uow_id - Unit of work ID
          • uow_lifetime_avg - Unit of work lifetime average
          • uow_lock_wait_time - Total time unit of work waited on locks
          • uow_log_space_used - Unit of work log space used
          • uow_start_time - Unit of work start timestamp
          • uow_status - Unit of work status
          • uow_stop_time - Unit of work stop timestamp
          • uow_throughput - Unit of work throughput
          • uow_total_time_top - UOW total time top
          • update_sql_stmts - Updates
          • update_time - Update response time
          • usage_list_last_state_change - Last state change
          • usage_list_mem_size - Usage list memory size
          • usage_list_name - Usage list name
          • usage_list_schema - Usage list schema
          • usage_list_size - Usage list size
          • usage_list_state - Usage list state
          • usage_list_used_entries - Usage list used entries
          • usage_list_wrapped - Usage list wrap indicator
          • user_cpu_time - User CPU time
          • util_heap_allocated - total utility heap allocated monitor element
          • utility_dbname - Database operated on by utility
          • utility_description - Utility description
          • utility_detail - Utility detail
          • utility_id - Utility ID
          • utility_invocation_id - Utility invocation ID
          • utility_invoker_type - Utility invoker type
          • utility_operation_type - Utility operation type
          • utility_phase_detail - Utility phase detail
          • utility_phase_type - Utility phase type
          • utility_priority - Utility priority
          • utility_start_time - Utility start time
          • utility_start_type - Utility start type
          • utility_state - Utility state
          • utility_stop_type - Utility stop type
          • utility_type - Utility type
        • V
          • valid - Section validity indicator
          • vectored_ios - Number of vectored I/O requests
          • version - Version of monitor data
          • virtual_mem_free - Free virtual memory
          • virtual_mem_reserved - Reserved virtual memory
          • virtual_mem_total - Total virtual memory
        • W
          • wl_work_action_set_id - Workload work action set identifier
          • wl_work_class_id - Workload work class identifier
          • wlm_queue_assignments_total - Workload manager total queue assignments
          • wlm_queue_time_total - Workload manager total queue time
          • wlo_completed_total - Workload occurrences completed total
          • work_action_set_id - Work action set ID
          • work_action_set_name - Work action set name
          • work_class_id - Work class ID
          • work_class_name - Work class name
          • workload_id - Workload ID
          • workload_name - Workload name
          • workload_occurrence_id - Workload occurrence identifier
          • workload_occurrence_state - Workload occurrence state
        • X
          • x_lock_escals - Exclusive lock escalations
          • xda_object_pages - XDA Object Pages
          • xda_object_l_pages - XML storage object (XDA) data logical pages
          • xid - Transaction ID
          • xmlid - XML ID
          • xquery_stmts - XQuery Statements Attempted
    • Monitoring metrics for column-organized tables
  • Built-in routines and views
    • Best coding practices
    • Authorizations for using built-in routines and views
    • Views versus table functions
    • Supported built-in routines and views
      • Administrative routines and ADMIN_CMD procedure
        • ADMIN_CMD - run administrative commands
          • ADD CONTACT using ADMIN_CMD
          • ADD CONTACTGROUP using ADMIN_CMD
          • DESCRIBE using ADMIN_CMD
          • DROP CONTACT using ADMIN_CMD
          • DROP CONTACTGROUP using ADMIN_CMD
          • EXPORT using ADMIN_CMD
          • FORCE APPLICATION using ADMIN_CMD
          • GET STMM TUNING using ADMIN_CMD
          • IMPORT using ADMIN_CMD
          • LOAD using ADMIN_CMD
          • REORG TABLE command using ADMIN_CMD
          • RESET ALERT CONFIGURATION using ADMIN_CMD
          • RUNSTATS using ADMIN_CMD
          • UPDATE ALERT CONFIGURATION using ADMIN_CMD
          • UPDATE CONTACT using ADMIN_CMD
          • UPDATE CONTACTGROUP using ADMIN_CMD
          • UPDATE HEALTH NOTIFICATION CONTACT LIST using ADMIN_CMD
        • ADMIN_COPY_SCHEMA - copy schema
        • ADMIN_DROP_SCHEMA - drop schema
        • ADMIN_EST_INLINE_LENGTH - estimate length required to inline data
        • ADMIN_GET_ENCRYPTION_INFO - Get database encryption settings
        • ADMIN_GET_INDEX_COMPRESS_INFO - return compressed index information
        • ADMIN_GET_INDEX_INFO table function - return index information
        • ADMIN_GET_INTRA_PARALLEL - Get intrapartition parallelism state
        • ADMIN_GET_MEM_USAGE - Get total memory consumption table function
        • ADMIN_GET_MSGS - retrieve messages for utilities using ADMIN_CMD
        • ADMIN_GET_STORAGE_PATHS - retrieve automatic storage path information
        • ADMIN_GET_SYSIBM_FUNCTIONS table function - Returns information about Db2 built-in functions
        • ADMIN_GET_SYSIBM_FUNCTION_PARMS table function - Returns information about Db2 built-in functions input and return parameters
        • ADMIN_GET_TAB_COMPRESS_INFO - estimate compression savings
        • ADMIN_GET_TAB_DICTIONARY_INFO - report properties of existing table dictionaries
        • ADMIN_GET_TAB_INFO - retrieve table size and state information
        • ADMIN_GET_TEMP_COLUMNS - retrieve column information for temporary tables
        • ADMIN_GET_TEMP_TABLES - retrieve information for temporary tables
        • ADMIN_IS_INLINED - determine if data is inlined
        • ADMIN_MOVE_TABLE - Move tables online
        • ADMIN_MOVE_TABLE_UTIL - modify parameters for online table moves
        • ADMIN_REMOVE_MSGS - clean up messages for utilities using ADMIN_CMD
        • ADMIN_REVALIDATE_DB_OBJECTS procedure - revalidate invalid database objects
        • ADMIN_SET_INTRA_PARALLEL procedure - Enables or disables intrapartition parallelism
        • ADMINTABINFO - retrieve table size and state information
        • ADMINTEMPCOLUMNS - retrieve column information for temporary tables
        • ADMINTEMPTABLES - retrieve information for temporary tables
      • Administrative Task Scheduler routines and views
        • ADMIN_TASK_ADD procedure - Schedule a new task
          • UNIX cron format
        • ADMIN_TASK_LIST - Retrieve information about tasks in the scheduler
        • ADMIN_TASK_REMOVE procedure - Remove scheduled tasks or task status records
        • ADMIN_TASK_STATUS - Retrieve task status information
        • ADMIN_TASK_UPDATE procedure - Update an existing task
      • Environment routines and views
        • ENV_GET_DB2_EDU_SYSTEM_RESOURCES - Return information about the database engine dispatchable units
        • ENV_GET_DB2_SYSTEM_RESOURCES - Return database system information
        • ENV_GET_NETWORK_RESOURCES - Return network information
        • ENV_GET_INSTANCE_CODE_LEVELS - return architectural level
        • ENV_GET_SYSTEM_RESOURCES table function - Return system information
        • ENV_INST_INFO - current instance information
        • ENV_PROD_INFO - installed database products information
      • Explain routines
        • EXPLAIN_GET_MSGS - explain messages
        • EXPLAIN_FORMAT stored procedure
        • EXPLAIN_FORMAT_STATS - displays statistics information
        • EXPLAIN_FROM_ACTIVITY procedure - Explain statement using activity event monitor information
        • EXPLAIN_FROM_CATALOG procedure - Explain a statement using section information from catalogs
        • EXPLAIN_FROM_DATA procedure - Explain a statement using the input section
        • EXPLAIN_FROM_SECTION procedure - Explain a statement using package cache or package cache event monitor information
      • Monitor views
        • MON_BP_UTILIZATION - Retrieve metrics for bufferpools
        • MON_CONNECTION_SUMMARY - Retrieve metrics for all connections
        • MON_CURRENT_SQL - Retrieve key metrics for all activities on all members
        • MON_CURRENT_UOW - Retrieve metrics for all units of work
        • MON_DB_SUMMARY - Retrieve accumulated metrics across all members of the database
        • MON_LOCKWAITS - Retrieve metrics for applications that are waiting to obtain locks
        • MON_PKG_CACHE_SUMMARY - Retrieve a high-level summary of the database package cache
        • MON_SERVICE_SUBCLASS_SUMMARY - Retrieve metrics for all service subclasses
        • MON_TBSP_UTILIZATION - Retrieve monitoring metrics for all table spaces and all database partitions
        • MON_TRANSACTION_LOG_UTILIZATION - retrieve log utilization information
        • MON_WORKLOAD_SUMMARY - Retrieves metrics for all workloads
      • Monitor procedures and functions
        • Monitor (MON) routines
          • MON_CAPTURE_ACTIVITY_IN_PROGRESS - collect activity information for activities event monitor
          • MON_COLLECT_STATS - collect and reset statistics for workload management objects and operating system resources
          • MON_FORMAT_LOCK_NAME - Format the internal lock name and return details
          • MON_FORMAT_XML_COMPONENT_TIMES_BY_ROW - Get formatted row-based component times
          • MON_FORMAT_XML_METRICS_BY_ROW - Get formatted row-based output for all metrics
          • MON_FORMAT_XML_TIMES_BY_ROW - Get formatted row-based combined hierarchy wait and processing times
          • MON_FORMAT_XML_WAIT_TIMES_BY_ROW - Get formatted row-based output for wait times
          • MON_GET_ACTIVITY - return a list of activities
          • MON_GET_ACTIVITY_DETAILS table function - return information about an activity as an XML document
          • MON_GET_AGENT - List agents, fenced mode processes, and system entities for the database
          • MON_GET_APPL_LOCKWAIT table function - Get information about locks for which an application is waiting
          • MON_GET_APPLICATION_HANDLE - Get connection application handle
          • MON_GET_APPLICATION_ID - Get connection application ID
          • MON_GET_AUTO_MAINT_QUEUE table function - Get information on the automatic maintenance jobs
          • MON_GET_AUTO_RUNSTATS_QUEUE table function - Retrieve information about objects queued for evaluation
          • MON_GET_BUFFERPOOL - get buffer pool metrics
          • MON_GET_CONNECTION - get connection metrics
          • MON_GET_CONNECTION_DETAILS table function - get connection metrics as an XML document
          • MON_GET_CONTAINER - get table space container metrics
          • MON_GET_DATABASE - get database metrics
          • MON_GET_DATABASE_DETAILS - get database metrics as an XML document
          • MON_GET_EXTENDED_LATCH_WAIT table function - Return information for latches
          • MON_GET_EXTENT_MOVEMENT_STATUS - get extent movement progress
          • MON_GET_FCM - Get FCM metrics
          • MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections
          • MON_GET_GROUP_BUFFERPOOL - Get group buffer pool metrics
          • MON_GET_HADR - get high availability disaster recovery (HADR) monitoring information
          • MON_GET_INDEX table function - get index metrics
          • MON_GET_INDEX_USAGE_LIST table function - Returns information from an index usage list
          • MON_GET_INSTANCE - get instance level information
          • MON_GET_LATCH - List all latches in the current member
          • MON_GET_LOCKS table function - List all locks in the currently connected database
          • MON_GET_MEMORY_POOL - get memory pool information
          • MON_GET_MEMORY_SET - get memory set information
          • MON_GET_PAGE_ACCESS_INFO - Get bufferpool page waiting information
          • MON_GET_PKG_CACHE_STMT table function - get package cache statement metrics
          • MON_GET_PKG_CACHE_STMT_DETAILS table function - get package cache statement metrics as an XML document
          • MON_GET_QUEUE_STATS - return threshold queue statistics
          • MON_GET_REBALANCE_STATUS table function - get rebalance progress for a table space
          • MON_GET_ROUTINE - get aggregated routine execution metrics
          • MON_GET_ROUTINE_DETAILS - get aggregated routine execution metrics as an XML document
          • MON_GET_ROUTINE_EXEC_LIST - get list of statements executed by routine
          • MON_GET_RTS_RQST table function - Retrieve information about real-time statistics requests
          • MON_GET_SECTION - Get a copy of a section from the package cache
          • MON_GET_SECTION_OBJECT - list objects accessed by a section
          • MON_GET_SECTION_ROUTINE - get list of routines for input section
          • MON_GET_SERVERLIST table function - get member priority details
          • MON_GET_SERVICE_SUBCLASS - get service subclass metrics
          • MON_GET_SERVICE_SUBCLASS_DETAILS - get service subclass metrics as an XML document
          • MON_GET_SERVICE_SUBCLASS_STATS - return statistics of service subclasses
          • MON_GET_SERVICE_SUPERCLASS - get service superclass metrics
          • MON_GET_SERVICE_SUPERCLASS_DETAILS - get service superclass metrics as an XML document
          • MON_GET_SERVICE_SUPERCLASS_STATS - return statistics of service superclasses
          • MON_GET_TABLE - get table metrics
          • MON_GET_TABLESPACE - get table space metrics
          • MON_GET_TABLESPACE_QUIESCER - get information about quiesced table spaces
          • MON_GET_TABLESPACE_RANGE - get information about table space ranges
          • MON_GET_TABLE_USAGE_LIST table function - Returns information from a table usage list
          • MON_GET_TRANSACTION_LOG table function - Get log information
          • MON_GET_UNIT_OF_WORK - get unit of work metrics
          • MON_GET_UNIT_OF_WORK_DETAILS - get unit of work metrics as an XML document
          • MON_GET_USAGE_LIST_STATUS table function - Returns the status on a usage list
          • MON_GET_UTILITY - get utilities running on the database
          • MON_GET_WLM_ADMISSION_QUEUE table function - Return a list of queued activities
          • MON_GET_WORKLOAD - get workload metrics
          • MON_GET_WORKLOAD_DETAILS - get workload metrics as an XML document
          • MON_GET_WORKLOAD_STATS - return workload statistics
          • MON_GET_WORK_ACTION_SET_STATS - return work action set statistics
          • MON_INCREMENT_INTERVAL_ID procedure - increment the monitoring interval
          • MON_SAMPLE_SERVICE_CLASS_METRICS - Get sample of service class metrics
          • MON_SAMPLE_WORKLOAD_METRICS - Get sample of workload metrics
        • Event monitor (EVMON) routines
          • EVMON_FORMAT_UE_TO_TABLES procedure - move an XML document to relational tables
          • EVMON_FORMAT_UE_TO_XML table function - convert unformatted events to XML
          • EVMON_UPGRADE_TABLES procedure - Upgrade event monitor target tables
  • Security routines and views
    • AUTH_GET_INSTANCE_AUTHID - get instance authorization ID
    • AUTH_LIST_AUTHORITIES_FOR_AUTHID - returns list of agents
    • AUTH_LIST_GROUPS_FOR_AUTHID - group membership for authorization IDs
    • AUTH_LIST_ROLES_FOR_AUTHID - returns roles list
    • AUTHORIZATIONIDS - authorization IDs and types
    • OBJECTOWNERS - object ownership information
    • PRIVILEGES - privilege information
  • SQL procedure routines
    • ALTER_ROUTINE_PACKAGE - alter package
    • GET_ROUTINE_NAME - get SQL PL object name
    • GET_ROUTINE_OPTS - get options for procedure creation
    • GET_ROUTINE_SAR - information required to install routine
    • PUT_ROUTINE_SAR - install routine
    • REBIND_ROUTINE_PACKAGE - rebind packages
    • SET_ROUTINE_OPTS - set options for procedure creation
  • Workload management routines
    • WLM_ENABLE_ADMISSION_CTRL procedure - Enabling the adaptive workload manager
    • WLM_CANCEL_ACTIVITY - cancel a given activity
    • WLM_CAPTURE_ACTIVITY_IN_PROGRESS - collect activity information
    • WLM_COLLECT_STATS - collect and reset workload management statistics
    • WLM_GET_CONN_ENV - get settings for activity data collection for a connection
    • WLM_GET_QUEUE_STATS - return threshold queue statistics
    • WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class
    • WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES table function - list workload occurrences
    • WLM_GET_SERVICE_SUBCLASS_STATS - return statistics of service subclasses
    • WLM_GET_SERVICE_SUPERCLASS_STATS - return statistics of service superclasses
    • WLM_GET_WORK_ACTION_SET_STATS - return work action set statistics
    • WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - return a list of activities
    • WLM_GET_WORKLOAD_STATS - return workload statistics
    • WLM_SET_CLIENT_INFO - set client information
    • WLM_SET_CONN_ENV - enable collection of activity data and measurement of section actuals
    • WLM_SET_SESSION_PRIORITY procedure - Set the priority of a given session
  • Miscellaneous routines and views
    • COMPILATION_ENV - compilation environment elements
    • SQLERRM - error message information
    • SYSINSTALLOBJECTS - create or drop objects
• 疑難排解及支援
  • 維護時間及系統狀況
  • 分析儲存程序疑難排解
• What's New
• Getting started
• Deployment overview
  • Provisioning an instance
    • CIDR and subnet allocation for your dataplane
    • Configuring and managing custom TLS certificates
  • Connectivity
• Disaster Recovery
  • Setting up disaster recovery for Db2 Warehouse SaaS on Azure
• Replication for Azure BYOC
• Architecture overview
  • Control plane
  • Data plane
    • Data plane infrastructure components
• Roles and responsibilities
• User management
• Scaling
• Backup and restore
• IBM Access/Monitoring/Logging
  • Viewing logs
  • Data plane logging configuration
• Data security and encryption
• Auditing Db2 Activities
  • Introduction to the Db2 audit facility for Db2 Warehouse SaaS
    • Audit policies
    • Audit facility record layouts
      • Audit events
      • Audit record object types
      • Audit record layout for AUDIT events
      • Audit record layout for CHECKING events
      • CHECKING access approval reasons
      • CHECKING access attempted types
      • Audit record layout for CONTEXT events
      • Audit record layout for EXECUTE events
      • Audit record layout for OBJMAINT events
      • Audit record layout for SECMAINT events
      • SECMAINT privileges or authorities
      • Audit record layout for SYSADMIN events
      • Audit record layout for VALIDATE events
  • Getting Started with Auditing for Db2 Warehouse SaaS
    • Before you start auditing
    • Rotating security credentials in Db2 Warehouse SaaS
    • Policy and data migration
    • Policy configuration
  • Audit facility management
    • Audit facility behavior
    • Audit facility tips and techniques
• Contact IBM Support