DB2 10.5 for Linux, UNIX, and Windows

Supported built-in SQL routines and views

You can use built-in routines and views to accomplish various DB2® tasks.

For example, you can use built-in routines to reorganize a table, capture and retrieve monitor data, or retrieve the application ID of the current connection.

Built-in routines and views are grouped by function.

Administrative routines and ADMIN_CMD procedure
This grouping of routines and views can be used to administer your DB2 databases.
Administrative Task Scheduler routines and views
This grouping of routines and views can be used to manage scheduled tasks.
Audit routines and procedures
This grouping of routines and views can be used to work with archive audit logs.
Automatic maintenance routines
This grouping of routines and views can be used to work with automatic maintenance policies for a database.
Common SQL API procedures
The common SQL API provides a collection of common-signature and signature-stable stored procedures that are portable across IBM data servers. You can use these stored procedures to create applications that perform a variety of common administrative functions, such as getting and setting configuration parameters, and getting system information.
Configuration routines and views
This grouping of routines and views can be used to retrieve database configuration parameter information and database manager configuration parameter information.
DB2 pureScale instance information routines and views
In a DB2 pureScale® environment, certain routines provide information about the state of the DB2 pureScale instance and its members.
Environment routines and views
This grouping of routines and views can be used to retrieve information about a database environment.
Explain routines
This grouping of routines and views can be used to retrieve information about the access plan that the optimizer chooses for an SQL statement or XQuery statement.
Monitor views
Monitor views are an ideal place to start when interested in basic monitoring.
Monitor procedures and functions
Monitor routines are procedures or functions with names that begin with "MON", such as MON_GET_SERVICE_SUBCLASS, or "EVMON", such as EVMON_FORMAT_UE_TO_TABLES.
WebSphere MQ routines
This grouping of routines and views can be used to interact with messages in an IBM® WebSphere® MQ (formerly known as IBM MQSeries®) environment.
Security routines and views
This grouping of routines and views can be used to retrieve information about security and authorities, such as roles, authorization IDs, and groups.
Snapshot routines and views
This grouping of routines and views can be used to retrieve information about the database and any connected applications at a specific time.
SQL procedure routines
This grouping of routines and views can be used to interact with SQL routines and packages.
Stepwise redistribute routines
This grouping of routines and views can be used to manage data distribution in partitioned database environments.
Storage management tool routines
This grouping of routines and views can be used to interact with storage management objects.
Text search routines
This grouping of routines and views can be used to manage the DB2 Text Search feature and the text search indexes it uses.
Workload management routines
This grouping of routines and views can be used to achieve effective management of work and workloads in your database.
Miscellaneous routines and views
This grouping of routines and views can be used to accomplish various, category-independent tasks.

Related reference:

Deprecated SQL administrative routines and views