Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Location
    malaysia
    Posts
    6

    Unanswered: kill user command

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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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?
    rws

  3. #3
    Join Date
    Jan 2003
    Location
    malaysia
    Posts
    6

    Re: kill user command

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

  4. #4
    Join Date
    May 2002
    Location
    Osnabrueck Germany
    Posts
    59
    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.
    Juergen Ladwig

  5. #5
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  6. #6
    Join Date
    Jan 2003
    Location
    malaysia
    Posts
    6

    Re: kill user command

    thanks Roelwe and ladwig

  7. #7
    Join Date
    Jan 2003
    Posts
    1
    I use

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

  8. #8
    Join Date
    Mar 2002
    Posts
    112

    re

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •