DSXchange

"Input string too long, limit 8192". What are you doing in the transformer? Any large derivations or large character fields?

Sounds like you may need the XP "Service Pack 2" or SP2 Patch that came out some time ago for the client. Request it from your service provider.

First you need to figure out what "this" is before you'll have a clue how to fix / avoid it. Use some basic detective skills. Check the file on the remote location before the transfer, are the characters there? Check after the transfer, are they there now? Etc. Pinpoint at what stage in th...

As noted, you need to figure this out, we can't. Are the characters in this other 'available' file? Or in the source file after the transfer? Or only there after you cat the two together? How exactly are you "importing the file from remote location"? How exactly are you doing the concatena...

Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :? ... Yes, In my sequence we are calling the MI job 12 times , but flow is sequential (i.e one MI with some invocation id after this job completion , next MI with different invocation id like this we ...

Is your multi-instance job running another job 'before job'? If so, is that other job MI as well?

You need to determine how they got there... created at the source? Problems during a transfer? Then ensure they are not in the file before you have to process it.

So, your "DS routine" is actually a Server job, yes?

Ask Tom is an excellent resource for Oracle questions. I saw this message on the site: "Sorry I have a large backlog right now, please ask a question later." Any other ideas would be appreciated. Regardless of that message, search there. I sincerely doubt any question you would be asking ...

So from your suggestion only thing to improve the performance is to use native DB2 stage to read the data. No, no-one has suggested that. What they have suggested is that the DB2 Enterprise stage inherently supports parallelism, whether that will improve anything or not is a whole 'nuther kettle of...

Clearly "nothing" is not the correct answer.

That or a quality DBA.

Was wondering the same thing, "improved reject link operation"? Hmmm... don't recall that being mentioned before...

True, it is a little ambiguous, but I was going by the "Did the clear status of the job" part. Guess we need to wait and see.

There's nothing special I'm aware of that you need to do. Can you check with whomever administers your server / email, see what they think?