RT_LOG149
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 102
- Joined: Tue Jan 31, 2006 4:13 am
RT_LOG149
I got a DB2 error of SQLSTATE=57016 when I tried to load the data into the DB2 table and also 'FAILED TO OPEN RT_LOG149 file' error. After fixing this DB2 error also I am unable to compile the ds load job . What is the reason for this?
Sujatha K
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Could be that the local Repository table RT_LOG149 has become corrupted. In the Administrator client command window count the rows. Let us know the result.
Code: Select all
SELECT COUNT(*) FROM RT_LOG149;
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.
-
- Premium Member
- Posts: 102
- Joined: Tue Jan 31, 2006 4:13 am
I am getting this message when run the command given by you.
'Datastage/SQL: Table "RT_LOG149" does not exist'
Since I got this error, I copied the load job and renamed it. Then I deleted the old load job which thrown error. Again renamed the new copied job to old load job name and ran it.
Now it is working fine. I am inquisitive to know the reason for this error.
'Datastage/SQL: Table "RT_LOG149" does not exist'
Since I got this error, I copied the load job and renamed it. Then I deleted the old load job which thrown error. Again renamed the new copied job to old load job name and ran it.
Now it is working fine. I am inquisitive to know the reason for this error.
Sujatha K
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 102
- Joined: Tue Jan 31, 2006 4:13 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No idea. There's nothing in DataStage per se that would destroy a job log table. Could be vandalism, could be an operating system flaw with file units getting confused, just to mention a couple off the top of my head.
The code that drops a job log table could be a malicious routine; the only part of DataStage that does it is the code that deletes a job.
The code that drops a job log table could be a malicious routine; the only part of DataStage that does it is the code that deletes a job.
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.
-
- Premium Member
- Posts: 102
- Joined: Tue Jan 31, 2006 4:13 am