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

[ Back to top | Database and File APIs | APIs by category ]