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