View Single Post

   
  #1 (permalink)  
Old 03-17-2008, 06:12 AM
Challenge
 
Posts: n/a
Default Questions about DB2 range partition

Hi,

I have some questions about DB2 range parition and I cannot find the
answer from the document.

1. Can I name the partition name for every partition in a range
partition? For example, p2008jan for data of Jan, 2008?

2. Can I select data from a particular partition? Such as, select
count(*) from <owner>.<table_name>.<partition1>

3. Which catalog tables provide information about range partition
tables?

Thanks.
Reply With Quote