Re: DBEXPORT help

Posted in 1995

"Malcolm Weallans" — Wed, 8 Feb 1995 17:23:30 GMT — source: Informix-list mailing list archive (1991-1998)

> I'm trying to use DBEXPORT to unload a database, but > there is a user process using the table. How > can I find out which sqlturbo process is locking > the table? The error message I get is: > "Database is currently opened by another user". > We have hundreds of users using our system, so > this is a little more difficult problem that expected. > > Thanks in advance! > > Michael Mstowski > msm@spaceworks.com ANSWER - look at the current locks using tbstat(or onstat) using the -l option. It would only take one user to have opened the database and not closed it for this type of error to have occurred. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc