Hitachi

JP1 Version 12 JP1/Automatic Job Management System 3 Command Reference


B.3 ajsembdbadduser

Format
ajsembdbadduser
     [-i embedded-database-practical-directory-name]
     [-mh logical-host-name]
     [-p embedded-database-communication-port]
     -a embedded-database-administrator-authorization-identifier
     -ap embedded-database-administrator-authorization-identifier-password
Description

Creates a new embedded database administrator by using the specified authorization identifier and password for the authorization identifier.

When you specify the existing authorization identifier of the embedded database administrator, you can change the password.

Execution permissions

In Windows: Administrators permissions

In UNIX: Superuser permissions

Storage directory
In Windows

JP1/AJS3 - Manager-installation-folder\tools\

In UNIX

/opt/jp1ajs2/tools/

Arguments
-i embedded-database-practical-directory-name

Specify the embedded database practical directory by using the full path to specify the directory. For Windows, if the full path contains a space character, enclose it in double quotation marks (").

You can use the ajsembdbidlist command to check the path to the embedded database practical directory. For details about the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup .

When you omit this option, the following value is assumed:

For UNIX: /opt/jp1ajs2/embdb/_JF0

For Windows: embedded-database-practical-directory-corresponding-to-embedded-database-setup-identifier_JF0

-mh logical-host-name

Specify the name of the target JP1 logical host. You can specify a character string of 1 to 32 bytes.

If you omit this option and the environment variable JP1_HOSTNAME has been set, the value of the environment variable is assumed. If no value is set for JP1_HOSTNAME, the physical host is assumed.

-p embedded-database-communication-port

Specify the connection port for the embedded database as a decimal number.

For the embedded database communication port to be specified, see the value specified in the RDBPORT environment setting parameter for the scheduler service.

You can use the ajsembdbidlist command to check the association between scheduler services and embedded databases. For details about the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup .

If you omit this option, 22220 is assumed.

-a embedded-database-administrator-authorization-identifier

Specify the owner of the tables in the new JP1/AJS3 scheduler database to be created. For this authorization identifier, do not specify a database access user (RDBUSER). When you specify the existing authorization identifier of the embedded database administrator, the current password is changed to the password specified in -ap option.

Use eight or fewer single-byte alphanumeric characters (the first character must be an alphabetic character) for this authorization identifier.

-ap embedded-database-administrator-authorization-identifier-password

Specify the password for the authorization identifier of the embedded database administrator.

Use 30 or fewer single-byte alphanumeric characters (the first character must be an alphabetic character) for this password.

Notes
  • You must execute this command while the embedded database is running. If you execute it while the embedded database is not running, an error occurs.

  • Before you execute the ajsembdbadduser command, set environment variable PDUSER by using the authorization identifier and the authorization identifier password of the existing database administrator. If you execute the command without setting environment variable PDUSER, an error occurs.

  • When you execute the ajsembdbadduser command and an error occurs during access to the embedded database server, the error information dated to the connection of the embedded database is created by the name of pderr1.trc and pderr2.trc in the working directory used when the ajsembdbadduser command is executed. When you re-execute the command and the embedded database server ends normally, delete these files.

  • The following table lists the characters you can specify for the -a and -ap options.

    Option name

    Allowed number of bytes

    Single-byte characters allowed

    Multi-byte characters allowed

    Upper-case characters and numbers

    Lower-case characters

    Underscores

    (_)

    Space characters

    Hyphens

    (-)

    -a

    8 bytes

    Yes

    Yes

    No

    No

    No

    No

    -ap

    30 bytes

    Yes

    Yes

    No

    No

    No

    No

  • Do not execute this command more than once in quick succession. If you do so, the command might result in an error.

  • If you specify root in the -a option when attempting to change the embedded database authorization identifier password, the jajs_setup command might result in an error.

Return values

0

Normal end (However, if an error message appears, take the action described in the message.)

Other than 0

Abnormal end

Actions to be taken if an error occurs

If an error occurs when you execute ajsembdbadduser command, take the action indicated in the following table.

Table B‒1: Actions to be taken if an error occurs when ajsembdbadduser command is executed

Message

Cause

Action to be taken

KAVS0996-E

The specified option and value are invalid.

Correct the option and the value for the option, and then re-execute the script.

KFPA11723-E

The embedded database is running.

Alternatively, the value specified for -p or -mh option is incorrect.

Start the embedded database.

If the embedded database is running, check the value specified for -p or -mh option, and then re-execute the script.

KFPA11564-E

The length of the character string specified for -a option exceeds 8 bytes.

Reduce the argument of -a option to 8 or fewer bytes, and re-execute the script.

KFPA11107-E

The length of the character string specified for -ap option exceeds 30 bytes.

Reduce the argument of -ap option to 30 or fewer bytes, and then re-execute the script.

KFPA11104-E

Characters other than alphanumeric characters are specified for the argument of -a or -ap option, or the first character is a number.

Use alphanumeric characters (the first character must be an alphabetic character) for the argument of -a or -ap option, and then re-execute the script.

Bad directory specified in -i option

The directory specified for -i option is not the embedded database practical directory or the embedded database is not correctly set up.

Specify the correct Embeddb practical directory in -i option. If the correct embedded database practical directory is specified, and then set up the embedded database again.

AuthID is not Specified

The -a option is not specified.

Specify the -a option.

AuthIDPassword is not Specified

The -ap option is not specified.

Specify the -ap option.

KAVS0101-E

No value is specified for an option that requires a value.

Specify a value for the option and then re-execute the command.

KFPA11724-E

Because the value specified for -p or -mh option is incorrect. The embedded database cannot be connected.

Correct the value specified for -p or -mh option, and then re-execute the script.

KFPA11560-E

The authorization identifier password specified for PDUSER is incorrect.

Specify the password for the authorization identifier specified for PDUSER and then re-execute the script.

KFPA11561-E

The specified authorization identifier is not valid.

Change the user specified for PDUSER to a user with the database administrator permission and then re-execute the script.