Search found 16 matches
- Tue Aug 06, 2013 3:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ora-1406: Unusual problem
- Replies: 10
- Views: 11389
- Wed May 02, 2012 1:21 pm
- Forum: Data Integration
- Topic: Oracle GoldenGate and DataStage
- Replies: 2
- Views: 20289
Re: Oracle GoldenGate and DataStage
We are investigating the same. Does anyone have an experience with this?
- Mon Feb 07, 2011 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash partition key's datatype changes partition behavior?
- Replies: 4
- Views: 2985
I understand that the internal representation is different based on datatype, but shouldn't the partitioning be consistent no matter what datatype is chosen? For this test, I'm reading in from a sequential file and can have the data successfully converted between data types of my choosing. But I wou...
- Wed Feb 02, 2011 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hash partition key's datatype changes partition behavior?
- Replies: 4
- Views: 2985
Hash partition key's datatype changes partition behavior?
Hello, I'm running Datastage 8.1 FP1 on Windows Server 2003. I'm experiencing a behavior that the documentation does not mention and is different than I expect. When using the Hash partitioning method in a parallel transformer stage, record distribution across the nodes appear to be dependent upon t...
- Mon May 03, 2010 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Monitoring
- Replies: 4
- Views: 3307
We have a similarly sized Windows server (dual quad core, actually) and receive intermittent resource errors that are extremely difficult to reproduce/replicate. IBM support indicates job design every time, but I feel that it is the easiest answer for them to give. We run multiple invocations at a t...
- Tue Apr 20, 2010 10:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-21561: OID generation failed
- Replies: 2
- Views: 9631
- Fri Aug 21, 2009 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiplying large decimals rounds to ten decimals. Why?
- Replies: 2
- Views: 3564
Thank you, thank you, thank you! That little nudge in the right direction was all that I needed. I didn't know that there were environment variables in Admin that affected data sizes. I looked and saw the following environment variable: APT_DECIMAL_INTERM_SCALE Default scale for decimal intermediate...
- Thu Aug 20, 2009 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiplying large decimals rounds to ten decimals. Why?
- Replies: 2
- Views: 3564
Multiplying large decimals rounds to ten decimals. Why?
Hello, I have created a dummy job to test and demonstrate the following behavior (with no other logic to complicate things) and am hoping someone can explain the behavior that I am experiencing. I have two Decimal(16,15) values coming in from a text file that I need to multiply together, and need a ...
- Thu Jul 09, 2009 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ability to view logs in Director but not start/stop jobs?
- Replies: 10
- Views: 6889
If RTLogging=1 and ORLogging=0 the logs will be available in both Director and via the Web Console. If RTLogging=0 and ORLogging=1 only via DS Director ..... In your second sentence, do you really mean Web Console? Here's what's odd. Like I said, our Test environment has RTLogging=1 and ORLogging=0...
- Thu Jul 09, 2009 7:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ability to view logs in Director but not start/stop jobs?
- Replies: 10
- Views: 6889
- Wed Jul 08, 2009 2:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ability to view logs in Director but not start/stop jobs?
- Replies: 10
- Views: 6889
Ability to view logs in Director but not start/stop jobs?
Hello, Running Datastage 8.1 Enterprise Edition on Windows 2003. I've seen in the Administrator Client Guide that the two user roles with access to the Director Client (Operator & Super Operator) both allow jobs to be started/stopped. We would like, for SOX reasons, the ability for certain staff...
- Thu Jun 25, 2009 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-21561: OID generation failed
- Replies: 2
- Views: 9631
ORA-21561: OID generation failed
Hello, I wanted to share a solution to a problem that used to be happening for us. I saw one other user on here who was having the same issue, but had not found a resolution up to this point. We are running Datastage Enterprise 8.1 on Windows Server 2003 and were receiving the following error messag...
- Tue Jun 16, 2009 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Stage Error Regarding Oracle Table Partition
- Replies: 1
- Views: 2960
ODBC Stage Error Regarding Oracle Table Partition
Hello, I'm running a parallel job on IBM WebSphere DataStage Enterprise Edition 8.1.0.4987 against a partitioned table on Oracle. The job runs fine when the destination (output) ODBC database stage is set to an Execution Mode of "Sequential". But when it is set to "Auto (Parallel)&quo...
- Tue Feb 05, 2008 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CPU usage by job processes
- Replies: 7
- Views: 7440
Yes, the read cache is enabled on each of the hashed file stages. The final target destination is a sequential file local to the datastage box, as to eliminate any network or database activity whatsoever. This is the configuration that I have been testing in. Do you have any thoughts as to whether t...
- Mon Feb 04, 2008 5:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CPU usage by job processes
- Replies: 7
- Views: 7440
Hello, Thanks for your response! I ran the performance statistics on the job as-is, and it appears that most of the cpu time is occurring on not the hash lookups, but rather, on the transformer, where many routines, functions, and miscellaneous if-then logic are occurring to transfrom practically ev...