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
 

 

U00087 in a DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
ponnu116
Warnings : 1

New User


Joined: 12 Sep 2007
Posts: 21
Location: chennai

PostPosted: Mon May 26, 2008 12:20 pm    Post subject: U00087 in a DB2 program
Reply with quote

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

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10257
Location: italy

PostPosted: Mon May 26, 2008 12:35 pm    Post subject: Reply to: U00087 in a DB2 program
Reply with quote

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
View user's profile Send private message
ponnu116
Warnings : 1

New User


Joined: 12 Sep 2007
Posts: 21
Location: chennai

PostPosted: Mon May 26, 2008 12:51 pm    Post subject:
Reply with quote

Thanks for the information
Back to top
View user's profile Send private message
ashishsr123

New User


Joined: 06 May 2008
Posts: 33
Location: Chennai

PostPosted: Fri Sep 12, 2014 12:55 am    Post subject: Reply to: U00087 in a DB2 program
Reply with quote

how did you search the manuals and find this error description.
I am not able to.

Please explain
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Fri Sep 12, 2014 4:05 am    Post subject:
Reply with quote

Did you simply try searching on google with literal 'REASON=00f30034'?
Back to top
View user's profile Send private message
ashishsr123

New User


Joined: 06 May 2008
Posts: 33
Location: Chennai

PostPosted: Fri Sep 12, 2014 6:24 am    Post subject:
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Sat Sep 13, 2014 2:02 am    Post subject:
Reply with quote

Ashish, Please spend some time searching logically, No one derives this by their own so trust US. Here I found you the link.

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


http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnc1k17/4.23.51?SHELF=&DT=20100614130926&CASE=
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 3 Mon May 29, 2017 8:10 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm


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