Scheduling through Datastage
Moderators: chulett, rschirm, roy
Scheduling through Datastage
Hi All ,
when I am trying to schedule the job from datastage director, I am getting the below error.
"Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG62 "
I tried to recompile the job but still the same problem persists. This problem is only in one project. In other projects on the same server, I am able to schedule the jobs.
How do I know that the RT_CONFIG file is corrupt or not and how can I rectify it.
One more question, is every project has unique RT_CONFIG file and is there only one RT_CONFIG file per project?
Can any one suggest any possible solution?
Thnx in advance
when I am trying to schedule the job from datastage director, I am getting the below error.
"Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG62 "
I tried to recompile the job but still the same problem persists. This problem is only in one project. In other projects on the same server, I am able to schedule the jobs.
How do I know that the RT_CONFIG file is corrupt or not and how can I rectify it.
One more question, is every project has unique RT_CONFIG file and is there only one RT_CONFIG file per project?
Can any one suggest any possible solution?
Thnx in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can test for a corrupted RT_CONFIG62 using UVFIXFILE RT_CONFIG62 command.
The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director?
What happens when you execute this command from your Administrator client command window?
The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director?
What happens when you execute this command from your Administrator client command window?
Code: Select all
LIST.ITEM RT_CONFIG62 JOBPARAMINSTS
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can test for a corrupted RT_CONFIG62 using UVFIXFILE RT_CONFIG62 command.
The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director?
What happens when you execute this command from your Administrator client command window?
The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director?
What happens when you execute this command from your Administrator client command window?
Code: Select all
LIST.ITEM RT_CONFIG62 JOBPARAMINSTS
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Scheduling through Datastage
shalini11 wrote:Hi All ,
Can any one suggest any possible solution?
unschedule the job, recompile it and again add to scheduler.
I tried with the below command:
$DSHOME/bin/uvfixfile RT_CONFIG62
The output of the command was:
"No filename specified."
Actually RT_CONFIG62 is a directory in which 3 files are there:
DATA.30, OVER.30 and one hidden file .Type30.
When I am using the same command for these files then also I am getting the same message.
Can you pls suggest what to do?
Thanks
$DSHOME/bin/uvfixfile RT_CONFIG62
The output of the command was:
"No filename specified."
Actually RT_CONFIG62 is a directory in which 3 files are there:
DATA.30, OVER.30 and one hidden file .Type30.
When I am using the same command for these files then also I am getting the same message.
Can you pls suggest what to do?
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I tried to execute the command in Administrator client and got the below output.
Beginning TRACE of RT_CONFIG62.
TRACE of RT_CONFIG62 completed.
Scanning overflow buffers.
Scan complete.
2 group (s) processed.
2 group buffer (s) processed.
6 record (s) processed.
Number of data bytes = 2508
But still I am not able to schedule.
Beginning TRACE of RT_CONFIG62.
TRACE of RT_CONFIG62 completed.
Scanning overflow buffers.
Scan complete.
2 group (s) processed.
2 group buffer (s) processed.
6 record (s) processed.
Number of data bytes = 2508
But still I am not able to schedule.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No it hasn't.
All you have done with UVFIXFILE is a trace of RT_CONFIG62 to prove that it is not internally corrupted.
That, in turn, meant that when you recompiled the job, correct details could be written into RT_CONFIG62 and when you scheduled the job the JOBPARAMINSTS record could also be written to RT_CONFIG62 to hold the scheduling and job parameter value details.
Please don't for a moment imagine that UVFIXFILE is a silver bullet that will cure all repository ills. It definitely is not.
All you have done with UVFIXFILE is a trace of RT_CONFIG62 to prove that it is not internally corrupted.
That, in turn, meant that when you recompiled the job, correct details could be written into RT_CONFIG62 and when you scheduled the job the JOBPARAMINSTS record could also be written to RT_CONFIG62 to hold the scheduling and job parameter value details.
Please don't for a moment imagine that UVFIXFILE is a silver bullet that will cure all repository ills. It definitely is not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.