Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    New York
    Posts
    248

    Question Unanswered: buffered or unbuffered loging

    Hi

    When querying sysmaster:sysdatabases
    there are fields: is_logging and is_buff_log I'm assuming one is for unbuffered and the other one is for buffered.

    I have two values 1 and 0 I'm assuming 1 for yes and 0 for no right?
    also, one database has 1 and 1 in both columns, how is that possible?

    Is there any other way to find out if the database is buffered and unbuffered login, running Informix 7.31 on WInNT. Do not have onmonitor utility
    (guess it does not exist for win NT)


    Thank you
    Last edited by artemka; 05-18-04 at 18:29.

  2. #2
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    BUFFERED LOG
    is_logging 1
    is_buff_log 1
    is_ansi 0
    is_nls 0
    flags 3

    UNBUFFERED LOG
    is_logging 1
    is_buff_log 0
    is_ansi 0
    is_nls 0
    flags 1

    ANSI MODE
    is_logging 1
    is_buff_log 0
    is_ansi 1
    is_nls 0
    flags 5
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

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