Thanks, Serge.

Probably I did not explain my question clearly.

My environment is UDB V8 on AIX.

My concern is not table size limit.  Because now I know the Max size
for the big table is 40GB. It is OK on single partition, even for 4K
page.

My concern is on query performance. I know if using multi-partition, it
must be resolved.
but the other tables are all very small, and the total DB size is not
big (50GB), based on the DB size, I want to  use single partition
database. Only because of this big table to use multi-partiton , seems
a little bit waste..

That's why I want to break down the big table to relatively smaller
ones. Use union all view.

One of my colleague remind me  this would change optimizer to not use
star schema to get good access plan..
(because currently , the big table is fact table, it is in star schema
model)
I'm not sure if this is the case..