corrected the job

iskapalli · Post by **iskapalli** » Tue Jun 12, 2012 6:36 am

Hi,

My job is corrected. I am unable to rename and delete the job.

I went through below link. I followed same what they are telling. But It is not working for me.

viewtopic.php?t=113012

Please help me

chulett · Post by **chulett** » Tue Jun 12, 2012 7:06 am

I assume you mean "corrupted" here. And I feel like we came in the middle of a conversation.

Start over. Tells us what exactly it is you are experiencing and the error(s) you get. I know you posted a link (which is good) but it would be helpful to know what you tried from it and what "not working for me" means.

srivalli_b · Post by **srivalli_b** » Tue Jun 12, 2012 8:02 am

Sorry ,Yes you are right
My job does not contains RT_CONFIG63, RT_STATUS63 files in my project path(/opt/IBM/InformationServer/Server/Projects/project_name).

I created this files(config and status) in project path. I have taken this files from some other RT_config.

srivalli_b · Post by **srivalli_b** » Tue Jun 12, 2012 8:04 am

My user id is not working. I am given reply from my friend userid

iskapalli · Post by **iskapalli** » Fri Jun 15, 2012 10:06 pm

HI,

After executing below commands I am able to delete the job.

DELETE FROM DS_JOB0BJECTS where name='jobname'

DELETE FROM DS_JOB0BJECTS where name='jobname'

my problem is solved.

chulett · Post by **chulett** » Sat Jun 16, 2012 6:47 am

In the 8.x release? I'm not so sure. And I thought the NAME field was only in DS_JOBS.

iskapalli · Post by **iskapalli** » Sat Jun 16, 2012 10:44 am

yes I am working on 8.5. but small correction.

DELETE FROM DS_JOB0BJECTS where name='jobname'

DELETE FROM DS_JOBS where name='jobname'

ray.wurlod · Post by **ray.wurlod** » Sat Jun 16, 2012 10:52 pm

Your approach leaves may orphan records in DS_JOBOBJECTS (note, too, that it's a letter "O", not a zero, in the name). You are missing deleting every stage, every link and every annotation.

What you really need is

Code: Select all

DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');

iskapalli · Post by **iskapalli** » Sun Jun 17, 2012 7:28 pm

what is mean by orphan records? can you explain clearly

ray.wurlod · Post by **ray.wurlod** » Sun Jun 17, 2012 7:45 pm

Records that describe/record the properties of stages, of links, of containers, of annotations.

Get yourself a premium membership and you can read the complete solution in my previous post.

iskapalli · Post by **iskapalli** » Sun Jun 17, 2012 7:55 pm

after executing above two commands I have taken copy of the job.
I was able delete the job in designer(including copy of the job). I think there is no entry in ds_objects. please correct me if i am wrong

ray.wurlod · Post by **ray.wurlod** » Sun Jun 17, 2012 10:06 pm

You're wrong. For starters the table name is DS_JOBOBJECTS. Secondly, the linkage between DS_JOBS and DS_JOBOBJECTS is through the job number, not the job name.

If you delete the job from Designer, all of the records from DS_JOBOBJECTS are removed. If you delete only the ROOT record from DS_JOBOBJECTS then you leave all the orphans I mentioned previously.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 18, 2012 2:43 am

1)Could anybody please tell me the procedure how to take the files from some other RT_config and
2)How to view the data in the files like RT_CONFIG63, RT_STATUS63 from unix enviornment?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 18, 2012 5:01 am

1) Not possible.
2) Not possible.

Both can only be performed within the DataStage ("UniVerse") environment.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 18, 2012 6:18 am

@Ray.Thanks for the Reply. I think we need to execute the following command to access the DataStage ("UniVerse") environment from command prompt.

cd $DSHOME
../dsenv
bin/uvsh

Please correct me if i am wrong?