how to oount no of warning messages

[singhald]

Hi all,


I need to count the no of warning messages which present in the datastage director for the current job run.

Please suggest me some way to count the warning messages.

Regards

[ray.wurlod]

Code: Select all

dsjob -logsum Project Job | grep WARN | wc -l

Code: Select all

SELECT COUNT(*) FROM RT_LOGnnn WHERE SEVERITY = ('Warning' OR SEVERITY = 'Fatal') AND TIMESTAMP >= 'yyyy-mm-dd hh:mm:ss';

where nnn is the job number and yyyy-mm-dd hh:mm:ss is the start date/time of the job.

[singhald]

dsjob -logsum -type WARNING DSProjectName DSJobName | grep "WARNING" | wc -l

i used this command , but it is count the warning which generated in previous run also.

Thanks

[ray.wurlod]

Then use more filtering, on timestamp!