General Page
This page includes FAQs for EP, Q Rep and SQL Rep topics that are not platform-specific.
It replaces the IBM Data Replication Community Wiki Q Rep SQL Rep and EP FAQ page.
It replaces the IBM Data Replication Community Wiki Q Rep SQL Rep and EP FAQ page.
| Title/Link or Questions | Abstract or Answers |
|
|---|---|---|
| EP | ||
|
How to specify code page, delimiters for delimited message format of EP? |
Often asked by customers. |
|
| How to handle for bit data (raw data) in EP comma-delimited messages? | Binary data is just like any data in an EP message. It is encoded before being published. So the consumer application first decodes the message before processing the binary/raw data. | |
| Is there a sample program to consume EP messages to files? | Event consumer sample program for moving DB2 changed data from WebSphere MQ to files using Q Replication Event Publisher. | |
| Is there a sample program to consume EP messages to Netezza? | Event consumer sample program for moving DB2 changed data from WebSphere MQ to files and then a Netezza database using Q Replication Event Publisher | |
| Q Rep | ||
 POCsupport.Nov2015.xlsx |
This spreadsheet is continuously updated from customer POC feedback. It includes links to relevant information and new tips on how to deploy Q Replication on z/OS. | |
| How do I start the Dashboard from Tivoli TEP? | GDPS/Active-Active users who monitor Q Replication with Tivoli Enterprise Portal (TEP) can view performance and health information by starting the InfoSphere Data Replication Dashboard from within TEP. | |
|
How do I migrate to Q Replication 10.2.1? |
Includes: new plan names, alters of CCD tables or use of a 'tolerate' option if that is not possible, alter add columns of control tables, conversion of data in tab version and column version tables. The link provided here points to the on-line doc. You can also go to the z/OS page for a presentation on the topic. |
EP QRep |
| How should I configure the Initial Refresh of Target tables? | Best practice is to use the external load option for very large tables. Note also that with internal load option (Q Apply triggers the load for you), the target table is load replaced (no parallelism or separation by db2 partition). So you may also want to use external load to load a table at a partition level (allows for more control). | |
| SQL Rep | ||
| How do I migrate to SQL Replication 10.2.1? (Required level for DB2 z V11 CM or NFM) Note: once SQL Capture is at 10.2.1, it requires SQL Apply z 10.2.1, or if LUW target, it is recommended to be at DB2 10.1 FP5 or 10.5 FP6 (requirement is to be at least at DB2 10.1 FP) |
Includes new plan names, alters of CCD tables or use of a 'tolerate' option if that is not possible, alter add columns of control tables include user CD tables, conversion of all LSN column values of all control tables as well as CD tables. The link provided here points to the online doc. You can also go to the z/OS page for a presentation on the topic. |
|
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF051","label":"Linux on IBM Z Systems"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
13 November 2019
UID
ibm11105179