How can I determine all of my Repository Extensions and what underlying DB2 tables are used by them?
Maps with map IDs less than 1001 and greater than 24999 are reserved and cannot be changed.
Anything in between this range can be customized. When we deliver maintenance we only do so for the maps that are reserved by CA.
You can determine all of your customizations by checking for all maps that fall between the customizable range.
The following query will return all maps within the customizable range that are assigned to a repository dialog. In addition, the underlying DB2 table name is returned. If the extension is a “association” meaning that there is no underlying table then the query results will indicate as such
SELECT DISTINCT D.DIALOG, A.MAP_ID,
WHEN ' ' THEN '***ASSOCIATION NO DB2 TABLE***'
ELSE ENT_TBL_NAME END AS TABLE
WHERE A.MAP_ID = D.MAP_ID
AND A.MAP_ID BETWEEN 1001 AND 24999
AND D.MAP_ID = M.MAP_ID
Note. Change DBXREL30 to your repository creator