|
View previous topic :: View next topic
|
| Author |
Message |
ponnu116
Warnings : 1
New User
Joined: 12 Sep 2007
Posts: 21
Location: chennai
|
|
|
|
Hi,
My program is abending with abend u00087. when i looked at the MSGLG sql codes are very different please have a look at the below messages
IDI0082E DB2 DARN Call Level Interface error: SQLAllocConnect SqlError 652
sqlrc=-1.{DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=58004
ERRLOC=2:170:10. CAF "OPEN" failed using DB2 system:DARN and
PLAN:DSLVCLA . RC=08 and REASON=00f30034.
Can anyone please help me in understanding what is the problem with the job and how to solve it |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10884
Location: italy
|
|
|
|
hint...
start reading the manuals
here is some reading done on your behalf
| Quote: |
Code 00F30034
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.
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 |
|
|
ponnu116
Warnings : 1
New User
Joined: 12 Sep 2007
Posts: 21
Location: chennai
|
|
|
|
| Thanks for the information |
|
| Back to top |
|
|
ashishsr123
New User
Joined: 06 May 2008
Posts: 33
Location: Chennai
|
|
|
|
how did you search the manuals and find this error description.
I am not able to.
Please explain |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| Did you simply try searching on google with literal 'REASON=00f30034'? |
|
| Back to top |
|
|
ashishsr123
New User
Joined: 06 May 2008
Posts: 33
Location: Chennai
|
|
|
|
| Quote: |
Did you simply try searching on google with literal 'REASON=00f30034'?
|
I get lot search results.
I was interested in the manuals enrico referred to.
I searched manuals on IBMMainframes.com but do not get any results.
Thanks
Ashish |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
| Back to top |
|
|
|
|
