[help me!!] I can't kill user session when I want to kill..!!!1

Posted in 1999

Taekyung Kim — Wed, 8 Sep 1999 15:57:10 +0900 — source: Informix-list mailing list archive (1991-1998)

When I want to update tables, other users are often using them. So I can't excute my update job. What should I do? "onmode -z session-id command" doesn't work well. I uses Informix AD/XP 8.21UD3 on AIX4.3.1... Thanks..

↪ replying to Taekyung Kim

Christian Brauer — Wed, 08 Sep 1999 13:18:50 +0200 — source: Informix-list mailing list archive (1991-1998)

Another guess: SET LOCK MODE TO WAIT;LOCK TABLE xxx IN EXCLUSIVE MODE; ... do your updates ... COMMIT WORK; While this script is waiting to get exclusive access, you have to find those people using your table at this time. Ask them to abort their database operations as soon as possible and wait... This should be a smarter way to "kill" other user sessions... Christian Brauer

Glossary

onmode