SQLCODE : -922, PLAN ACCESS 00F30034

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

HI All

In one of our test environments we are getting -922 abends due to plan
access. One of our program FALC052 is calling One program from V+ and getting some details and updating our DB2 table. While updating the things we are getting the eoor message as below

FALC052 09/27/2007 17:53:44 1418 00000000 00000000 FALC052
1000-PROC-TRANS TABLE : NONE SQLCODE : -922
PLAN ACCESS 00F30034 GECF-TH 4093380150190417 U.CHAIKRITYANON

The letter in bold are the details which we want to update.

As the extraction of details from V+ is successful, i think there is problem in updating DB2 table.

We are z/OS 1.4 and DB2 V7.1. Any one have any idea to resolve this issue.

enrico-sorichetti · Posted: Wed Oct 03, 2007 12:18 pm

what does the manual say about -922 sqlcode

read, follow the manual advice

repost if You have problems

regards

e.s

mbr_raja · Posted: Wed Oct 03, 2007 12:29 pm

Hi,

The problem arises due to the Authorization failure for this problem. See the information given below.

Problem
You have a DB2® transaction failing in your CICS® region with an abend AD2U. You are trying to find the reason code in the transaction dump so you can determine why the create thread failed.

Cause
An abend AD2U means an attempt to create a DB2 thread by the TCB servicing the DB2 request failed. Note that the AD2U does not always mean the transaction abnormally terminated with an AD2U, but that an AD2U dump was taken. This depends on the setting of THREADERROR in the DB2CONN definition.

Solution
Examine the AD2U dump to determine what SQLCODE and reason code you are receiving. You can locate the reason code by entering a find on the term SQLCA in the transaction dump. You should find it in the eyecatcher area of a piece of task storage. For example, you might see 00F30034 within the SQLCA area.

Reason code 00F30034 is an Authorization failure. If THREADERROR(N906D) is specified, an error code is passed back to the application. SQLCODE -922 indicates an Authorization Failure. Subsequent requests from the application would receive an SQLCODE -906.

Following is a more detailed explanation of 00F30034 taken from the DB2® Messages and Codes manual:

Explanation: The authorization ID associated with this connection is not authorized to use the specified plan name or the specified plan name does not exist.
This reason code is issued by the following CSECTs: DSN3CT30, DSN3SI30

System Action: The request to allocate a plan to the authorization ID is denied.

User Response: Verify that the correct plan name was specified. If this plan exists, then request execution authority to the plan from either the owner of the plan or from another person given authority to grant execution authority to the plan.

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

Thanks mbr_raja.

I will check with our DBA.
BTW can you please send me some link where i find the datails.

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

FYI

We are using RACF for security.

mbr_raja · Posted: Wed Oct 03, 2007 12:51 pm

Hi,

The RACF security will not solve this problem, you need to contact Application DBA to authorize the plan. Check the plan name already exist else create a new plan and inform to DBA to have execute privileage for the given plan.

omnamashiva · New User Joined: 24 Sep 2007 Posts: 10 Location: chennai

Hi friend,
May i know what tool your using for access DB2 like file -aid etc. Then goto admin for db2 where you can change PLAN to public. This will help you to solve your problem

Regards,
Arunachalla