--- title: "Handling Primary Keys for DDS Tables in IBM Db2 for i" slug: "handling-primary-keys-for-dds-tables-in-ibm-db2-for-i" updated: 2025-06-23T10:45:35Z published: 2025-06-23T10:45:35Z canonical: "skthelp.syniti.com/handling-primary-keys-for-dds-tables-in-ibm-db2-for-i" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Handling Primary Keys for DDS Tables in IBM Db2 for i **Issue** In Syniti Replicate 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 Data Description Specifications (DDS) table, Syniti Replicate is unable to identify/retrieve the primary key fields using standard catalog queries. **Resolution** To resolve this issue: 1. In the Metadata Explorer, right-click the connection and select **Connection Properties**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(743).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A26Z&se=2026-11-17T20%3A30%3A26Z&sr=b&sp=r&sig=lZfINX9rNyc7aLFIojn3o7yLyQogfrrqYrB2Ys9UrrY%3D) 2. In the Management Center Connection Properties dialog, set **Use Primary Keys Extended** to **True**. 3. Reload the table settings by right-clicking the table, library, or connection node in the Metadata Explorer and selecting **Refresh**. Refreshing forces Syniti Replicate to reload the primary key information using the extended detection method.