Yes - what you want is called a REPLICATED SUMMARY TABLE. It's a special
type of MQT. Small reference tables held in a single partition group can be
replicated to each partition to facilitate co-location of joins within a
partitioned database. See the Admin Guide for the background and the
CREATE TABLE command for the syntax, an example follows:

create table basehist.country2
as (select * from basehist.country)
data initially deferred refresh immediate
enable query optimization
maintained by system in basehists001 <=== this is a multipartition
tablespace
replicated

________
Alex Levy
Sustainable Software Ltd.




"philiplo"
<db2udbdba-ezmlms
hield-x3975674.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
27/07/2006 10:04
Subject
Table on all partitions










Hi

I have small table that gets joined to nearly every other table in user
queries.
This is on a 7 partition database.
Is it possible to create the table in all partitions so that the
interpartiton communication is reduced.
ie. have the full table on all partitions.


********************
Nedbank Limited Reg No 1951/000009/06. The following link displays the
names of the Nedbank Board of Directors and Company Secretary. [
http://www.nedbank.co.za/terms/DirectorsNedbank.htm ]
This email is confidential and is intended for the addressee only. The
following link will take you to Nedbank's legal notice. [
http://www.nedbank.co.za/terms/EmailDisclaimer.htm ]
********************


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page