Re: dbexport

Ampon Chumpia <fengapc@nontri.ku.ac.th> on 20/10/98 02:16:28 >> I want to export an SE (5.06.UC1) database so that I can reconstruct >> the database to be used by another version of SE (7.24.UC5). >> However, I have a problem trying to get 'dbexport' to work. After >> executing the command an error 'Database is currently opened by >> another user' was generated. I am sure I logged in as informix user >> and only one user (informix) was reported to be using the system by >> the 'who' command. Could some knowledgable informix users out here >> tell me where to look for the answer to the problem. I skimmed >> through Informix Migration Guide and SE Adminstration Guide but did >> not find any clue. >> Informix SE 5.06.UC1 >> SCO OpenServer Enterprise 5.0.2 PaulITID.Matthews@chase.com replied: > > Try 'tbstat -u'. > tbmode -z 'pid' would get rid of them, but that's a bit naughty. Best > try asking them to leave first Er, Paul, unless some radical features have been added to SE, tbstat applies only to IDS, not to SE. However, a judicious use of the fuser command might tell you who has a file open on the file system containing the database. WHo knows, maybe a shell script to list the names of the tables and running fuser against each of them in a shell loop. -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+