Re: How to enable journalling?

["Kolata Patrice" <PaKolata@xxxxxxxxxx>]

Hi,

Journaling files is mandatory on AS400 to allow "commit-rollback" feature on 
JDBC - using connection.setAutoCommit(false).
Each file concerned by the update/insert/delete requests needs to be updated.
If these files are located in a library created by CRTLIB, Journaling is not 
initiated.
To initiate Journaling automatically on all files from a library, you can 
create this library with SQL request "CREATE COLLECTION YOUR_LIB_NAME" (surely 
also with CREATE SCHEMA command as Dieter Bender wrote)
To initiate journaling manually:
- Create a journal receiver (CRTJRNRCV LIB/JRNRCVNAME): this journal receiver 
will remind of all operation on all records for journaled files
- Create a journal CRTJRN JRN(LIB/JOURNAL) JRNRCV(LIB/JRNRCVNAME). The Journal 
is the "gate" where data passes through to be stored in associated journal 
receiver. This is useful for instance to change/clear the receiver without 
stopping journaling, and without changing journaling properties.
- Start journaling your files STRJRNPF FILE(LIB/FILE1 LIB/FILE2 ...) - see 
STRJRNPF command options like OMTJRNE(*OPNCLO) for instance.
- To end journaling a file, use ENDJRNPF FILE(...)

Note that journaling stores any requests performed on journaled files. The 
journal receiver size may grow significantly for many database use/updates.
If the size of the receiver becomes too large, creates a new journal receiver 
and change the "link" between the journal and the "attached" receiver (see 
CHGJRN command)

Dr Patrice Kolata

>Hi,
>
>easiest way is ito start with CREATE SCHEMA and then run your sql scripts to 
>create your tables etc. Anything with journaling is happening automatically 
>this way.
>
>Dieter Bender
>
>On Montag, 8. März 2004 17:12, Deepa Ramamurthy wrote:
>> Hello!
>>
>> I am a Java programmer and came across the SqlException 7008 when I
>> deployed some code on the AS400.
>> After some research, I found out that this is happening because the files
>> are not journalled.
>> How do I journal the files?
>>
>> Thanks.





**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************