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
 

 

SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME PACKAGE NAME NOT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
kudamala

New User


Joined: 12 Sep 2008
Posts: 51
Location: Bangalore

PostPosted: Tue Dec 23, 2008 5:43 pm    Post subject: SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME PACKAGE NAME NOT
Reply with quote

Hi I have a CICS-DB2-COBOL program. I have removed one field from the DB2 query in program and recompiled using a tool which has default JCL for Complie,link and BIND. When I look into the BIND, it shows BIND successful, but when I access it on screen, it is failing with the following error.

DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME MUCMVS_DBP0..EU
6F8A7410E5BD40 NOT FOUND IN PLAN DEUMN1. REASON 02
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -350 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFEA2' X'00000000' X'00000000' X'FFFFFF
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

It is an existing program and was running properly.

Can anybody help to solve the problem

thanks in advance
Ravi
Back to top
View user's profile Send private message

acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Dec 23, 2008 6:08 pm    Post subject:
Reply with quote

what about NEWCOPY in CICS?
Back to top
View user's profile Send private message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Wed Dec 24, 2008 10:23 am    Post subject: Reply to: SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME PACKAG
Reply with quote

Hi kudamala,

Please verify
1)Whether your job uses current load or not?
2)Check if your using Steplib which overrides any load from Joblib
3)Check same plan name,program name(same plan name you are using or not)?


Thanks
Jagadesh
Back to top
View user's profile Send private message
kudamala

New User


Joined: 12 Sep 2008
Posts: 51
Location: Bangalore

PostPosted: Wed Dec 24, 2008 11:07 am    Post subject:
Reply with quote

Hi Jagadesh

Thanks for your suggestions. I have posted this problem after checking all the points mentioned by you only.

Please let me know if you have any other idea

Rrgards
Ravi
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Wed Dec 24, 2008 1:21 pm    Post subject:
Reply with quote

and....

what about NEWCOPY in CICS?

you should check newcopy (phasein) is done, if not, it means your running the old version of the program.
Back to top
View user's profile Send private message
kudamala

New User


Joined: 12 Sep 2008
Posts: 51
Location: Bangalore

PostPosted: Wed Dec 24, 2008 2:03 pm    Post subject:
Reply with quote

thanks for your help.
NEWCOPY also done in CICS.

still the problem exists..

Thanks in advance
Ravi
Back to top
View user's profile Send private message
shrinivasabharathi_b

New User


Joined: 04 Nov 2008
Posts: 11
Location: Chennai

PostPosted: Wed Dec 24, 2008 2:08 pm    Post subject:
Reply with quote

If you doing a package bind .. check whether the package is associated with the plan that you execute
Back to top
View user's profile Send private message
kudamala

New User


Joined: 12 Sep 2008
Posts: 51
Location: Bangalore

PostPosted: Wed Dec 24, 2008 3:06 pm    Post subject:
Reply with quote

Thanks for support given by forum members.
This problem is application specific, the program required special rebind whenever we change DB2 query. I have followed the same and it is working now. Some rebind options are application specific.

thanks to all
Ravi
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm


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