View previous topic :: View next topic
|
Author |
Message |
kudamala
New User
Joined: 12 Sep 2008 Posts: 51 Location: Bangalore
|
|
|
|
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 |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
what about NEWCOPY in CICS? |
|
Back to top |
|
|
itjagadesh
New User
Joined: 05 Dec 2006 Posts: 89 Location: chennai
|
|
|
|
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 |
|
|
kudamala
New User
Joined: 12 Sep 2008 Posts: 51 Location: Bangalore
|
|
|
|
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 |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
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 |
|
|
kudamala
New User
Joined: 12 Sep 2008 Posts: 51 Location: Bangalore
|
|
|
|
thanks for your help.
NEWCOPY also done in CICS.
still the problem exists..
Thanks in advance
Ravi |
|
Back to top |
|
|
shrinivasabharathi_b
New User
Joined: 04 Nov 2008 Posts: 11 Location: Chennai
|
|
|
|
If you doing a package bind .. check whether the package is associated with the plan that you execute |
|
Back to top |
|
|
kudamala
New User
Joined: 12 Sep 2008 Posts: 51 Location: Bangalore
|
|
|
|
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 |
|
|
|