Hi, Just want to know if its possible to somehow have more than one DW setup on the same AIX machine

Version installed DB2 8.1 ESE

Reason, only have one CPU license and need a Test environment setup for the Warehouse.

I heard something along the lines of Partitioning but if someone could clarify please.

Regards

Zarier

Would prefer you to buy more licenses of course :-).........but the answer to your question is yes, you can have multiple databases on the same machine.

Keep in mind you should create on a separate instance, with different admin users, groups, etc., when creating different databases (not a must, but makes admin easier).

If you have a DB2 license for a CPU, you won't get charged double of you have more then one database on that CPU.

On the Partitioning side, if you are working on a DB2 Datawarehouse, and it will eventually grow into the 100s GBs and even TBs......then it is always an idea to look at DB2 Partitioning (DPF Feature).

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Not only can you have multiple DB2 instances on AIX, each one can a different DB2 release or different fixpack level if you use alternate fixpacks.

Hi Everybody,

Thanks for the responses, I think my question might have been misunderstood
Rephrasing

Can I have 2 Active datawarehouses running in parralel on one Server?

Regards

Zarier

Yes, you can have > 1 DB2 DW on the one physical server.

Will need one instance per database.

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Well, I am aware that you can have 2 instances and 2 datawarehouses on the same machine, but can both DWCTRL DB's be active at the same time.
can they run in parralel, as I have been reading in the snip from a DB2 doc
below

Article in PDF Doc:

E.1.4 Creating the test environment
It is your database administrator’s responsibility to create a second warehouse
control database on the warehouse server. This database, DWTESTDB, should
be used for development and testing. To initially synchronize up the production
and test warehouse control databases, DWCTRLDB and DWTESTDB
respectively, the database administrators will restore a copy of the backup of
DWCTRLDB to the test DB name, DWTESTDB.
The production warehouse control database, DWCTRLDB, must be the active
warehouse control database on the warehouse server so that the production
programs can run on its schedule. Since a server or workstation can have only
one active warehouse control database at a time, the test warehouse control
database has to run on its own server or workstation.
The DWTESTDB warehouse control database will be initialized on the
workstation by running Control Database Management. This program sets the
active warehouse control database on the workstation to DWTESTDB allowing
DB2 Warehouse Manager services to run

A data warehouse is a generic term for a type of database that usually has a large number of rows that is used primarily for decision support or ad-hoc queries. You can have many of these on one server.

You seem to be talking about a specific add-on product/feature of DB2 that includes a DWCTRLDB (data warehouse control database). You should have made that clear in your initial post.

If you can't ask the right question, you will not get the right answers.

Probably the right question would be:

Can I have more than one aktive Warehouse Server process ?
-> I guess no, from what you quoted from the documentation.

But of course you can have as many DWCTRLDB instances running on any server, just the server warehouse process can only be single and thus only one can be active for this process.