The following entries should be added to Table 11. Fields in the db2HistData
Structure:
Field Name | Data Type | Description |
---|---|---|
oOperation | char | See Table 12. |
oOptype | char | See Table 13. |
The following table will be added following Table 11.
Table 12. Valid event values for oOperation in the db2HistData Structure
Value | Description | C Definition | COBOL/FORTRAN Definition |
---|---|---|---|
A | add tablespace | DB2HISTORY_OP_ADD_TABLESPACE | DB2HIST_OP_ADD_TABLESPACE |
B | backup | DB2HISTORY_OP_BACKUP | DB2HIST_OP_BACKUP |
C | load-copy | DB2HISTORY_OP_LOAD_COPY | DB2HIST_OP_LOAD_COPY |
D | dropped table | DB2HISTORY_OP_DROPPED_TABLE | DB2HIST_OP_DROPPED_TABLE |
F | roll forward | DB2HISTORY_OP_ROLLFWD | DB2HIST_OP_ROLLFWD |
G | reorganize table | DB2HISTORY_OP_REORG | DB2HIST_OP_REORG |
L | load | DB2HISTORY_OP_LOAD | DB2HIST_OP_LOAD |
N | rename tablespace | DB2HISTORY_OP_REN_TABLESPACE | DB2HIST_OP_REN_TABLESPACE |
O | drop tablespace | DB2HISTORY_OP_DROP_TABLESPACE | DB2HIST_OP_DROP_TABLESPACE |
Q | quiesce | DB2HISTORY_OP_QUIESCE | DB2HIST_OP_QUIESCE |
R | restore | DB2HISTORY_OP_RESTORE | DB2HIST_OP_RESTORE |
S | run statistics | DB2HISTORY_OP_RUNSTATS | DB2HIST_OP_RUNSTATS |
T | alter tablespace | DB2HISTORY_OP_ALT_TABLESPACE | DB2HIST_OP_ALT_TBS |
U | unload | DB2HISTORY_OP_UNLOAD | DB2HIST_OP_UNLOAD |
The following table will also be added.
Table 13. Valid oOptype values db2HistData Structure
oOperation | oOptype | Description | C/COBOL/FORTRAN Definition |
B | F | Offline | DB2HISTORY_OPTYPE_OFFLINE |
N | Online | DB2HISTORY_OPTYPE_ONLINE | |
I | Incremental offline | DB2HISTORY_OPTYPE_INCR_OFFLINE | |
O | Incremental online | DB2HISTORY_OPTYPE_INCR_ONLINE | |
D | Delta offline | DB2HISTORY_OPTYPE_DELTA_OFFLINE | |
E | Delta online | DB2HISTORY_OPTYPE_DELTA_ONLIN | |
F | E | End of log | DB2HISTORY_OPTYPE_EOL |
P | Point in time | DB2HISTORY_OPTYPE_PIT | |
L | I | Insert | DB2HISTORY_OPTYPE_INSERT |
R | Replace | DB2HISTORY_OPTYPE_REPLACE | |
Q | S | Quiesce share | DB2HISTORY_OPTYPE_SHARE |
U | Quiesce update | DB2HISTORY_OPTYPE_UPDATE | |
X | Quiesce exclusive | DB2HISTORY_OPTYPE_EXCL | |
Z | Quiesce reset | DB2HISTORY_OPTYPE_RESET | |
R | F | Offline | DB2HISTORY_OPTYPE_OFFLINE |
N | Online | DB2HISTORY_OPTYPE_ONLINE | |
I | Incremental offline | DB2HISTORY_OPTYPE_INCR_OFFLINE | |
O | Incremental online | DB2HISTORY_OPTYPE_INCR_ONLINE | |
T | C | Add containers | DB2HISTORY_OPTYPE_ADD_CONT |
R | Rebalance | DB2HISTORY_OPTYPE_REB |