By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Rename a tablespace file?

P: 3
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
Share this Question
Share on Google+
2 Replies


P: 1
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

P: 3
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.