DB2 Log Database: sessions cannot be deleted

Symptom

When using DB2 as Runtime Log Database, deletion of sessions are not working properly, or is partially performed.

 

Solution

Check if the following parameter is properly present in Runtime's Configuration file for the Log Database.

We updated the samples in recent Runtimes to include it but it may be missing on old versions.

 

<...>
  <logs>
    <log userLogName="logDatabase" autoUpdate="true" userLogClass="com.indy.engine.userLog.RdbmsUserLog">
      <...>
      <parameter name="userLogRdbmsUseAliasTableForDeleteClause" value="true">
      <...>
    </log>
  </log>
<...>