A database named MYDB was created as follows: CREATE DATABASE mydb
AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB
to an automatic storage database?
A.
Use the DROP DATABASE command to drop the database; then, recreate the database
by executing a CREATE DATABASE commandstatement that does not contain the
AUTOMATIC STORAGE NO option.
B.
Use the ALTER DATABASE statement to add storage paths to the database.
C.
Use the CREATE STOGROUP statement to define a new storage group in the database
and to assign storage paths to the new storage group.
D.
Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC
STORAGE configuration parameter for the database toYES.
Procedure
To convert an existing database to an automatic storage database, use the ALTER DATABASE statement to add storage paths to it:
Formulate an ALTER DATABASE statement with an ADD STORAGE ON clause. For example, to convert the database DATABASE1 to use automatic storage, use the following statement:
ALTER DATABASE DATABASE1 ADD STORAGE ON storagePath
where storagePath is the path you want to use for automatic storage table spaces.
Run the statement.
0
0