Re: dbexport
This is a multi-part message in MIME format.
--------------0DD56AF3184D590535B5D951
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Yes, you are right. The tbstats are only found in IDS, not in SE. Sorry
for the confusion caused.
However, the 'who' or 'ps' or 'fuser' might not give you sure answers
either, because they cannot
reveal any real users logged on through an application (eg PeopleSoft,
ARsystem, etc.). In this
case I guess you might have to rely on your intuition, or be a 'dictator' -
kill with no mercy !
More humane approach, though, is to upgrade to Informix Dynamic Server (hey,
Informix, I should
share part of your sales commissions !).
Regards
Raymond
Jacob Salomon wrote:
> 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) |
> +------------------------------------------------------------+
--------------0DD56AF3184D590535B5D951
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Raymond
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Raymond
n: ;Raymond
org: Davids Limited
adr: ;;;;;;Australia
email;internet: kukra@davids.com.au
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1
end: vcard
--------------0DD56AF3184D590535B5D951--