[nor]

i want to backup my database in informix.
how to kill user in informix

[Roelwe]

onmode -z <sess-id>

to find out what session id is still open:
onstat -g sql or onstat -g ses.

Why do you want to kill sessions for backup? Ever heard of onilne backup?

[nor]

i have tried to run dbexport command. when i run that command, i got error : database open by another user.

[ladwig]

Hi,
if you use dbexport, any user isn't allowed to habe a connection to Informix. So you have to find who have a connection in that way Roelwe wrote. If you don't find any connection, shut down informix.

[Roelwe]

dbexport is not the best way of making backups. ontape or onbar can be configured to create online backups. In that case users can still work in the database without harming any data consisteny.

[nor]

thanks Roelwe and ladwig

[Angst]

I use

"onmode -uy" to kill all users
and
"onmode -m" to get server multiuser again,next I run dbexport

[dananio]

Informix have ontape , onbar ,onarchive to backup database in online mode
You don't have to use dbexport for backup ,this command is suit for reorganize more than backup