|Product:||Syniti Data Replication (Syniti DR, fka DBMoto)|
|Summary:||Primary Key Not Shown for IBM Db2 for i, iSeries or AS/400 DDS Tables|
I’m using IBM Db2 for i ( iSeries, AS/400) as my target for replication. When I run Syniti DR/DBMoto Management Center and open each table in the target node, I can see a list of all fields in the target tables. However, Syniti DR/DBMoto shows that some of the tables have no primary key defined, when in fact there are primary keys. Why is this?
From Syniti DR/DBMoto Management Center, when you click on Db2 target tables in the target node, you should see the primary key defined in each table. However, when the table is defined as a DDS table, Syniti DR/DBMoto is unable to see the primary key fields using the standard catalog queries.
You can solve this issue by setting the property Use Primary Keys Extended to True in the Management Center Connection Properties dialog (available by selecting the the connection in the Metadata Explorer and choosing Connection Properties from the right mouse button menu.) Afterwards, you can force Syniti DR/DBMoto to reload the table settings (and specifically the primary key information) by selecting the table/library/connection node in the Metadata Explorer, and choosing Refresh from the right mouse button menu.