Results 1 to 9 of 9

Thread: dbexport

  1. #1
    Join Date
    Sep 2012
    Posts
    5

    Unanswered: dbexport

    Can someone help please? I need to use dbexport to get copy of an informix 10 database but i need a script to kick off all users as it will not work otherwise. THere is an onmode -u i can use but i am unclear of the consequences of doing this. Could i be causing data issues by kicking users off? Any advice greatly appreciated.
    Last edited by cnort1; 09-13-12 at 09:15.

  2. #2
    Join Date
    Sep 2004
    Posts
    51
    I would use onmode -s instead of onmode -u because onmode -u will roll back any current user transactions and end the user session, then take the server offline.


    You may want to review the following website for additional information.

    IBM Informix Dynamic Server v10 Information Center

    HTH

  3. #3
    Join Date
    Sep 2012
    Posts
    5
    thanks for your response.

    Any users that I am trying to kill off have gone home leaving themselves logged into application so how would 'onmode -s work' with letting user finish before going to quiescent mode?

    Also would there be any risk to the database by doing this every night , changing the mode back and forth?

    Is there any way to do this without changing the mode of the database. Just kill users sessions, keeping data in tact in online mode?

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    If the sessions are interactive session ( screen IO ), chances are that the sessions will never end until the next day in the morning.

    the right way to terminate an informix session is the following:
    onmode -z sessionnumber

    you can get the session number by issuing 'onstat -g ses' and pick the session number

    onmode -z will rollback any active transaction then terminate the client process. You are ensured to keep the data as they were at the last committed transaction. This does not mean that the session will not lose data at all. This will
    be according to how the active sessions programs are coded....

  5. #5
    Join Date
    Sep 2012
    Posts
    5
    Thanks for your response.

    I cant risk losing any data so i dont think -z is the way to go if there is a chance of losing data.
    It doesn't look like there is a successful way to kick off users while keeping data in tact.

    THanks for all your help guys!

  6. #6
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    In any case, check in the iiug software repository, there is a utility called myexport, written by Mr Art Kagel, an eminent guru of Informix technology. It does not lock the database, and this is what you are looking for...

    Here is the url of the readme file

    and the link for the download

    Art's utilities are 100% trustable.

  7. #7
    Join Date
    Sep 2012
    Posts
    5
    great thanks for your help.

  8. #8
    Join Date
    Sep 2012
    Posts
    12
    Use follow way it's ezy

    run "onmode -c" command first

    and then as soon you run it

    run "onmode -j" command it will change you db server to admin mode

    and then run

    "dbexport dbname -o . ("." for current directory)

  9. #9
    Join Date
    Sep 2012
    Posts
    12
    Use follow way it's ezy

    run "onmode -c" command first

    and then as soon you run it

    run "onmode -j" command it will change you db server to admin mode

    and then run

    "dbexport dbname -o . ("." for current directory - it's a dot)

Tags for this Thread

Posting Permissions

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