How to turn on OR logging?

karthi_gana · Post by **karthi_gana** » Fri Mar 02, 2012 5:48 am

All,

I have ganthered enough information about RTLogging and ORLogging. I have verified my DSParams file too.

It has the below details.

RTLogging=1
ORLogging=0

now...my question is if i want to turn on ORLogging, do i need to just change the value from 0 to 1? or is there any option available in the job property window? i don't think so.

if i enabled the ORLogging, where i can see the log details? say for example, for RTLogging, I can see the log in RT_LOGXXXX table like that for ORLogging where i can see the log?

shall i maintain as below in my project?

RTLogging=1
ORLogging=1

is it possible?

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 02, 2012 6:20 am

In what scenario you would need the logs stored in 2 places? Hence I think it should not be the case when you mark both variables as 1 and even though it allows it, you should not use that. Hope someone gives the answer to what happens if you set both to 1 but should be mutually exclusive. Have you tried it?

ORLogging enables datastage to store the logs in xmeta and yes it is done by changing just these two environment variables.

chulett · Post by **chulett** » Fri Mar 02, 2012 7:36 am

While I agree that I don't see turning both 'on' as a good idea, it's obvious they've allowed for that because there are two separate variables that control it. If they wanted to ensure it was always one or the other, they would have used a single variable. One would certainly hope so, anyway.

From what I recall, the logs stored in XMETA are viewed from the console.

karthi_gana · Post by **karthi_gana** » Tue Mar 06, 2012 1:48 am

How should i view the XMETA database from console?

ray.wurlod · Post by **ray.wurlod** » Tue Mar 06, 2012 3:02 pm

Administration tab, Log Management menu, Log View option.

karthi_gana · Post by **karthi_gana** » Tue Mar 06, 2012 10:45 pm

which tool? Datastage Designer or Datastage Administrator or "Console for IBM Information Server".

kmsekhar · Post by **kmsekhar** » Wed Mar 07, 2012 12:06 am

In "Console for IBM Information Server"...

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2012 12:19 am

Wrong. Console for IBM InfoSphere Information Server supports Information Analyzer and Information Services Director. The one you want is Web Console for IBM InfoSphere Information Server and you will require sufficient privileges to view the logs (granted through Information Server roles and DataStage and QualityStage project roles).