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

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

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

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.

Can you INSERT into the view you create with UNION ALL?

Yes
.................