I m facing a problem while xctl in CICS programs. I have an MQ triggered program A which xlts to program B. This program B links to program C. Program A is a Cobol-CICS program without DB2 while programs B & C are Cobol-CICS-DB2 programs. The problem is I am getting an sqlcode of -805 in program C while accessing database. The error message is
** DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME USG EAEBGNET1D2T1..RECC0101.1712AD1007A0A625 NOT FOUND IN PLAN SPSS00RQ.
Plan of Program B = SPSS00RQ
Program C = RECC0101
Initially I had DB2 in program A also and then I was getting sqlcode in while accessing database in program B. Thus it allows me to access DB2 databse only in the first program in the chain of programs. This problem does not occur if the program is not MQ triggered.
We do not use packages while compilation. The DBRM are directly bound to the Plans.
Can anyone please help ?