ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ API Support » sqlcode -805 in DB2 access for Mq triggered program

Post new topic  Reply to topic
 sqlcode -805 in DB2 access for Mq triggered program « View previous topic :: View next topic » 
Author Message
ronny23
PostPosted: Tue Jan 07, 2003 7:17 am    Post subject: sqlcode -805 in DB2 access for Mq triggered program Reply with quote

Newbie

Joined: 07 Jan 2003
Posts: 2
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 ?
Back to top
View user's profile Send private message
gwlfng
PostPosted: Wed Jan 15, 2003 12:43 pm    Post subject: Reply with quote

Newbie

Joined: 13 Nov 2002
Posts: 8
Location: Boston
Might need an RCT entry for the tran being triggered, or maybe it points to the wrong plan
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ API Support » sqlcode -805 in DB2 access for Mq triggered program
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.