MVSFORUMS.com

[pnbalaji]

Hi,

Can some one help me in finding the DB2 table qualifiers that a CICS region is accessing?. The command CEMT I DB2E gives only the DB2 sub system the CICS region is connected to, and not the table qualifiers. Is there any way I can find it?.

We have 5 DB2 sub systems and 9 CICS regions at our work place.

Thanks,
Balaji

[kolusu]

Pnbalaji,

Once you know the DB2 subsystem, run the following query in spufi

[pnbalaji]

Well, I need to get the DB2 qualifier info from CICS, not from SPUFI or any other DB2 command processor under MVS TSO or ISPF.

Thanks,
Balaji.

[Maheshwari]

Balaji,

You can use CEMT INQ DB2T(*) to get the plan name and then inquire on SYSIBM.SYPLAN table to get the Qualifier.

SELECT NAME, QUALIFIER
FROM SYSIBM.SYPLAN
WHERE NAME IN ('XXXXXXXX','YYYYYYYY')

where XXXXXXXX and YYYYYYYY are the plan names extracted above.

Hope this helps.
_________________
Amit