Results 1 to 5 of 5
  1. #1
    Join Date
    May 2011
    Posts
    3

    Unanswered: how many types of partitions is there in db2

    hai friend i am new to DB2.can u help me outttttttttt

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For DB2 LUW (Linux, UNIX, Windows) there are these types:

    • Partitioned Databases (also known as Data Partitioning Feature or InfoSphere Warehouse). This is not included in DB2 ESE by default (requires extra licensing). This uses hash partitioning to spread data in a table across multiple logical and physical nodes.
    • Table Partitioning - Also known as range partitioning, such as partitioning by month, etc. This is available for ESE licenses.
    • Multiple Dimensional Clustering (MDC) - This is not exactly partitioning but is physically storing data in a hierarchical manner, sort of like IMS (a hierarchical non-relational database). This is available for ESE licenses.

    You can Google for more background information on these.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Also, there are "range clustered tables", which basically provide direct addressing of rows as you can do in arrays.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by stolze View Post
    Also, there are "range clustered tables", which basically provide direct addressing of rows as you can do in arrays.
    Is that really a type of partitioning?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I guess you're right - it's a clustering mechanism not a partitioning because RCTs do not physically separate the data.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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