The following SQL can be issued against the DB2 Subsystem where the CA Repository for z/OS is installed to determine the various DB2 Tables used for each Repository Exchange.
This information may be useful for cleanup efforts, routine maintenance etc.
DISTINCT D.DIALOG AS "EXCHANGE",
WHEN ' ' THEN 'Association - No Table'
END AS "TABLE NAME",
KEYWORD AS "ENTITY TYPE"
FROM repowner.DBX_IO_MAP_DESC E,
WHERE A.MAP_ID = E.MAP_ID
AND E.MAP_ID = P.MAP_ID
AND P.ENT_TYPE = D.ENT_TYPE
AND D.DIALOG = 'DB2'
ORDER BY 2
Note. Change 'repowner' to your Repository creator.
In the above example, DB2 is specified as the Dialog Name. To run this query for additional exchanges simply change DB2 to the various Dialog names.