kill user command

nor · #1 (**permalink**) 01-09-03, 08:00

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

Roelwe · #2 (**permalink**) 01-09-03, 09:40

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 · #3 (**permalink**) 01-09-03, 22:10

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

ladwig · #4 (**permalink**) 01-10-03, 01:46

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 · #5 (**permalink**) 01-10-03, 04:47

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 · #6 (**permalink**) 01-15-03, 21:39

thanks Roelwe and ladwig

Angst · #7 (**permalink**) 01-16-03, 10:03

I use

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

dananio · #8 (**permalink**) 01-17-03, 03:50

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

Internet Services

Web Development

Digital Marketing

Consumer Tech