CA TPX Session Management for z/OS

Repository Tip: Repository Exchange / DB2 Table Correlation 

10-28-2014 02:54 PM

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

           

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.