Event log table requirment through datastage

[pran.praveen]

Hi all,
We need to create a event table which captures information of each event for each job which happens during running of job. The table(EVENT_LOG) will have below columns.
1)Event_code(text)
2)Event_type_txt(1) example:-Error,Warning, information
3)Event_message example :-message from code
4)Object_code example:- hard coded to file name or table name(source)
5)PK_field_name example: PK field name of source file or table
6)PK_field_value example : value of PK which caused the event
7)SRC_field_name example: secondary column which caused the event
8)SRC_Field_value example: column value which cause event may be a look up failure
9)Data_Record example:Actual record which caused the event.It should be same as what is in source.

is there any ways this can be done in Datastage. any suggestion where in we can create any other table to which can materialize this table.

[ray.wurlod]

What (precisely) do you mean by "event" here?

[qt_ky]

It seems like DataStage used to have an option defaulted at version 8.0 or 8.1 to log the job log details into the XMETA database and it caused terrible performance problems. That option is probably still available for you to turn on if you dare.