Hi guys,
I have a repetitive error :
Unknown reference from 'ttaad231.user' to 'ttaad200'
when trying to list the sessions authorizations by user (ttaad2131m000) and some place else...

The problem clears himself when rebooting the server but always comes back a little while after. I didn't identified the source yet, still trying.

I tried looking for orphan entry in the ttaad231 table with ( select * from ttaad231 where ttaad231.user not in (select user from ttaad200) ) but without success.

This brings me to two questions :
- Does someone have an idea about how to correct/debug this specific problem ?
- Is there a possibility to see a session's generated query ?


Thanks a lot for your help,
I continue learning to some day, be able to help.
Fred

Are you really on MK/Bisam?

There is some tracing, etc for MK but it's very limited. (and it's been about 3 years for me since i've touched the stuff....)

Dave

Yes sir I am on MK/Bisam, AIX 5.2!
I've seen that MK doesn't have a lot of logging, tracing or I don't understand how to level up the debug mode !?

If you can point anything that could help it would be greatly appreciate since this bug makes me reboot the server at least once a week now.

the more i look at it, the more it seems like a shared memory corruption issue.

you might just want to log a case with infor..

Dave

Doing it right now ! Thanks !