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.
SELECT
DISTINCT D.DIALOG AS "EXCHANGE",
CASE E.ENT_TBL_NAME
WHEN ' ' THEN 'Association - No Table'
ELSE E.ENT_TBL_NAME
END AS "TABLE NAME",
KEYWORD AS "ENTITY TYPE"
FROM repowner.DBX_IO_MAP_DESC E,
repowner.DBX_DIALOG D,
repowner.DBX_IO_MAP_ATTR A,
repowner.DBX_PRODUCT_MAP P
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.
e.g
DB2
ERWIN2
ERWTRD
EXTEND
IDMS
IMS
MSSQLSRV
ORACLE
RECORDS
SHOPCNTL
SYSTEM
TERADATA