IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Getting -922 with protection exception in cobol/db2 module.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
daga.aditya

New User


Joined: 30 Jun 2010
Posts: 9
Location: noida

PostPosted: Sat Sep 24, 2011 2:10 pm
Reply with quote

Hi,

I am getting protection exception (System Completion Code=0C4).
in one of my new batch module. This is happening when i am calling another module from this batch module. This happens when system encounters first db2 query in the called module.

I have checked db2 logs in abend aid there it shows -922 The connection to DB2 failed with a 'PLAN ACCESS', authorization error
and a '00F30034' reason code.

I am not able to understand the reason since the pointer that is required in the called module is getting set correctly and the new batch module is also bound correctly (through changeman).

The plan for the new batch module is also public in PLAN AUTH table.

Please if possible let me know how to get over this. This would be a great help.


Thanks.
Aditya
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Sep 24, 2011 2:59 pm
Reply with quote

Quote:
00F30034

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


It is one or the other. Forget everything you've already checked and go through it again, remembering it is one or the other.
Back to top
View user's profile Send private message
daga.aditya

New User


Joined: 30 Jun 2010
Posts: 9
Location: noida

PostPosted: Sat Sep 24, 2011 3:06 pm
Reply with quote

It is one or the other. Forget everything you've already checked and go through it again, remembering it is one or the other..

Can you please explain it a bit.

Thanks in advance.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Sep 24, 2011 3:21 pm
Reply with quote

Quote:
The authorization ID associated with this connection is not authorized to use the specified plan name <== one
or
the specified plan name does not exist <== the other.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Sep 24, 2011 3:21 pm
Reply with quote

The 00F30034 explanation shows you what causes the 00F30034.

So, go back, because one of the two bolded explanations is telling you what the cause is. Try to identify. If you fail, start again, because it is one of these two things. It helps when starting again to forget everything you "know" about the problem, because something you know is "wrong". The message is right. So find which you have got wrong/are using wrong.

Edit: Thanks enrico. Succinct.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Sep 24, 2011 3:34 pm
Reply with quote

Bill, it is Saturday, afterall.

sit down and teach this guy db2.
you can start by asking daga.aditya what does his SYSTIN control cards look like for IKJEFT01/1A/1B?
Back to top
View user's profile Send private message
daga.aditya

New User


Joined: 30 Jun 2010
Posts: 9
Location: noida

PostPosted: Sat Sep 24, 2011 3:39 pm
Reply with quote

dbzTHEdinosauer,

I would love learn to learn from you guys as it is i am new to this technology.

I thought this forum is to technically help the needies, but what i am seeing is ppl here more to pass comments than to help.

Thanks a lot for your input,

@Bill Woodger : Thanks for your help and guidance greatly appreciate this. Thanks... : icon_sad.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Sep 24, 2011 3:51 pm
Reply with quote

you receive comments because you don't need help,
you need full education about the subject.

there is a beginners forum,
this is not a beginners forum.
I gave you a starting point.

we are not here to train you
/ that is the responsibility of your organization
/ or yours incase of resume fraud,
we will help you interpret the manual when something is not clear
or as in your case, i told you to look at the dsn parms.

you are a typical whinny child
who has no grasp of the basics
and expects us to save his job for him.

RTFM.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Sat Sep 24, 2011 3:57 pm
Reply with quote

daga.aditya,

dbz knows several mountains more than I do about DB2. I can just about spell DNB2, but I can read error messages.

When you are starting out, you have to learn, quickly, that what a message is telling you is correct even if you have already checked it and found out that the message is wrong. If you stick to thinking the message is wrong, you've made another mistake and you won't fix either without help.

An aid to looking again at a message that you think doesn't give the answer is to forget everything you already "know" about it, because something you "know" is wrong.

If you are just a beginner, good luck, and you might find the climate less intimidating in the associated forum for students and beginners. Instant access, designed for the new starter. Some of the contributors here also contribute there, as well as other knowledgeable people, so you're not missing out on quality of answer, just on the expectation that you should know more than you do before posting here.
Back to top
View user's profile Send private message
daga.aditya

New User


Joined: 30 Jun 2010
Posts: 9
Location: noida

PostPosted: Sat Sep 24, 2011 4:08 pm
Reply with quote

Bill Woodger,

Thanks a lot for making me understand this as i was really unaware about the beginners forum.


dbzTHEdinosauer,

If i am whinny child, then you are an overknowledged elder who has too much attitude about it.

But being the youngest here i just want to share one thing that knowledge should always be shared,

And the grace of the knowledeged person always remains when he is humble.

That was just a thought that came to my mind.

Would really like to you once i reach the same knowledge level where you think you are.

Pleas excuse me if it has hurt any body. I am closing my post here.

Thanks a lot for your help guys.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Sep 24, 2011 4:34 pm
Reply with quote

i don't ascribe to liberal PC watch out for others feelings BS.

also, was anything I said - untrue.

In my first post i made three comments:
1.it is saturday
2.the TS needs to learn DB2
3.and a question to start the analysis phase.

the first, i am sure, did not offend your feelings
the second apparently hit home
you ignored the third.

that so much of this thread was wasted on your feelings,
instead of analysis of your technical problem,
indicates that with your attitude,
it will take more time than you have to achieve the pittance of knowledge that i have.

what i do have is an ability to get to the root of the problem.
in this case two problems.

the greatest hindrance to solving a problem
is the insistence of the analyzer that he has done nothing wrong.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Sep 24, 2011 6:11 pm
Reply with quote

Quote:
But being the youngest here i just want to share one thing that knowledge should always be shared,

knowledge should be shared with people who deserve it
not with any <any derogatory adjective of Your choice> <any derogatory noun of Your choice> who feels entitled to a reply just because he asked !
what research di You carry on on your own to show that You deserve to be helped ?

From Your profile I.T PROFESSIONAL
researching and reading manuals are part of the very basic skills ot the profession
if You do not have them You do not have any right to qualify as such

here is the link to the mother of all knowledge for IBM software
www-03.ibm.com/systems/z/os/zos/bkserv/index.html

meditate on the fact that the answers You get on a forum are free of charge and on our own time

a suggestion
to make the most out of the questions You ask and to forecast the comments You might receive
it would be wise for You to read and meditate on
how to ask questions the smart way
here catb.org/~esr/faqs/smart-questions.html
or .. for a more PC language
here support.microsoft.com/kb/555375
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sun Sep 25, 2011 9:52 am
Reply with quote

Hello,

Quote:
But being the youngest here i just want to share one thing that knowledge should always be shared,
Interestingly enough, this coment is posted often - by people who want lots for nothing. . . Those of us who believe and practice sharing knowledge do not need to say it . . .

Quote:
I thought this forum is to technically help the needies, but what i am seeing is ppl here more to pass comments than to help.
No, not the needies, but rather those who show they want to help themself. You need to understand that if the seniors here can show you how to research problems and to present proper questions they will have provided more help than some simple answer. . .

You also need to understand that this forum was intended for experts, but now has more complete beginners than experts. . . As was mentioned, we have another forum for students and beginners (of which you are one).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 2
No new posts COBOL -Linkage Section-Case Sensitive COBOL Programming 1
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts Generate random number from range of ... COBOL Programming 3
Search our Forums:

Back to Top