Database Performance APIs
The Database Performance APIs are:
- Cancel Requested Statistics Collections (QDBSTCRS, QdbstCancelRequestedStatistics) cancels statistics collections that have been requested, but are not yet completed or not successfully completed.
- Clear SQL Database Monitor Statistics (QQQCSDBM) clears and frees the associated memory area of the database monitor statistics.
- Delete Statistics Collections (QDBSTDS, QdbstDeleteStatistics) deletes existing completed statistics collections immediately.
- Dump SQL Database Monitor (QQQDSDBM) dumps the SQL database monitor that has been gathered.
- End SQL Database Monitor (QQQESDBM) ends the memory-based SQL database monitor.
- List Requested Statistics Collections (QDBSTLRS, QdbstListRequestedStatistics) lists all of the columns and combination of columns and file members that have background statistic collections requested, but not yet completed.
- List Statistics Collection Details (QDBSTLDS, QdbstListDetailStatistics) lists additional statistics data for a single statistics collection not returned by the List Statistics Collections (QDBSTLS, QdbstListStatistics) API.
- List Statistics Collections (QDBSTLS, QdbstListStatistics) lists all of the columns and combination of columns for a given file member that have statistics available.
- Query SQL Database Monitor (QQQQSDBM) returns information about the activity of the SQL and the original database monitor.
- Request Statistics Collections (QDBSTRS, QdbstRequestStatistics) requests that one or more statistics collections for a given set of columns of a database file member be created.
- Start SQL Database Monitor (QQQSSDBM) starts the memory-based SQL database monitor.
- Update Statistics Collection (QDBSTUS, QdbstUpdateStatistics) updates the attributes and refreshes the data of an existing single statistics collection.
- Visual Explain (QQQVEXPL) is used to create a query graph that graphically displays the execution of an SQL statement