I find this statement, but it's not correct for Udb v8:


alter table tabella add partition by range (chiave)
( STARTING(MINVALUE) ENDING AT (99999999999999999) INCLUSIVE,
STARTING(100000000000000000) ENDING AT (199999999999999999) INCLUSIVE,
STARTING(200000000000000000) ENDING AT (299999999999999999) INCLUSIVE,
STARTING(300000000000000000) ENDING AT (MAXVALUE)
);


I would to create 4 range for a table not partitioned... it's possible?
Thank you..

Fabio

No range partitioned table in V8 ..

Allegedly, it is in V9

Cheers
Sathyaram

Oh no!!!

Have you idea about the date of new release?

Thank you!
Fabio

BTW, an alternative to Range Partitioning is Union All views ...

create tabella_r1 (col1 int <check constraint for the range>,col2 int)
create tabella_r2 (col1 int <check constraint for the range>,col2 int)

create view tabella as
select * from tabella_r1
union all
select * from tabella_r2
etc ....

You can, INSERT, UPDATE and DELETE using the view .. If you are using a recent fixpak, UPDATE of the 'partiioning key' is also possible ... Row movement between tables happens behind the scenes ...

Being a view, there are limitations -
a) Load not possible
b) If your select query does not include the partitioing key in the predicate, in many cases, the optimizer decides to do a Union All before evaluating your predicate which obviously is a performance killer

There are some more as well ...

This approach is an alternative to range partitioning, but not real range partitioning

Cheers
Sathyaram

tentatively, end of Q3/ early Q4

I'll speak with my boss about this!!!

Bye and Thanks very well!!

You can get a beta copy of V9 now, if you can convice IBM to let you join the beta program. Be aware, that the DB2 beta program in not informal like Microsoft and other vendor beta programs.

Marcus, Do you know when the 'public' beta starts ?

Sathyaram

I don't think that DB2 usually has public betas.

I remember one being avaiable under the name 'Stinger' for 8.2 ... Previously I don't remember to have had any ..

Cheers
Sathyaram

You are correct, I forgot about that one. I guess it is possible that they have another one for V9, but I have not heard anything.