DB2-supplied user tables

You or certain tools might create user tables that are supplied with DB2® on your DB2 10 for z/OS® subsystem.

Supplied user tables enable you to capture information about data access by using the EXPLAIN function, to monitor query and system performance with monitor profiles, and to limit the use of resources by particular applications or middleware servers by using the resource limit facility. Instances of these tables also enable optimization tools to capture, analyze, and store information about query performance.

This information assumes that your DB2 subsystem is running in DB2 10 new-function mode.

Availability of new function in DB2 10: Generally, new SQL capabilities, including changes to existing functions, statements, and limits, become available only in new-function mode, unless explicitly stated otherwise. Exceptions to this general statement include optimization and virtual storage enhancements, which are also available in conversion mode unless stated otherwise. In DB2 Version 8 andDB2 9, most utility functions were available in conversion mode. However, for DB2 10, most utility functions become available in new-function mode.