Performance Advisor SAMP members
Several members of the SAMP library help you set up and maintain your PADB tables.
These samples can be customized to your environment by using the administrative option to generate a PADB starter set as described in Setting-up-the-Performance-Advisor-database.
For more information, see the description for each member in the Performance Advisor samples table.
SAMP member | Description |
|---|---|
DMDBMERG | Sample job to generate data for Performance Advisor tables |
DMDBMERN | Sample job to generate data for Performance Advisor tables |
DMDBMERP | Sample job to generate data for Performance Advisor tables |
DMDBRTSU | Sample job to generate unload and load statements for real-time stats |
INSCACT | Corrective action inserts for DASD MANAGER PLUS tables |
INSOBJS | Insert object sets for DASD MANAGER PLUS tables |
INSTHRSH | Insert thresholds for DASD MANAGER PLUS tables |
IODGDG | Creates generation data groups |
IODPAREO | Sample job to run Apptune REORG advisor |
IODRPTLD | Sample job to run reports from Apptune DB2LOAD data |
PACOLMNS | Column definitions for Performance Advisor tables |
PAMIGRB1 | Sample job to migrate from version 11.1 of Apptune |
PAMIGRB2 | Sample job to migrate from version 11.2 of Apptune |
PAMIGRDO | Sample job to describe how to migrate from an earlier version of Apptune |
PAPARTOS | Sample job to convert OBJ_STATISTICS tables to partitioned |
PAPARTSO | Sample job to convert STMT_OBJ tables to partitioned |
PAPARTSS | Sample job to convert STMT_STATISTICS tables to partitioned |
PAPARTSU | Sample job to convert STMT_SUMMARY tables to partitioned |
PAPARTWS | Sample job to convert WKLD_STATISTICS tables to partitioned |
PAREADME | Sample job to describe PADB Starter library contents |
PARTSUC1 | Updates historical RTS tables in a centralized PADB |
PARTSUC2 | Updates historical RTS tables in a centralized PADB |
PARTSUL | Updates historical RTS tables in a localized PADB |
PASETUP | Creates tables with Apptune data you specify |
QUERIES | Sample SQL queries to be run against Performance Advisor tables |
TRIGEXCP | Sample job to run BMCSTATS |
TRIGFORC | Sample job to run BMCTRIG |
Related topic