Three more things to consider.
1) you will need to create any existing indexes on the replicated tables
2) run runstats on replicated tables
3) if you replicate to all partitions, remember that if the source table
replicated to the tablespace which contains the source table or
partitions, you will have two copied of these table (source table and
replicated table)

Thanks,
Bobby

-----Original Message-----
From: Alex Levy
[mailto:db2udbdba-ezmlmshield-x15369778.[Email address protected]
Sent: Thursday, July 27, 2006 5:23 AM
To: LazyDBA Discussion
Subject: Re: Table on all partitions

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





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

NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.

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