Job Audit Logs

reddy · Post by **reddy** » Wed Mar 22, 2006 11:03 am

Hi Datastage gurus,

I have a question on designing of Job audit logs.

I have 8 jobs running in production but now i have a requirement like this :
I have to create a Oracle Audit_log table with columns source_tablename,source_count,target_tablename,target_count,run_date.

I created a Audit_log table like the above requirement.

All jobs using ODBC Table as a source and Oracle Table as a target.

Can you light on me how to design the jobs to load audit_log table after the original job ran ......

Thanks in advance.
Reddy

ray.wurlod · Post by **ray.wurlod** » Wed Mar 22, 2006 5:29 pm

You need a mechanism for determining these numbers. The DSGetLinkInfo() function can report the number of rows passed by DataStage, but - when there are errors - this may not be the same number as were processed successfully by Oracle. To differentiate Insert from Update your original job design will need to separate these rows.
Once you have these numbers (probably via a Routine that writes them into a temporary file) you can run a job that moves them from there into your Oracle "audit" table.

kduke · Post by **kduke** » Wed Mar 22, 2006 7:37 pm

Download EtlStats from my tips page. It will get you most the way there. You still need a table which will has the table names for each link name because EtlStats has row counts by job name and link name. You may have to build that manually. Otherwise hack the repository or pay Ray or Ken how to do it.