Ian wrote:
db2admin wrote:
>hello,
I am wondering if i can install db2 connect product on a AIX server
which already has db2 ese installed on it ?
DB2 ESE already includes the DB2 Connect functionality (I believe ESE
even includes a very limited license to connect to host data sources,
although not as a gateway).
Not anymore it doesn't.
You can create a new instance, using 'db2icrt -s wse', and install your
DB2 connect license file.
Licenses are applies globally for an entire copy of DB2 (at the install
path), not per instance.
To answer the original question, "yes." However, you have choices on how to
do this. You can install to a new location if you don't want your ESE
instances to have access to the host databases, or you can install over top
of ESE if you do want your ESE instances to have access to the host
database.
Separate copy (vs install to the same location)
* takes up more HD space (Connect Server is about the same size as ESE)
* prevents your ESE instance(s) from connecting to a host
* need to set up new instance(s) to connect to host with
* allows you to upgrade one product without upgrading the other
* requires the universal fix pack for upgrade (instead of product-specific
fix packs)
Hope that helps.