how to send datastage director log details to database

reddyamarnath · Post by **reddyamarnath** » Tue Aug 31, 2010 4:28 am

Hi All,

Is there any possibility that to send datastage director log details to database.If so how can i send the log details to database.currently iam using 8.1px and SQLserver is my database.

srinivas.g · Post by **srinivas.g** » Tue Aug 31, 2010 5:07 am

Use the below command to load the log detail in to file.From file use datastage job load the log detail in to database.

dsjob -logdetail PROJECT name JObname > filename.txt

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 31, 2010 6:19 am

Do you want selected logs or all of them ?

chulett · Post by **chulett** » Tue Aug 31, 2010 6:21 am

In other words you need to build a process to extract the log information you need and then load it to your target of choice. If you search here for ETLStats you'll find a free framework to do just that written by our friend Kim Duke, you can use or extend that.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 31, 2010 6:33 am

If you are planning to move all logs to tables, you can reset the installation method to write logs to tables.

chulett · Post by **chulett** » Tue Aug 31, 2010 6:37 am

Ah... if you just mean you want to store them in the XMETA repository rather than the 'old Universe RT_xxx tables, then yes that's a setting. Search here for RTLooging or ORLogging for the details.