DB2 for Z/OS Plan Name 'DEFAULT'

Jeffrey Schade

DB2 for Z/OS Plan Name 'DEFAULT'
We are running DB2 V8 in compatibility mode and we have a problem with a
CICS transaction accessing DB2. We are experiencing intermittent
security failures with CICS transactions attempting to access a DB2 plan
called DEFAULT. We do not have any plan with a name of DEFAULT but the
only way we can get this transaction to run is to put an ACF2 rule in
that allows the CICS authid to execute this plan.



Does anyone know what causes a CICS transaction to execute using a DB2
plan name of DEFAULT and how it works when the plan does not exist.



Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering


Insurance Services Office, Inc.
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
[login to unmask email] <mailto:[login to unmask email]>




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Richard Gugel

Re: DB2 for Z/OS Plan Name 'DEFAULT'
(in response to Jeffrey Schade)
Hi Jeff.

If you sign on to CICS and enter a CEMT I DB2CONN what shows up in the
Plan entry and the Plan exit name?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Carol Anne Sutfin

Re: DB2 for Z/OS Plan Name 'DEFAULT'
(in response to Richard Gugel)
Jeff

In the CICS region check your DB2Entry. This shows the Plan assigned to
each transaction ID.
Tis also contains the parameter for AUTH checking.
TX = transaction needs EXEC on the PLAN
SIG = subsystem ID needs EXEC on the PLAN
GRO = IBM Group needs EXEC on the PLAN

If there is no entry here check the DB2Conn. There is a PLAN here that is
used if no DB2Entry is found.
The usual default from IBM is DEFAULT.
The AUTHID and AUTHTYPE also determine what needs EXEC on the default plan.

Sometimes if every transaction in the subsystem uses the same plan, the
CICS Systems person will substitute an actual PLAN name.

I suggest that you RTM for these entries

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



"Schade, Jeffrey"
<[login to unmask email]>
Sent by: DB2 Data To
Base Discussion [login to unmask email]
List cc
<[login to unmask email]
ORG> Subject
[DB2-L] DB2 for Z/OS Plan Name
'DEFAULT'
12/08/2006 10:59
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-L.ORG>






We are running DB2 V8 in compatibility mode and we have a problem with a
CICS transaction accessing DB2. We are experiencing intermittent security
failures with CICS transactions attempting to access a DB2 plan called
DEFAULT. We do not have any plan with a name of DEFAULT but the only way we
can get this transaction to run is to put an ACF2 rule in that allows the
CICS authid to execute this plan.

Does anyone know what causes a CICS transaction to execute using a DB2 plan
name of DEFAULT and how it works when the plan does not exist.

Jeff
_________________________________________
Jeffrey Schade
Systems Consultant, Technology Engineering

Insurance Services Office, Inc.
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
[login to unmask email]



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm