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?
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.
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.