IBM Db2 Showing Unique Index for Non-Unique Columns


I have a database which has 2 non-unique indexes, but tools like "Modify Table" or "Scripts > Copy DDL" show the columns as being unique indexes.

In the SYSIBM.SYSINDEXES and SYSCAT.INDEXES tables, they have a UNIQUERULE of "D", which means "Not unique; duplicates allowed" (

I am using the latest version of the driver (4.23.42).

I can provide other information as needed.

1 comment
Comment actions Permalink

@ Christian Snodgrass 
Looks like the described issue was fixed
Try to use the latest DataGrip 2019.1 EAP for verification.


Please sign in to leave a comment.