Manual

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

4.23.1. Linkdatenbank Fehlerbehebung 4.23.1.1. Disabling Journaling on DB2/400
Zurück	Weiter

	Hinweis
	Only concerns DB2 databases of type AS400.

Journaling is a special property on this database and has to be enabled for tables when working in the "AutoCommit=false" mode.

Problem:

The data source is DB2/400.
The Auto Commit initialization property is set to FALSE
The target object that you are attempting to update is an AS/400 physical file or keyed physical file residing in an AS/400 library (as opposed to a DB2/400 collection) for which journaling has not been enabled.

Solution:

The following describes two ways to prevent this problem:

Set Auto Commit to TRUE.

In this case INSERT, UPDATE, and DELETE operations are automatically committed whenever they are executed. Journaling is not required.
Enable journaling in AS/400 for that particular table (physical file) for which you want to do an INSERT, UPDATE, or DELETE.

To enable journaling, do the following:
1. Create the journal receiver (CRTJRNRCV).
2. Create the journal (CRTJRN) by inputting the journal receiver created in step 1.
3. Start the journal physical file (STRJRNPF) by inputting the journal and journal receiver created in steps 1 and 2 and associating the journal to a specific SQL table (physical file).

Zurück	Nach oben	Weiter
4.23.1. Linkdatenbank Fehlerbehebung	Zum Anfang	4.23.1.2. Fehlgeschlagener Datenbank Login