Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
regarding db2--805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
karthikuma

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Fri Jul 22, 2005 9:50 am    Post subject: regarding db2--805
Reply with quote

Hi,

this i've been faced in the interview.

the interviewer asked me what is -805.i said that it's program name is not found in plan.he told that progarm name is correct but still i'm facing the same problem,wat's the reason usually u'll get this type of sqlcode.please any one give me an good solution ,even the progarm name is correct but i'm geting -805.what's the problem.give me an good solution.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Jul 22, 2005 4:31 pm    Post subject: Re: regarding db2--805
Reply with quote

Hi karthikuma,

I Cant give you a clear picture....As I didnt have any exp on that.....Just got some material on that ...

Check whether it helps you.....

Explaination :

An attempt was made to execute the application program 'location name.collection id.program name.consistency token' (this token can be 'location name..program name.consistency token' if the current package set special register is blank for the local program execution) that has not been found due to one or more or the following reasons:
*The program 'program name' has not been bound as the member part of the application plan 'plan name'
*The 'collection id' in the PKLIST was not correct when the application plan 'plan name' was bound
*The current package set special register was not set correctly
*The 'location name' in the CURRENTSERVER was not correct when the application plan 'plan name' was bound,
*The application was not connected to the proper location
*The location id in the package list was not correct when the application 'plan name' was bound
*The DBRM of the version of the application program being executed was not bound.

Resolution :

Based on the above reasons, the programmer can perform the following operations to correct the error.
* Bind the program 'program name' as the member part of the application plan 'plan name'
* Correct the collection id in the PKLIST and bind the application plan 'plan name'
* Set the current package set special register correctly
* Put the correct 'location name' in the CURRENTSERVER of the BIND command and bind the application plan 'plan name'
* Connect to the correct RDB name
* Correct the location id in the PKLIST and bind the application plan 'plan name'
* Bind the DBRM of the version of the application program to be executed

Regards,

Priyesh.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:


Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us