How to determine Repository Extensions
Article ID: 47616
Updated On:
Products
Issue/Introduction
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,
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
Environment
7.2
Repository-Webstation Option
Resolution
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
;
Note. Change DBXREL30 to your repository creator
Feedback
