-805 plan abend with plan exit

sure116 · New User Joined: 03 Feb 2006 Posts: 11

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

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

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.

ramakrishnan2k5 · New User Joined: 01 Dec 2006 Posts: 1 Location: bangalore

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***

sure116 · New User Joined: 03 Feb 2006 Posts: 11

Hi,

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

Thanks
Suresh

Suryanarayana.tadala · New User Joined: 03 Nov 2005 Posts: 43 Location: St.Louis

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..

sure116 · New User Joined: 03 Feb 2006 Posts: 11

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