RT_LOG149

sujaoschin · Post by **sujaoschin** » Wed Sep 24, 2008 10:39 pm

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?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 24, 2008 11:45 pm

Could be that the local Repository table RT_LOG149 has become corrupted. In the Administrator client command window count the rows.

Code: Select all

SELECT COUNT(*) FROM RT_LOG149;

Let us know the result.

sujaoschin · Post by **sujaoschin** » Thu Sep 25, 2008 5:46 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 25, 2008 8:01 pm

Impossible to tell now that you've destroyed the evidence.

sujaoschin · Post by **sujaoschin** » Fri Sep 26, 2008 1:35 am

May I know the possiblities of this error, please.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 2:18 am

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.

sujaoschin · Post by **sujaoschin** » Sun Sep 28, 2008 5:44 pm

Thanks for your information, Ray.