The Db2/z Capture Agent and Apply Engines that access Db2 tables require a Db2 Package/Plan in order to access the Db2 system catalogs to obtain information regarding the tables being processed. A common database request module (DBRM) SQDDDB2D is shipped as part of the Connect CDC SQData product distribution in SQDATA.V400.DBRMLIB. The Bind of the Package/Plan SQDV4000 should be performed using JCL similar to sample member BINDSQD.
Note:
- Remove the APPLCOMPAT parameter if Db2 is not at level V12R1M500.
- The ENCODING parameter should match the default CCSID for the DB2 Subsystem which typically matches the CCSID's in the majority of tables in the Subsystem.
- Once the Bind is complete, authorization for its use must be granted for started task and job user-ids, see Prepare Db2/z for Capture.
- If the bind is being performed as part of an upgrade from Connect CDC SQData V3 to V4 then the current Capture Cab file must be updated to reflect the new Package and Plan. That can be accomplished using the sqdconf utility modify command with the --plan=SQDV4000 specified.