IBM Support

Default DB2 database transaction log size may be too small for IBM Content Collector

Troubleshooting


Problem

The DB2 Transaction log (logfilsiz) value of the database will need to be increased if you encounter a transaction log full message, SQL0964C, in the db2cli.log or db2diag.log files.

Symptom

The IBM® Content Collector (ICC) P8 Connector log will show errors similar to the following:

2010-02-05T09:57:04Z Error An error occurred while evaluating the task route 'Archiving (Automatic)': Task Method 'ibm.ctms.p8connector.p84x.XMLInstanceTextTask' failed for entity with id '224@168@164@32@3CF5F295B4645C68C125761D001DB5A1-1@-1@119@IMPL==DOMINO;TYPE==MAILBOX;SERVERID==CN=MAIL01/OU=SRV/O=MAILSYS;STOREID==mail\jdoe;EMAILADDR==null;FILEPATH==null36@bfd52788-ace8-456e-abc1-6ecf428acc232@{}7@INITIAL': Status=error; Message='An error occurred accessing the database.  ErrorCode: -964, Message: 'DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.50.152' Statement List:  SQL: "DELETE FROM Generic WHERE object_id = ? and epoch_id = ?" In-bindings: ({C660FBE7-1A6D-446D-92CF-C3BD98B84EC8},0)  SQL: "DELETE FROM ListOfString WHERE parent_id = ?" In-bindings: ({C660FBE7-1A6D-446D-92CF-C3BD98B84EC8})' ibm::ctms::taskrouting::TaskRouteEvaluator::SubmitRoute (taskrouteevaluator.cpp:329)

Corresponding DB2 SQL0964C errors will be seen in the db2cli.log and/or db2diag.log files.

Environment

This issue may occur when IBM Content Collector is used with either a DB2® Content Manager or FileNet® P8 repository with an underlying DB2 database.

Resolving The Problem

Use the following procedure to increase the size of the DB2 transaction log (logfilsiz):

  1. Determine the current log file size setting by issuing the command:

    su - <db2instance>
    db2 list db directory # to list the database name
    db2 connect to <databaseName>
    db2 get db config for <databaseName> | grep -i logfilsiz

    Example:

    su - icmadmin
    db2 connect to icmnlsdb
    db2 get db config for icmnlsdb | grep -i logfilsiz

  2. Increase the size of the log file size setting by issuing the command:

    db2 UPDATE db cfg for <databaseName> using LOGFILSIZ <new_value>

    Example:

    db2 UPDATE db cfg for icmlsdb using LOGFILSIZ 5000

  3. Stop all ICC-related processes.

  4. Issue the commands:

    db2 force applications all
    db2stop force
    db2start

  5. Restart ICC.

Related Information

DB2 Information Center

[{"Product":{"code":"SSAE9L","label":"Content Collector"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"All Content Collector products","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.1;2.1.0;2.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

ICC;InfoSphere Content Collector;ICCP8;ICCCM;ICCLD;ICCEX;ICCFS;ICCSP

Document Information

Modified date:
23 June 2018

UID

swg21410935

Page Feedback