Statistics Manager APIs

 

The following APIs are used to implement the statistics function of iSeries™ Navigator.

• Cancel Requested Statistics Collections (QDBSTCRS, QdbstCancelRequestedStatistics) immediately cancels statistics collections that have been requested, but are not yet completed or not successfully completed.

• Delete Statistics Collections (QDBSTDS, QdbstDeleteStatistics) immediately deletes existing completed statistics collections.

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

• List Statistics Collections (QDBSTLS, QdbstListStatistics) lists all of the columns and combination of columns for a given file member that have statistics available.

• Request Statistics Collections (QDBSTRS, QdbstRequestStatistics) allows you to request one or more statistics collections for a given set of columns of a specific file member.

• Update Statistics Collection (QDBSTUS, QdbstUpdateStatistics) allows you to update the attributes and to refresh the data of an existing single statistics collection

 

Parent topic:

Collecting statistics with the Statistics Manager

 

Related reference

Viewing statistics requests