Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2004
    Posts
    26

    Thumbs down Unanswered: Mulitple Data Warehouses on a Single AIX box

    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

  2. #2
    Join Date
    Apr 2005
    Posts
    41
    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/

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jun 2004
    Posts
    26

    Re: DataWarehouse

    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

  5. #5
    Join Date
    Apr 2005
    Posts
    41
    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/

  6. #6
    Join Date
    Jun 2004
    Posts
    26

    Re: 2 Active DataWarehouses

    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

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Oct 2005
    Posts
    109
    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.
    Juliane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •