MVSFORUMS.com

svhgk · Beginner Joined: 14 Feb 2006 Posts: 12 Topics: 5

Hi,

I need to bind a program which accesses table A in one susbsystem SS1(under SQL1) & table B in another subsystem (under SQL2) SS2.

Kolusu,

I checked earlier links in the forum & found that using the CURRENT SQLID we can direct the DB2 to the particular subsystem. Now the program I am dealing with is a production program which does not have this statement. Then how the production program is working in this case?

We are copying the program to test region & then binding it. So incase we need to add the SET CURRENT SQLID command we need to edit the program. Any other work around on this other than the SET CURRENT SQLID command. Someone told me I need to create a synonym of the table B in SS1 & then bind it. Is this feasible?

Awaiting your reply.

Thanks,
Ganesh

bauer · Posted: Wed Oct 04, 2006 4:56 am Post subject:

svhgk,

are you talking about a program which accesses table a in system ss1 and at the same time table b in system ss2 ??? Program runs once ans accesses both tables at the same time ?

Or are you talking about a program wich accesses table a in system ss1 and accesses table b in system ss2? So program runs twice? Is table a in system ss1 the same table as table b in system ss2?

regards,
bauer

svhgk · Beginner Joined: 14 Feb 2006 Posts: 12 Topics: 5

Bauer,

The same program in a single run accesses table A in SS1 & table B in SS2.

We checked out here yesterday. There were settings in the bind panel screen to specify the subsystems to which the program has to be bound.

Thanks,
Ganesh

aashish.paul · Beginner Joined: 17 Apr 2008 Posts: 12 Topics: 3

Svghk,

I have a similiar requirement, a program that has sqls running against 2 Db2 susbsytems at different points in the program. my pkg binds are failing when binding against the second susytem.

How do you control which SQL is bound to which db2 subsystem?

bauer · Posted: Tue Jan 11, 2011 2:08 am Post subject:

aashish.paul,

you can use

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Concerning your question of binding: You have to BIND your program only against 1 DB2 subsystem. Within this subsystem, you have to implement the possibility for your program to access the table in the other subsystem with

- creating a communication between the two subsystems, so that you can work with the described three part name for the table

- creating an ALIAS for this table in subsystem 1, so that you don't have to code this three part name in your program but only use it in the ALIAS definition

regards
Christian

bauer · Posted: Tue Jan 11, 2011 5:20 am Post subject:

CZerfas,

yes, i agree.

Do you remember how to connect the two db2 Subsystems, you said communication.

Was i right with sysibm.syslocations to see if the subsystems are connected, communication available ?

regards bauer

aashish.paul · Beginner Joined: 17 Apr 2008 Posts: 12 Topics: 3

the table to check the connection is sysibm.locations, i did check that the subsystem i wanted to connect to is available.

My facility uses DRDA access, according to the manual I have to do a local bind and a remote pkg bind followed by aplan bind including both these packages to be able to execute the sql.

The issue with this is that I am unable to do a remote bind as this is failing on the SQLs that are to be executed at the local server.

I have tried the "Connect" followed by the SELECT which returned a -918 SQLCODE.

If i use an ALIAS would that still require a remote bind ?

jsharon1248 · Posted: Wed Jan 12, 2011 8:39 am Post subject:

Are you using VALIDATE(BIND), or VALIDATE(RUN) in your package BIND? You should be using VALIDATE(RUN).

aashish.paul · Beginner Joined: 17 Apr 2008 Posts: 12 Topics: 3

Changed the VALIDATE(BIND) to VALIDATE(RUN) and got a -805 bonk

jsharon1248 · Posted: Tue Jan 18, 2011 8:36 am Post subject:

Are you implying that DB2 returned the -805 on the bind? Do you know what causes a -805?