Q Replication and Event Publishing

Specifying nicknames for the automatic load option for Q Replication

Some Q subscriptions that use the LOAD from CURSOR utility to load target tables require nicknames. The nickname is defined on the Q Apply server to refer to the source table on the Q Capture server.

Before you begin

The Q Apply server must be a federated server.
If you want the Replication Center or ASNCLP program to create nicknames, you must create a server definition, wrapper, and user mapping.

About this task

Nicknames are required when the Q Apply program is on Linux, UNIX, or Windows in the following cases:

Q Apply is at Version 9.7 Fix Pack 3 or older and is remote from the Q Capture server.
Q Apply is at Version 9.7 Fix Pack 4 or newer but the Q subscription includes XML columns.

In all other cases, the Q Apply program calls the LOAD from CURSOR utility by using a DB2® alias for a cataloged database rather than a nickname. You must add the DB2 alias to a password file that is created by the asnpwd utility.

When you create Q subscriptions, you can have the Replication Center or ASNCLP program create nicknames, or you can specify existing nicknames.

Note: The federated server does not support user-defined types, distinct types, and reference types as columns of nicknames. To create a nickname on a remote object that uses these types, you can create a remote view on the remote object. The remote view must use supported data types. Then create a nickname on that remote view. For more details, see Mapping data types from data sources to the federated database system.

Procedure

To specify nicknames for loading Q subscriptions, use one of the following methods:

Method	Description
Replication Center	Use the Loading Target Tables page of the Create Q Subscriptions wizard to specify an existing nickname or create a new one: Single Q subscription To create a new nickname, select a registered server definition on the Q Apply server and specify an owner and name for the new nickname. To specify an existing nickname, provide the name and owner of the nickname. Multiple Q subscriptions To create new nicknames, select a registered server definition on the Q Apply server. To specify existing nicknames, click Properties on the Review Q Subscriptions page to select each Q subscription that requires a nickname.
ASNCLP program	Use one of the following options in the CREATE QSUB command: Single Q subscription Use the NICKNAME or NEW NICKNAME RMT SERVERNAME keywords to specify an existing or new nickname. Multiple Q subscriptions It is recommended that you use the NAMING PREFIX option with the NEW NICKNAME RMT SERVERNAME keywords so that the ASNCLP program can generate a unique nickname for each source table.

Method

Description

Replication Center

Use the Loading Target Tables page of the Create Q Subscriptions wizard to specify an existing nickname or create a new one:

Single Q subscription

To create a new nickname, select a registered server definition on the Q Apply server and specify an owner and name for the new nickname.
To specify an existing nickname, provide the name and owner of the nickname.

Multiple Q subscriptions

To create new nicknames, select a registered server definition on the Q Apply server.
To specify existing nicknames, click Properties on the Review Q Subscriptions page to select each Q subscription that requires a nickname.

ASNCLP program

Use one of the following options in the CREATE QSUB command:

Single Q subscription: Use the NICKNAME or NEW NICKNAME RMT SERVERNAME keywords to specify an existing or new nickname.
Multiple Q subscriptions: It is recommended that you use the NAMING PREFIX option with the NEW NICKNAME RMT SERVERNAME keywords so that the ASNCLP program can generate a unique nickname for each source table.

Send your feedback | Information roadmap | The Q+SQL Replication Forum

Last updated: 2013-10-25