Communication channel locks AS400 file

[michel_dekimpe]

Hello,

We've got the following problem.

Scenario is Proxy -> JDBC adapter to as400 database

The file is always locked when filling entries in it.

Stopping the communication channel solves this, but, next time the process runs, the file is locked again.

Regards, Michel

[Former Member · Accepted solution]

Hi,

in reciver JDBC adapter, in Advanced Mode option, use the option Disconnect from database after processing each message.........

Regards,

Rajeev Gupta

[michel_dekimpe]

Hello,

It was sovled by the first reply to this thread

"in reciver JDBC adapter, in Advanced Mode option, use the option Disconnect from database after processing each message........."

Regards, Michel

[former_member206760]

Dear Michel,

can you share how did this problem got solved ?

[Former Member]

Hi

I guess for "as400 database" table which u r inserting data from Proxy is the master data which is connection to u r many other applications.

So better to have seperate Intermidate table for XI data transfer , from here transfer to u r main table

This will solve u r problem.

Any more elobration ??

rgds

srini