Views:

Several of the Provance Web Services and connectors log their activity into the PMDB.Job and PMDB.Log tables. Theses tables are very useful as a troubleshooting tool. Over time these tables will continue to grow. Eventually contributing to the growth of the Provance Database.

There is no built in mechanism to groom these tables.

Resolution:

The PMDB.Job and PMDB.Log tables must be manually truncated. The following SQL Statements will help to accomplish the grooming. The intermediate step is to back up the two tables to backup tables that will not continue to grow.

Select * from PMDB.Job

Select * from PMDB.Log

 

Select * into Bakup_<date>_PMDB_Job from PMDB.Job

Select * into Bakup_<date>_PMDB_Log from PMDB.Log

 

Select * from Bakup_112216_PMDB_Job

Select * from Bakup_112216_PMDB_Log

 

Truncate table PMDB.Log

Truncate table PMDB.Job

 

Alternately, you may wish to groom all records/entries before a specific time/date:

Select * from PMDB.Job

Select * from PMDB.Log

 

Select * into Bakup_112216_PMDB_Job from PMDB.Job where StartTime <= '2016-11-23'

Select * into Bakup_112216_PMDB_Log from PMDB.Log where StartTime <= '2016-11-23'

 

Select * from Bakup_112216_PMDB_Job

Select * from Bakup_112216_PMDB_Log

 

Delete from PMDB.Log where StartTime <= '2016-11-23'

Delete from PMDB.Job where StartTime <= '2016-11-23'