what is the advantage of audit logs in datastage

MURALI123 · Post by **MURALI123** » Wed Jul 01, 2009 6:43 am

Hi All,
Can any body help me what is the advantage of audit logs in datastage.

Thanks,
Murali

chulett · Post by **chulett** » Wed Jul 01, 2009 6:47 am

You really need to start doing a better job of asking questions here. What the heck do you mean by 'audit logs'? I for one prefer not to guess.

ArndW · Post by **ArndW** » Wed Jul 01, 2009 7:09 am

How can something that you cannot change be either an "advantage" or a "disadvantage"? This sounds suspiciously like an interview question asked by someone without DS knowledge. There is a DS_AUDIT "trial" for tracking job changes. There are job logs which could be construed as containing "audit" type of information (but that would require a very flexible approach to semantics).

ray.wurlod · Post by **ray.wurlod** » Wed Jul 01, 2009 4:24 pm

Yet another guess is that an audit log allows such things as row count reconciliation to be performed more easily.

But we really don't know what you mean?

IS is an interview question? If so, we might like "a word" with the author of that question.

MURALI123 · Post by **MURALI123** » Thu Jul 02, 2009 11:02 pm

Hi,
Is not a interview question to implement datastage projects how can do that?

Thanks,
Malli

ray.wurlod · Post by **ray.wurlod** » Fri Jul 03, 2009 12:09 am

How to do WHAT ?!!!

MURALI123 · Post by **MURALI123** » Fri Jul 03, 2009 1:05 am

In datastage how to implement the audit logs mechanisam

Thanks,
Malli

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 03, 2009 1:44 am

DataStage provides you information about count of rows processed with other information such as time taken, CPU utilized etc.

You can extend it further to extract and store in external media (i.e. outside DataStage) for audit.

If you plan carefully, you can also automate this with proper naming conventions.

Always easy to start...but difficult to follow.

Sreenivasulu · Post by **Sreenivasulu** » Fri Jul 03, 2009 2:24 am

You can also collect the number of rows passed in each link. Sometimes i found this is not correct. (when the job aborts)

Regards
Sreeni

chulett · Post by **chulett** » Fri Jul 03, 2009 6:31 am

MURALI123 wrote:In datastage how to implement the audit logs mechanism

When someone asks you to explain what you mean, you cannot simply repeat the same string of words over and over. You rephrase, you explain using different words, you go into details so people know what you need help with rather than having to guess or assume.

I for one, in my crotchety old age, am more and more disinclined to guess what the heck people may need help with. If it's unclear and the poster has been asked to clarify and that clarification doesn't come or is like pulling teeth, I'll move on.

Help us help you, people.

[/rant]