Tuesday, 5 April 2016

Truncating Logs with the pmrep TruncateLog Command


Truncating Logs with the pmrep TruncateLog Command 

You can use the pmrep TruncateLog command to truncate workflow and session logs in the PowerCenter repository. 

The command returns "truncatelog completed successfully" or returns "Failed to execute truncatelog." 

The truncate operation might fail for the following reasons: • The folder name is not valid. •
 
The workflow does not exist in the given folder. • You specified a workflow, but no folder name.

 The TruncateLog command uses the following syntax: truncatelog -t [-f ] [-w ]

Step 1 : 
 pmrep connect -r ******** -d ******* -n ********* -x ***********

Step2 :  pmrep truncatelog -t 200

Truncatelog command purges the log information in below listed tables 

OPB_DTL_SWIDG_LOG
OPB_PERF_COUNT
OPB_SESS_TASK_LOG
OPB_SWIDGINST_LOG
OPB_TASK_INST_BRK
OPB_TASK_INST_RUN
OPB_WFLOW_CACHE
OPB_WFLOW_DEP_RUN
OPB_WFLOW_RUN

No comments:

Post a Comment