master_key reset argument: Change the keystore password (SQL administration API)

Use the master_key reset argument with the admin() or task() function to change the password for the storage space encryption keystore. The password is used to encrypt the keystore for storage space encryption.

Syntax

  >>-EXECUTE FUNCTION--+-admin-+--(-+-"master_key reset"-------+--->
                       '-task--'    '-"master_key reset stash"-'

   >----,--"--password--"--)-;------------------------------------><


Element	Purpose	Key considerations
`password`	A password that you supply for the storage space encryption keystore.	The maximum length is 32 bytes and the minimum length is 8 bytes.

Usage

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

The password protects the storage space encryption keystore. You can run the admin() or task() function with the master_key reset argument at any time to change the password. The keystore gets encrypted with the new password. If you do not supply a master key, a new random master key is generated. The optional keyword "stash" enforces the stashing of the new password even if the old password was not stashed before.

Example

The following example shows how to change the password:

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