Results 1 to 4 of 4

Thread: DB2 scalabilty

  1. #1
    Join Date
    Aug 2012
    Posts
    70

    Unanswered: DB2 scalabilty

    hello all


    I am wondering which possibilities there are for DB2 scalability, and which are the differences between them.
    I am only aware of PureScale, but I would like to know the other possibilities.

    Thanks in advance
    Best regards
    Renaud

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    This is a pretty broad topic, but to tackle a bit:
    1. DPF - Database Partitioning Feature - is a shared nothing architecture. In my experience it is great for large data warehouses, as it lets you partition a database across multiple hosts (phyiscal and/or logical). Very stable, been around a long time.
    2. Table Partitioning - different than DPF, allows partitioning a single table to make it more manageable.
    3. PureScale - Shared storage architecture. Allows multiple compute nodes for a single logical database.
    4. BLU - newest offering. Currently we are evaluating this as an alternative to DPF, if this works as well as what we have been told this will be a great option for data warehouse environments. Compression rates are impressive, 10 TB's down to 1 TB, so scalability will be incredible. I am really hoping this works as well as we have been told.

    Lots more to this discussion but those are a few options at a very high level. I am sure others will respond in more detail.

  3. #3
    Join Date
    Aug 2012
    Posts
    70
    thanks a lot. It is very helpful
    I will take some time to read more about the topics you mentionned

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by azready View Post
    4. BLU - newest offering. Currently we are evaluating this as an alternative to DPF, if this works as well as what we have been told this will be a great option for data warehouse environments. Compression rates are impressive, 10 TB's down to 1 TB, so scalability will be incredible. I am really hoping this works as well as we have been told.
    BLU (column based tables) will have advantages in situations where many queries only access a sub-set of the columns in the table. If most or all columns in a table need to be accessed, BLU is not likely to be an advantage, and may actually take longer.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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