var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: kill user command
i want to backup my database in informix.
how to kill user in informix
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?
Re: kill user command
i have tried to run dbexport command. when i run that command, i got error : database open by another user.
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.
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.
"onmode -uy" to kill all users
"onmode -m" to get server multiuser again,next I run dbexport
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