View table indexes - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

You can use a Table Refresh to return index information for all DBMS types. For available and sending tables that are defined with indexes, the Connect CDC Director displays each index’s name, its uniqueness (the term “UNIQUE” or “NON-UNIQUE”), and the names of the columns that are part of it. See Refresh the available tables cache.

Two areas in which the display of the indexes may be helpful:

  • The columns you select as distribution key columns on the Sending Table Properties, Columns page must be primary key columns or columns that constitute a unique constraint.

  • The Connect CDC Director considers unique indexes as well as primary keys in its determination of distribution keys in default column mappings. If a primary key is defined for the table, it is used. If the table has no primary key but at least one unique index, the first unique index defined for the table is used as if it were a primary key.