Optimize 10.7 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Purging Data from Optimize Database Components | Viewing Purge Operation Events
 
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