Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE : -922, PLAN ACCESS 00F30034

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
riju_luvjust

New User


Joined: 04 Oct 2006
Posts: 18

PostPosted: Wed Oct 03, 2007 11:54 am    Post subject: SQLCODE : -922, PLAN ACCESS 00F30034
Reply with quote

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.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Oct 03, 2007 12:18 pm    Post subject: Reply to: SQLCODE : -922, PLAN ACCESS 00F30034
Reply with quote

what does the manual say about -922 sqlcode

read, follow the manual advice

repost if You have problems

regards

e.s
Back to top
View user's profile Send private message
mbr_raja

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Wed Oct 03, 2007 12:29 pm    Post subject: Reply to: SQLCODE : -922, PLAN ACCESS 00F30034
Reply with quote

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.
Back to top
View user's profile Send private message
riju_luvjust

New User


Joined: 04 Oct 2006
Posts: 18

PostPosted: Wed Oct 03, 2007 12:36 pm    Post subject:
Reply with quote

Thanks mbr_raja.

I will check with our DBA.
BTW can you please send me some link where i find the datails.
Back to top
View user's profile Send private message
riju_luvjust

New User


Joined: 04 Oct 2006
Posts: 18

PostPosted: Wed Oct 03, 2007 12:42 pm    Post subject:
Reply with quote

FYI

We are using RACF for security.
Back to top
View user's profile Send private message
mbr_raja

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Wed Oct 03, 2007 12:51 pm    Post subject: Reply to: SQLCODE : -922, PLAN ACCESS 00F30034
Reply with quote

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.
Back to top
View user's profile Send private message
omnamashiva

New User


Joined: 24 Sep 2007
Posts: 10
Location: chennai

PostPosted: Wed Oct 03, 2007 8:30 pm    Post subject: Reply to: SQLCODE : -922, PLAN ACCESS 00F30034
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts RACF profile access vasanthz All Other Mainframe Topics 11 Fri Sep 23, 2016 5:51 am
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts How to perform Digest Access Authenti... vasanthz All Other Mainframe Topics 0 Tue Mar 15, 2016 4:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us