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|
- 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.