467,189 Members | 1,165 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Rename a tablespace file?

Hi,
I have started using Db2 V9 on AIX 5L and in the process of getting to grips with it I wondered if it has the ability to rename tablespace files. I could not find anything in the docs to indicate this ability. I am thinking of a situation where I want to move tablespaces around disk logical volumes.

Regards

Pete
Jul 9 '07 #1
  • viewed: 2392
Share:
2 Replies
Hi,
I have started using Db2 V9 on AIX 5L and in the process of getting to grips with it I wondered if it has the ability to rename tablespace files. I could not find anything in the docs to indicate this ability. I am thinking of a situation where I want to move tablespaces around disk logical volumes.

Regards

Pete
Try this:
RENAME TABLESPACE statement
The RENAME TABLESPACE statement renames an existing table space.

Invocation
This statement can be embedded in an application program or issued
through the use of dynamic SQL statements. It is an executable statement
that can be dynamically prepared only if DYNAMICRULES run behavior is in
effect for the package (SQLSTATE 42509).

Authorization
The privileges held by the authorization ID of the statement must
include either SYSCTRL or SYSADM authority.

Syntax
>>-RENAME--TABLESPACE--source-tablespace-name------------------->

>--TO--target-tablespace-name----------------------------------><

good luck

___________
Janet Kellman, software reviews
Jul 9 '07 #2
Thanks for the pointer.

Pete
Jul 10 '07 #3

Post your reply

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

Similar topics

6 posts views Thread by robert | last post: by
4 posts views Thread by Joachim Klassen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.