Changing user-managed objects to use the new qualifier

You can change user-managed objects to use the new high-level qualifier.

Procedure

To change user-managed objects:

Stop the table spaces and index spaces by using the following command:
```
-STOP DATABASE(dbname) SPACENAM(*)
```
Use the following SQL ALTER TABLESPACE and ALTER INDEX statements with the USING clause to specify the new qualifier:
```
ALTER TABLESPACE dbname.tsname
  USING VCAT newcat;
```
```
ALTER INDEX creator.index-name
  USING VCAT newcat;
```
Repeat this step for all the objects in the database.

Using IDCAMS, rename the data sets to the new qualifier. Also, be sure to specify the instance qualifier of your data set, y, which can be either I or J:

ALTER oldcat.DSNDBC.dbname.*.y0001.A001 - 
NEWNAME (newcat.DSNDBC.dbname.*.y0001.A001) 
ALTER oldcat.DSNDBD.dbname.*.y0001.A001 - 
NEWNAME (newcat.DSNDBD.dbname.*.y0001.A001)

Start the table spaces and index spaces, using the following command:
```
-START DATABASE(dbname) SPACENAM(*)
```
Verify the success of the procedure by entering the following command:
```
-DISPLAY DATABASE(dbname)
```
Using SQL, verify that you can access the data.

What to do next

Renaming the data sets can be done while Db2 is down. They are included here because the names must be generated for each database, table space, and index space that is to change.