DSXchange

Hi, There is a job, in which 9 hash files are used as lookup. Couple of hash files are static and few of them are dynamic. All the dynamic hash files are very small except one. This job usually takes less than a minute to process 5 to 10K records but yesterday's run the job was running for more than...

When this error occurred? What is your source? Are you encountering this error while loading into target table?

Pls give us more info, which would help everyone to understand the problem and suggesst solution based on that.

Regards
Saravanan

Can you check the non-nullable column values, whether they contain null values. This error is causing somewhat related to NULL handling in any one of the file if my memory works correctly.

Check column metadata in the input and output whether they have same nullablity property set.

Regards
Saravanan

What is the join operation that you are doing in the Merge stage.

It seems to me, key columns in the input/output having null values so pls check the key columns in the input whether they have null values.

HTWH.

Regards
Saravanan

Pls read Page No 242 in Parallel job developer's guide to understand more.

Regards
Saravanan

Hi qmbs, Can you share with us how the problem was resolved so that everyone else will get benefit while searching the forum for these kind of problems. I would suggesst you to separate the topic if this is considered as a separate issue. Are you doing any conversion/transformation in the transforme...

Hi Siva,

I had faced the same problem in my previous project. This error due to the size of memory allocated to sort operation in DB2 database. As Ogmios mentioned, DBA is able to fix this issue by increasing the memory for sort operation.

HTWH.

Regards
Saravanan

We use Remove Duplicate stage to eliminate duplicates and what we have done was to transform the null value and submit the result set to RD stage and that would eliminate duplicates in the mentioned key column. So i would suggest you to handle null before submitting the results to RD stage. HTWH. Re...

Hi, I think this error was caused due to the characters that were not able to identify the NLS settings that was defined in the job. '??' seems to me, as Arnd mentioned the defined NLS setting not able to convert the input characters in the source. Pls check your input to identify the invalid charac...

Yes. This can be done using aggregator stage but your input should be loaded first into hash file and then aggregator then do the count(3rd column) group by 1,2. While loading into hash file, define all three columns as key and read from hash file and change the keys (key would be the first two colu...

Yes. Ray is right(always). In order to verify the no of rows in the hash file, just execute 'select count(*) from the hashfile' that would give you the no of rows in the hash file. Pls keep in mind that you may need to establish the pointer to the hash file if it the file is created in the folder ot...

In order to configure DB2 plug-in, you need to do the following as of my best knowledge. 1. Install DB2 client in DS server. 2. Configure DB2 in DSENV file. DB2 libraries and binary folder (Look at the PDFs and this configuration is clearly mentioned in that) in the library path. The Shared library ...

The job should not fail due to the same lookup referenced different instances of the same job. And the target file names should be taken care of if the same file is created in both instances.

Regards
Saravanan

Maximum customer id file should have a key column, which can be dummy column and get maximum customer id based on this dummy column. And Dummy column should exist in the Customer input as well and the value for this dummy column should be the same in Customers input and lookup so that maximum custom...

Siebel components need to be installed in the DataStage server and client if you access Siebel thru Siebel Pack as you would need design and run time information required to talk to Siebel.

HTWH.

Regards
Saravanan