I'm thinking of upgrading to say DB2 Express from Express-C but .. If
I were to purchase an Authorized user License for 1 user, how many
simultaneous 'connections' could that user maintain to a single
database / server ?

My setup does not have 'users' so to speak, rather just me, but I do
need have multiple connections available to me say via a Rexx
application, also via a product say SQLDBX at the same time. I note
that http://www-01.ibm.com/software/lotus...tml#authorized
this doc explains Authorized but also specifies Concurrent user, but
there is no License for Concurrent User on
https://www-112.ibm.com/software/how...ry=USA&PT=html

Thus my concern, So can my Authorized user License enable me to
maintain multiple concurrent connections and applications to my DB at
the same time ?

Can someone also explain how the license is linked to a User ID in
Windows environment, say db2admin as the single user ?

"Fin" <tdavidge (AT) hotmail (DOT) com> wrote

Maybe you should explain what you are trying to do with DB2 and your overall
application/database architecture, and then the DB2 licensing choices can be
explained to you. Please also explain your hardware where you will run DB2.

On Jan 29, 12:01*pm, "Mark A" <no... (AT) nowhere (DOT) com> wrote:
It's a simple standalone DB on an IBM workstation PC [Single Pentium 4
processor] running Windows XP SP3, DB2 9.7 Express-C. Works fine
albeit a little slow at times. It is approx 30gb in total when backed
up, I am the ONLY user, no online transactions, just me loading new
result sets via csv files and processing via ooREXX executing numerous
SQL Stored Procedures I have built and querying results via SQLDBX.

I use it for primarily for datamining with association rules.

I am perhaps looking to upgrade the PC to say a x4 core i7-2500k 4gb
memory in the near future and just wanted to know which version of DB2
would suit and what license I may need if I go beyond Express-C. My
main concern is that I often have multiple concurrent 'connections' up
from both REXX and SQLDBX for the same user DB2ADMIN, I note in the
above links that a single Authorized User license costs $184 and I
need to make sure it supports multiple concurrent connections for the
single user.

Thanks for any help.

"Fin" <tdavidge (AT) hotmail (DOT) com> wrote

I am not sure you would be much better (if any better) off performance-wise
with DB2 Express compared to Express-C. All editions of DB2 support multiple
concurrent connections. My guess is that you need some database tuning, and
it would help if your tablespaces had multiple containers, each on a
separate physical disk.

Also, I think you need to purchase at least 5 user licenses according to the
link below, and I believe that an Intel i7-2500k (Sandy Bridge) has 400
PVU's, so that may be another problem.

http://www.ibm.com/developerworks/da...909db2compare/
"The DB2 Express AU license allows you to license DB2 Express on a per user
basis. With this license, you have to buy an AU license for each user that
wants to connect to a specific DB2 Express server. If the same user wants to
connect to two different DB2 Express servers, that one person needs two AU
licenses. In addition, you need to buy at least 5 AU licenses when licensing
DB2 Express using this method. A DB2 Express server with an AU license can't
be installed on a server with more than 200 PVUs."


The main difference is that DB2 Express can use up to 4 GB of memory and 4
CPU cores, and DB2 Express-C will only use up to 2 GB of memory and 2 CPU
cores . You can install them on any size machine. Considering you will have
other things running on the same machine, not sure if you really need DB2 to
utililize more than half the CPU power and half the memory.

DB2 Express has some features not found in Express-C, as indicated in the
link above, but they may not apply to anything you need to use.

Mark,

Thanks for the response. Guess I will be sticking with Express-C based
upon apparent licensing costs for my very simple environment.

It wouldn't be so bad if all I had to purchase was the minimum 5 AU
licenses, but not being able to install Express with an AU license on
a machine with 400 PVU's is plain silly, especially in my case.

As far as tuning goes, I have a fairly good understanding of tuning,
but I'm asking a lot of the existing 10 year old hardware with some of
stored procedures I have written and they have all been through
vigorous Visual Explain etc every time I write them so I know what to
expect. I was just hoping via an upgrade to be able to utilize 4
cores ,4gb of memory but I'm thinking that is now out of the question.
Will just have to make do with x2 core/2gb of mem I guess.

Thanks again for your input, appreciate it.

"Fin" <tdavidge (AT) hotmail (DOT) com> wrote

Assuming you allocate enough memory to your database (bufferpools, etc), I
would guess that your new hardware should run at least 10 times faster than
old setup. However, as you may know by now, Intel announced yesterday that
there is bug in the Sandy Bridge chipset, so there may be a delay in getting
your new hardware in place.

For situations where you have a data warehouse type application that needs
to read a lot of data for each query, it will help if you have more than one
physical drive and then create paths on each drive to be assigned to the
automatic storage pool.

It may be that the 400 PVU limit for DB2 Express will be (or has been)
re-evaluated by IBM, since the pre-Sandy Bridge Intel cores were valued at
50 PVU's each. So you could check with IBM on this, however, I doubt it will
run much faster than DB2 Express-C in your environment.