5.26.1.1. Journaling Disabled in DB2/400
![[Note]](https://webapi.partcommunity.com/service/help/latest/pages/en/ecatalogsolutions/doc/images/note.png) | Note |
|---|
Applies only to DB2 databases of the
AS400 type. |
Journaling is a special feature of this
database and must be enabled for tables when working in
"AutoCommit=false" mode.
Problem:
The data source is DB2/400.
The Auto Commit initialization property
is set to FALSE.
The target object you want to update
is a physical file or a physical file with a key
in an AS/400 library (as opposed to a DB2/400 collection),
for which journaling is not enabled.
Solution:
There are two ways
to avoid this problem:
Set Auto Commit to TRUE.
In this case, INSERT, UPDATE, and DELETE operations
are automatically committed each time they are executed.
Journaling is then not required.
In AS/400, enable journaling for the specific
table (physical file) on which you want to perform INSERT, UPDATE, or
DELETE operations.
To enable journaling, follow
these steps:
Create the journal receiver
(CRTJRNRCV).
Create the journal (CRTJRN) and
specify the journal receiver created in Step 1.
Start journaling for the physical file
(STRJRNPF): Specify the journal and the journal receiver
from steps 1 and 2, and assign the journal to a
specific SQL table (physical file).
