DSXchange

I am using a bulk load job having DB2 bulk stage which loads the rows very fast onto the target table but then it does not finishes and takes an hour after transferring all rows before it finally stops.

please advice. thanx a lot.

Hi, we are constantly facing this issue of scratch space full which causes our jobs to abort. We have around 15 jobs using the same scratch space ( 4 nodes) but out of these around 4 fail everyday. Please let me know of any posible solutions. Do i need a scratch cpace in another file system and use ...

Its Frequency Analysis buffer count to be exact. Raising this limit solved our problem once (processing huge file). Index buffer count and Report buffer count are some more of them.

Parameter like Buffer analysis count. Hey ray, is the description for these parameters availble anywhere. Basically what i am looking at is some document which tells me exactly what these parameters do.

there aer some buffers defined in advance run setting of a job which determine tha buffer size while the job runs..if these have not been set accordingly, that makes qualitystage job abort for huge data.

Our old QS match job now runs in a different server with less memory. Now we find that there are more matches than in the previous server. It's strane as if lesser memory effects the match data volume then it should fine lesser matches. Is there any parameters which i whould try and check? All other...

FTP solves the issue all right. but what if the two servers are unix and windows. FTP takes a lot of time to do this.
is there any alternative method to do so?

Hi people, We need some feedback on following errors. Any input will be appreciated. 1.Parallel job reports failure (code Internal error - missing script file RT_SC1273/OshExecuter.sh 2.Once the job is started, it runs for some time(row count changing) and then row count stops changing.The job remai...