System-defined routines and views

The system-defined routines and views provide a primary, easy-to-use programmatic interface to administer and use DB2® through SQL. They encompass a collection of built-in views, table functions, procedures, and scalar functions for performing a variety of DB2 tasks. For example, system-defined routines are available for reorganizing a table, capturing and retrieving monitor data, or retrieving the application ID of the current connection.

These routines and views can be invoked from an SQL-based application, a DB2 command line, or a command script.