Challenge wrote:
> For Q no. 2, I can select data from a partition in Oracle. So I tried
> to find a similar thing in DB2. Yes, I can select data by a range
> query. But how can I know that data are distributed in the right
> partition?
>
> For Q no. 3, it seems that I couldn't find the some information I want
> to know from the catalog tables. Such as, data distribution in
> different partitions, etc.
Did you take a look at the views I posted?
SYSCAT.DATAPARTITIONS.LOWVALUE and
SYSCAT.DATAPARTITIONS.HIGHVALUE
tell you the range of the partition.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab