Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    11

    Unanswered: how to find no. of hash partitions per database partition, of a table ?

    How to find no. of hash partitions per database partition, of a table, in partitioned database environment?
    Last edited by VenkatG; 03-12-11 at 23:04. Reason: to make question more clear

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What do you mean by "hash partitions"?

  3. #3
    Join Date
    Mar 2011
    Posts
    11
    hash partitions: Also called as hash keys that are generated by hash alogrithm, during the distribution of table rows, as per the distribution key across the database partitions.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by VenkatG View Post
    hash partitions: Also called as hash keys that are generated by hash alogrithm, during the distribution of table rows, as per the distribution key across the database partitions.

    Maybe you're looking for 32767 (4096 in pre-v9.7) - partitioning/distribution map mentioned here:
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center


    "Database partitioning is the method by which the placement of each row in the table is determined. The method works as follows:
    A hashing algorithm is applied to the value of the distribution key, and generates a number between zero (0) and 32 767.
    The distribution map is created when a database partition group is created. Each of the numbers is sequentially repeated in a round-robin fashion to fill the distribution map.
    The number is used as an index into the distribution map. The number at that location in the distribution map is the number of the database partition where the row is stored."

Posting Permissions

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