DB2 for i Services

There are many system-provided views, procedures, and functions.

These are grouped in the following categories.

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.
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