SSFMBX - Documentation Index

Table of Contents

• IBM Db2 as a Service documentation
• Accessibility features
• Overview
  • Getting started
• Getting started with AI usage and metering
• Federation
  • Supported data sources
• Security features
  • Database user management
    • Identity and access management (IAM) on IBM Cloud
      • Authentication methods for servers
    • Updating your Db2 SaaS instance password
    • 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 Db2 as a Service
      • 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 Db2 as a Service
      • Before you start auditing
      • Auditing to Cloud Object Storage
      • Policy and data migration
    • Audit facility management
      • Audit facility behavior
      • Audit facility tips and techniques
  • Security compliances
    • Details about security compliance
  • Integration with IBM Key Protect
• Data source compatibility
  • Terminology mapping: Oracle to IBM Db2 as a Service, IBM Db2 Warehouse as a Service, and IBM Db2 Warehouse
  • 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
  • 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
  • SPSS
    • Tutorial: Analyzing with SPSS Statistics
• Administering your database
  • Connecting to Db2
    • Database details and connect credentials
    • Db2 driver package
      • Installing
        • Windows
        • Installing on Linux or PowerLinux
        • Installing on Mac OS X
      • Configuring
      • Secure Sockets Layer (SSL)
    • Connecting programmatically
      • JDBC
      • ODBC or CLI
      • .Net
      • ODBC Data Source Administrator
      • PHP
      • REST API
    • Connecting IBM or third-party tools
      • Data integration
        • DataStage
        • InfoSphere Data Replication
        • IBM Data Studio
        • Data Server Manager
        • Connecting CLPPlus
        • InfoSphere Data Architect
      • Data visualization & BI
        • Looker
        • Connecting Tableau to a Db2 database
      • Data science
        • Watson Studio
        • SPSS Statistics
        • SAS
  • Loading your data
    • Load your data in the cloud
    • Loading data from a local or host file
    • Loading data from Amazon S3
      • Loading data from a file on Amazon S3
      • Loading public data sets from Amazon S3 for IBM Db2 Warehouse
    • Loading data from DataStage
    • Loading data from InfoSphere Data Replication
  • Designing your database
    • Creating a new database design
    • Duplicating an existing database design
  • Db2 workload management
    • Domains of workload management
    • Workload management administrator authority
    • Frequently asked questions
    • Work identification
      • Activities
      • Workload management DDL statements
      • Work identification by origin with workloads
        • Workload assignment
        • Default workloads
          • Taking corrective action using the default administration workload
        • Creating a workload
        • Altering a workload
        • Enabling a workload
        • Disabling a workload
        • Dropping a workload
        • Permitting occurrences of a workload to access the database
        • Preventing occurrences of a workload from accessing the database
        • Granting the USAGE privilege on a workload
        • Revoking the USAGE privilege on a workload
        • Example: Workload assignment
        • Example: Workload assignment when workload attributes have single values
        • Example: Workload assignment for a unit of work when multiple workloads exist
        • Example: Workload assignment when workload attributes have multiple values
      • Work identification by type, cost, or data accessed with work classes
        • Work classes and work class sets
          • Creating a work class
          • Altering a work class
          • Dropping a work class
          • Creating a work class set
          • Altering a work class set
          • Dropping a work class set
        • Evaluation order of work classes in a work class set
        • Assignment of activities to work classes
        • Work classifications supported by thresholds
        • Example: Analyzing workloads by activity type
        • Example: Using a work class set to manage specific types of activities
        • Example: Working with a work class defined with the ALL keyword
        • Example: Determining the priority of activities based on what data might be accessed
    • Activities management
      • Resource assignment with service classes
        • Default service superclasses and subclasses
        • Activity-to-service class mapping
        • States of connections and activities in a service class
        • System-level entities not managed by service classes
        • Creating a service class
        • Altering a service class
        • Dropping a service class
      • Adaptive workload manager
        • Enabling adaptive workload manager
        • Restoring the legacy system workload manager objects
        • Default adaptive WLM environment
        • Resources that affect query admission
        • Short query bypass
        • Monitoring queuing in a default adaptive WLM environment
          • The impact of queuing on the database
          • Listing query activity
          • Determining why queries are queued
            • Queuing caused by high thread usage
            • Queuing caused by high sort memory usage
            • Queuing caused by queued queries with high sort memory estimates
            • Displaying resource usage information for executing or queued queries
          • Historical resource usage for queries
        • Customizing the adaptive workload manager environment
          • Service class resource assignment
            • Service class resource shares
            • Service class minimum resource share
            • Monitoring resource entitlements and minimum resource share
          • Adaptive WLM admission queue order
          • Resource configuration for the default workload manager environment
          • Using workload types to simplify service class creation
            • Resource configuration for a MIXED workload type service superclass
            • Resource configuration for a BATCH workload type service superclass
            • Resource configuration for an INTERACTIVE workload type service superclass
            • Resource configuration for a CUSTOM workload type service superclass
          • Session priority
          • Monitoring a customized adaptive WLM environment
            • Monitoring queuing in a customized adaptive WLM environment
              • Monitoring general queuing behavior in a customized adaptive WLM environment
              • Monitoring current queries in a customized adaptive WLM environment
              • Investigating queuing caused by hard resource entitlements
            • Monitoring service class load
            • Monitoring service class resource entitlement and usage
            • Monitoring service class compliance with resource entitlements
        • Deadlocks and the adaptive workload manager
        • Best practices
      • Control of work with thresholds
        • Threshold domain and enforcement scope
        • Threshold evaluation order
        • Creating a threshold
        • Altering a threshold
        • Dropping a threshold
        • Example: Using thresholds
        • Connection thresholds
          • CONNECTIONIDLETIME threshold
        • Activity thresholds
          • Domain precedence for activity thresholds
          • ACTIVITYTOTALTIME threshold
          • ACTIVITYTOTALRUNTIME threshold
          • ACTIVITYTOTALRUNTIMEINALLSC threshold
          • CPUTIME threshold
          • CPUTIMEINSC threshold
          • DATATAGINSC threshold
          • ESTIMATEDSQLCOST threshold
          • SORTSHRHEAPUTIL threshold
          • SQLROWSREAD threshold
          • SQLROWSREADINSC threshold
          • SQLROWSRETURNED threshold
          • SQLTEMPSPACE threshold
        • Aggregate thresholds
          • Activity queuing
          • AGGSQLTEMPSPACE threshold
          • CONCURRENTDBCOORDACTIVITIES threshold
          • CONCURRENTWORKLOADACTIVITIES threshold
          • CONCURRENTWORKLOADOCCURRENCES threshold
          • TOTALMEMBERCONNECTIONS threshold
          • TOTALSCMEMBERCONNECTIONS threshold
        • Unit of work thresholds
          • UOWTOTALTIME threshold
      • Apply controls to types of activities with work action sets
        • How work classes, work class sets, work actions, and work action sets work together and are associated with other Db2 objects
        • Work actions and work action sets
          • Creating a work action
          • Altering a work action
          • Disabling a work action
          • Dropping a work action
          • Creating a work action set
          • Altering a work action set
          • Disabling a work action set
          • Dropping a work action set
        • Work actions and the work action set domain
        • Thresholds that can be used in work actions
        • Application of work actions to database activities
        • Concurrency control at the workload level using work action sets
        • Workload and work action set comparison
        • Example: Using a database work action set and database threshold
        • Example: Using work action sets to determine the types of work being run
      • Workload management dispatcher overview
        • Enabling the workload management dispatcher
          • Workload management dispatcher
          • Workload management dispatcher behavior in multimember environments
        • Ensuring maximum Db2 workload management dispatcher scheduling accuracy
        • Enabling and setting CPU shares
          • Hard CPU shares
          • Soft CPU shares
        • Setting a CPU limit
          • CPU limit
        • Setting minimum CPU resource utilization for service class to be considered active
          • Minimum CPU resource utilization for service class to be considered active
        • Setting dispatch concurrency level
          • Dispatch concurrency level
        • Monitoring and tuning workload management dispatcher performance
      • Canceling activities
    • Monitoring and intervention
      • Real-time monitoring with table functions
        • Example: Using Db2 workload management table functions
        • Example: Monitoring current system behavior at different levels using Db2 workload management table functions
        • Example: Obtaining point-in-time statistics from service classes
        • Example: Aggregating data using Db2 workload management table functions
      • Historical monitoring with event monitors
      • Available monitoring data
      • Db2 workload management stored procedures
      • Statistics for Db2 workload management objects
        • Statistics collection and monitoring with remapped activities
        • Histograms in workload management
          • Creating a histogram template
          • Altering a histogram template
          • Dropping a histogram template
          • Example: Computing averages and a standard deviation from histograms in a Db2 workload management configuration
        • Collecting workload management statistics using a statistics event monitor
        • Resetting statistics on Db2 workload management objects
      • Monitoring metrics for Db2 workload management
      • Monitoring threshold violations
        • How to generate email notifications for threshold violations
      • Collecting data for individual activities
      • Guidelines for capturing information about and investigating a rogue activity
• Database reference
  • Standards compliances
  • 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
      • 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
        • UNNEST
        • XMLTABLE
      • User-defined functions
    • Built-in procedures
      • XSR_ADDSCHEMADOC
      • XSR_COMPLETE
      • XSR_DTD
      • XSR_EXTENTITY
      • XSR_REGISTER
      • XSR_UPDATE
    • 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 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
      • 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 EXTERNAL TABLE
      • 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 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
      • 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
      • OPEN
      • PIPE
      • PREPARE
      • REFRESH TABLE
      • RELEASE (connection)
      • RELEASE SAVEPOINT
      • RENAME
      • 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
    • 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_FORMAT_OUTPUT
      • EXPLAIN_INSTANCE
      • EXPLAIN_OBJECT
      • EXPLAIN_OPERATOR
      • EXPLAIN_PREDICATE
      • EXPLAIN_STATEMENT
      • EXPLAIN_STREAM
      • OBJECT_METRICS
    • Explain register values
  • Messages
    • Messages handling roadmap
    • Protocol-specific error codes for the SQL30081N message
      • SOAP errors
      • SOCKS errors
      • TCP/IP errors
    • SQLSTATE Messages
    • CDFAA messages
      • 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
      • 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 messages
      • CDFAE0000I
      • 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
      • CDFAE1500E
      • CDFAE1502E
      • CDFAE1503E
      • CDFAE1504E
      • CDFAE1505E
      • CDFAE1506E
      • CDFAE1507E
      • CDFAE1508E
      • CDFAE2044E
      • CDFAE2045E
    • CDFAS messages
      • CDFAS0000I
  • Command line processor 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
      • 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
  • Analytic stored procedures
    • Analysis of variance (ANOVA)
      • Background
      • Usage
      • Functions
        • IDAX.ANOVA_CRD_TEST - Analyze variance by using completely randomized design
        • IDAX.ANOVA_RBD_TEST - Analyze variance by using randomized block design
    • Association rules
      • Background
      • Usage
      • Functions
        • IDAX.ASSOCRULES - Build an association rules model
        • IDAX.PRUNE_ASSOCRULES - Prune rules and patterns
        • IDAX.PREDICT_ASSOCRULES - Apply rules and patterns
      • Examples
      • Model table data formats
        • _ITEMS table
        • _ASSOCPATTERNS table
        • _ASSOCPATTERNS_STATISTICS table
        • _ASSOCRULES table
    • Data transformation
      • Background
      • Usage
      • Functions
        • IDAX.IMPUTE_DATA - Impute missing data
        • IDAX.SPLIT_DATA - Split data
        • IDAX.STD_NORM - Standardize or normalize columns of the input table
    • Decision trees
      • Background
        • Growing
        • Pruning
        • Prediction
        • Support for missing values
      • Usage
      • Functions
        • IDAX.DECTREE - Build and prune a decision tree model
        • IDAX.GROW_DECTREE - Build a decision tree model
        • IDAX.PRUNE_DECTREE - Prune a decision tree model
        • IDAX.PREDICT_DECTREE - Apply a decision tree model
      • Examples
      • Model table data formats
        • _MODEL table
        • _NODES table
        • _PREDICATES table
        • _COLUMNS table
        • _COLUMN_STATISTICS table
        • _DISCRETE_STATISTICS table
        • _NUMERIC_STATISTICS table
    • Diagnostic measures
      • Usage
      • Functions
        • IDAX.ACC - Calculate the classification accuracy
        • IDAX.CERROR - Calculate classification error
        • IDAX.CMATRIX_ACC - Calculate the classification accuracy from a confusion matrix
        • IDAX.CMATRIX_STATS - Calculate classification quality factors from a confusion matrix
        • IDAX.CMATRIX_WACC - Calculate the weighted classification accuracy from a confusion matrix
        • IDAX.CONFUSION_MATRIX - Build a confusion matrix
        • IDAX.FMEASURE - Calculate the F-measure from a confusion matrix
        • IDAX.FPR - Calculate the false positive rate from a confusion matrix
        • IDAX.MAE - Calculate the mean absolute error of regression predictions
        • IDAX.MSE - Calculate the mean squared error of regression predictions
        • IDAX.PPV - Calculate the positive predictive value from a confusion matrix
        • IDAX.RAE - Calculate the relative absolute error of regression predictions
        • IDAX.RSE - Calculate the relative squared error of regression predictions
        • IDAX.TPR - Calculate the true positive rate from a confusion matrix
        • IDAX.WACC - Calculate the weighted classification accuracy
    • Discretization and moments
      • Background
      • Usage
      • Functions for discretization
        • IDAX.AGGDISC - Aggregate data in outliers and bins
        • IDAX.APPLY_DISC - Discretize data by limits for discretization bins
        • IDAX.EFDISC - Discretization bins of equal frequency
        • IDAX.EMDISC - Discretization bins of minimal entropy
        • IDAX.EWDISC - Discretization bins of equal width
        • IDAX.EWDISC_NICE - Discretization bins of equal width with human-friendly limits
      • Functions for moments
        • IDAX.DROP_SUMMARY1000 - Drop output tables created by SUMMARY1000
        • IDAX.KURTOSIS_AGG - Calculate the excess kurtosis value
        • IDAX.MOMENTS - Calculate moments of a column
        • IDAX.NUMERIC_SUMMARY - Calculate summary statistics
        • IDAX.SKEWNESS_AGG - Calculate the skewness value
        • IDAX.SUMMARY1000 - Summary of up to 1000 columns
        • IDAX.SUMMARY1000CHAR - Summary of up to 1000 character columns
        • IDAX.SUMMARY1000DATE - Summary of up to 1000 date columns
        • IDAX.SUMMARY1000NUM - Summary of up to 1000 numeric columns
        • IDAX.SUMMARY1000TIME - Summary of up to 1000 time columns
        • IDAX.SUMMARY1000TIMESTAMP - Summary of up to 1000 timestamp columns
    • K-means clustering
      • Background
        • Statistics
      • Usage
      • Functions
        • IDAX.KMEANS - Build a K-means clustering model
        • IDAX.PREDICT_KMEANS - Apply a K-means clustering model
      • Examples
      • Model table data formats
        • _MODEL table
        • _CLUSTERS table
        • _COLUMNS table
        • _COLUMN_STATISTICS table
        • _DISCRETE_STATISTICS table
        • _NUMERIC_STATISTICS table
    • k-Nearest Neighbors (KNN)
      • Background
      • Usage
      • Functions
        • IDAX.KNN - Build a KNN model
        • IDAX.PREDICT_KNN - Apply a KNN model
      • Examples
      • Model table data formats
        • _MODEL table
    • Linear regression
      • Background
      • Usage
      • Functions
        • IDAX.LINEAR_REGRESSION - Build a linear regression model
        • IDAX.PREDICT_LINEAR_REGRESSION - Apply linear regression
      • Model table data formats
        • _MODEL table
        • _COVARIANCE_MATRIX table
    • Metadata management
      • Overview
        • Required privileges
      • Naming conventions for models
        • Length of the model name
        • Uniqueness of the model name
        • Case sensitivity in model names
      • Naming conventions for model components
      • Column properties
        • Column properties in parameters
        • Column properties in column properties tables
          • Available functions
            • IDAX.COLUMN_PROPERTIES - Create a column properties table
            • IDAX.SET_COLUMN_PROPERTIES - Set or update properties
            • IDAX.GET_COLUMN_LIST - Get a list of columns
      • Functions
        • Administrative operations on model metadata objects
          • Stored procedures for administrative operations
            • IDAX.CLEANUP - Drop all metadata objects
            • IDAX.INITIALIZE - Create the database objects
            • IDAX.IS_INITIALIZED - Determine whether the database objects are created
        • Basic operations
          • Stored procedures for basic operations
            • IDAX.ALTER_MODEL - Alter properties of a model
            • IDAX.COPY_MODEL - Duplicate a model
            • IDAX.DROP_MODEL - Drop a model
            • IDAX.DROP_ALL_MODELS - Drop selected or all models
            • IDAX.MODEL_EXISTS - Determine whether a model exists
            • IDAX.EXPORT_MODEL - Export model
            • IDAX.EXPORT_PMML - Export an analytic model as PMML
            • IDAX.IMPORT_MODEL - Import model
            • IDAX.PMML_MODEL - Create a PMML representation of a model
            • IDAX.PRINT_MODEL - Print a model
        • List operations
          • Stored procedures for list operations
            • IDAX.LIST_COLPROPS - List column properties for selected or all models
            • IDAX.LIST_COMPONENTS - List components of selected or all models
            • IDAX.LIST_MODELS - List selected or all models
            • IDAX.LIST_PARAMS - List parameters for selected or all models
        • Security operations
          • Stored procedures for security operations
            • IDAX.GRANT_MODEL - Grant a privilege on a model
            • IDAX.LIST_PRIVILEGES - List privileges on all models
            • IDAX.REVOKE_MODEL - Revoke privileges on a model
    • Naive Bayes
      • Background
        • Support for missing values
      • Usage
      • Functions
        • IDAX.NAIVEBAYES - Build a Naive Bayes model
        • IDAX.PREDICT_NAIVEBAYES - Apply a Naive Bayes model
      • Examples
      • Model table data formats
        • _MODEL table
        • _DISCRANGES table
    • Principal component analysis (PCA)
      • Background
      • Usage
      • Functions
        • IDAX.PCA - Build a PCA model
        • IDAX.PROJECT_PCA - Apply a PCA model
      • Examples
      • Model table data formats
        • _META table
        • _PCA table
        • _PCA_ATTMEAN table
        • _PCA_ATTSD table
        • _PCA_ATTSD_DIV table
        • _PCA_SDEV table
        • _PCA_SCORES table
    • Probability distributions
      • Background
      • Usage
      • Functions
        • BERN - Bernoulli distribution
          • IDAX.DBERN - Density of the Bernoulli distribution
          • IDAX.PBERN - Cumulative Bernoulli distribution
          • IDAX.PBERN_H - High-tail cumulative Bernoulli distribution
          • IDAX.QBERN - Inverse Bernoulli distribution
          • IDAX.QBERN_H - High-tail inverse Bernoulli distribution
        • BETA - beta distribution
          • IDAX.DBETA - Density of the beta distribution
          • IDAX.PBETA - Cumulative beta distribution
          • IDAX.PBETA_H - High-tail cumulative beta distribution
          • IDAX.QBETA - Inverse beta distribution
          • IDAX.QBETA_H - High-tail inverse beta distribution
        • BINOMIAL - binomial distribution
          • IDAX.DBINOM - Density of the binomial distribution
          • IDAX.PBINOM - Cumulative binomial distribution
          • IDAX.PBINOM_H - High-tail cumulative binomial distribution
          • IDAX.QBINOM - Inverse binomial distribution
          • IDAX.QBINOM_H - High-tail inverse binomial distribution
        • CAUCHY - Cauchy distribution
          • IDAX.DCAUCHY - Density of the Cauchy distribution
          • IDAX.PCAUCHY - Cumulative Cauchy distribution
          • IDAX.PCAUCHY_H - High-tail cumulative Cauchy distribution
          • IDAX.QCAUCHY - Inverse Cauchy distribution
          • IDAX.QCAUCHY_H - High-tail inverse Cauchy distribution
        • CHISQ - chi-square distribution
          • IDAX.DCHISQ - Density of the chi-square distribution
          • IDAX.PCHISQ - Cumulative chi-square distribution
          • IDAX.PCHISQ_H - High-tail cumulative chi-square distribution
          • IDAX.PCHISQ_S - Cumulative chi-square distribution with string argument
          • IDAX.QCHISQ - Inverse chi-square distribution
          • IDAX.QCHISQ_H - High-tail inverse chi-square distribution
        • EXP - exponential distribution
          • IDAX.DEXP - Density of the exponential distribution
          • IDAX.PEXP - Cumulative exponential distribution
          • IDAX.PEXP_H - High-tail cumulative exponential distribution
          • IDAX.QEXP - Inverse exponential distribution
          • IDAX.QEXP_H - High-tail inverse exponential distribution
        • F - Fisher distribution
          • IDAX.DF - Density of the Fisher distribution
          • IDAX.PF - Cumulative Fisher distribution
          • IDAX.PF_H - High-tail cumulative Fisher distribution
          • IDAX.QF - Inverse Fisher distribution
          • IDAX.QF_H - High-tail inverse Fisher distribution
        • FISK - Fisk distribution
          • IDAX.DFISK - Density of the Fisk distribution
          • IDAX.PFISK - Cumulative Fisk distribution
          • IDAX.PFISK_H - High-tail cumulative Fisk distribution
          • IDAX.QFISK - Inverse Fisk distribution
          • IDAX.QFISK_H - High-tail inverse Fisk distribution
        • GAMMA - gamma distribution
          • IDAX.DGAMMA - Density of the gamma distribution
          • IDAX.PGAMMA - Cumulative gamma distribution
          • IDAX.PGAMMA_H - High-tail cumulative gamma distribution
          • IDAX.QGAMMA - Inverse gamma distribution
          • IDAX.QGAMMA_H - High-tail inverse gamma distribution
        • GEOM - geometric distribution
          • IDAX.DGEOM - Density of the geometric distribution
          • IDAX.PGEOM - Cumulative geometric distribution
          • IDAX.PGEOM_H - High-tail cumulative geometric distribution
          • IDAX.QGEOM - Inverse geometric distribution
          • IDAX.QGEOM_H - High-tail inverse geometric distribution
        • HYPER - hypergeometric distribution
          • IDAX.DHYPER - Density of the hypergeometric distribution
          • IDAX.PHYPER - Cumulative hypergeometric distribution
          • IDAX.PHYPER_H - High-tail cumulative hypergeometric distribution
          • IDAX.QHYPER - Inverse hypergeometric distribution
          • IDAX.QHYPER_H - High-tail inverse hypergeometric distribution
        • LNORM - log-normal distribution
          • IDAX.DLNORM - Density of the log-normal distribution
          • IDAX.PLNORM - Cumulative log-normal distribution
          • IDAX.PLNORM_H - High-tail cumulative log-normal distribution
          • IDAX.QLNORM - Inverse log-normal distribution
          • IDAX.QLNORM_H - High-tail inverse log-normal distribution
        • LOGIS - logistic distribution
          • IDAX.DLOGIS - Density of the logistic distribution
          • IDAX.PLOGIS - Cumulative logistic distribution
          • IDAX.PLOGIS_H - High-tail cumulative logistic distribution
          • IDAX.QLOGIS - Inverse logistic distribution
          • IDAX.QLOGIS_H - High-tail inverse logistic distribution
        • MWW - Mann-Whitney-Wilcoxon distribution
          • IDAX.DMWW - Density of the Mann-Whitney-Wilcoxon distribution
          • IDAX.PMWW - Cumulative Mann-Whitney-Wilcoxon distribution
          • IDAX.PMWW_H - High-tail cumulative Mann-Whitney-Wilcoxon distribution
          • IDAX.QMWW - Inverse Mann-Whitney-Wilcoxon distribution
          • IDAX.QMWW_H - High-tail inverse Mann-Whitney-Wilcoxon distribution
        • NBINOM - negative binomial distribution
          • IDAX.DNBINOM - Density of the negative binomial distribution
          • IDAX.PNBINOM - Cumulative negative binomial distribution
          • IDAX.PNBINOM_H - High-tail cumulative negative binomial distribution
          • IDAX.QNBINOM - Inverse negative binomial distribution
          • IDAX.QNBINOM_H - High-tail inverse negative binomial distribution
        • NORM - standard normal distribution
          • IDAX.DNORM - Density of the standard normal distribution
          • IDAX.PNORM - Cumulative standard normal distribution
          • IDAX.PNORM_H - High-tail cumulative standard normal distribution
          • IDAX.QNORM - Inverse standard normal distribution
          • IDAX.QNORM_H - High-tail inverse standard normal distribution
        • NORM3P - normal distribution
          • IDAX.DNORM3P - Density of the normal distribution
          • IDAX.PNORM3P - Cumulative normal distribution
          • IDAX.QNORM3P - Inverse normal distribution
        • IDAX.PPOINT - Percentage point distribution
        • POIS - Poisson distribution
          • IDAX.DPOIS - Density of the Poisson distribution
          • IDAX.PPOIS - Cumulative Poisson distribution
          • IDAX.PPOIS_H - High-tail cumulative Poisson distribution
          • IDAX.QPOIS - Inverse Poisson distribution
          • IDAX.QPOIS_H - High-tail inverse Poisson distribution
        • T - t-student distribution
          • IDAX.DT - Density of the t-student distribution
          • IDAX.PT - Cumulative t-student distribution
          • IDAX.PT_H - High-tail cumulative t-student distribution
          • IDAX.QT - Inverse t-student distribution
          • IDAX.QT_H - High-tail inverse t-student distribution
        • UNIF - uniform distribution
          • IDAX.DUNIF - Density of the uniform distribution
          • IDAX.PUNIF - Cumulative uniform distribution
          • IDAX.PUNIF_H - High-tail cumulative uniform distribution
          • IDAX.QUNIF - Inverse uniform distribution
          • IDAX.QUNIF_H - High-tail inverse uniform distribution
        • WALD - Wald distribution
          • IDAX.DWALD - Density of the Wald distribution
          • IDAX.PWALD - Cumulative Wald distribution
          • IDAX.PWALD_H - High-tail cumulative Wald distribution
          • IDAX.QWALD - Inverse Wald distribution
          • IDAX.QWALD_H - High-tail inverse Wald distribution
        • WEIBULL - Weibull distribution
          • IDAX.DWEIBULL - Density of the Weibull distribution
          • IDAX.PWEIBULL - Cumulative Weibull distribution
          • IDAX.PWEIBULL_H - High-tail cumulative Weibull distribution
          • IDAX.QWEIBULL - Inverse Weibull distribution
          • IDAX.QWEIBULL_H - High-tail inverse Weibull distribution
        • WILCOX - Wilcoxon distribution
          • IDAX.DWILCOX - Density of the Wilcoxon distribution
          • IDAX.PWILCOX - Cumulative Wilcoxon distribution
          • IDAX.PWILCOX_H - High-tail cumulative Wilcoxon distribution
          • IDAX.QWILCOX - Inverse Wilcoxon distribution
          • IDAX.QWILCOX_H - High-tail inverse Wilcoxon distribution
    • Random sampling
      • Background
      • Usage
      • Functions
        • IDAX.RANDOM_SAMPLE - Random sampling
    • Regression trees
      • Background
        • Growing
        • Pruning
        • Prediction
        • Support for missing values
      • Usage
      • Functions
        • IDAX.REGTREE - Build and prune a regression tree model
        • IDAX.GROW_REGTREE - Build a regression tree model
        • IDAX.PRUNE_REGTREE - Prune a regression tree model
        • IDAX.PREDICT_REGTREE - Apply a regression tree model
      • Examples
      • Model table data formats
        • _MODEL table
        • _NODES table
        • _PREDICATES table
        • _COLUMNS table
        • _COLUMN_STATISTICS table
        • _DISCRETE_STATISTICS table
        • _NUMERIC_STATISTICS table
    • Sequential patterns
      • Background
      • Usage
      • Functions
        • IDAX.SEQRULES - Build a sequential patterns model
        • IDAX.PRUNE_SEQRULES - Prune sequential patterns
        • IDAX.PREDICT_SEQRULES - Apply sequential patterns
      • Examples
      • Model table data formats
        • _ITEMS table
        • _ITEMSETS table
        • _SEQPATTERNS table
        • _SEQPATTERNS_STATISTICS table
        • _SEQRULES table
    • Statistics - parametric and nonparametric
      • Background
      • Usage
      • Functions
        • Parametric statistics
          • IDAX.CHISQ_TEST_AGG - Pearson's chi-square
          • IDAX.CHISQ_TEST_S_AGG - Pearson's chi-square with degree of freedom
          • IDAX.SPLIT_TEST_S - Split specific returned strings into an output table
          • IDAX.T_LS_TEST - t-Student test for the linear relationship of two columns
          • IDAX.T_LS_TEST_S_AGG - t-Student test between linearly dependent samples as a string
          • IDAX.T_ME_TEST - t-Student test for the expected mean of a column
          • IDAX.T_ME_TEST_S_AGG - t-Student test for the expected mean of a variable as a string
          • IDAX.T_PMD_TEST - t-Student test for the expected mean difference between two paired columns
          • IDAX.T_TEST_AGG - t-Student test of a variable split into two classes
          • IDAX.T_TEST_S_AGG - t-Student test for a variable split into two classes
          • IDAX.T_UMD_TEST - t-Student test for the expected mean difference between class values of a column
        • Nonparametric statistics
          • IDAX.CHISQ_TEST - Pearson's chi-square test of independence
          • IDAX.MWW_TEST - Mann-Whitney-Wilcoxon test of independence
          • IDAX.SPEARMAN_CORR - Spearman rank correlation
          • IDAX.WILCOXON_TEST - Wilcoxon paired samples difference test
  • SQL PL support
    • Inline SQL PL
    • 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
        • ALLOCATE_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
    • SYSIBMADM functions
      • SYSIBMADM.STORAGE_ACCESS_ALIAS.LIST table function
    • SYSIBMADM procedures
      • SYSIBMADM.STORAGE_ACCESS_ALIAS.CATALOG procedure
      • SYSIBMADM.STORAGE_ACCESS_ALIAS.UNCATALOG procedure
  • 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
          • 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
          • 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
          • 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
          • 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_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_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_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_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_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_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_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_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_l_reads - Buffer pool column-organized temporary logical reads
          • pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads
          • pool_temp_data_l_reads - Buffer pool temporary data logical reads
          • pool_temp_data_p_reads - Buffer pool temporary data physical reads
          • pool_temp_index_l_reads - Buffer pool temporary index logical reads
          • pool_temp_index_p_reads - Buffer pool temporary index physical reads
          • pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads
          • pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads
          • pool_watermark - Memory pool watermark
          • pool_write_time - Total buffer pool physical write time
          • pool_xda_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_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
          • 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
          • 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
          • 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
        • 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_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
        • 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
        • 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
  • 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
  • Miscellaneous routines and views
    • COMPILATION_ENV - compilation environment elements
    • SQLERRM - error message information
    • SYSINSTALLOBJECTS - create or drop objects
  • Configuration parameters
  • Registry and environment variables
• Troubleshooting and support
  • Maintenance windows and system status
• 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
  • Configure disaster recovery for Db2 SaaS on Azure
• Clone a Db2 SaaS Engine on Azure
• Architecture overview
  • Control plane
  • Data plane
    • Data plane infrastructure components
• Roles and responsibilities
• User management
• High availability
• Scaling
• Auto-scaling
• Backup and restore
• External Restore API Overview
• IBM Access/Monitoring/Logging
  • Viewing logs
  • Data plane logging configuration
• Data security and encryption
• Contact IBM Support