DB2 UDB Warehouse

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • cjshea@gov.pe.ca
    #1

    DB2 UDB Warehouse

    I am running DB2 UDB Workgroups V8.2 on Linux. I don't believe I
    installed the Data Warehouing capability when I installed. Is it
    difficult to enable that capability post installation?, and a second
    question is "Are the data warehousing capabilities available with my
    install limited, or are they full blown capabilities?, or is full Data
    Warehousing a separate product and install?, with a separate purchase
    price? If so I will proceed to IBM to get all relevant information.
    At this early stage I wish to learn from your experiences. Thank you
    for anything you can provide. Perhaps if you are aware of a
    whitepaper that may describe what I'm asking for, that could be very
    helpful. Thanks
    Claude
    Tags: None
    • Ian
      #2
      Re: DB2 UDB Warehouse

      cjshea@gov.pe.c a wrote:
      I am running DB2 UDB Workgroups V8.2 on Linux. I don't believe I
      installed the Data Warehouing capability when I installed. Is it
      difficult to enable that capability post installation?, and a second
      question is "Are the data warehousing capabilities available with my
      install limited, or are they full blown capabilities?, or is full Data
      Warehousing a separate product and install?, with a separate purchase
      price? If so I will proceed to IBM to get all relevant information.
      It depends on what you mean by "data warehousing capability".

      I think you're referring to the checkbox from the DB2 Installer that
      mentions data warehousing. This checkbox installs a couple of
      components that were used by DB2 Warehouse Manager. Warehouse
      manager provides some very basic ETL tools.

      Please note that this product (DB2 Warehouse Manager) has been
      discontinued, so I would not use it.

      In DB2 9.1 and later releases, DB2 Data Warehouse Edition includes
      a component "SQL Warehousing" which provides similar functionality
      to what was available DB2 Warehouse Manager.







        Comment

        • Dan van Ginhoven
          #3
          Re: DB2 UDB Warehouse

          Hi!

          With DB2 V9.5 (or earlier) Enterprise Server Edition you have the possibility to
          partition the database across multiple CPU's and or Servers. Thus DB2 can run "dataware house questions" in parallell across the
          partitions. Search DB2 documentation for partitioned databases.
          "Administra tion Guide Planning" has a good overview on the issue.

          /dg


          <cjshea@gov.pe. cawrote in message news:e12104c7-b675-4f9b-9410-fccd1564131c@34 g2000hsh.google groups.com...
          I am running DB2 UDB Workgroups V8.2 on Linux. I don't believe I
          installed the Data Warehouing capability when I installed. Is it
          difficult to enable that capability post installation?, and a second
          question is "Are the data warehousing capabilities available with my
          install limited, or are they full blown capabilities?, or is full Data
          Warehousing a separate product and install?, with a separate purchase
          price? If so I will proceed to IBM to get all relevant information.
          At this early stage I wish to learn from your experiences. Thank you
          for anything you can provide. Perhaps if you are aware of a
          whitepaper that may describe what I'm asking for, that could be very
          helpful. Thanks
          Claude

            Comment

            Previous template Next
            Working...