DSXchange

It will be greatful if you can share to all, your work if it is done.

Is your job failing everytime with the same inforamtion. I mean node1 with player2?
Try have a run in sequential mode, or a single node config file.

If a category is moved, why should it be deleted. I was under the impression (false impression) that you want to delete only the empty category. Craig pointed out that cleanly. If the jobs are moved to production via version control, it doesnt mean you need to delete the category in Dev, rather crea...

I totaly with your Kim. I too suggest not to deletet the job from DS_JOBS. OP is looking for deletion of category and not job. Category alone doesnt have any hash of its own.
Whatever it be, its not advisable to delete directly from repositry.

Yes I was asking about some routines. What other stages you have in your job. Is it the exactly same error message you get. Could you post you error message.

8000 Jobs in a project should defenitely need to work out.

So one option is move the content of the category to other category first and then delete.

Absolutely. That is what I mentioned in my first post. If a category needs to be deleted the jobs residing in that category need to be deleted.
Moreover you cannot delete a category from command line, if it has a content in it (though it might show you it has been deleted)

ysrini9 - Why do you want to create duplicate post. You other post "YTD Problem" will also lead to the same sort of solution.

If you delibrately want to do in Datastage, use transformer to limit the records, and aggregator stage to sum the sales amount.

All those RT_* files will be generated only when the jobs/routine/transform.. created or compiled or made to run. But not for Category. Category is just a logical clasification of job and routines maintained in DS_JOBS.

What version is your Datastage?
Click on Tools-->Multiple Job Compile from designer.

Category is not stored in DS_JOBOBJECTS.
Still as Ray sugessted, it is not advisable to work with this hashed files.

There is no process of creating Datastage user as such. Datastage is invoked by the Operating system user id. All you can do is, you can set the permission in the datastage for each user of group.

Perhaps you can ask you SA to wrap the shutdown command in a shell which also shuts down the Datastage smoothly.