Unix Technical Forum

SEO

vBulletin Search Engine Optimization


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-02-2008, 05:04 AM
zgh1970
 
Posts: n/a
Default DB2 CONNECT configure and Sysplex support

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,

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-02-2008, 05:04 AM
Larry
 
Posts: n/a
Default Re: DB2 CONNECT configure and Sysplex support

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,
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-05-2008, 05:51 AM
zgh1970
 
Posts: n/a
Default Re: DB2 CONNECT configure and Sysplex support

On May 1, 4:10*pm, Larry <la...@nospam.net> wrote:
> 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,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 08:41 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62