Unfortunately, in Version 5 you must drop and recreate
the tablespace. Yes, this is a big pain (unload, drop,
create, load, image copy). In the future you might
want to create more partitions than you need.
--- "Reid, Louise" <[login to unmask email]> wrote:
> How do you add another partition to a partitioned
> tablespace in V5? Can I
> just alter or create the new partition? I do not
> have to change the key
> limit in any other partition. If yes - does someone
> have sample syntax they
> have used?
> TIA, Louise
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
owners of the list
B.L. "Tink" Tysor
Bayard Lee Tysor, Inc
Do You Yahoo!?
Send your FREE holiday greetings online!