How to determine Repository Extensions

Document ID : KB000047616
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How can I determine all of my Repository Extensions and what underlying DB2 tables are used by them?

 

Answer

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,

CASE M.ENT_TBL_NAME

WHEN ' ' THEN '***ASSOCIATION NO DB2 TABLE***'

ELSE ENT_TBL_NAME END AS TABLE

FROM

                DBXREL30.DBX_IO_MAP_ATTR A,

                DBXREL30.DBX_DIALOG D,

                DBXREL30.DBX_IO_MAP_DESC M

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