Knowledge Management

Question:
Hi All,
I run the job AnalyzeTab every week end, for the past two runs the AnalyzeTab run fails with return code 002, in the log file it says "SAPDBA: Error - table SAPR3.JSTO locked" , What could be the reason ? Please suggest ?
Thanks in Advance
Answer:
have a look in SM12. If not, it is locked at Oracle level. I don'T know how to unlock at Oracle level but a shutdown/startup of Oracle will surely do the trick.
Perhaps someone else has a better way of doing this?
Snowy
Answer:
I recommend that you'll execute AnalyzeTab when the load of the system is lower. Saying extremely, when processing isn't executed at all.
I don't know what DB you are using, if you want to know the cause of the lock, will it not be possible to examine from the results of 'DB01' or v$locked_object in 'ST04' ?
I hope that you find this information helpful.
Answer:
Would dropping/deleting the table work?
Answer:
Yes , if you drop the table you would not get the error anymore.
I don't know if it will help you or not.
Answer:
Of course, you'll lose table contents... and table structure...
Answer:
and is that okay?
Answer:
will the locking cause the whole analyze to fail or will it fail only for that particular table ?
Answer:
Yes it'll fail only for locked table, and I wouldn't recommend to drop locked tables