Search found 251 matches
- Thu Oct 25, 2007 10:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job finishes ok but does no work
- Replies: 4
- Views: 2358
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...
- Thu Oct 18, 2007 9:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cant use $PROJDEF in a Parameter Set
- Replies: 4
- Views: 2351
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
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
- Sun Oct 07, 2007 6:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No OCI stage in v8 Parallel job
- Replies: 9
- Views: 3433
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 ...
- Sat Oct 06, 2007 9:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling Null in Load Utility
- Replies: 2
- Views: 1040
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...
- Fri Oct 05, 2007 11:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No OCI stage in v8 Parallel job
- Replies: 9
- Views: 3433
OCI Load vs. Dynamic RDBMS vs. Oracle Enterprise
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...
- Tue Oct 02, 2007 8:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cant use $PROJDEF in a Parameter Set
- Replies: 4
- Views: 2351
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...
- Tue Oct 02, 2007 5:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cant use $PROJDEF in a Parameter Set
- Replies: 4
- Views: 2351
Cant use $PROJDEF in a Parameter Set
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...
- Fri Sep 28, 2007 8:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No OCI stage in v8 Parallel job
- Replies: 9
- Views: 3433
- Thu Sep 27, 2007 6:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No OCI stage in v8 Parallel job
- Replies: 9
- Views: 3433
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...
- Wed Sep 26, 2007 11:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No OCI stage in v8 Parallel job
- Replies: 9
- Views: 3433
No OCI stage in v8 Parallel job
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...
- Wed Jul 25, 2007 2:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Automation of job schedule without director usage
- Replies: 10
- Views: 4573
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...
- Thu Jul 05, 2007 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: When does DS issue RDBMS commits
- Replies: 2
- Views: 1027
When does DS issue RDBMS commits
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 -...
- Fri Mar 09, 2007 12:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error while Calling SP from OCI Stage
- Replies: 18
- Views: 4458
- Fri Mar 09, 2007 12:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: last date of the prior month
- Replies: 5
- Views: 3306
- Thu Feb 22, 2007 9:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: incremental loading
- Replies: 6
- Views: 3456