Cause of RT_STATUSxxx

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
krystlecsy
Participant
Posts: 50
Joined: Wed Jul 14, 2004 7:56 am

Cause of RT_STATUSxxx

Post by krystlecsy »

Hi all,

I browsed through issues regarding about RT_STATUSxxx or RT_CONFIGxxx and I'm curious to know what are the cause of this?

The errors are like:-
Cannot open executable job file RT_CONFIGxxx
If there are 3 projects residing on the same server but re-build index is only done on 1 of the project, will all the RT_STATUS errors' be resolved? Or a mass re-build index needs to be done?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

RT_... are database tables in the Repository. They don't have any "cause" other than the job to which they relate being created.

Errors relating to being unable to open them are usually fairly standard things like lack of permission or corruption within the structure. Re-indexing will not help, because the RT_... tables are not indexed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Is it only that that job with job no xxx, or for all the jobs that exist in project? It it confined to one, you can try to create a copy of the job and delete the old one and rename the existing one, which will create a new set of interfile hashed file and hence solves the problem. If you have problems in whole project, check for the permssions as mentioned. You may need to start some project clean up steps.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Projects are separate directories, so corruptions to one projects files doesn't affect other projects. If all projects are on the same file system and that file system runs out of space, then you have systemic problems. Otherwise, re-indexing a project is an isolated activity wrt other projects. The easiest way to fix jobs with corrupted or missing supporting files is to export and reimport the job as that creates a new set of supporting files.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply