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 |