UNCATALOG STORAGE ACCESS command for NCOS

You can remove a remote storage access alias with the UNCATALOG STORAGE ACCESS command either remotely by using a stored procedure or locally by using a command line prompt for instance-level storage access aliases.

Authorization

You will need SYSADM authorization to run the CALL SYSIBMADM.STORAGE_ACCESS_ALIAS.UNCATALOG stored procedure or the UNCATALOG STORAGE ACCESS command.

Required connection

Once a storage access alias is associated with a remote storage group, the storage access alias is expected to be used exclusively for the remote storage group.

Command parameters

ALIAS alias name: The new storage alias name.

Use a stored procedure

You can use the CALL SYSIBMADM.STORAGE_ACCESS_ALIAS.UNCATALOG stored procedure to remotely remove a storage access alias.

To disconnect Db2 from the remote storage service and prevent access, you can delete the storage access alias by running the following command:

CONNECT TO <database name>
CALL SYSIBMADM.STORAGE_ACCESS_ALIAS.UNCATALOG('<alias name>')
CONNECT RESET

Note: Instance-level storage access aliases are managed by a user with SYSADM privileges.

Use the command line

The command UNCATALOG STORAGE ACCESS can be used to remove a storage access alias:


uncatalog storage access alias <alias>

If this alias is associated with a remote storage group, further access to the storage group will fail with SQL1051N when attempting to activate the database:

$ DB2 CONNECT TO BLUDB
SQL1051N  The path "DB2REMOTE://IBMDEFAULTREMALIAS//" does not exist or is not valid.  SQLSTATE=57019