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. |