I need to find domain owners and other things using SQL. I found few examples with geodatabase system tables for SQL Server and Oracle but nothing for DB2. I'd appreciate it if anybody provides an example on how to use SQL with the DB2 system tables.
This may point you in the correct direction: Domains in a geodatabase in DB2—Help | ArcGIS Desktop
You are probably going to have to join some of the GDB_ tables to get the desired output.
Here is a SQL sample for Oracle, you will want to verify the table names, etc.
select i.name “Domain Name”, t.name “Domain Type” from gdb_items i, gdb_itemtypes t where i.type = t.uuid and t.name like '%Domain%' order by t.name,i.name asc;