Page 1 of 2
corrected the job
Posted: Tue Jun 12, 2012 6:36 am
by iskapalli
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
Posted: Tue Jun 12, 2012 7:06 am
by chulett
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.
Posted: Tue Jun 12, 2012 8:02 am
by srivalli_b
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.
Posted: Tue Jun 12, 2012 8:04 am
by srivalli_b
My user id is not working. I am given reply from my friend userid
Posted: Fri Jun 15, 2012 10:06 pm
by iskapalli
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.
Posted: Sat Jun 16, 2012 6:47 am
by chulett
In the 8.x release? I'm not so sure. And I thought the NAME field was only in DS_JOBS.
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Sat Jun 16, 2012 10:44 am
by iskapalli
yes I am working on 8.5. but small correction.
DELETE FROM DS_JOB0BJECTS where name='jobname'
DELETE FROM DS_JOBS where name='jobname'
Posted: Sat Jun 16, 2012 10:52 pm
by ray.wurlod
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>>');
Posted: Sun Jun 17, 2012 7:28 pm
by iskapalli
what is mean by orphan records? can you explain clearly
Posted: Sun Jun 17, 2012 7:45 pm
by ray.wurlod
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.
Posted: Sun Jun 17, 2012 7:55 pm
by iskapalli
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
Posted: Sun Jun 17, 2012 10:06 pm
by ray.wurlod
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.
Posted: Mon Jun 18, 2012 2:43 am
by vamsi.4a6
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?
Posted: Mon Jun 18, 2012 5:01 am
by ray.wurlod
1) Not possible.
2) Not possible.
Both can only be performed within the DataStage ("UniVerse") environment.
Posted: Mon Jun 18, 2012 6:18 am
by vamsi.4a6
@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?