DSXchange

I know it's an old thread, but I'll throw my support in as well. This is happening to us on 8.0 as well. We have a number of small multi-instance administrative Server Jobs where this happens. We also have some multi-instance Parallel jobs, but we do not experience the same problem. We don't have an...

Turns out it is a bug.

Resolved in fixpak 1 for all platforms except SUSE Linux

This is the link for fixpak 1 http://www-1.ibm.com/support/docview.wss?uid=swg24017220

Did some very quick 'n' nasty testing using Oracle Enterprise to perform parallel SELECT. Sadly my 1-proc windoze Oracle server is not really up to the task, so the results are - again - inconclusive. Once again though, some interesting things to note. Parallel Unload with Oracle Enterprise Stage I ...

Datastage should not be that much slower than native RDBMS tools. What database are you using? If you were using Oracle (for example) you could load using SQL*Loader, directing it to trim trailing spaces. Since Oracle does not support the ANSI empty-string-different-to-null concept, the resultant em...

Here's an interim update on Oracle Enterprise stage. I haven't done a heap of benchmarking, but I have some interesting points: General As Vincent pointed out Dynamic RDBMS gives you all of the Oracle OCI stuff you know and love. I've run some tests and it appears to work exactly the same as well. D...

Thanks Craig, thought I'd try here first to see if I was doing something stupid (again). @lstsaur, not sure what you mean. $ODMORASID is the name of the parameter - it's an Environment Variable Parameter within the Parameter Set ODM . I'm pretty sure I have constructed the reference correctly in the...

The runtime environment variable default $PROJDEF does not appear to work when the parameter is part of a parameter SET. Here's what I did: Create an environment variable $ODMORASID in Administrator and give it a value of XYZ Create a Parameter Set ODM including the $ODMORASID variable. Set the defa...

It's all starting to come together! Enterprise stage requires SELECT privs on a bunch of data dictionary tables including DBA_EXTENTS. My bet is that - when you use the "Table" SQL Type - it looks up the starting and ending block address of each extent in DBA_EXTENTS, and farms out ROWID R...

Ray, we found OCI in the repository tree - under SERVER stages. We cannot drag it into a Parallel Job though. Good tip to know though, thanks. Vincent, found the OCI Load stage under Parallel Stages (same as yours), but I doubt this will give us anything the Oracle Enterprise stage cannot - probably...

I'm a former 7.5.1A Server developer. We've just installed an evaluation version of DSv8 for a new project and I'm sussing out the differences. We can only see the Oracle OCI stage in the palette for Server jobs, and the Oracle Enterprise stage for Parallel jobs. The doco doesn't say that OCI is ser...

If you have a one-off non-standard scheduling requirement, you can just schedule it to run every day, and call a Server Routine as the first step in the sequence to work out whether it should run or not. Then you create a conditional link to the rest of the sequence that only runs when the SR succee...

Apols for an easily tested question, but I don't have an instance of DS at the moment to test it on. If you have a job with multiple pipelines, does an OCI stage perform its final commit immediately after the last row / after-SQL is processed, or does it wait until the end of the job. OCI ----> TX -...

Is it the ONLY command in the BEFORE SQL tab?

Get the day of the month (should be possible with oconv) and then subtract that number for the date.

I think the CDC triggers/packages are a 9i thing, and 10g does it straight from the logs. Never used it, so can't swear on it.