View previous topic :: View next topic
|
Author |
Message |
daga.aditya
New User
Joined: 30 Jun 2010 Posts: 9 Location: noida
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
daga.aditya
New User
Joined: 30 Jun 2010 Posts: 9 Location: noida
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
daga.aditya
New User
Joined: 30 Jun 2010 Posts: 9 Location: noida
|
|
|
|
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... : |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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 |
|
|
daga.aditya
New User
Joined: 30 Jun 2010 Posts: 9 Location: noida
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|