Accessing a table of other db2 system



IBM's flagship relational database management system

Accessing a table of other db2 system

Postby gopal_NKP » Tue Sep 06, 2011 3:21 pm

Hi,

One of the program in my application has the following scenario.

1. I am doing testing in db2 systm DB21. The program in DB21 has an alias of a table, which of another system DB22.

We have done bind successfully. but even though we are getting the sql code -805. plant not found in db22.programname. (this program is subprogram called by the main program). We are using dynamic call of sub programs. All the subprograms and main program is bind in the db2system DB21.

Please help me.
thanks
vgl
gopal_NKP
 
Posts: 22
Joined: Fri Feb 25, 2011 11:47 am
Has thanked: 0 time
Been thanked: 0 time

Re: Accessing a table of other db2 system

Postby GuyC » Tue Sep 06, 2011 5:23 pm

I think (I'm not sure about aliasses) but DRDA-protocol requires package to be available in both subsystems
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: Accessing a table of other db2 system

Postby gopal_NKP » Wed Sep 07, 2011 2:00 pm

Hi,

thanks for your response.

The environment is as follows.

IN DB2SYS DB21:
one main program mainpgm1 and many sub programs with plan COBPLN1.
ALIAS : EXTABLE POINTS TO ACTTABLE IN DB2SYS DB22.
subpgm4 is the sub program with select query on alias EXTABLE.
IN DB2SYS DB22:
TABLE : ACTTABLE

DB2SYS DB21:
We have one cobol program (PLAN COBPGM1) which calls number of sub programs. One (subpgm4) of the sub programs, performs a select query on alias EXTABLE

The program mainpgm1 is getting abended with the following message.

 
DSNT408I SQLCODE = -805, ERROR:  DBRM OR PACKAGE NAME DB22..subpgm4.1-
          90A022211956B4C NOT FOUND IN PLAN ROSPA120. REASON 01         
 DSNT418I SQLSTATE   = 51002 SQLSTATE RETURN CODE                       
 DSNT415I SQLERRP    = DSNXEPM SQL PROCEDURE DETECTING ERROR             
 DSNT416I SQLERRD    = -350  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION   
 DSNT416I SQLERRD    = X'FFFFFEA2'  X'00000000'  X'00000000'             
          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC           
          INFORMATION                                                   
 


Please help me.
gopal_NKP
 
Posts: 22
Joined: Fri Feb 25, 2011 11:47 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post