OWJRNL with AS400 enterprise Server

[franck_blettner]

Hi all,

I've a strange problem on an AS400 enterprise server. We are currently upgrading from XE to 9.1, Tools Release 9.1.3.
Several transactions failed on our enterprise server. After analysis, we can see that tables are not started for journaling, even in pristine environment.
Usually, the process to start should be done automatically but not on our AS400.
I did a test with another enterprise server on Windows with the same DB2/400 database, and the process works fine with this server.
Does someone see the same behavior because i don't want to start manually journaling for every needed table.

thanks for your answer

 

[78aspide78]

Make sure to setup the journal library and receiver in your jee.ini

 

[jdelisths]

Also verify that the database system user has authority to issue the STRJRN command on the iSeries.

 

[franck_blettner]

We have already check all these parameters and all seems to be good. For information, we can also start journaling manually with the user defined in JDE.INI.

 

[78aspide78]

Are you sure you have the right journal library in your jde.ini?
Can you post your jee.ini?