Db2® for i Services

There are many system-provided views, procedures, and functions that can be used to access database information.

Application Services
These procedures provide interfaces that are useful for application development.
Performance Services
These services include procedures that provide interfaces to work with indexes and a view to see information about database monitors.
Plan Cache Services
These services include procedures to assist you in performing database administration (DBA) and database engineering (DBE) tasks.
Utility Services
These procedures provide interfaces to monitor and work with SQL in jobs on the current system or to compare constraint and routine information across systems.

Parent topic: Database performance and query optimization