DSXchange

"It was due to fault with internal datasets that datastage creates "
Do you mean virtual dataset?
May I konw what where the steps taken to overcome this?

Perhaps Unix search utility.
What is the user id you use to stop and start. Issue may be with lack of permission. Try with dsadm.

That depends on how you trigger you job. If you want to execute jobs parallaly, dont wait for it to finish before other job starts.

It may be possible with Start and End loop activity.
Pass on a value thorough a parameter say 'I' from the looping activity and fetch the Ith value of the given string and pass as parameter to the next job activity.

Or search for "Remote Connection" in Install and Upgrade Guide.

What is your job design? How many stages does you job has? What is the load on the server when your job runs? What is the load of your job (how big is the input and outfiles are)? How many joins, lookups, Pivoting does your job perform? Was it a read or write to the oracle? What is the commit rate o...

So what was the action point taken to the table to make the job to perform well?

By default it takes the TMPDIR defined in the adminstrator or in the path for scratch disk defined in dsenv. But if workspace is specifically given in the satge, it should get the precedence over other. Just make sure the disk and path given in the stage have necessary previlage to the user from whi...

Yes the Code poped out is for the same.


You ll also get the remedy for this as the following. Try to increase the table space.

Hi Krishna,
Click on the blue word given on the both of the post. You ll be diverted to a new page where you can get the releven informations.

How are you trying to run the job?
Is it from designer or director, if so in the Job Run Option you can find a tab called Limit. You can find the option Abort after and No limit. You can choose the No limit. If you run from command prompt, dsjob -warn will help you to acheive this.

Parallel job reports failure (code 139)... Hum... Got the same once.... What is the length of the query you execute? Once i got the same with DB2 database. I tried to execute the qure in command line it executes well. When I try to do the same thought Execute command activity it gave out the same er...

Yes there are some pre processing required, something like sorting, de-duplication.... but the error you got is not relevent to that.
Just try to make that particular field to dfloat.

Is it possible to share the exact error message you got while crossing the threshold limit. So that it would help the Search facility to acquire more informations.

Hope you are calling the Job sequence from a unix script.
If so export the parameter and its value to a file. Read it through the script and pass it to the Job sequence for each environment, say DEV, or PROD.
And inturns from Job sequence to the underlying jobs.