IUG News

Aktuelles von der IUG.

 

IIUG - Informix News
IIUG Forum: IDS Forum
  • Re: dbexport on RSS Secondary
    blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px
    #715FFA solid !important; padding-left:1ex !important; background-color:white
    !important; } Last commited only works on secondaries if the secondary is...
  • dbexport on RSS Secondary
    I’m running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on
    separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the
    following:

    Enhancements...
  • Re: Use of offset for new chunks
    We have been running IDS on Linux and using Logical Volumes on raw disk
    for many years with chunk offset of 0 ( Zero) with...
  • Re: LOGBUFF size
    As you can see on the logical logging bloack, pages/io is 1.2. So your
    using, on avrerage less that 4K (if your system page size...
  • Re: LOGBUFF size
    blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px
    #715FFA solid !important; padding-left:1ex !important; background-color:white
    !important; } Also you might want to consider having a transaction running...
  • Re: LOGBUFF size
    If you try buffered logging, remember that your average log buffer flush is
    only writing 1.2pages so your transactions are fairly small so set the...
  • Re: LOGBUFF size
    Thanks Art and Andrew for the info!

    We have a lot of small transactions , about one million per hour.

    So, when each COMMIT trigger...
  • Re: LOGBUFF size
    Hi, Fernando,

    I tried "onstat -l" a couple of times( see below for its top part. today
    might not be a busy day). I saw...
  • Re: LOGBUFF size
    First, if your databases are UNBUFFERED or ANSI mode logged then the size
    of the logical log buffer is not important and increasing it will...
  • RE: LOGBUFF size
    I wrote a little bit about it back in 2010 when I was messing around with an
    OLTP benchmark.

    http://www.informix-dba.com/2010/05/oltp-benchmark-cheats.html

    Setting buffered logging improved my...