DSXchange

Hi All, I am Pushing message from sequential file to target using MQ stage. In middle of job run the connection was closed/losed. In between that some messages were pushed to queue. when i running next time i getting duplicate in my queue. how to rollback the messages if datastage job failed??? how ...

Check in Project Directory.

You cannot compress the dataset. Only the descriptor file will be created in directory where you trying to create the dataset. The data will be stored in the resource disk (path mentioned in configuration file) in internal format.

You need to add the PXEngine Library Path to the Environment variable

Try this.

(@INROWNUM * @NUMPARTITIONS) - @PARTITIONNUM

This will generate unique numbers.

Are you using any transformer stage in the job?

Use a Copy Stage inbetween Lookup Stage & DB2 Stage. It may give solution.

Inform your Unix Administrator to increase the Maximum number of PROCESSES allowed per user Value

Try the below command in unix box & check the maximum number of process allowed per user. If the value is less than 100 inform your Administrator to increase the value.

lsattr -E -l sys0 | grep maxuproc

Try the below function

DateFromJulianDay(JulianDayFromDate(Link.Column) - 365)

Try below unix command to remove the Control-M Character from a file

perl -pi -e 's/\r//g;' filename

first thing use partition 'entire' for creating lookup fileset.

convert decimal to varchar in both db2stage and lookup fileset (use entire par.) before joining.

importing job from Unix Server

dsjob -import <project> DSXfile [ [-OVERWRITE] -JOB[S] | jobname ...] | [-LIST]


compiling job from Client


dscc /h <server ip> /u <username> /v <password> <projectname> /j <job name|*> /ouc

cann you try nulltoempty function

hi..

can you run the job without constraint.and find out records poupulated in the target.

do you have any message handler in your job...