Results 1 to 2 of 2

Thread: sqlcode -805

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: sqlcode -805

    Hi,

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

    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 ?

  2. #2
    Join Date
    Nov 2002
    Location
    Ohio
    Posts
    90
    Double check:

    Your access security to the DB2 plan and tables.

    The post compile bind was successful.

    The execution JCL points to the correct bind/object libraries.

    We spent hours and hours trying to solve this error.

    We compiled all programs in the string as DB2 programs.

    Good Luck,
    Bruce Baasch

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •