Re: AW: dbexport
Posted in 1998
In article <70hnrd$fbq$1@news.xmission.com>, Bettin Andreas (ABe)
<andy@pneu.com> writes
>
>Hello Raymond,
>
>Ampon uses SE, not OnLine!
>
>Hello Ampon!
>
>Pls try ps -ef | grep sqlexec to check out, if there
>are running sql-processes. I so, then kill -15 them and
>try dbexport again. Look out, if there is an sqlexecd=20
>(Informix-NET) process, which is running in background, if
>so then kill it or stop it.
>
Nope...NEVER KILL sqlexec..
Kill it's parent process instead....
>Hope this helps.
>
>Bye=20
>
>Andy M. Bettin
>
>
>-----Urspr=FCngliche Nachricht-----
>Von: Raymond [mailto:owls@accsoft.com.au]
>Gesendet am: Dienstag, 20. Oktober 1998 04:00
>An: informix-list@iiug.org
>Betreff: Re: dbexport
>
>The 'who' command cannot reveal actual users of Informix, because it is
>possible for some
>application program to 'log on' to Informix without appearing as a
>terminal
>user. The best
>tool to check if there is any Informix user (not Unix user) is to use
>'tbstat -u' or (onstat -u for
>Dynmaic Server). If it shows users other than 'informix', then find =
>out
>the
>application program
>that is still active and terminate them if possible (warn the users
>first,
>or do any necessary
>backup first).
>
>Good luck.
>
>
>
>Ampon Chumpia wrote:
>
>> Hello,
>>
>> 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
>>
>> Regards,
>> Ampon.
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care