Clear Out Warehouse Builder Log Messages

 

Problem:

How does one clear out all Warehouse Builder log messages?

Solution:

Clear the contents of TRACE1, TRACE2, TRACE3 and JOBMSGS files. It is REQUIRED that a SAVSRVRINF be run prior to using this process. If any of the Warehouse Builder tables is inaccurate, the entire Warehouse Builder product data no longer works and is LOST!
Note: Replace SCSERVER with the name of your Showcase Server Library name in the steps below.

1.  End the ShowCase server (ENDSCSVR) to make sure no jobs are using these files using the following:

   WRKOBJLCK SCSERVER *LIB

2. Make sure there aren't any WB sets scheduled to run at that time. Remember WB jobs do not need the ShowCase server jobs to be active to run.
    
3. Run the SAVSRVINF against your ShowCase server. Be aware that these files contain the run statistics for ER jobs. Once cleared, that information will go away as well.

   Disclaimer: This process should only be used in scenarios where there is a major DASD concerns. These procedures have not been tested and therefore are not technically supported.

Commands to Run:

RMVPFTRG FILE(SCSERVER/TRACE1)

RMVPFTRG FILE(SCSERVER/TRACE2)

RMVPFTRG FILE(SCSERVER/TRACE3)

RMVPFTRG FILE(SCSERVER/JOBMSGS)

CLRPFM FILE(SCSERVER/TRACE1)

CLRPFM FILE(SCSERVER/TRACE2)

CLRPFM FILE(SCSERVER/TRACE3)

CLRPFM FILE(SCSERVER/JOBMSGS)

ADDPFTRG FILE(SCSERVER/TRACE1) TRGTIME(*BEFORE) TRGEVENT(*DELETE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE1) TRGTIME(*BEFORE) TRGEVENT(*INSERT) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE1) TRGTIME(*BEFORE) TRGEVENT(*UPDATE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE2) TRGTIME(*BEFORE) TRGEVENT(*DELETE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE2) TRGTIME(*BEFORE) TRGEVENT(*INSERT) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE2) TRGTIME(*BEFORE) TRGEVENT(*UPDATE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE3) TRGTIME(*BEFORE) TRGEVENT(*DELETE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE3) TRGTIME(*BEFORE) TRGEVENT(*INSERT) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/TRACE3) TRGTIME(*BEFORE) TRGEVENT(*UPDATE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/JOBMSGS) TRGTIME(*BEFORE) TRGEVENT(*DELETE) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/JOBMSGS) TRGTIME(*BEFORE) TRGEVENT(*INSERT) PGM(SCSERVER/SCTRIG)

ADDPFTRG FILE(SCSERVER/JOBMSGS) TRGTIME(*BEFORE) TRGEVENT(*UPDATE) PGM(SCSERVER/SCTRIG)

The Clear of the jobmsgs file is now complete.

Start your ShowCase Server (STRSCSVR) and verify Warehouse Builder