Redirectly job log to oracle db tables

getsatish_gk · Post by **getsatish_gk** » Thu Jul 10, 2008 11:22 pm

Hi ETLers,

Sinario is: i want to load the ds-job log(warnings) into a oracle table.
can anyone suggest how to achive this?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 10, 2008 11:30 pm

Search

getsatish_gk · Post by **getsatish_gk** » Thu Jul 10, 2008 11:42 pm

Thanks for that universal first option.. i do before posting it...

Most of them are dealing with warnings avoiding warning and etc...
but couldnt find how to redirect or write any ds-warning to an oracle table...

whether this is achieable with existing options or should go for routines
anythought?

mahadev.v · Post by **mahadev.v** » Fri Jul 11, 2008 12:35 am

Routines is your best option. In the online help of DataStage, search for sub routines that start with DS.

chulett · Post by **chulett** » Fri Jul 11, 2008 12:36 am

Then you're not searching the right search as there are tons of posts on extracting the log information and shoving it into another hiding place. They may not all deal specifically with just 'warnings' but the information is out there. I'm assuming the 'get out' part is the issue, not the 'put into Oracle' part.

For a routine-based solution, search for the various 'DSGetLog' functions:

DSGetLogSummary
DSGetLogEntry
DSGetNewestLogId

For a scripted solution, there are equivalents to all of these in dsjob which a search would also turn up:

dsjob -logsum
dsjob -logdetail
dsjob -lognewest

The former are in the online help, the latter in either of the Developer's Guides in the Command Line Interface chapter.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 11, 2008 1:06 am

Why not just get ETLstats, which does pretty much all you want and acts as a prototype for the remainder?