| General |
What are the versions of your source and target
databases? |
|
| What data types do you plan to replicate? |
|
| Will your database log retention policy have
to be altered in order to retain the database logs that CDC Replication requires
for replication? |
|
| Is your database part of a clustered environment
or a Db2 for z/OS® data sharing group? |
|
| Do you have session limits on database connections? |
|
| Are you replicating multibyte character data
(MBCS) or double byte character data (DBCS) ? |
|
| Are there any database constraints in place? |
|
| Do you want CDC Replication to
continue processing the source database log during periods when the
target is unavailable due to maintenance, network outages, or other
reasons? |
|
| CDC Replication Engine for Db2
Database |
Are you installing CDC Replication on
a different server from your source or target database? |
|
| Are you installing CDC Replication in
a Db2 HADR environment? |
|
| Have you enabled log retention for each Db2 LUW database being used for
replication? |
|
| Have you performed a database backup and scheduled
regular backups for each Db2 LUW
database being used for replication? |
|
| Are you deploying CDC Replication in
a DPF environment? |
|
| Are you targeting a Db2 pureScale environment? |
|
| Are you replicating temporal tables? |
|
| CDC Replication Engine for Db2 for
z/OS |
Is your ECSA storage size sufficient? |
|
| Do you have enough storage ‘above the
bar'? |
|
| What is the current setting in Db2 for the maximum number of batch connections
and allied threads? |
|
| How does CDC for Db2 for z/OS handle
code page conversion? |
|
| How does CDC for Db2 for z/OS handle
Data Definition Language (DDL) changes performed on in-scope tables? |
|
| Are you replicating temporal tables? |
|
| CDC Replication Engine for InfoSphere®
DataStage® |
Will you be using a Hadoop Distributed File
System (HDFS)? |
|
| CDC Replication Engine for Microsoft SQL Server |
Will CDC Replication be
installed on a different server than the target database? |
|
| Would you like to deploy CDC Replication as
part of a SQL Server clustering environment? |
|
| Are your table indexes clustered? |
|
| Will you be replicating data to tables with
computed columns? |
|
| Will you be replicating data to tables with
identity columns? |
|
Will you be replicating data to tables containing
the rowversion data type? |
|
| Will you be replicating columns with database
defaults? |
|
| Do the tables in your database have primary
keys? |
|
| Are SQL Server TCP/IP connections enabled in
the database? |
|
| How are the SQL Server services configured? |
|
| Is the server configured to be a Publisher that
acts as its own Distributor? And does the Distribution database exist? |
|
| How is the recovery model configured? FULL or
BULK_LOGGED? |
|
| What is your database backup plan? |
|
| Is there a transaction log backup plan? Do you
use third-party tools to do this or SQL Server? |
|
| CDC Replication Engine for Netezza® Technology |
Are there any installation restrictions? |
Installation considerations |
| What JDBC drivers need to be installed? |
Netezza JDBC drivers |
| CDC Replication Engine for Oracle databases |
Will your database log retention policy have
to be altered? Has enough tablespace been allocated? |
|
| Has enough undo tablespace been allocated? |
|
| Do you want to install CDC Replication in
a RAC environment? |
|
| Are you using ASM storage for redo logs? |
|
| Do your business requirements limit access to
your source database and only allow read-only users? |
|
| Is log parallelism enabled? |
|
| Do you want to ship your database logs to a
secondary system that is accessible to CDC Replication? |
|
| Are you installing CDC Replication on
a different server than the source or target database? |
|
| Do you intend to replicate compressed tables? |
|
| Is the tablespace encrypted? |
|
| Do you plan on creating multiple subscriptions
to replicate your data? |
|
| Do you plan on processing large database transactions
with CDC Replication? |
|
| Is supplemental logging enabled? |
|
| Are your online redo database logs archived
and are they accessible to CDC Replication? |
|
| Will you be performing bulk load refreshes? |
|
| Is the Oracle listener running? |
|
| Are there any Oracle database constraints in
place? |
|