-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Thursday, October 16, 2003 10:24 AM
To: datastage-users@oliver.com
Subject: log entries
Is there a way to clear the log files for an entire project through
Administrator, other than at the job level through Director?
Any suggestions appreciated.
Regards,
Doris
log entries
log entries
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
log entries
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Thursday, October 16, 2003 10:36 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Yes, there are some.
- Every log is a hash-file and you can send a SQL-Skript to it. You can
clear this hash-file, but you should keep some lines. I think Ray will
answer to it later an tell you the correct command or you make a search on
http://www.dsxchange.com, because this is a regular question in this forum.
An other way is to export all Jobs of a project, delete all Jobs and
reimport them.
We in our company have all logfiles set in that manner, that all entries but
those of the last run are deleted (via Director)
Wolfgang
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Thursday, October 16, 2003 5:24 PM
To: datastage-users@oliver.com
Subject: log entries
Is there a way to clear the log files for an entire project through
Administrator, other than at the job level through Director?
Any suggestions appreciated.
Regards,
Doris
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Thursday, October 16, 2003 10:36 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Yes, there are some.
- Every log is a hash-file and you can send a SQL-Skript to it. You can
clear this hash-file, but you should keep some lines. I think Ray will
answer to it later an tell you the correct command or you make a search on
http://www.dsxchange.com, because this is a regular question in this forum.
An other way is to export all Jobs of a project, delete all Jobs and
reimport them.
We in our company have all logfiles set in that manner, that all entries but
those of the last run are deleted (via Director)
Wolfgang
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Thursday, October 16, 2003 5:24 PM
To: datastage-users@oliver.com
Subject: log entries
Is there a way to clear the log files for an entire project through
Administrator, other than at the job level through Director?
Any suggestions appreciated.
Regards,
Doris
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
log entries
-----Original Message-----
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Thursday, October 16, 2003 11:08 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Doris
Log files are simple. You can read them with dsjob, SQL or in BASIC.
When clearing do not clear the records that start with "/". If you
process in BASIC then they put %s and other macros which get substituted
with the job name by other DataStage processes like DSR_MESSAGE. A log
file is RT_LOG27 if the job number is 27. The job number is stored in
DS_JOBS. The key to DS_JOBS is the job name. The easiest way to process
the log file is probably in SQL.
SELECT * FROM RT_LOG27;
You can do this in BASIC or from a shell script like:
uvsh "SELECT * FROM RT_LOG27;" >>log.txt
To clear:
DELETE FROM RT_LOG27 WHERE EVAL "@ID" NOT LIKE '/...';
Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Thursday, October 16, 2003 9:36 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Yes, there are some.
- Every log is a hash-file and you can send a SQL-Skript to it. You can
clear this hash-file, but you should keep some lines. I think Ray will
answer to it later an tell you the correct command or you make a search
on
http://www.dsxchange.com, because this is a regular question in this
forum.
An other way is to export all Jobs of a project, delete all Jobs and
reimport them.
We in our company have all logfiles set in that manner, that all entries
but
those of the last run are deleted (via Director)
Wolfgang
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Thursday, October 16, 2003 5:24 PM
To: datastage-users@oliver.com
Subject: log entries
Is there a way to clear the log files for an entire project through
Administrator, other than at the job level through Director?
Any suggestions appreciated.
Regards,
Doris
From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com]
Sent: Thursday, October 16, 2003 11:08 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Doris
Log files are simple. You can read them with dsjob, SQL or in BASIC.
When clearing do not clear the records that start with "/". If you
process in BASIC then they put %s and other macros which get substituted
with the job name by other DataStage processes like DSR_MESSAGE. A log
file is RT_LOG27 if the job number is 27. The job number is stored in
DS_JOBS. The key to DS_JOBS is the job name. The easiest way to process
the log file is probably in SQL.
SELECT * FROM RT_LOG27;
You can do this in BASIC or from a shell script like:
uvsh "SELECT * FROM RT_LOG27;" >>log.txt
To clear:
DELETE FROM RT_LOG27 WHERE EVAL "@ID" NOT LIKE '/...';
Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com
-----Original Message-----
From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de]
Sent: Thursday, October 16, 2003 9:36 AM
To: datastage-users@oliver.com
Subject: RE: log entries
Yes, there are some.
- Every log is a hash-file and you can send a SQL-Skript to it. You can
clear this hash-file, but you should keep some lines. I think Ray will
answer to it later an tell you the correct command or you make a search
on
http://www.dsxchange.com, because this is a regular question in this
forum.
An other way is to export all Jobs of a project, delete all Jobs and
reimport them.
We in our company have all logfiles set in that manner, that all entries
but
those of the last run are deleted (via Director)
Wolfgang
-----Original Message-----
From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us]
Sent: Thursday, October 16, 2003 5:24 PM
To: datastage-users@oliver.com
Subject: log entries
Is there a way to clear the log files for an entire project through
Administrator, other than at the job level through Director?
Any suggestions appreciated.
Regards,
Doris
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.