Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Related topic

Performance-Advisor-reference

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*