HELP : DB2 Licence

I've just read that I need to buy "DB2 CONNECT UNLIMITED
EDITION HOST SERVER" so I can use a Web Server to connect
to the DB2 at the AS/400 server. There must be some type
of error because the licence costs 67,137 ?.

The configuration is as follows (it's just an Intranet):

1) Operators within the company connect to the Windows
2003 Web Server and access the ASPX pages.

2) The Windows 2003 Web Server connects to the AS/400 DB2
(through DB2 Connect) and gets the information returned by
the SQL Query.

3) Windows 2003 Web Server returns the information to the
operator's browser.

Can't I use "DB2 Connect PE Licence" for the above
configuration? There may be at some time 5 concurrent
operators sending web petitions to the Windows 2003 Web
Server, but the only computer connecting to the AS/400
will be the Web Server.

Thank You

Frans
Wed Jul 28 04:07:37 CDT 2004

Antoni Massó Mola wrote:

> I've just read that I need to buy "DB2 CONNECT UNLIMITED
> EDITION HOST SERVER" so I can use a Web Server to connect
> to the DB2 at the AS/400 server. There must be some type
> of error because the licence costs 67,137 ?.

Every AS/400 comes with a package called Clientconnect, which contains the
DB2 client and various software to get you connected like an OLEDB driver.
I'm not sure if the .NET provider is already added to this package, last time
I checked it's still in beta.

> The configuration is as follows (it's just an Intranet):
>
> 1) Operators within the company connect to the Windows
> 2003 Web Server and access the ASPX pages.
>
> 2) The Windows 2003 Web Server connects to the AS/400 DB2
> (through DB2 Connect) and gets the information returned by
> the SQL Query.
>
> 3) Windows 2003 Web Server returns the information to the
> operator's browser.
>
> Can't I use "DB2 Connect PE Licence" for the above
> configuration? There may be at some time 5 concurrent
> operators sending web petitions to the Windows 2003 Web
> Server, but the only computer connecting to the AS/400
> will be the Web Server.

It depends on the amount of client licenses your company has bought for the
AS/400 box. The webserver is just another user connecting to the box. But
perhaps IBM has a different opinion on this, I don't know. However IF you
really are required to pay 67000$ according to IBM, I'd use an intermediate
database on the webserver, like sqlserver or firebird and migrate that data
to the AS/400 in a batch process.

FB

--
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET Blog: http://weblogs.asp.net/fbouma
Microsoft C# MVP

amasso
Wed Jul 28 04:52:58 CDT 2004

We have 200 client licences for the AS/400 server. That's=20
what I thought, the Web Server is another client=20
connecting to the AS/400 to retrieve data from the DB2.=20
$67,000 is a lot of money to build up a Web Server to=20
retrieve data from the AS/400-DB2.

>-----Original Message-----
>Antoni Mass=F3 Mola wrote:
>
>> I've just read that I need to buy "DB2 CONNECT=20
UNLIMITED=20
>> EDITION HOST SERVER" so I can use a Web Server to=20
connect=20
>> to the DB2 at the AS/400 server. There must be some=20
type=20
>> of error because the licence costs 67,137 ?.
>
> Every AS/400 comes with a package called=20
Clientconnect, which contains the
>DB2 client and various software to get you connected like=20
an OLEDB driver.
>I'm not sure if the .NET provider is already added to=20
this package, last time
>I checked it's still in beta.
>
>> The configuration is as follows (it's just an Intranet):
>>=20
>> 1) Operators within the company connect to the Windows=20
>> 2003 Web Server and access the ASPX pages.
>>=20
>> 2) The Windows 2003 Web Server connects to the AS/400=20
DB2=20
>> (through DB2 Connect) and gets the information returned=20
by=20
>> the SQL Query.
>>=20
>> 3) Windows 2003 Web Server returns the information to=20
the=20
>> operator's browser.
>>=20
>> Can't I use "DB2 Connect PE Licence" for the above=20
>> configuration? There may be at some time 5 concurrent=20
>> operators sending web petitions to the Windows 2003 Web=20
>> Server, but the only computer connecting to the AS/400=20
>> will be the Web Server.
>
> It depends on the amount of client licenses your=20
company has bought for the
>AS/400 box. The webserver is just another user connecting=20
to the box. But
>perhaps IBM has a different opinion on this, I don't=20
know. However IF you
>really are required to pay 67000$ according to IBM, I'd=20
use an intermediate
>database on the webserver, like sqlserver or firebird and=20
migrate that data
>to the AS/400 in a batch process.
>
> FB
>
>--=20
>Get LLBLGen Pro, productive O/R mapping for .NET:=20
http://www.llblgen.com
>My .NET Blog: http://weblogs.asp.net/fbouma
>Microsoft C# MVP
>.
>

bruce
Wed Jul 28 12:45:01 CDT 2004

you should check directly with ibm, they may allow you to use your client
licenses if its an intranet application.

note: MS has the same issue with SQLServer. If a web page accesses sqlserver
either directly or though a business object you need the 15K SQLConnect
license, the19K processor license or a CAL for each web page user.

-- bruce (sqlwork.com)


"Antoni Massó Mola" <amasso@triliumsoftware.com> wrote in message
news:59cb01c4747f$61c53800$a501280a@phx.gbl...
> I've just read that I need to buy "DB2 CONNECT UNLIMITED
> EDITION HOST SERVER" so I can use a Web Server to connect
> to the DB2 at the AS/400 server. There must be some type
> of error because the licence costs 67,137 ?.
>
> The configuration is as follows (it's just an Intranet):
>
> 1) Operators within the company connect to the Windows
> 2003 Web Server and access the ASPX pages.
>
> 2) The Windows 2003 Web Server connects to the AS/400 DB2
> (through DB2 Connect) and gets the information returned by
> the SQL Query.
>
> 3) Windows 2003 Web Server returns the information to the
> operator's browser.
>
> Can't I use "DB2 Connect PE Licence" for the above
> configuration? There may be at some time 5 concurrent
> operators sending web petitions to the Windows 2003 Web
> Server, but the only computer connecting to the AS/400
> will be the Web Server.
>
> Thank You