Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
Author Message
ponnu116
Warnings : 1

New User


Joined: 12 Sep 2007
Posts: 23
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
References
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 3277
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: 23
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1