DB2 Connect Enterprise Edition license question

Tina Hilton

DB2 Connect Enterprise Edition license question
We have DB2 Connect 7.2 Enterprise Edition on a gateway server (NT), which
we use for access to DB2 6.1 on OS/390. We're licensed for 5 concurrent
users on our test gateway. We have a new application being developed in
java and they want to test and code for exceeding the maximum concurrent
users. We got 5 users connected, and then another person started up the
java application. The "license center" function of Control Center noted
that there were 6 concurrent users and 1 license infraction. However, the
java application ran normally. Is this the way it's supposed to work? I
can't imagine that IBM wants to let customers exceed their licensed quota.

Thanks,

Tina Hilton
Random House Bertelsmann Shared Services


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dave Shapiro

Re: DB2 Connect Enterprise Edition license question
(in response to Tina Hilton)
Tina,

They are "letting" you exceed your number of licenses. This is a customer friendly approach that lets your application run while you "adjust" your licensing requirements.

This may not apply to your situation, but beginning with v7.2, if you use the web or a thread concentrating application (i.e. a pool of threads on an application server serves a whole department) "concurrent" users is not a valid licensing model. You must provide Registered Users, or buy DB2 Connect Unlimited.

You might check with your rep.

Dave

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of [login to unmask email]
Sent: Tuesday, December 23, 2003 1:59 PM
To: [login to unmask email]
Subject: DB2 Connect Enterprise Edition license question



We have DB2 Connect 7.2 Enterprise Edition on a gateway server (NT), which we use for access to DB2 6.1 on OS/390. We're licensed for 5 concurrent users on our test gateway. We have a new application being developed in java and they want to test and code for exceeding the maximum concurrent users. We got 5 users connected, and then another person started up the java application. The "license center" function of Control Center noted that there were 6 concurrent users and 1 license infraction. However, the java application ran normally. Is this the way it's supposed to work? I can't imagine that IBM wants to let customers exceed their licensed quota.

Thanks,

Tina Hilton
Random House Bertelsmann Shared Services

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Tina Hilton

Re: DB2 Connect Enterprise Edition license question
(in response to Dave Shapiro)
If only I knew who my rep was. They keep changing. I did fill out a form
on IBMs web site, asking them to have someone contact me so hopefully they
will after the holidays.

This is a simple app that will be executed strictly from/on the desktop --
no web and no app servers -- so our concurrent licensing should work okay.
The chance of hitting the limit on our production server is very small as
long as the user group is as small as they expect. If we don't have to
worry about it failing, then we'll just check it every now and then to make
sure it will be okay.

Thanks.

-----Original Message-----
From: Shapiro, Dave [mailto:[login to unmask email]
Sent: Tuesday, December 23, 2003 3:47 PM
To: [login to unmask email]
Subject: Re: DB2 Connect Enterprise Edition license question


Tina,

They are "letting" you exceed your number of licenses. This is a customer
friendly approach that lets your application run while you "adjust" your
licensing requirements.

This may not apply to your situation, but beginning with v7.2, if you use
the web or a thread concentrating application (i.e. a pool of threads on an
application server serves a whole department) "concurrent" users is not a
valid licensing model. You must provide Registered Users, or buy DB2 Connect
Unlimited.

You might check with your rep.

Dave

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Tuesday, December 23, 2003 1:59 PM
To: [login to unmask email]
Subject: DB2 Connect Enterprise Edition license question



We have DB2 Connect 7.2 Enterprise Edition on a gateway server (NT), which
we use for access to DB2 6.1 on OS/390. We're licensed for 5 concurrent
users on our test gateway. We have a new application being developed in
java and they want to test and code for exceeding the maximum concurrent
users. We got 5 users connected, and then another person started up the
java application. The "license center" function of Control Center noted
that there were 6 concurrent users and 1 license infraction. However, the
java application ran normally. Is this the way it's supposed to work? I
can't imagine that IBM wants to let customers exceed their licensed quota.

Thanks,

Tina Hilton
Random House Bertelsmann Shared Services

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Leon Katsnelson

Re: DB2 Connect Enterprise Edition license question
(in response to Tina Hilton)
Yes, this is the way is supposed to work. When the number of licensed users
is exceeded DB2 Connect will write a message to the db2diag.log advising
you that you are in violation of the license agreement but it will NOT stop
you from going ahead with your work.

Leon Katsnelson. Manager, DB2 Product Management and Planning. Admin
Assistant: Susanne Mcfarlane (905) 413-3632
"Things should be made as simple as possible, but not any simpler." --
Albert Einstein



[login to unmask email]
OSYSTEMS.COM
Sent by: DB2 Data To
Base Discussion [login to unmask email]
List cc
<[login to unmask email]
ORG> Subject
DB2 Connect Enterprise Edition
license question
12/23/2003 02:58
PM


Please respond to
DB2 Database
Discussion list
at IDUG






We have DB2 Connect 7.2 Enterprise Edition on a gateway server (NT), which
we use for access to DB2 6.1 on OS/390. We're licensed for 5 concurrent
users on our test gateway. We have a new application being developed in
java and they want to test and code for exceeding the maximum concurrent
users. We got 5 users connected, and then another person started up the
java application. The "license center" function of Control Center noted
that there were 6 concurrent users and 1 license infraction. However, the
java application ran normally. Is this the way it's supposed to work? I
can't imagine that IBM wants to let customers exceed their licensed quota.


Thanks,


Tina Hilton
Random House Bertelsmann Shared Services


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DB2 Connect
(in response to Leon Katsnelson)
We use Oracle Transparent Gateway. Requires a separate started task on
OS390 for each DB2 subsystem (at least that's how we have it configured),
and user has to be defined in an Oracle instance that is connected to the
gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
can't tell how good or bad performance is. From my point of view, it's very
kludgy. And the user has to have an Oracle userid/password as well as a
mainframe userid/password.

We were looking at ODBC alternatives to OTG and DB2 Connect, and one of the
most promising ones (which we didn't get) was Neon Systems' Shadow Connect.
If it were up to me, I would get DB2 Connect.

Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Fazio, Paul
Sent: Monday, December 22, 2003 5:47 AM
To: [login to unmask email]
Subject: DB2 Connect


Is anyone using a product other than DB2 Connect to access DB2 data on a
mainframe from a PC? If so how does it compare to DB2 Connect?

Thanks,
Paul

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

=====

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Myron Miller

Re: DB2 Connect
(in response to Cathy Taddei)
My client has Oracle transparent Gateway and DB2 Connect. They now only use
the OTG whenever they must access Oracle and Db2 tables simulataneously. They
converted a number of app's that accessed only Db2 from OTG to DB2 Connect with
the result that average response time went from minutes to seconds (4 minutes
to 5 seconds in a couple of cases). Plus its just been recently that there is
a timeout value for OTG to cancel inactive users.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> We use Oracle Transparent Gateway. Requires a separate started task on
> OS390 for each DB2 subsystem (at least that's how we have it configured),
> and user has to be defined in an Oracle instance that is connected to the
> gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
> can't tell how good or bad performance is. From my point of view, it's very
> kludgy. And the user has to have an Oracle userid/password as well as a
> mainframe userid/password.
>
> We were looking at ODBC alternatives to OTG and DB2 Connect, and one of the
> most promising ones (which we didn't get) was Neon Systems' Shadow Connect.
> If it were up to me, I would get DB2 Connect.
>
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Fazio, Paul
> Sent: Monday, December 22, 2003 5:47 AM
> To: [login to unmask email]
> Subject: DB2 Connect
>
>
> Is anyone using a product other than DB2 Connect to access DB2 data on a
> mainframe from a PC? If so how does it compare to DB2 Connect?
>
> Thanks,
> Paul
>
> ----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
>
------------------------------------------------------------------------------
>
> This email is confidential and may be legally privileged.
>
> It is intended solely for the addressee. Access to this email by anyone else,
> unless expressly approved by the sender or an authorized addressee, is
> unauthorized.
>
> If you are not the intended recipient, any disclosure, copying, distribution
> or any action omitted or taken in reliance on it, is prohibited and may be
> unlawful. If you believe that you have received this email in error, please
> contact the sender, delete this e-mail and destroy all copies.
>
>
=====
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can
> be reached at [login to unmask email] Find out the latest on IDUG
> conferences at http://conferences.idug.org/index.cfm
>


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Camitta

Re: DB2 Connect
(in response to Myron Miller)
We use HIT Software's type 4 JDBC driver. Very solid. But we also use DB2
Connect for CLI, ODBC and type 3 JDBC. Haven't tested the new DB2 Connect
V8 type 4 yet.

Steve

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Fazio, Paul
Sent: Monday, December 22, 2003 5:47 AM
To: [login to unmask email]
Subject: DB2 Connect


Is anyone using a product other than DB2 Connect to access DB2 data on a
mainframe from a PC? If so how does it compare to DB2 Connect?

Thanks,
Paul

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DB2 Connect
(in response to Steven Camitta)
That's interesting that the OTG was so slow compared to DB2 Connect. Does
your OTG run on the mainframe? We are forced to use OTG for several
applications that join Oracle tables to DB2 tables in a single transaction.
However, we're thinking about moving OTG off the mainframe and onto the
Oracle server (since OTG comes with Oracle, as far as I know), and then
using an ODBC driver (such as DB2 Connect) to access DB2. Does that sound
plausible to you?

Thanks,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Myron Miller
Sent: Wednesday, December 24, 2003 1:08 PM
To: [login to unmask email]
Subject: Re: DB2 Connect


My client has Oracle transparent Gateway and DB2 Connect. They now only use
the OTG whenever they must access Oracle and Db2 tables simulataneously.
They
converted a number of app's that accessed only Db2 from OTG to DB2 Connect
with
the result that average response time went from minutes to seconds (4
minutes
to 5 seconds in a couple of cases). Plus its just been recently that there
is
a timeout value for OTG to cancel inactive users.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> We use Oracle Transparent Gateway. Requires a separate started task on
> OS390 for each DB2 subsystem (at least that's how we have it configured),
> and user has to be defined in an Oracle instance that is connected to the
> gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
> can't tell how good or bad performance is. From my point of view, it's
very
> kludgy. And the user has to have an Oracle userid/password as well as a
> mainframe userid/password.
>
> We were looking at ODBC alternatives to OTG and DB2 Connect, and one of
the
> most promising ones (which we didn't get) was Neon Systems' Shadow
Connect.
> If it were up to me, I would get DB2 Connect.
>
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Fazio, Paul
> Sent: Monday, December 22, 2003 5:47 AM
> To: [login to unmask email]
> Subject: DB2 Connect
>
>
> Is anyone using a product other than DB2 Connect to access DB2 data on a
> mainframe from a PC? If so how does it compare to DB2 Connect?
>
> Thanks,
> Paul
>
>
----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
>
----------------------------------------------------------------------------
--
>
> This email is confidential and may be legally privileged.
>
> It is intended solely for the addressee. Access to this email by anyone
else,
> unless expressly approved by the sender or an authorized addressee, is
> unauthorized.
>
> If you are not the intended recipient, any disclosure, copying,
distribution
> or any action omitted or taken in reliance on it, is prohibited and may be
> unlawful. If you believe that you have received this email in error,
please
> contact the sender, delete this e-mail and destroy all copies.
>
>
===
==
>
>
----------------------------------------------------------------------------
-----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can
> be reached at [login to unmask email] Find out the latest on IDUG
> conferences at http://conferences.idug.org/index.cfm
>


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

=====

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Myron Miller

Re: DB2 Connect
(in response to Cathy Taddei)
Our OTG runs on the mainframe. And I don't know if it can run on a server. As
far as I know this piece must run on the mainframe. But there certainly could
be something that I don't know. I've been told by our Oracle guru's that in
order to access DB2 and Oracle tables simulataneously, we needed OTG setup this
way. If there's another way, I'd be glad to learn how to do it.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> That's interesting that the OTG was so slow compared to DB2 Connect. Does
> your OTG run on the mainframe? We are forced to use OTG for several
> applications that join Oracle tables to DB2 tables in a single transaction.
> However, we're thinking about moving OTG off the mainframe and onto the
> Oracle server (since OTG comes with Oracle, as far as I know), and then
> using an ODBC driver (such as DB2 Connect) to access DB2. Does that sound
> plausible to you?
>
> Thanks,
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Myron Miller
> Sent: Wednesday, December 24, 2003 1:08 PM
> To: [login to unmask email]
> Subject: Re: DB2 Connect
>
>
> My client has Oracle transparent Gateway and DB2 Connect. They now only use
> the OTG whenever they must access Oracle and Db2 tables simulataneously.
> They
> converted a number of app's that accessed only Db2 from OTG to DB2 Connect
> with
> the result that average response time went from minutes to seconds (4
> minutes
> to 5 seconds in a couple of cases). Plus its just been recently that there
> is
> a timeout value for OTG to cancel inactive users.
>
> Myron
> --- "Taddei, Cathy" <[login to unmask email]> wrote:
> > We use Oracle Transparent Gateway. Requires a separate started task on
> > OS390 for each DB2 subsystem (at least that's how we have it configured),
> > and user has to be defined in an Oracle instance that is connected to the
> > gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
> > can't tell how good or bad performance is. From my point of view, it's
> very
> > kludgy. And the user has to have an Oracle userid/password as well as a
> > mainframe userid/password.
> >
> > We were looking at ODBC alternatives to OTG and DB2 Connect, and one of
> the
> > most promising ones (which we didn't get) was Neon Systems' Shadow
> Connect.
> > If it were up to me, I would get DB2 Connect.
> >
> > Cathy Taddei
> >
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> > Behalf Of Fazio, Paul
> > Sent: Monday, December 22, 2003 5:47 AM
> > To: [login to unmask email]
> > Subject: DB2 Connect
> >
> >
> > Is anyone using a product other than DB2 Connect to access DB2 data on a
> > mainframe from a PC? If so how does it compare to DB2 Connect?
> >
> > Thanks,
> > Paul
> >
> >
> ----------------------------------------------------------------------------
> > -----
> > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home
> > page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select
> > "Join or Leave the list". If you will be out of the office, send the SET
> > DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> > can be reached at [login to unmask email] Find out the latest on
> > IDUG conferences at http://conferences.idug.org/index.cfm
> >
> >
> ----------------------------------------------------------------------------
> --
> >
> > This email is confidential and may be legally privileged.
> >
> > It is intended solely for the addressee. Access to this email by anyone
> else,
> > unless expressly approved by the sender or an authorized addressee, is
> > unauthorized.
> >
> > If you are not the intended recipient, any disclosure, copying,
> distribution
> > or any action omitted or taken in reliance on it, is prohibited and may be
> > unlawful. If you believe that you have received this email in error,
> please
> > contact the sender, delete this e-mail and destroy all copies.
> >
> >
> ====
> ==
> >
> >
> ----------------------------------------------------------------------------
> -----
> > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home
> > page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select
> > "Join or Leave the list". If you will be out of the office, send the SET
> > DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can
> > be reached at [login to unmask email] Find out the latest on IDUG
> > conferences at http://conferences.idug.org/index.cfm
> >
>
>
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
>
> ----------------------------------------------------------------------------
> -----
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
> can be reached at [login to unmask email] Find out the latest on
> IDUG conferences at http://conferences.idug.org/index.cfm
>
>
------------------------------------------------------------------------------
>
> This email is confidential and may be legally privileged.
>
> It is intended solely for the addressee. Access to this email by anyone else,
> unless expressly approved by the sender or an authorized addressee, is
> unauthorized.
>
> If you are not the intended recipient, any disclosure, copying, distribution
> or any action omitted or taken in reliance on it, is prohibited and may be
> unlawful. If you believe that you have received this email in error, please
> contact the sender, delete this e-mail and destroy all copies.
>
>
=====
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". If you will be out of the office, send the SET
> DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can
> be reached at [login to unmask email] Find out the latest on IDUG
> conferences at http://conferences.idug.org/index.cfm
>


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DB2 Connect
(in response to Myron Miller)
I'll let you know if we ever get to the point of testing the other
configuration (OTG off the mainframe). Our Oracle guru suggested it, and
we've been operating under the assumption that it would work. Now I see
that we had better confirm that before deciding on a direction.

Thanks!
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Myron Miller
Sent: Friday, December 26, 2003 1:33 PM
To: [login to unmask email]
Subject: Re: DB2 Connect


Our OTG runs on the mainframe. And I don't know if it can run on a server.
As
far as I know this piece must run on the mainframe. But there certainly
could
be something that I don't know. I've been told by our Oracle guru's that in
order to access DB2 and Oracle tables simulataneously, we needed OTG setup
this
way. If there's another way, I'd be glad to learn how to do it.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> That's interesting that the OTG was so slow compared to DB2 Connect. Does
> your OTG run on the mainframe? We are forced to use OTG for several
> applications that join Oracle tables to DB2 tables in a single
transaction.
> However, we're thinking about moving OTG off the mainframe and onto the
> Oracle server (since OTG comes with Oracle, as far as I know), and then
> using an ODBC driver (such as DB2 Connect) to access DB2. Does that sound
> plausible to you?
>
> Thanks,
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Myron Miller
> Sent: Wednesday, December 24, 2003 1:08 PM
> To: [login to unmask email]
> Subject: Re: DB2 Connect
>
>
> My client has Oracle transparent Gateway and DB2 Connect. They now only
use
> the OTG whenever they must access Oracle and Db2 tables simulataneously.
> They
> converted a number of app's that accessed only Db2 from OTG to DB2 Connect
> with
> the result that average response time went from minutes to seconds (4
> minutes
> to 5 seconds in a couple of cases). Plus its just been recently that
there
> is
> a timeout value for OTG to cancel inactive users.
>
> Myron
> --- "Taddei, Cathy" <[login to unmask email]> wrote:
> > We use Oracle Transparent Gateway. Requires a separate started task on
> > OS390 for each DB2 subsystem (at least that's how we have it
configured),
> > and user has to be defined in an Oracle instance that is connected to
the
> > gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
> > can't tell how good or bad performance is. From my point of view, it's
> very
> > kludgy. And the user has to have an Oracle userid/password as well as a
> > mainframe userid/password.
> >
> > We were looking at ODBC alternatives to OTG and DB2 Connect, and one of
> the
> > most promising ones (which we didn't get) was Neon Systems' Shadow
> Connect.
> > If it were up to me, I would get DB2 Connect.
> >
> > Cathy Taddei
> >
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> > Behalf Of Fazio, Paul
> > Sent: Monday, December 22, 2003 5:47 AM
> > To: [login to unmask email]
> > Subject: DB2 Connect
> >
> >
> > Is anyone using a product other than DB2 Connect to access DB2 data on a
> > mainframe from a PC? If so how does it compare to DB2 Connect?
> >
> > Thanks,
> > Paul
> >
> >

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

=====

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ron Root

Re: DB2 Connect
(in response to Cathy Taddei)
We use Neon's Shadow and are very happy with it. It is used by a variety of
Powerbuilder, Java and decision support applications.

Ron Root
Texas Comptroller of Public Accounts


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Fazio, Paul
Sent: Monday, December 22, 2003 7:47 AM
To: [login to unmask email]
Subject: DB2 Connect


Is anyone using a product other than DB2 Connect to access DB2 data on a
mainframe from a PC? If so how does it compare to DB2 Connect?

Thanks,
Paul

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Holmans

Re: DB2 Connect
(in response to Ron Root)
We have the OTG for DRDA running on some flavour of Unix or other (HP/UX or Solaris, I can't remember off-hand). It works a *lot* better than the configuration we had with the mainframe component. We have an issue with our users, who seem somewhat hard of thinking because we keep telling them to get the userid that the gateway uses set up right, but they don't, it expires and then they tell us the gateway has stopped working.


Mike Holmans
Database consultant
BTexact ESS Database Services
[login to unmask email]
__________________________________________
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000
This electronic message contains information from British Telecommunications plc which may be privileged and confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the number or address above) immediately.

Activity and use of the British Telecommunications plc email system is monitored to secure its effective operation and for other lawful business purposes. Communications using this system will also be monitored and may be recorded to secure effective operation and for other lawful business purposes.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Taddei, Cathy
Sent: 26 December 2003 21:56
To: [login to unmask email]
Subject: Re: DB2 Connect



I'll let you know if we ever get to the point of testing the other configuration (OTG off the mainframe). Our Oracle guru suggested it, and we've been operating under the assumption that it would work. Now I see that we had better confirm that before deciding on a direction.

Thanks!
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [ mailto:[login to unmask email]On
Behalf Of Myron Miller
Sent: Friday, December 26, 2003 1:33 PM
To: [login to unmask email]
Subject: Re: DB2 Connect


Our OTG runs on the mainframe. And I don't know if it can run on a server. As
far as I know this piece must run on the mainframe. But there certainly could
be something that I don't know. I've been told by our Oracle guru's that in
order to access DB2 and Oracle tables simulataneously, we needed OTG setup this
way. If there's another way, I'd be glad to learn how to do it.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> That's interesting that the OTG was so slow compared to DB2 Connect. Does
> your OTG run on the mainframe? We are forced to use OTG for several
> applications that join Oracle tables to DB2 tables in a single transaction.
> However, we're thinking about moving OTG off the mainframe and onto the
> Oracle server (since OTG comes with Oracle, as far as I know), and then
> using an ODBC driver (such as DB2 Connect) to access DB2. Does that sound
> plausible to you?
>
> Thanks,
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [ mailto:[login to unmask email]On
> Behalf Of Myron Miller
> Sent: Wednesday, December 24, 2003 1:08 PM
> To: [login to unmask email]
> Subject: Re: DB2 Connect
>
>
> My client has Oracle transparent Gateway and DB2 Connect. They now only use
> the OTG whenever they must access Oracle and Db2 tables simulataneously.
> They
> converted a number of app's that accessed only Db2 from OTG to DB2 Connect
> with
> the result that average response time went from minutes to seconds (4
> minutes
> to 5 seconds in a couple of cases). Plus its just been recently that there
> is
> a timeout value for OTG to cancel inactive users.
>
> Myron
> --- "Taddei, Cathy" <[login to unmask email]> wrote:
> > We use Oracle Transparent Gateway. Requires a separate started task on
> > OS390 for each DB2 subsystem (at least that's how we have it configured),
> > and user has to be defined in an Oracle instance that is connected to the
> > gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I
> > can't tell how good or bad performance is. From my point of view, it's
> very
> > kludgy. And the user has to have an Oracle userid/password as well as a
> > mainframe userid/password.
> >
> > We were looking at ODBC alternatives to OTG and DB2 Connect, and one of
> the
> > most promising ones (which we didn't get) was Neon Systems' Shadow
> Connect.
> > If it were up to me, I would get DB2 Connect.
> >
> > Cathy Taddei
> >
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [ mailto:[login to unmask email]On
> > Behalf Of Fazio, Paul
> > Sent: Monday, December 22, 2003 5:47 AM
> > To: [login to unmask email]
> > Subject: DB2 Connect
> >
> >
> > Is anyone using a product other than DB2 Connect to access DB2 data on a
> > mainframe from a PC? If so how does it compare to DB2 Connect?
> >
> > Thanks,
> > Paul
> >
> >

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venkatesh Mokshagundam

DB2 Connect Enterprise Edition license question
(in response to Mike Holmans)

Resending the message. The original did not make it. This is a test as well.

Thanks,

Venkatesh

-----Original Message-----
From: Venkatesh Mokshagundam
Sent: Tuesday, December 23, 2003 2:30 PM
To: 'DB2 Database Discussion list at IDUG'
Subject: RE: DB2 Connect Enterprise Edition license question


Its been a while since I have done it, but, I think the following is still
true.

You can configure DB2 Connect for either hard or soft stop. If you configure
for hard stop, excess connections will be rejected. Soft stop will allow the
users to get thru, but, a message will be written to DB2DIAG.LOG. If you
check this file, you should see the messages.

HTH,

Venkatesh Mokshagundam

Venkatesh Mokshagundam
Database Administrator
Corporate Systems,
Amarillo, TX 79102
Ph: 806-337-3374
Fax: 806-345-2736

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Tuesday, December 23, 2003 1:59 PM
To: [login to unmask email]
Subject: DB2 Connect Enterprise Edition license question



We have DB2 Connect 7.2 Enterprise Edition on a gateway server (NT), which
we use for access to DB2 6.1 on OS/390. We're licensed for 5 concurrent
users on our test gateway. We have a new application being developed in
java and they want to test and code for exceeding the maximum concurrent
users. We got 5 users connected, and then another person started up the
java application. The "license center" function of Control Center noted
that there were 6 concurrent users and 1 license infraction. However, the
java application ran normally. Is this the way it's supposed to work? I
can't imagine that IBM wants to let customers exceed their licensed quota.

Thanks,

Tina Hilton
Random House Bertelsmann Shared Services



The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DB2 Connect
(in response to Venkatesh Mokshagundam)
Hi Mike. How does the gateway communicate with DB2 on OS/390? Are you
using an ODBC driver, or something else? We would like to do something like
this -- any information you can provide would be welcome. Email me offline
if you prefer.
Thanks!
Cathy Taddei
[login to unmask email] <mailto:[login to unmask email]>

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Monday, December 29, 2003 6:56 AM
To: [login to unmask email]
Subject: Re: DB2 Connect


We have the OTG for DRDA running on some flavour of Unix or other (HP/UX or
Solaris, I can't remember off-hand). It works a *lot* better than the
configuration we had with the mainframe component. We have an issue with our
users, who seem somewhat hard of thinking because we keep telling them to
get the userid that the gateway uses set up right, but they don't, it
expires and then they tell us the gateway has stopped working.


Mike Holmans
Database consultant
BTexact ESS Database Services
[login to unmask email]
__________________________________________
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000
This electronic message contains information from British Telecommunications
plc which may be privileged and confidential. The information is intended to
be for the use of the individual(s) or entity named above. If you are not
the intended recipient, be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. If you have
received this electronic message in error, please notify us by telephone or
email (to the number or address above) immediately.

Activity and use of the British Telecommunications plc email system is
monitored to secure its effective operation and for other lawful business
purposes. Communications using this system will also be monitored and may be
recorded to secure effective operation and for other lawful business
purposes.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Taddei, Cathy
Sent: 26 December 2003 21:56
To: [login to unmask email]
Subject: Re: DB2 Connect



I'll let you know if we ever get to the point of testing the other
configuration (OTG off the mainframe). Our Oracle guru suggested it, and
we've been operating under the assumption that it would work. Now I see
that we had better confirm that before deciding on a direction.

Thanks!
Cathy

-----Original Message-----
From: DB2 Data Base Discussion List [ mailto:[login to unmask email]
<mailto:[login to unmask email]> ]On
Behalf Of Myron Miller
Sent: Friday, December 26, 2003 1:33 PM
To: [login to unmask email]
Subject: Re: DB2 Connect


Our OTG runs on the mainframe. And I don't know if it can run on a server.
As
far as I know this piece must run on the mainframe. But there certainly
could
be something that I don't know. I've been told by our Oracle guru's that in

order to access DB2 and Oracle tables simulataneously, we needed OTG setup
this
way. If there's another way, I'd be glad to learn how to do it.

Myron
--- "Taddei, Cathy" <[login to unmask email]> wrote:
> That's interesting that the OTG was so slow compared to DB2 Connect. Does

> your OTG run on the mainframe? We are forced to use OTG for several
> applications that join Oracle tables to DB2 tables in a single
transaction.
> However, we're thinking about moving OTG off the mainframe and onto the
> Oracle server (since OTG comes with Oracle, as far as I know), and then
> using an ODBC driver (such as DB2 Connect) to access DB2. Does that sound

> plausible to you?
>
> Thanks,
> Cathy Taddei
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [ mailto:[login to unmask email]
<mailto:[login to unmask email]> ]On
> Behalf Of Myron Miller
> Sent: Wednesday, December 24, 2003 1:08 PM
> To: [login to unmask email]
> Subject: Re: DB2 Connect
>
>
> My client has Oracle transparent Gateway and DB2 Connect. They now only
use
> the OTG whenever they must access Oracle and Db2 tables simulataneously.
> They
> converted a number of app's that accessed only Db2 from OTG to DB2 Connect

> with
> the result that average response time went from minutes to seconds (4
> minutes
> to 5 seconds in a couple of cases). Plus its just been recently that
there
> is
> a timeout value for OTG to cancel inactive users.
>
> Myron
> --- "Taddei, Cathy" <[login to unmask email]> wrote:
> > We use Oracle Transparent Gateway. Requires a separate started task on
> > OS390 for each DB2 subsystem (at least that's how we have it
configured),
> > and user has to be defined in an Oracle instance that is connected to
the
> > gateway. It uses CAF, as opposed to DDF. We don't use it heavily, so I

> > can't tell how good or bad performance is. From my point of view, it's
> very
> > kludgy. And the user has to have an Oracle userid/password as well as a

> > mainframe userid/password.
> >
> > We were looking at ODBC alternatives to OTG and DB2 Connect, and one of
> the
> > most promising ones (which we didn't get) was Neon Systems' Shadow
> Connect.
> > If it were up to me, I would get DB2 Connect.
> >
> > Cathy Taddei
> >
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [ mailto:[login to unmask email]
<mailto:[login to unmask email]> ]On
> > Behalf Of Fazio, Paul
> > Sent: Monday, December 22, 2003 5:47 AM
> > To: [login to unmask email]
> > Subject: DB2 Connect
> >
> >
> > Is anyone using a product other than DB2 Connect to access DB2 data on a

> > mainframe from a PC? If so how does it compare to DB2 Connect?
> >
> > Thanks,
> > Paul
> >
> >

----------------------------------------------------------------------------
--

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone
else, unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

===
==


----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else,
unless expressly approved by the sender or an authorized addressee, is
unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution
or any action omitted or taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error, please
contact the sender, delete this e-mail and destroy all copies.

=====

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

DB2 Connect
(in response to Cathy Taddei)
Oracle Gateway for DB2 comes in two flavours: Transparent and DRDA.

The Transparent consist of two STCs running on OS/390 or z/OS, the DRDA
consist of a bunch of processes running on AIX or Solaris (I think this are
the only two opions) and works like a DB2 client via DDF.

My experience is limited to the Transparent one and can confirm that it is
designed for small to medium workload generated by ad-hoc type of access
(Data Centre-like). Definetely not the choice for serious OLTP, in spite of
the recently added GTWY_IDLE_TIME parameter (version 8.1.7) to control
termination of idle connections.

The Oracle DRDA gateway is probably a better choice because it should
deploy DBAT Inactive type 2 thread but I am not sure of its connection
management capability, especially when compared to the CICS-like techniques
provided by DB2 Connect (i.e.connection pooling and connection
concentrator).

As far as simultaneous access of Oracle and DB2 data, IBM still provides
the very efficient DB2 DataJoiner that you can use to simultaneosly access
not only Oracle and DB2 data but all sort of relational databases, in
addition you can investigate the more recent DB2 Information Integrator
that extend the DataJoiner capabilities to unstructured data (eg. Excel
spreadsheet, sequential files, Word Documents ...).

Please be aware that in terms of data integration, the IBM offering is very
open and flexible, while Oracle is quite proprietary solution.

Good luck with you integration and happy new year.

Kind regards
Gabriele Gambassi
----------------------------------------------------------------------
New Zealand
S36°50.787' E174°45.466'



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DB2 Connect
(in response to gabriele@NZ1.IBM.COM)
Thanks for the clear and concise explanation, Gabriele!

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Gab Gambassi
Sent: Tuesday, December 30, 2003 3:08 PM
To: [login to unmask email]
Subject: DB2 Connect


Oracle Gateway for DB2 comes in two flavours: Transparent and DRDA.

The Transparent consist of two STCs running on OS/390 or z/OS, the DRDA
consist of a bunch of processes running on AIX or Solaris (I think this are
the only two opions) and works like a DB2 client via DDF.

My experience is limited to the Transparent one and can confirm that it is
designed for small to medium workload generated by ad-hoc type of access
(Data Centre-like). Definetely not the choice for serious OLTP, in spite of
the recently added GTWY_IDLE_TIME parameter (version 8.1.7) to control
termination of idle connections.

The Oracle DRDA gateway is probably a better choice because it should
deploy DBAT Inactive type 2 thread but I am not sure of its connection
management capability, especially when compared to the CICS-like techniques
provided by DB2 Connect (i.e.connection pooling and connection
concentrator).

As far as simultaneous access of Oracle and DB2 data, IBM still provides
the very efficient DB2 DataJoiner that you can use to simultaneosly access
not only Oracle and DB2 data but all sort of relational databases, in
addition you can investigate the more recent DB2 Information Integrator
that extend the DataJoiner capabilities to unstructured data (eg. Excel
spreadsheet, sequential files, Word Documents ...).

Please be aware that in terms of data integration, the IBM offering is very
open and flexible, while Oracle is quite proprietary solution.

Good luck with you integration and happy new year.

Kind regards
Gabriele Gambassi
----------------------------------------------------------------------
New Zealand
S36°50.787' E174°45.466'



----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mike Holmans

Re: DB2 Connect
(in response to Cathy Taddei)
Gab,

I don't think you're exactly right. The Oracle Transparent Gateway used to come in two flavours - OTG for DB2 and OTG for DRDA. I have a vague feeling that the OTG4DRDA used to run with a similar mainframe configuration as the other one because DB2 was unable to speak TCP/IP and Orrible unable to speak SNA. The OTG4DB2 operated a simpler connection than the DRDA one -quite possibly basic ODBC. When we trialled the two versions many years ago, we found that the DRDA version performed worse than the other at low volumes, but was to be preferred if there were to be a fair amount of traffic (even if I could remember the kind of numbers we found were breakpoints, they'd be way out of date by now).

I think it was with Oracle 8 that they came up with an OTG4DRDA which runs on the Unix end and only creates a few tables and views to aid with catalog visibility and UOW management at the mainframe.

Mike Holmans
Database consultant
BTexact ESS Database Services
[login to unmask email]
__________________________________________
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000
This electronic message contains information from British Telecommunications plc which may be privileged and confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the number or address above) immediately.
Activity and use of the British Telecommunications plc email system is monitored to secure its effective operation and for other lawful business purposes. Communications using this system will also be monitored and may be recorded to secure effective operation and for other lawful business purposes.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Gab Gambassi
Sent: 30 December 2003 23:08
To: [login to unmask email]
Subject: DB2 Connect


Oracle Gateway for DB2 comes in two flavours: Transparent and DRDA.

The Transparent consist of two STCs running on OS/390 or z/OS, the DRDA
consist of a bunch of processes running on AIX or Solaris (I think this are
the only two opions) and works like a DB2 client via DDF.

My experience is limited to the Transparent one and can confirm that it is
designed for small to medium workload generated by ad-hoc type of access
(Data Centre-like). Definetely not the choice for serious OLTP, in spite of
the recently added GTWY_IDLE_TIME parameter (version 8.1.7) to control
termination of idle connections.

The Oracle DRDA gateway is probably a better choice because it should
deploy DBAT Inactive type 2 thread but I am not sure of its connection
management capability, especially when compared to the CICS-like techniques
provided by DB2 Connect (i.e.connection pooling and connection
concentrator).

As far as simultaneous access of Oracle and DB2 data, IBM still provides
the very efficient DB2 DataJoiner that you can use to simultaneosly access
not only Oracle and DB2 data but all sort of relational databases, in
addition you can investigate the more recent DB2 Information Integrator
that extend the DataJoiner capabilities to unstructured data (eg. Excel
spreadsheet, sequential files, Word Documents ...).

Please be aware that in terms of data integration, the IBM offering is very
open and flexible, while Oracle is quite proprietary solution.

Good luck with you integration and happy new year.

Kind regards
Gabriele Gambassi
----------------------------------------------------------------------
New Zealand
S36°50.787' E174°45.466'



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm