Re: Please Help !!! Can't drop table

Hi, Someone else is using the table. Use onstat -k to see who has locks on the system. The tblsnum column of onstat -k output will help you identify which tables/rows have locks on them. You need to cross reference the tblsnum with the partnum in systables for the table that you are trying to lock. Then to get the owner of the lock grab the owner column for all rows that match on tblsnum and compare with onstat -u output. Then you can ask them to log out or kill the session with onstat -z. -Bill > > Howdy folks, > > I keep getting the following error when trying to drop a table. I can > exclusively lock the table and then rollback, I try again to delete the > table and still get this error message. Does anyone have any ideas on > how I can get around this, apart from bouncing the engine.....??? > > FYI, > Suze. > > 214: Cannot remove file for table (ttdsst020001). > 106: ISAM error: non-exclusive access.> > Susan Elliott > Host Team Leader > ISG > ( 520 -8608 > * susane@fclcis.co.nz