Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2005
    Posts
    4

    Unanswered: Question on UDB Feature

    Hi, We have a table with high volume .Is there any feature in UDB Version 8.0 to partition tables (Kind of similar to Oracle ) or is database partitioning the only way . We do not have the hardware to set up database partioning hence was wondering if there is a way out .

    Thanks very much,
    Venky

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Look into UNION all view; you create each partition(say data for each month) as a seperate table but view the group of such tables as a master table
    mota

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    A table partition resides in a database partition. If you have a single-partition database then you can only create tables that reside in that single partition.

    You could implement "poor man's table partitioning" by creating multiple tables with the same structure and range check constraints for the pseudo-partitioning key column(s) and defining a UNION ALL view over those tables. The optimizer will be able to take advantage of that.

    More about this here: http://www-128.ibm.com/developerwork...209rielau.html

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The UNION ALL view works exceptionally well with multiple processors, because it can make use of parallel query processing. You will need to set the DB2 parms to allow for parallel processing. For best results, put each table on a different physical device or different array.
    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
    Mar 2005
    Posts
    108
    Can you INSERT into the view you create with UNION ALL?

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Yes
    .................

Posting Permissions

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