Hitachi

Hitachi Advanced Database Command Reference


20.2.1 Explanation of the specification format and options

Organization of this subsection

(1) Specification format

adbinit
   -u authorization-identifier
  [-p password]
  initialization-option-file-name
  DB-directory-name

(2) Explanation of options

-u authorization-identifier

~<character string>((1 to 100 bytes))

Specifies an authorization identifier for the first HADB user that is to be created when the HADB server is initialized. The DBA and CONNECT privileges are granted automatically to this first HADB user.

For this option, specify an authorization identifier in the range from 1 to 100 bytes. Note that the byte count (1 to 100 bytes) does not include the double quotation marks used to enclose the authorization identifier.

The following rules apply to specifying this information:

  • The characters permitted for the authorization identifier include single-byte uppercase and lowercase letters, single-byte numeric characters, backslash (\), hash mark (#), and at mark (@).

  • If the character string used as the authorization identifier includes a lowercase letter, enclose the entire authorization identifier in backslashes and double quotation marks (\"). Alternatively, enclose the entire authorization identifier in double quotation marks (") and then enclose it in single quotation marks (').

    Example 1: -u \"ADBuser01\"

    Example 2: -u '"ADBuser01"'

    If the authorization identifier is not specified as shown above, the character string used as the authorization identifier will be treated as being in all uppercase letters. For example, -u ADBuser01 will be treated as -u ADBUSER01.

  • If the character string used as the authorization identifier contains a backslash (\), specify the escape character (\) immediately before the backslash. Alternatively, enclose the entire authorization identifier in single quotation marks (').

    Example 1: -u ADBUSER\\01

    Example 2: -u 'ADBUSER\01'

    In this example, ADBUSER\01 is specified as the authorization identifier.

For details about the rules for specifying authorization identifiers, see Authorization identifier specification rules in the HADB Setup and Operation Guide.

Note

After initialization, use of the authorization identifier and password specified in the adbinit command will be required to connect to the HADB server.

-p password

~<character string>((1 to 255 bytes))

Specifies a password for the first HADB user that is to be created when the HADB server is initialized.

The following rules apply to specifying this information:

  • The characters permitted for the password include single-byte uppercase and lowercase letters, single-byte numeric characters, and the following single-byte symbols:

    \ @ ` ! " # $ % & ' ( ) * : + ; [ ] { } , = < > | - . ^ ~ / ? _

  • Unlike the authorization identifier specified in the -u option, the password is case sensitive.

  • If the password contains a character that has a special meaning in the OS or shell, such as a double quotation mark (") or vertical bar (|), specify the escape character (\) immediately before that character. Alternatively, enclose the entire password in single quotation marks (').

    Example 1: -p Password\|01

    Example 2: -p 'Password|01'

    In this example, Password|01 is specified as the password.

For details about the rules for specifying passwords, see Password specification rules in the HADB Setup and Operation Guide.

If the adbinit command is executed with this option omitted, a message prompting the user to enter a password will be displayed. In such a case, enter the password from the standard input.

Note

You can change the password entered here with the ALTER USER statement. For details about how to change passwords, see Changing an HADB user's password in the HADB Setup and Operation Guide.

Important

How you specify a character string containing a lowercase letter differs between the -u and -p options.

The following shows specification examples:

Example 1: Specifying ADBUSER01 as the authorization identifier and PASSWORD01 as the password

adbinit -u ADBUSER01 -p PASSWORD01

Example 2: Specifying ADBuser01 as the authorization identifier and Password01 as the password

adbinit -u \"ADBuser01\" -p Password01

Example 3: Specifying ADBuser\01 as the authorization identifier and Password\01 as the password

adbinit -u \"ADBuser\\01\" -p Password\\01

initialization-option-file-name

~<OS path name>((1 to 1,023 bytes))

Specifies the absolute path name or relative path name of the file that contains the initialization options. For details about the initialization options, see 20.2.2 Format of initialization options.

DB-directory-name

~<path name>((2 to510 bytes))

Specifies the absolute path name of the DB directory. Specify the DB directory name specified in the adb_db_path operand in the server definition.

When you execute the adbinit command, the command creates the file entities of or symbolic links to the DB area files under the DB directory specified here.

The following notes apply:

  • Only one DB directory can be created.

  • If an existing DB directory is specified, files in the DB directory that are to be overwritten are first deleted and then re-created.

  • Do not create the DB directory under the server directory. The root directory cannot be used as the DB directory.