RE: DB2 AS/400 client connector

[Gord Royle <GRoyle@xxxxxxxx>]

Hi Bryan

We've heard in the past that the "native" DB2 driver (???) might be faster.
We've had no significant performance questions using the ODBC driver. We use
it for Cognos but we also use it to extract data to our Operational Data
Store. As for Cognos, the biggest performance hit is when you separate the
data from the client. Cognos Impromptu does so much of it's work locally
that it draws a ton of data to the client. If you have bandwidth problems to
contend with (most of us do), you'll need to come up with some neat
solutions to get around them. Cognos discussions are probably off topic for
this list so if you need more info feel free to contact me directly.

Gord

-----Original Message-----
From: Burns, Bryan [mailto:burnsbm@xxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, August 26, 2003 3:14 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 AS/400 client connector


Thanks Gord, and to the others who responded.  We connected using the Client
Access driver.  What confused me is that they didn't just say "client access
driver".  Also, we were referred to a web page that indicated "DB2/400 V4R5
via DB2 Connect 7.1" is also supported.

Management thinks there may be performance issues with ODBC and that one
method of connecting may be better than the other performance-wise.  Do you
have any performance issues?
 


-----Original Message-----
From: Gord Royle [mailto:GRoyle@xxxxxxxx]
Sent: Tuesday, August 26, 2003 12:34 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 AS/400 client connector


Hi Bryan

You just need to install the Client Access ODBC driver as part of your
Client Access install. We have Cognos and over 300 reports that access the
AS400 directly. If you want to use Stored Procedures, there is a special
little twist but, other than that, the DB2 access is seamless. If you need
some help, let me know.

Cott Corporation
Gord Royle

-----Original Message-----
From: Burns, Bryan [mailto:burnsbm@xxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, August 26, 2003 9:00 AM
To: 'MIDRANGE-L@xxxxxxxxxxxx'
Subject: DB2 AS/400 client connector


We are installing COGNOS and the COGNOS consultant needs:

DB2 AS/400 CLIENT CONNECTOR and IBM AS/400 CLIENT SOFTWARE AND ODBC FOR
DATABASE.

Where do I get the client CD's?  Is this part of Client Access Family for
Windows?

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.