DSXchange

FYI: I experienced this error too and found that the Oracle Connector throws this error if it can't match up a column to the actual data. For the same problem, the Oracle Enterprise stage, however, throws a much more meaningful error that says "Could not find input field 'mycolumnname'". i...

We are investigating the same. Does anyone have an experience with this?

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...

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...

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...

Sorry for the delay in responding, as I just saw this when I was browsing for another topic. I do not get email notifications.

To answer your question, we are currently running Oracle 10g on Unix. The setting that I referred to which fixed our problem is on the Datastage (Windows) server.

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...

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 ...

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...

Thanks, this is all good stuff! With our EE 8.1, I'm finding that if DSParams is set such that RTLogging=1 & ORLogging=0, then the logs are ONLY available via Director and not via the Web Console. On the other hand, if RTLogging=0 and ORLogging=1, then the logs are only visible via the Web Conso...

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...

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...

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...

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...

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...