DSXchange

Strange indeed. Are you passing a constant string value for "hostname" in your DS job?

Is drive "E" a local drive or a remotely mounted one?

I don't know the "-h" option of df but could you confirm that your Scratch and Datasets directories are mounted, perhaps with the "mount" command and grepping for "Scratch"?

Two common reasons:

1. The field is CHAR(5) somewhere in the stream

2. The extra characters are not whitespace. Try a derivation of SEQ(In.KeyField[3,1]) to a peek to see the ASCII value of that character.

That is unlikely. Could you post the APT_CONFIG file used for the run, that will contain the paths.

What SQL write statement are you using, in particular do you have a stored procedure involved, which can cause a bad cursor. This is a database error and is most likely caused there.

Just to make Craig's note clearer, he was addressing the response to naveen19 since DataStage will dynamically repartition datasets to the required number of nodes.

I'm not at a DS system now, or an AIX one, but check up on the "ldd" command with this library to see if all the links from it are OK.

I have a "mqsco.so" object in my "$DSHOME/../DSComponents/bin" directory. Where are you getting this file from and where is the error message being generated?

Our problem is that we don't understand what your problem is.

Think of it like DataStage opening up a sequential file - it need a path and a filename. MQ is not different to DataStage, it needs a Queue Manager and Queue name. I am assuming you do have MQ installed witha local queue manager - is that the case?

Just to confirm, you specified this in the column metadata?

No, you mistyped the last one (but the others look good)
"ls -al $DSHOME/lib/libgciudt6.so" (there is no pipe in the command)

Is is best to cut-and-paste error messages, but in this case the gist of it is visible. It would seem you have a cluster configuration, with DataStage running across more than one machine and your access rights for rsh are not set up correctly.

You don't need to configure DataStage for MQ. If you need to configure your MQ Series local manager then you will need to look elsewhere, there are plenty of documents and also MQ-Series specific forums.