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
 
-805 plan abend with plan exit

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

New User


Joined: 03 Feb 2006
Posts: 11

PostPosted: Fri Feb 02, 2007 3:27 am    Post subject: -805 plan abend with plan exit
Reply with quote

Hi,

I am trying to execute 2 cobol DB2 pgms EMXOEM11 and EMXOEM10.
Thru CICS transaction WMGW for which I have assigned planexit TBEMXXIT.

TBEMXXIT is an existing PLANEXIT for TRFT.

Whenever EMXOEM11 or EMXOEM10 are executed individually any number of times, they are running fine.

But EMXOEM11 and EMXOEM10 are executed alternatively, the second pgm is abending with -805.

Strange thing is when I check DUMP I found below
------------------------------------------------
SQLCODE ,-805,

Program name,GEIMCDST1..EMXOEM11.1802112A00E15F6A,was not found in plan ,
TBEMXK04.,An attempt was made to execute the specified application program , which was not found. ,
------------------------------------------------

But the plan name TBEMXK04 is plan for EMXOEM10.

Wrong plan is displayed in the dump.

Could anyone help me in this.
The correct plan for EMXOEM11 is TBEMXK05.

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

vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Fri Feb 02, 2007 12:15 pm    Post subject:
Reply with quote

Note : Below quey You can execute and check it

Problem Determination: The following queries aid in determining the
problem. Run these queries at the local location.
1. This query displays the DBRMs in the member list for the plan. If no
rows are returned, then the plan was bound without a member list.

SELECT PLCREATOR, PLNAME, NAME, VERSION
FROM SYSIBM.SYSDBRM
WHERE PLNAME = 'plan-name';

2. This query displays the entries in the package list for the plan. If
no rows are returned, then the plan was bound without a package list.

SELECT LOCATION, COLLID, NAME
FROM SYSIBM.SYSPACKLIST
WHERE PLANNAME = 'plan-name';
3. This query displays the CURRENTSERVER value specified on the BIND
subcommand for the plan.

SELECT NAME, CURRENTSERVER
FROM SYSIBM.SYSPLAN
WHERE NAME = 'plan-name';

4. This query displays if there is a matching package in SYSPACKAGE. If
the package is remote, put the location name in the FROM clause. If no
rows are returned, the correct version of the package was not bound.

SELECT COLLID, NAME, HEX(CONTOKEN), VERSION
FROM <location-name.>SYSIBM.SYSPACKAGE
WHERE NAME = 'dbrm-name'
AND HEX(CONTOKEN) = 'consistency-token';

5. This query displays if there is a matching package in SYSPACKAGE. If
5. This query displays if there is a matching package in SYSPACKAGE. If
the package is remote, put the location name in the FROM clause. Use
this query when collection-id is not blank. If no rows are returned,
the correct version of the package was not bound.

SELECT COLLID, NAME, HEX(CONTOKEN), VERSION
FROM <location-name.>SYSIBM.SYSPACKAGE
WHERE NAME = 'dbrm-name'
AND HEX(CONTOKEN) = 'consistency-token'
AND COLLID = 'collection-id';
SQLSTATE: 51002

Everthing it is fine..You can look into bindcard and add REPLACE option.
Back to top
View user's profile Send private message
ramakrishnan2k5
Currently Banned

New User


Joined: 01 Dec 2006
Posts: 1
Location: bangalore

PostPosted: Wed Feb 07, 2007 5:15 pm    Post subject:
Reply with quote

Hi May i know the use of WMGW transaction in CICS-DB2 applications
reply 2 ***EMail ID REMOVED... Use CODE tag to include mail id***
Back to top
View user's profile Send private message
sure116

New User


Joined: 03 Feb 2006
Posts: 11

PostPosted: Thu Feb 08, 2007 8:19 pm    Post subject:
Reply with quote

Hi,

WMGW is CICS gateway transaction for Webmethod 6x.
Currently we are upgrading Webmethod 4x transaction TRFT to 6X transaction gateway WMGW.

Thanks
Suresh
Back to top
View user's profile Send private message
Suryanarayana.tadala

New User


Joined: 03 Nov 2005
Posts: 43
Location: St.Louis

PostPosted: Fri Feb 09, 2007 10:10 pm    Post subject:
Reply with quote

So did the soultion provided by vickey work out..i am eagarly looking for some status for you as the solution provided should be good enough to solve your problem..
Back to top
View user's profile Send private message
sure116

New User


Joined: 03 Feb 2006
Posts: 11

PostPosted: Wed Oct 10, 2007 5:52 am    Post subject:
Reply with quote

Hi,

Finally the issue got resolved. Sorry for updating so late.

The issue is WMGW is invoked from EAI webmethod gateway.
Every time EAI invokes a new TASK# has to be assigned.
But in above case EAI TASK# is not reset.
And after 8 or 10 invocations the modules are abending with PLAN not found as too many threads concurrently active with same TASK#.

Even though the modules are abending at Mainframe end.
The root cause is at EAI.

Thx
Suresh
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts EXIT or RETURN cvnlynn CLIST & REXX 18 Wed Jul 19, 2017 2:50 am
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm

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