Step 21. Initialize HPO Activity Log table
Skip this step if you are not using
Manager.
Follow the instructions below to determine which one of the listed
DML members in QMFHPO.SRAASAMP need to be run.
- RAADML2A
- Run this SQL if you ran RAADDL2A in "Step 1b. Alter HPO Activity Log
table." This SQL will initialize the new last-modified columns
in Q.OBJ_ACTIVITY_SUMM.
- RAADML2I
- Run this SQL if you executed "Step 1a. Create database, table
spaces, tables, and indexes," and if you are using QMF 3.1.1 or
earlier. You need to make the following changes to this member before
you run it:
- Change 'SSID' to the ID of the DB2 subsystem
in which you are installing.
- Include the single quotes and the value within the quotes must
be four characters long, for example, 'DB 2 '.
This SQL initializes Q.OBJ_ACTIVITY_SUMM with default values for all
QMF objects.
- RAADML3I
- Run this SQL if you executed "Step 1a. Create database, table
spaces, tables, and indexes," and if you are using QMF 3.2 or higher.
You need to make the following changes to this member before you
run it:
- Change 'SSID' to the ID of the DB2 subsystem
in which you are installing.
- Include the single quotes and the value within the quotes must
be four characters long, for example, 'DB2 '.
This SQL initializes Q.OBJ_ACTIVITY_SUMM with CREATED, LAST_USED,
and MODIFIED values from Q.OBJECT_DIRECTORY.
Note:
No initialization takes place for objects where
any of these columns contain a null value. Because of this, you
may want to replace null values in these columns with an initial
timestamp value before running RAADML3I.
