By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,457 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

DB2 CONNECT configure and Sysplex support

P: n/a
Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.

Why DB2 CONNECT can connect to DB2 mainframe without the DCS?

Another issue on the Sysplex support on the above db2 connect
configuration.
We have set DB2CONNECT_IN_APP_PROCESS=NO ,
But i can still see reroute.
I checked IBM http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?
In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_APP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.

db2set DB2CONNECT_IN_APP_PROCESS=NO

db2stop

db2start
However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERVER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.

thanks,

Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
As for your first question, are you certain that you are connecting to
the mainframe? Could it be that you are connecting locally?

Larry E.

zgh1970 wrote:
Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.

Why DB2 CONNECT can connect to DB2 mainframe without the DCS?

Another issue on the Sysplex support on the above db2 connect
configuration.
We have set DB2CONNECT_IN_APP_PROCESS=NO ,
But i can still see reroute.
I checked IBM http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?
In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_APP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.

db2set DB2CONNECT_IN_APP_PROCESS=NO

db2stop

db2start
However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERVER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.

thanks,
Jun 27 '08 #2

P: n/a
On May 1, 4:10*pm, Larry <la...@nospam.netwrote:
As for your first question, are you certain that you are connecting to
the mainframe? Could it be that you are connecting locally?

Larry E.

zgh1970 wrote:
Hi, All,
I have question on DB2 CONNECT configure.
We installed DB2 ESE V8 FixPak 14 o AIX .
When we set up the connection to DB2 Mainframe.
We just catalog node and DB directory without DCS.
From what I know, DB2 conenct needs to set up node, dcs and db
directories.
Why DB2 CONNECT can connect to DB2 mainframe without the DCS?
Another issue on the Sysplex support *on the above db2 connect
configuration.
We have set DB2CONNECT_IN_APP_PROCESS=NO ,
But i can still see reroute.
I checked IBM *http://www-1.ibm.com/support/docview...id=swg21253021
It has the difference on DB2 Connect and gateway.
Is my above set is gateway or DB2 Connect?
In case the client applications are running locally on the same
physical machine as DB2 Connect, you need to set
DB2CONNECT_IN_APP_PROCESS=NO to force the local clients to run in an
agent so as to utilize Sysplex support.
db2set DB2CONNECT_IN_APP_PROCESS=NO
db2stop
db2start
However, if you want to disable DB2 Connect Sysplex support on your
gateway, you can simply catalog a DCS database without specifying the
Sysplex in the parameter list and re-catalog the DCS database as your
database alias. You can also turn off Sysplex in V8 by setting the DB2
registry variable DB2SYSPLEX_SERVER to zero, but this variable is
deprecated in DB2 Connect V9. By default this variable is set to a
nonzero value in DB2 Connect V8.
thanks,- Hide quoted text -

- Show quoted text -
Hi, Larry,
I am sure it can connect to mainfrmaw withour DCS directory.
thanks,
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.