Hello all. We have AS/400 servers with OS/400 V5R2M0 installed.
When I try to replicate some tables with RI rules to other server "apply" warns me about referential integrity violations on target server. The database structure and rules are identical to a source server's.
Transaction mode work was allowed with COMMIT_COUNT=1.
Everything works fine when every insert is commited separatelly, but when i use one commit for several inserts - apply fails and ends with referential constraint violations and "Apply could not read from work file" in IBMSNAP_APPLYTRAIL.
From which file it cannot read?
Why does it work when commiting every insert and doesn't work with block insert and commit?