Built-in routines and views

Built-in administrative routines and views provide an simplified programmatic interface to administer and use DB2® databases and database objects through structured query language (SQL). Built-in routines encompass procedures, scalar functions, and table functions.

You can use built-in routines and views to perform a variety of 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.

You can invoke these built-in routines and views from an SQL-based application, a DB2 command line, or a command script.