If I understand correctly, UDB on UNIX doesn't let me specify
partitioning key ranges like OS/390 DB2.
In OS/390 I can 'point' key ranges to specific partitions. This allows
me to direct the growth of a table toward the end(highest numbered
partition), keeping the beginning (low numbered) partitions static. The
advantage is that I never have to reorg the oldest (lowest numbered)
partitions. With UDB 7.2, my understanding is that I have to let the
random assignment to nodes put new rows whereever the hashing algorithm
chooses. Is this right? If so, is there any plan in IBM to make UDB on
UNIX more like OS/390 with respect to partition key assignment?
I'd appreciate your thoughts advice on how to deal with this kind of
situation.
Thanks in advance,
Roy
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
