467,199 Members | 1,020 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

Controling tablespace for a primary key index in alter table

Using DB2 version 9, fixpak 2 on AIX 5L.

I created my DDL for defining a Primary Key to be done by a ALTER TABLE command, but I could not find a way of naming the tablespace to control were the index that gets created goes.

I did find that I could create the table with the clause "INDEX IN ...", name the tablespace I wanted and then when the ALTER TABLE ran it resulted in the index going into the tablespace I wanted. I guess I could also pre-create the index.

But is there a way of specifying the tablespace in an ALTER TABLE ADD CONSTRAINT ... command? I would prefer to do it that way, because it makes it explict where the index is going to go, when for what ever reason the constraint has to be dropped and re-created.


Jul 10 '07 #1
  • viewed: 2189

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Jens H. Hamann | last post: by
4 posts views Thread by Peter Scott | last post: by
4 posts views Thread by mairhtin o'feannag | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.