The LOADLOG table
The LOADLOG table contains the information you need to access and manage the performance data.
| Column name | Data type | Key | Description |
|---|---|---|---|
| LL_ID | INTEGER | P | Unique LOADLOG ID |
| LL_INSERTEDBY | VARCHAR(8) | User ID of the user who inserted the data | |
| LL_STARTTS | TIMESTAMP | Date and time of the first event recorded | |
| LL_STOPTS | TIMESTAMP | Date and time of the last event recorded | |
| LL_LOADTYPE | CHAR(10) | Load type:ACCOUNTING, STATISTICS |
Each row in the table is associated with a LOAD step
executed by the OMEGAMON® Collector and
has a unique LL_ID. This LL_ID is referenced by an Accounting or a
Statistics table with its foreign key STEPLOGID, which is defined
with delete rule ON DELETE SET NULL. If you delete a row from the
LOADLOG table, the column STEPLOGID of the dependent rows is set to
NULL. To delete data from the DB2PM_STAT and DB2PMSACCT tables:
- Determine the entries using the LOADLOG table and apply a search condition on the STEPLOGID column in the DELETE statements.
- Delete the corresponding LOADLOG entries.
The LOADLOG entries related to the LOAD steps are displayed under Time setting on the View SQL page of the Query Execution window and on the Options page of the Rules-of-Thumb Analysis window. They help you restrict your queries and rules of thumb to the time intervals during which data was loaded.