DSXchange

Possibly there could be constraints on the table that you are trying to load. Make sure that you meet all of them and use a modify stage to convert the datatype, atleast you will be able to keep a track of the datatypes you are changing.

It probably gives you the time to think over hehe.

I got it guys. The director wasnt giving me any warning or error message because i was forcing the job to abort. Couldnt find out the real problem. Then i looked into the msg.txt that the bulk loader creates. In that i found the problem SQL0551N "XXX" does not have the privilege to perform...

Then donot concatenate the stage variables as sunshine has posted.
Instead just pass each stage var into a column.

Hi guys, Now i am bumping into another problem. I got the db2/udb load stage to work. But towards the end, the performance starts decreasing and the job never seems to finish. i ran a test to just load 1000 rows, in the performance stats, it shows that all the rows are transfered, but the job doesnt...

And opinion on the feedback given: I dont think DSXCHANGE is a site to tutor, nor anyone is here to provide complete solutions at DSXCHANGE. Here everyone is to help with good intentions. And is someone doesn't get an answer to his/her post this doesnt mean that we should be pin pointing. You get wh...

hey ogmios, i got it. the problem was that i was specifying the directory path on the AIX box. (dont ask me why i was doing that :oops: ) then i changed it to path on my DS server. it works now. Got a real boost in performance (A whopping 15,000 rows/sec). My architecture team is going to like that....

Its always better to sort in a seperate stage, this will help in your performance as mentioned by kumar.

Kumar, What I meant was what she found
When the lkp file and the driving data dont match the reference result is less. which was 95 in the case instead of 99.
Thanks anyways.

Probably there is a seperate utility to Unzip MQ compressed XML files.

My exact requirement is like this: source: NO TYPE NAME1 NAME2 1 A AA W 1 B BB 1 C CC Y 1 D DD Z Create Temp with metadata like this NO Type1 Type2 Type3 Type4 Type5 Type6 Type7 Type8 Type9 .... 1 A AA W B BB C CC Y .... Thanks smita Yes, create it like as you have mentioned. Then from the Temp fil...

I think if you are trimming your data in the transformer where you are matching the keys, then probably whats happening is that the composite keys are resulting to be duplicate.

You will put it as a constraint in the trasformer and allow only those rows that are of : First_service_day<=(current date-36 mths).
Try it !
You will get it. As Ray says, Take it as a challenge!

the path i have specified for the "directory for Data and command files" is on the AIX box where udb is.
i am not exactly sure what to specify in the LOB path, i gave the same path as above.
load method is NamedPipe
rest i left it as default.

dont know whats going wrong

Try pinging the server and see what are the results. If the T.T is too much and there are many delays, then definetly its your network.