DB2 graphic QMF Version 8

Step 1b. Alter HPO Activity Log table

Skip this step if you are not using Manager.

Skip this step if you executed "Step 1a. Create database, table spaces, tables, and indexes."

Follow the instructions below to determine which DDL member in QMFHPO.SRAASAMP needs to be run.

RAADDL2A
This member contains ALTER statements that add the following columns to the Q.OBJ_ACTIVITY_SUMM table:

Skip this SQL if these columns exist.

RAADDL3A
This member contains SQL that changes multiple objects:

Skip this SQL if the IXTIME column exists and if the FACTN, LACTN, and LMACTN columns are defined with FOR BIT DATA.

RAADDL4A
This member contains ALTER statements that add the following columns to the Q.REPORTS table:

Skip this SQL if these columns exist.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004