Sometime
having too much logs stored in the metadata repository can be a reason behind a
jobs slow performance.
Periodic
log clearance would not only improve the performance but would keep the metadata
database healthy.
There are two ways to clear the job log:
1) by
setting the clear log property present on director client under Job menu. There
are options to choose from. You can purge the log just after the job run or
purge upto previous few runs or days or till particular date. This approach is
fairly simple can be performed by the developer having appropriate access
rights. This approach is also project dependent.
2) by
using the logging admin. Logging admin is a utility which can be executed on
the server from command prompt. following command can be executed from command
prompt in order to purge the logs:
Loggingadmin
-user <<admin user>> -password <<admin password>>
-create -schedule -name "DS Job log purge" -frequency -minutes 30
-threshold 10000 -percentage 100 -includecategories IIS-DSTAGE-RUN.
njoy the simplicity.......
Atul Singh
Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Tuesday, September 11, 2012
Clear the Job log in MetaData Repository
Labels:
Administration
,
DataStage
,
delete
,
logs
,
Metadata
,
remove
,
Troubleshoot
,
Unix
,
windows
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment