Can someone help please? I need to use dbexport to get copy of an informix 10 database but i need a script to kick off all users as it will not work otherwise. THere is an onmode -u i can use but i am unclear of the consequences of doing this. Could i be causing data issues by kicking users off? Any advice greatly appreciated.
If the sessions are interactive session ( screen IO ), chances are that the sessions will never end until the next day in the morning.
the right way to terminate an informix session is the following:
onmode -z sessionnumber
you can get the session number by issuing 'onstat -g ses' and pick the session number
onmode -z will rollback any active transaction then terminate the client process. You are ensured to keep the data as they were at the last committed transaction. This does not mean that the session will not lose data at all. This will
be according to how the active sessions programs are coded....
In any case, check in the iiug software repository, there is a utility called myexport, written by Mr Art Kagel, an eminent guru of Informix technology. It does not lock the database, and this is what you are looking for...