B. Notes on Using the Embedded-Database Commands
When you use the ajsembdbadduser command to add a new user or modify an existing user, the following embedded-database commands allow you to use the authorization identifier (-a) and the password (-ap) of the user who executes those commands:
-
ajsembdbstatus
-
ajsembdbrorg
-
ajsembdbreclaim
-
ajsembdbsetup
The following describes the -a and -ap options.
- -a command-executer-authorization-identifier
-
Specify the authorization identifier of the user who executes the applicable command.
You usually do not need to specify this option because, root is assumed as the authorization identifier. Specify it only if you have used the ajsembdbadduser command to add a new administrator for the embedded database, or if you have modified the existing administrator.
The specified value is case sensitive.
- -ap command-executer-password
-
Specify the password corresponding to the authorization identifier specified in the -a option.
You usually do not need to specify this option because root is assumed as the password. Specify it only if you have used the ajsembdbadduser command to add a new administrator for the embedded database, or if you have modified the existing administrator.
The specified value is case sensitive.
An error might occur when you execute a command. If an error occurs, take the action indicated in the following table and re-execute the command.
|
Message |
Cause |
Action to be taken |
|---|---|---|
|
KAVS0983-E |
The database cannot be connected because there is an error in the user name or the password. |
Specify correct values in the -a and -ap options, and then re-execute the command. If this error occurs while the SHIFT TABLE message is being output, check the configuration definition. The configuration definition must contain pre-migration settings that work correctly. |
|
KAVS1003-E |
The value specified for -a option is invalid. |
For -a option, specify the authorization identifier of an existing database administrator. |
|
KFPA11564-E |
The character string specified for -a option exceeds 8 bytes. |
Reduce the argument specified for -a option to 8 or fewer bytes and re-execute the command. |
|
KFPA11107-E |
The character string specified for -ap option exceeds 30 bytes. |
Reduce the argument specified for -ap option to 30 or fewer bytes, and then re-execute the command. |
|
KFPA11104-E |
Characters other than alphanumeric characters are specified in an argument of -a or -ap option. |
Use alphanumeric characters for the argument of -a or -ap option, and then re-execute the command. |
|
KFPA11204-E |
No table exists. |
Check the values specified for -a and -ap options, and then specify the authorization identifier of the table owner. |
|
KFPA11561-E |
The specified authorization identifier is not valid. |
Change the values specified for -a and -ap options to the values of the user with who has the DBA permission, and the re-execute the command. |