DB2 graphic QMF Version 8

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:
  1. Change 'SSID' to the ID of the DB2 subsystem in which you are installing.
  2. 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:
  1. Change 'SSID' to the ID of the DB2 subsystem in which you are installing.
  2. 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.


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