Determine DDS described physical files containing Unique Keys

RetrievePFwithUniqueKey

-- Determine DDS described physical files with unique Keys
Select a.* 
From syspartitionIndexstat a
Where     Table_Schema = 'YOURSCHEMA' 
      and Index_Type   = 'PHYSICAL' 
      and UNIQUE       = '0';

Determine DDS described physical files containing Unique Keys

For determining DDS described physical files with a non-unique key, UNIQUE = '2' must be checked.
-- Determine DDS described physical files with non-unique Keys

Select a.* 
From syspartitionIndexstat a
Where     Table_Schema = 'YOURSCHEMA' 
      and Index_Type   = 'PHYSICAL' 
      and UNIQUE       = '2';