The RENAME STOGROUP statement renames an existing storage
group.
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--STOGROUP--source-storagegroup-name------------------->
>--TO--target-storagegroup-name--------------------------------><
Description
- source-storagegroup-name
- Identifies the storage group to rename; source-storagegroup-name must
identify a storage group that exists at the current server (SQLSTATE
42704). This is a one-part name.
- target-storagegroup-name
- Names the storage group. This is a one-part name. It is an SQL
identifier (either ordinary or delimited). The target-storagegroup-name must
not identify a storage group that already exists in the catalog (SQLSTATE
42710). The target-storagegroup-name must
not begin with the characters 'SYS' (SQLSTATE 42939).
Rules
- The RENAME STOGROUP statement cannot be executed while a database
partition server is being added (SQLSTATE 55071).