Table locks driving me nuts..

Hi All, I am having a lot of problems with tables retaining locks after I disconnect our app from the DB. Is there a way that I can list all of the tables and their associated locks? Thanks for your help, Jack

Jack Murphy wrote: > > Hi All, > > I am having a lot of problems with tables retaining locks after I disconnect > our app from the DB. > > Is there a way that I can list all of the tables and their associated locks? Platform? Engine type (SE or IDS)? Version? Front-end (UNIX -vs- PC, ESQL -vs- 4GL -vs- D4GL -vs- VB -vs- whatever)? Client server or local? We need more to help. On IDS you just run onstat -k to see locks but in IDS locks do not survive the disconnection of clients.... Art S. Kagel