DB2 database configuration

Edit online

In this topic, a check is made that database parameter CUR_COMMIT has been set.

The CUR_COMMIT parameter controls the behavior of cursor stability scans and works in conjunction with the FILENET_CM setting of the DB2_WORKLOAD registry parameter.

To check that the database parameter CUR_COMMIT is enabled:
  1. A connection to the database was made.
  2. The database configuration was obtained:
    
> db2 get db cfg
…
Currently Committed                         (CUR_COMMIT) = ON
 CHAR output with DECIMAL input        (DEC_TO_CHAR_FMT) = NEW
 Enable XML Character operations        (ENABLE_XMLCHAR) = YES
 WLM Collection Interval (minutes)     (WLM_COLLECT_INT) = 0
…
  3. If required, the CUR_COMMIT parameter was enabled.
For information about tuning IBM® FileNet® P8 databases, proceed to this URL at the IBM Knowledge Center:
https://www.ibm.com/docs/en/filenet-p8-platform/5.2.1
Then select: Performance tuning and proceed to the Web page that describes how to improve the performance of IBM FileNet P8 components that use an IBM DB2® database.