Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: How to create Partitioned Tables in DB2 LUW

    Hi

    Can anybody give me Syntax for creating partitioned TABLES in LUW DB2?

    I have created the table space USERSPACE1 as below, to create Partitioned tables in USERSPACE1

    CREATE REGULAR TABLESPACE "USERSPACE1"
    IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
    PAGESIZE 4 K
    MANAGED BY SYSTEM
    USING ( '/db/db2inst2/SAMPLE/db2inst2/NODE0000/SQL00001/SQLT0002.0')
    EXTENTSIZE 32
    BUFFERPOOL "IBMDEFAULTBP"
    TRANSFERRATE 0.18;

    Basically I would like to know how to know how to divide data across multiple data partitions according to values in the table partitioning key columns for the table

    Thanks in Anticipation
    Neha

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    you may find the following article helpful:
    Introducing DB2 9, Part 2: Table partitioning in DB2 9

Posting Permissions

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