Re: ODBC Error

On Tue, Sep 20, 2011 at 9:23 AM, <rob@xxxxxxxxx> wrote:

Honestly, there are some performance concerns with journalling.  We ended
up purchasing IBM's
Resource
  ID     Option  Feature  Description
5770SS1   42       5117    HA Journal Performance

That significantly helped our month end's.  Much more so than SSD's did.

More correctly, there are performance concerns of journalling without
using commitment control that can be solved by the above license
program option.

If using commitment control, the above will have no effect. The above
allows the system to cache journal entries for writes done outside of
commitment control. The caching behavior is automatic when you use
commitment control.

However, in order to benefit from caching if you are using commitment
control, you need to make sure your transactions are large enough.
Committing after every write isn't going to benefit from the cache.
Ideally, you'd want as close to 128KB of journal entries generated
before the commit. I tend to simply commit blocks of 1000 records.

HTH,
Charles