DB2 10.5 for Linux, UNIX, and Windows

RENAME STOGROUP statement

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

Read syntax diagramSkip visual syntax diagram
>>-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