DB2 is providing a new “soft fence” feature that will restrict write access to a tablespace. The feature will allow write access to programs that register themselves with DB2 as replication programs.
In Q Replication, the Q Capture and Capture programs must run from a load library that is authorized by the Authorized Program Facility (APF). APF authorization is only required for the Q Capture and Capture programs. However, DB2 "soft fence" new feature needs register the Q Apply or Apply programs with the Automatic Restart Manager recovery system, you must APF authorize Q Apply program also.
You can enter " d prog,apf" command to check whether Q Apply program in APF list.
Add Q Apply program into APF list.
Delete Q Apply program into APF list.
Start database with RREPL mode: >START DATABASE(trgDB) SP(trgSP) ACCESS(RREPL)
trgDB is target site database name;
trgSP is target site tablespace name;
RREPL: Allows programs only read access to the specified databases, table spaces, indexes, or partitions, unless those programs were identified as replication programs. Attempts by non-replication programs to write to the specified objects fail.
You can use "dis db(*) sp(*) res" command to check your specified database status
- If Q Apply is not APF authorized, the RREPL registration call will fail and a new informational message (ASN7789I) will be issued.