DSXchange

i have a px job which is joining some cols from look up table input is a file and out put is aslo a file , it has 3 keys on which i have to do lookup .Job is running fine without any warnings or error but it is not finding any match but there are keys in both table and file which matches . if i do i...

I have the same issue i saw this post but dint understand what exactly i have to do, i am using a join stage with input file set and out put seq file

any helps will be appreciated

I have a px job which uses a container in which we have a small server job(used for lookup) ,input to the container is file set which has around 60 mil rows my job takes around 6 hrs to run and finally abort due to time out issue..errors i get --Unable to wait for job to finish - 81002. --ds_ipcput(...

Yes DSGuru i mean not to run half of my job and only execute the remaining half.

Hi All - i have a PX job i need this job by making some of the part as dummy which contain couple of stages how can i do that?

Thanks in advance

Hi All - i have a PX job i need this job by making some of the part as dummy which contain couple of stages how can i do that?

Thanks in advance

i gave the complete path in the script and its running fine

THANKS A LOT

my script contain :

bcp pumpkin.dbo.ACTIVE_DB out abc.dat -c -S GWRDBS -U adminxx -P ******* >>file.log

this is the path i am using in input value for before job subroutine
/dev/dsdd/data/files/xyz.sh

i ran this script on unix its working fine it is creating abc.dat file
i suspect the path i am giving in input value do i need to add something else with the path or just the path stated above

i am getting this info :
testjob2..BeforeJob (ExecSH): Executed command: /dev/dsdd/data/files/xyz.sh
*** No output from command ***

path is correct

Hi All , i have a small script xyz.sh(which creates a new file abc.dat) on my unix machine ,i need to run it before running my parallel job . i thought of using EXECsh before job sub routine , i gave the path of the file xyz.sh in input value .Job is running fine but it is not creating abc.dat. i tr...

Ray,

I have 16GB of RAM on my box. I am using four columns in my lookup stage which are very much needed so I cannot remove any of the columns. IBM suggested me to use JOIN stage instead of lookup. So I am redesigning my job again.

Thanks for your support.

Regards,
Sri

Thanks RAY and Sudeep for your suggestions.

I would like to go for LOOKUP rather than JOIN and if I cannot figure out the solution for this problem then I will redesign my job. I opened a ticket in IBM and awaiting their response.

Thanks,
Sri1111

Ray, I added one more disk to the resouce pools: { node "node1" { fastname "serever" pools "" resource disk "K:/Ascential/DataStage/Datasets" { pools "" } resource disk "M:/Ascential/DataStage/Datasets" { pools "" } resource scrat...

Hello John,

I think the problem is not with the disk space as I am having more than 200GB on that drive.

Ray,

Let me follow your suggestion and add more directories.

Thanks guys