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:
- LMDATE
- LMTIME
- LMTSOID
- LMSQLID
- LMACTN
- LMENVIRO
- LMMODE
Skip this SQL if these columns exist.
- RAADDL3A
- This member contains SQL that changes multiple objects:
- It contains an ALTER statement to add the IXTIME column to the Q.OBJ_ACTIVITY_DTL
table.
- It drops the index on this table and creates the index to include
the IXTIME column.
- The FACTN, LACTN, and LMACTN columns in Q.OBJ_ACTIVITY_SUMM
are redefined with FOR BIT DATA by updating their column definitions
in SYSIBM.SYSCOLUMNS.
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:
- DATAOUT_LRECL
- DATAIN_LRECL
- REPORT_LRECL
- NUM_REPORT_FILES
Skip this SQL if these columns exist.
