Db2-supplied user tables
You or certain tools might create user tables that are supplied with Db2 on your Db2 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 Db2 11 is running in new-function mode, and that your application is running with the application compatibility value of 'V11R1'.
- Availability of new function in Db2 11
-
The behavior of data definition statements such as CREATE, ALTER, and DROP, which embed data manipulation SQL statements that contain new capabilities, depends on the application compatibility value that is in effect for the application. An application compatibility value of 'V11R1' must be in effect for applications to use new capability in embedded statements such as SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, and SET assignment-statement. Otherwise, an application compatibility value of 'V10R1' can be used for data definition statements.
Generally, new SQL capabilities, including changes to existing language elements, functions, data manipulation statements, and limits, are available only in new-function mode with applications set to an application compatibility value of 'V11R1'.
Optimization and virtual storage enhancements are available in conversion mode unless stated otherwise.
SQL statements can continue to run with the same expected behavior as in DB2® 10 new-function mode with an application compatibility value of 'V10R1'.