DSXchange

Thanks for your responses. Yes, our DSODB and XMETA databases are on the same Oracle instance. But separate schemas and tablespaces.

Hi, We are running DataStage 8.7 on AIX. Our Operations Database is on Oracle. We have one fairly large project (5000+ jobs) running mission critical parallel jobs 24/7. One of our departments would like to create a custom report/query against the ODB for monitoring purposes on a few of those jobs i...

Gotcha. Thanks.

Thanks all! Paul, yes, our developers are aware of the impact on multi-instance jobs. And most of our non-default purge settings at the job level are on these multi-instance jobs. I just need to get a handle on what these are set at. I will check Mr. Bland's site for his utility....or write a script...

Hi, I was wondering if there was a way to determine (query the xmeta repository?) what jobs in a given project have their job purge settings different than the project level settings. We currently have project level job purge settings to keep the previous two runs of logs. But I know that there are ...

Found the problem. The powers-that-be changed the following User Define Environment Variable for the project: DS_NO_INSTANCE_PURGING They changed it from "1" (don't purge) to "0" (purge). I changed it back and that seemed to do the trick. I will mark this as resolved. Thanks for ...

Thanks for responding. I am not talking about how ds purges log entries...I am talking about how many invocations you see when in Director's Status view. I ran 11 different instances of a paticular job, and while they were running, I say all 11 instances in the Status view. But then as they complete...

Hi, I have a set of multi-instance jobs. 11 invocations of these jobs are initiated via a loop in a shell scirpt. When we invoke all 11 instnaces of the job, I can see them all running in Director. But as they complete, some are removed from the Director log, and I only end up seeing 4 or 5 invocati...

Thanks Ray. That is what I thought, but just wanted to get confirmation from the experts. :D They are both set to Overwrite. But I am suspecting that something is amiss in our dev environment. They are small jobs, so I am going to rewrite the dev job from scratch and re-export to qa. I am going to m...

Hi, I have a job that APPEARS to be the same between our DEV and QA environments. I took a look at the generated OSH code and it is identical in both environments. I then took a look at the job score and noticed some differences. One that I would like to get to the bottom of is that the job score fo...

Understood. Thanks everyone!

That makes my derivation much simpler. Thanks!

Just curious what you (jonesv) are using for this - field, I assume. I don't understand your question. To extract everything after the "@" (after already validating that it does have an "@") I have this derivation is the stage var: Right(Trim(lnk_TestDataRead.EMAIL_ID),Len(Trim(...

Very true

Now why didn't I think of that :D

Makes perfect sense. Thanks!