Viewing Purge Operation Events
The OPERATION_LOG table contains logging data on purge execution. You can use the information in this table to track the performance of and troubleshoot the purge operation.
Optimize purges this table based on the value you set in the OPERATION_LOG parameter of the OPERATION_PARAMETER table. For more information, see Setting Purge Operation Parameters.
The following table is a sample OPERATION_LOG table.
| LOG _ID | OPERATION _CD | PROCEDURE _NAME | RTN_ STATUS _CD | EVENT_TEXT | CTRL_ INSERT_DT | CTRL_ UPDATE_DT |
|---|---|---|---|---|---|---|
| 2427 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Waiting for jobs to
complete
|
5/8/2005 9:28:56
PM
|
5/8/2005 9:28:56
PM
|
| 2428 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
START MASSIVE_DATA
_PURGE
|
5/8/2005 9:28:58
PM
|
5/8/2005 9:28:58
PM
|
| 2429 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Removed 0 stale
jobs
|
5/8/2005 9:30:02
PM
|
5/8/2005 9:30:02
PM
|
| 2430 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Creating CD job for
table OPERATION _LOG
|
5/8/2005 9:31:00
PM
|
5/8/2005 9:31:00
PM
|
| 2431 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Dropping foreign keys
related to tables being purged
|
5/8/2005 9:33:00
PM
|
5/8/2005 9:33:00
PM
|
| 2432 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Sending jobs to queue
for processing
|
5/8/2005 9:35:23
PM
|
5/8/2005 9:35:23
PM
|
| 2433 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Job FullInsertJo
bMgmt.FullIn sertJob('BAM _FACT_STEP_M ETRICS_V1...
|
5/8/2005 9:36:43
PM
|
5/8/2005 9:36:43
PM
|
| 2434 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Registering alert:
BAM_FACT_MTR CS_V1/319832 8093
|
5/8/2005 9:40:06
PM
|
5/8/2005 9:40:06
PM
|
| 2435 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Waiting for jobs to
complete
|
5/8/2005 9:41:26
PM
|
5/8/2005 9:41:26
PM
|
| 2436 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
Executing DDL: CREATE
INDEX "BMFCTSTPMTR CSV1DD_IX_ X"...
|
5/8/2005 9:53:16
PM
|
5/8/2005 9:53:16
PM
|
| 2437 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
BAM_FACT_STE
P_METRICS_V1 rebuilt
|
5/8/2005 9:57:12
PM
|
5/8/2005 9:57:12
PM
|
| 2438 |
MASSIVE DATA
PURGE
|
MASSIVE_DA
TA_PURGE
|
0
|
END - All jobs have
completed * Start Time: 2005-08-05 09:28:58 PM...
|
5/8/2005 9:59:35
PM
|
5/8/2005 9:59:35
PM
|