DSXchange

Hi Everyone,

The issue got resolved by changing the transaction isolation level to Read Uncommitted in the source DRS stage (DB2 database on AS400).

Thanks to everyone for sharing the knowledge..

Hi, Ray -- For one job the size of each row is 1100 bytes and for the other the size is 500 bytes. Chulett-- Sorry i have rechecked again the job by running with the Source DRS stage array size as 1 and target drs stage ( SQL server) with array size as 1 and transaction size as 10000 and 50000... In...

Thanks for the reply.

What is VLIST. and how it can be implemented in my scenario as

Thanks

Hi

Thanks for the reply. i searched the forums. But the other threads were different from my error.
We are moving to new server. We face this issue only in 3 of 2500 jobs.

So I am eager to know that whether this can happen across the project in the future.

Thanks

Hi All i ma getting the following error after I reset the abnormal termination in one of the job DataStage Job 1062 Phantom 12580 jobnotify: Unknown error 911 DataStage Phantom Finished. DataStage Job 1062 Phantom 12585 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run mac...

Hi Chulett, I tried by tweaking the array size and transaction size . Array size as 128 , Transaction size as 0 --- Job aborted with Heap allocation message. Array size as 1 and transaction size 50000 -- job aborted with same error. Array size as 1 and transaction size 10000-- job ran successfully.....

Thanks Chulett for you reply,

As per my understanding, you dont want me to change the transaction size and isolation level . So transaction size of 10000 is fine right?

Can you suggest what values need to play with the array size..( Not greater than 128 or 256)

Hi , I have a simple job that extracts data from db2 database and loads in to sql server. The job design is source drs stage ---> copy stage ---> target drs stage (SQLserver) and from copy stage ---> aggregator --> audit table.(In aggregator iam taking count of source records). The job is processing...

Hi ,

The Stp stage is working and no need to continuously import metadata
By forcing it to use a parameter even though the stored proc does not need one.

Thanks for everyone sharing the knowledge and iam marking the topic as resolved.

Hi, Iam posting the same issue i got with the network underflow buffer problem. i have searched the forum but still iam lost on this. I have a job source from db2 database .... flows through copy stage .. from copy stage one link to target sql server database and one more link from copy stage to agg...

Jobs are in the right state. They are compiled

Sure will do this.
i migrated the jobs for the first time to production

Hi All I am running a job sequence in two different environments (Integration and Production). In integration its runing fine, but in production its failing with error code=-1 "Controller problem: Error calling DSWaitForJob(), code=-1 [Invalid JobHandle]" What this error code=-1 represents...

Hi Everyone, Below is the script which is used to get files from FTP share site. ***********************Script************* # name: GetFile.ksh # # purpose: # # Script to get files from FTP share site. # One control file is used # # /ds/etc/FTPPassword.ctl (text file in secured location) # # revisio...

Ok thanks Chulett..