db2 plan used by CICS region

3 posts / 0 new
Last post
Anonymous
db2 plan used by CICS region

Say suppose you are logged on to a CICS region, how would you determine the db2 plan used by the CICS region? is they any direct command for getting the plan name used by a CICS region?

"; ; ; ;
Anonymous
cics-db2 plan

hi, the plan do not belongs to CICS region, the plan is created when you BIND a program that uses SQL within the code. the plan belongs to the program that you are creating. 

Anonymous
cics-db2 plan

I guess you need to get the plan name for respective SSID. The plan do not belong to any region. To get plan name goto table SYSIBM.SYSPLAN and search for plan name with respective SSID.

Regards,

Vishal Sinha

Log in or register to post comments
Sponsored Listing