Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Virginia
    Posts
    11

    Question Unanswered: Is it possible to turn logging off for a command?

    Good morning!

    Is it possible to turn logging off for a command? We know how to turn logging on/off for the database, but we are wondering if it is possible to turn logging on/off for just a command (and then it revert back to the state it was in before the command was executed)?

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    You can change logging mode, depending of Informix version.

    Please test run ondblog <new mode> [-f <filename>] [<database list>]

    new mode:
    buf - Change database to buffered mode.
    unbuf - Change database to unbuffered mode.
    nolog - Change database to no logging.
    ansi - Change database to be ANSI-compliant
    cancel - Cancel logging request.

    Then ondblog nolog, press <Enter>. Next onbar -b -F.

    Gustavo.

  3. #3
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    The answer to your question is no. You would have to go throught the process with ondblog/onbar or ontape. If just one command is maxing you out figure out a way to break up the command with checkpoints.
    Fred Prose

  4. #4
    Join Date
    Jul 2003
    Posts
    23
    Running SQL that copies data to a raw table is not logged.

Posting Permissions

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