B.4 ajsembdbreuse

Format

ajsembdbreuse
     {{-l | -m | -s | -n number-of-segments} | -D}
     [-mh logical-host-name]
     [-p embedded-database-communication-port]
     [-tp table-prefix]
     [-a embedded-database-administrator-authorization-identifier]
     [-ap embedded-database-administrator-authorization-identifier-password]
     [-i embedded-database-practical-directory-name]
     [-b]

Description

Allows you to apply the free space reusage facility to the JP1/AJS3 tables created in the embedded database that matches the specified prefix.

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

-l|-m|-s|-n number-of-segments

Specify the point at which you want to start using the free space reusage facility. When the usage rate of the data area reaches the threshold specified here, the free-segment reuse function starts operation.

-l, -m, and -s options correspond to each of the database model sizes of ajsembdbbuild command (-l for large-scale, -m for medium-scale, and -s for small-scale). Specify the option that matches the size of the database model specified in ajsembdbbuild command.

In the -n option, specify the total number of segments in the database area (AJS2DATA) when the total number of segments in the database area is different from the values for the large, medium, and small database models.

For the value of -n option, specify a value for 100 to the number of secured segments. The value must be an integer. If you specify a value outside the range, or a value other than an integer, specify a correct value, and then re-execute the script.

To change the reusage point for the AJS1JINF table, specify the -b option together with the -l, -m, -s, or -n option. When you specify the -b option, specify the total number of database area (AJS2DATA2) segments for the -n option.

To check the total number of database area (AJS2DATA, AJS2DATA2) segments, execute the ajsembdbstatus command with the -db option specified.

The following table lists the point at which the free space reusage facility is applied to the database area for each table.

Table B‒2: Point at which the free space reusage facility is applied
Table name	Point at which the free space reusage facility is applied
`AJS1UNIT`	6% of the total segments in the database area `AJS2DATA` (`18` when the `-s` option is specified, `183` when the `-m` option is specified, and `957` when the `-l` option is specified.)
`AJS1ARROW`
`AJS1BODY`
`AJS1SCH`
`AJS1CAL`
`AJS1PERF`
`AJS1ENTRY`
`AJS1GEN`
`AJS1STAT`	16% of the total segments in the database area `AJS2DATA` (`48` when the `-s` option is specified, `489` when the `-m` option is specified, and `2553` when the `-l` option is specified.)
`AJS1RELS`	6% of the total segments in the database area `AJS2DATA` (`18` when the `-s` option is specified, `183` when the `-m` option is specified, and `957` when the `-l` option is specified.)
`AJS1ID`
`AJSAGTEXECCNT`	1% of the total segments in the database area `AJS2DATA` (`3` when the `-s` option is specified, `30` when the `-m` option is specified, and `159` when the `-l` option is specified.)
`AJSEXECAGT`
`AJSEXECAGTGRP`
`AJSLINKAGT`
`AJS1JINF`	70% of the segments of the entire `AJS2DATA2` database area (Specify 70 when `-s`, `-m`, or `-l` is specified.)

Note

The above table names are used when the table prefix is set to the default, AJS1.
In the -n option of the ajsembdbreuse command, if the free space reusage start point has changed, specify the value without using a decimal point.
The AJS1JINF table and database area AJS2DATA2 exist only when the backup enhancement function is enabled.

The following table lists the total number of segments in the data area that are created in the large, medium, and small database models of ajsembdbbuild command.

Table B‒3: Total number of segments in the data area created in the large, medium, and small database models of ajsembdbbuild command
Database area name	Small scale	Medium scale	Large scale
Database area `AJS2DATA`	300	3,060	15,960
Database area `AJS2DATA2`	100	100	100

-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 specified 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.

-tp table-prefix

Specify the prefix of the names of the tables in the JP1/AJS3 scheduler database with four or fewer bytes. If you omit this option, AJS1 is assumed.

For the table prefix to be specified, see the value of the TABLENAMEPREFIX environment setting parameter for the scheduler service for which you want to use the free space reusage facility.

-a embedded-database-administrator-authorization-identifier

Specify the owner of the tables in the JP1/AJS3 scheduler database.

Use eight or fewer single-byte alphanumeric characters (the first character must be an alphabetic character). If you omit this option, root is assumed.

-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). If you omit this option, root is assumed.

-D

Disables the free space reusage facility. If you specify this option while the free space reusage facility is disabled, no error occurs.

To disable the AJS1JINF table reusage facility, specify the -b option together with this option.

-i embedded-database-practical-directory-name

Specify the embedded database practical directory by using the full path. 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/HiRDB_J/

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

-b

Specify this option to change the reusage point for the AJS1JINF table.

Do not specify this option when you execute the command for an embedded database for which the backup enhancement function is disabled. You can check the setting of the backup enhancement function by using the ajsembdbstatus command. For details about the ajsembdbstatus command, see ajsembdbstatus in 3. Commands Used for Normal Operations.

Notes

Before you execute this command, on the JP1/AJS3 - Manager host, stop all JP1/AJS3 services, including the services on the logical host. If you execute this command while JP1/AJS3 is accessing the embedded database, an error occurs.
You must execute this script while the embedded database is running. If you execute it while the embedded database is not running, an error occurs.
When you execute the ajsembdbreuse 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 ajsembdbreuse command is executed. When you re-execute the command, and the embedded database server ends normally, delete these files.
Do not execute this command more than once in quick succession. If you do so, the 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 ajsembdbreuse command, take the action indicated in the following table.

Table B‒4: Actions to be taken if an error occurs when ajsembdbreuse 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 then 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 re-execute the script.
KFPA11104-E	Characters other than alphanumeric characters are specified for the argument of `-a` or `-ap` option.	Use alphanumeric characters for the argument of `-a` or `-ap` option, and then re-execute the script.
KFPA11204-E	No table exists.	Check the values specified for `-a` and `-ap` options, and then specify the authorization identifier of the table owner. Alternatively, check the value of `-tp` option and then specify a correct table prefix. Do not specify the `-b` option if the backup enhancement function is disabled. Then re-execute the script.
KFPA11561-E	The specified authorization identifier is not valid.	Change the values of the `-a` and `-ap` options to values for a user with DBA permission, and then re-execute the script.
KFPA11563-E KFPA11732-E	A lock wait timeout error occurred because another user was accessing the embedded database.	Stop all access from JP1/AJS3 to the embedded database 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 embedded database practical directory in `-i` option. If the correct embedded database practical directory is specified, set up the embedded database again.
-D cannot be specified with these options.	An illegal combination of the `-D` option and the `-l`, `-m`, `-s`, or `-n` option is specified.	Correct the specified option and then re-execute the script.
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.
KFPA11560-E	The authorization identifier password specified for `-ap` option is incorrect.	Specify the password for the authorization identifier specified for `-a` option, and then re-execute the script.
KFPA11724-E	The embedded database cannot be connected, because the value specified for `-p` or `-mh` option is incorrect.	Correct the value specified for `-p` or `-mh` option, and then re-execute the script.
KFPA11105-E KFPA11705-E ERROR Invalid value specified in -n option.	An invalid value is specified for `-n` option.	Specify a value from 10 to the number of secured segments. The specified value must be an integer.

To Page Top