master_key reset argument: Change the storage space encryption key (SQL administration API)

Use the master_key reset argument with the admin() or task() function to change the master key for storage space encryption. The master key encrypts the keystore for storage space encryption.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"master_key reset"----------->
                     '-task--'                          

>--+---------------------+--)--;-------------------------------><
   '-,--"--master_key--"-'         

Element Purpose Key considerations
master_key A master key for storage space encryption that you supply. The maximum length is 32 bytes.

Usage

You must be logged in as user informix or the root user to run this command.

When you enable storage space encryption, a master key is automatically generated. You can run the admin() or task() function with the master_key reset argument at any time to change the key, store the new key in the stash file, and encrypt the keystore with the new key. If you do not supply a master key, a new random master key is generated.

Example

The following example shows how to change the master key to a user-supplied key:

execute function task("master_key reset", "This is my new key");

Copyright© 2019 HCL Technologies Limited