Re: No user sessions, yet still receive 107 (lock) error

It was some "indirect" connections. Problem solved. Thank you. DG "rkusenet" <rkusenet@sympatico.ca> wrote in message news:c616kj$6pjtq$1@ID-75254.news.uni-berlin.de... > > "David E. Grove" <david_grove@correct.state.ak.us> wrote > > > I called tech support and they told me there were phantom locks and I needed > > to bounce the server to clear them. > > > > Is there really no way to fix the problem without bouncing the server? > > Try running this query in sysmaster > > select syslocks.owner > from syslocks, > sysdbspartn,outer syssessions > where syslocks.tabname = 'sysdatabases' and> syslocks.owner = syssessions.sid and > syslocks.rowidlk = sysdbspartn.rowid and > sysdbspartn.name = 'your database name' > > This will tell you those sessions which are not connected directly to > the database in question, but indirectly thru views, synonymns etc. > > if you find some sessions, onmode -z them and hopefully that should > solve your problem. > > good luck. > >

"David E. Grove" <david_grove@correct.state.ak.us> wrote > It was some "indirect" connections. > > Problem solved. > > Thank you. I am glad that I was able to you. I am bit intrigued that the tech support told you:- "I called tech support and they told me there were phantom locks and I needed to bounce the server to clear them". What kind of support is this if they told you this and not what I told you. This is not the first time a solution has been found in c.d.i when the tech support sent the customer on a wild goose chase. Sometime back I posted this in c.d.i http://tinyurl.com/ywann The customer in question got a very poor support from IBM. In fact when I saw their onconfig, I was appaled to see wrong suggestions given by tech support.