Skip to Content
Custom Search

db2 plan used by CICS region

  • Post reply
2 replies [Last post]
Sat, 12/31/2011 - 15:20
Anonymous

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?

"; ; ; ;
Top
  • reply
Sponsored Listing
Top
  • Email this page
Thu, 01/05/2012 - 19:24
#1
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. 

Top
  • reply
Wed, 02/01/2012 - 18:03
#2
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

Top
  • reply
  • Post reply

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Who's online

There are currently 0 users and 24 guests online.
Dr. Radut | forum