Articles & Content


Build Replication in a Snap! (H13)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-22 (08:00 AM - 09:00 AM)
SPEAKERS: Ray Houle (The Fillmore Group)

Since the beginning of IBM replication the GUI front end has been a pain point. The much improved Replication Center still remains an element of frustration for many users. Both Q and SQL replication support a command interface called ASNCLP. ASNCLP is essentially DDL (data definition language) for replication. We will expose the workings of this form of syntax. The presentation visits the technique of coding SELECTs which generate customized syntax as output. In this case we use this approach to generate ASNCLP syntax. This presentation will share a definition strategy where we build entire replication scenarios from the ground up with a single script. I've used this technique to build SQL replication between 6 sets of databases involving over 2000 tables. In another scenario, a script builds peer-to-peer Q Replication including the MQ definitions and all the operational runtime scripts. The user simply provides the number of peers as a parameter.

EXP. LEVEL: Advanced


Present ASNCLP command interface as a powerful alternative technique to build either Q or SQL Replication.

Expose the workings of the ASNCLP syntax.

Present the concept of using SQL and scripting to generate customized ASNCLP syntax, MQ definitions and operational scripts, and Capture & Apply runtime scripts.

Share customizable scripting templates for building SQL Replication and another for building Q Replication.

Explain how to customize the scripts and build in significant additional persistent value for your scenario reflecting replication best practices.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.