Job Management Partner 1/Automatic Job Management System 3 Command Reference 2

ajsembdbsetup

Format

 
ajsembdbsetup
     [-mh logical-host-name]
     [-F service-name]
     [-p port-number]
     [-m [-s send-buffer-size] [-r receive-buffer-size]]
     [-ct maximum-wait-time]
     [-tp table-name-prefix]
     [-c]
     [-ru { l | m | s }]
     [-id setup-identifier]
     [-convert]
     [-del]

Description

The ajsembdbsetup command sets up an embedded database environment in which the database for the scheduler service and agent management can operate.

You can execute this command only when the embedded database is operating.

Execution privileges

In Windows: Administrators privileges

In UNIX: Superuser privileges

Storage directory

In Windows:

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

In UNIX:

/opt/jp1ajs2/tools/

Arguments

-mh logical-host-name

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

If environment variable JP1_HOSTNAME is set when this option is omitted, the system assumes the logical host name specified in the environment variable. If JP1_HOSTNAME is not specified, the system assumes the physical host.

-F service-name

Specify the name of the scheduler service to be processed.

If environment variable AJSCONF is set when this option is omitted, the system assumes the service name specified in the environment variable. If AJSCONF is not specified, the system assumes the default scheduler service.

-p port-number

Specify a decimal number as the port number used for connection to the embedded database. Make sure that the port number you specify in this option is the port number specified in the -p option when the ajsembdbbuild command was executed.

If you omit this option, the system assumes 22220.

This communication port is set in the RDBPORT parameter for the configuration definition.

You can specify a value from 5,001 to 65,535.

-m [-s send-buffer-size] [-r receive-buffer-size]

Specify the sizes of send and receive buffers that are used for the inter-process memory communication function of the embedded database.

The function specified here is set in the RDBIPC, RDBSENDMEMSIZE, and RDBRECVMEMSIZE parameters of the configuration definition.

-s
Specifies the send buffer size with a decimal number (unit: kilobytes).

-r
Specifies the receive buffer size with a decimal number (unit: kilobytes).

For the -s and -r options, you can specify a value from 4 to 2,097,152.

If you omit the -s or -r option, the system assumes the standard embedded database values for operations.

The optimal values for JP1/AJS3 are: send buffers size =100 and receive buffer size = 1600.

If you omit the -m option, the system uses the inter-process memory communication function, and assumes send buffer size = 100 and receive buffer size = 1600 regardless of the -s and -r options that you specify.

-ct maximum-wait-time

This option takes effect if the RDB connection wait function is used. Specify a value from 0 to 60 (in minutes) as the maximum wait time for connection to the RDB.

If you omit this option, the system assumes 1.

Specifying a value of 0 disables the RDB connection wait function.

If you specify a value outside the 0-60 range in this option, the invalid value is set in the configuration definition. As a result, the following error message might be output when JP1/AJS3 starts: KAVS1003-E Invalid specification in configuration definition. (item-name). In addition, the KAVA0334-E error message might be output while the ajsembdbsetup command is being executed.

-tp table-name-prefix

Specify the table name prefix of the JP1/AJS3 scheduler database. Use up to 4 bytes.

If you omit this option, the system assumes AJS1.

In the configuration definition, the TABLENAMEPREFIX parameter settings are modified.

-c

Specify this option if you want to reset the scheduler services after a table creation error occurs, despite schema creation ending successfully.

-ru { l | m | s }

Specify this option to use the free area re-use function. When you specify -ru together with l, m, or s, you can specify the re-use start point.

When you omit this option, the system assumes -ru l.

Specify the re-use start point of the free area re-use function after -ru option. Free area is re-used when the usage rate of the database (table) area reaches the re-use start point specified in this option.

l, m, and s correspond to the large database model, medium database model, and small database model of ajsembdbbuild command, respectively. Specify the option that matches the size of the database model specified in ajsembdbbuild command.

The re-use start point of the free area re-use function for the database area is set as follows, for each table.

Table 2-1 Re-use start point of the free area re-use function for the database area set for each table

Table name Re-use start point of the free area re-use function for each table

AJSUNIT 6% of the segments of the entire AJS2DATA database area

AJSARROW

AJSBODY

AJSSCH

AJSCAL

AJSPERF

AJSENTRY

AJSGEN

AJSSTAT 16% of the segments of the entire AJS2DATA database area

AJSRELS 6% of the segments of the entire AJS2DATA database area

AJSID

AJSAGTEXECCNT 1% of the segments of the entire AJS2DATA database area

AJSEXECAGT

AJSEXECAGTGRP

AJSLINKAGT

Note

The above table names are used when the standard table prefix (AJS) is used.

The total number of area segments in the large, medium, and small database models of ajsembdbbuild command are as follows.

Table 2-2 Total number of area segments created in the large, medium, and small database models of ajsembdbbuild

Database area name Small Medium Large

Data area AJS2DATA 300 3,060 15,960

-id setup-identifier

Use four characters, _JFn (n is from 0 to 9 or from A to Z), to specify the setup identifier for identifying the embedded database. Specify the value specified in the -id option of the ajsembdbbuild command.

If you omit this option, the system assumes _JF0.

-convert

Specify this option if you want to perform advanced setup after JP1/AJS2 - Manager has been upgraded to JP1/AJS3 - Manager.

-del

This option is specified to restore processing if an error occurs during advance setup performed by specifying the -convert option.

Before you execute the command with the -del option, make sure that the option settings that were specified when the error occurred are also specified. If you specify different option settings, restoration processing might not be performed normally.

Table name	Re-use start point of the free area re-use function for each table
AJSUNIT	6% of the segments of the entire AJS2DATA database area
AJSARROW
AJSBODY
AJSSCH
AJSCAL
AJSPERF
AJSENTRY
AJSGEN
AJSSTAT	16% of the segments of the entire AJS2DATA database area
AJSRELS	6% of the segments of the entire AJS2DATA database area
AJSID
AJSAGTEXECCNT	1% of the segments of the entire AJS2DATA database area
AJSEXECAGT
AJSEXECAGTGRP
AJSLINKAGT

Database area name	Small	Medium	Large
Data area AJS2DATA	300	3,060	15,960

Notes

Before executing ajsembdbsetup command, stop all the JP1/AJS3 and JP1/AJS3 Console Agent services, including the logical host in the JP1/AJS3 - Manager host. Note that ajsembdbsetup command may terminate normally even if these services are not stopped. Also, make sure that the logical host name specified for the -mh option can be resolved into an IP address.

The ajsembdbsetup command is incorporated in a script. For this reason, specifying a long character string or an invalid character string or value may result in an unexpected error. In the options, specify the character strings and numeric values defined in the DBMS and JP1/AJS3.

Even if an error that occurred is in a configuration definition not necessary for scheduler database setup, the following error message is output: KAVS1003-E Invalid specification in configuration definition. (item-name). Setup is complete upon the normal termination of ajsembdbsetup command. You do not have to perform setup again even if this message is output repeatedly. After terminating ajsembdbsetup command, correct any configuration definition errors as prompted by the error message KAVS1003-E.

If an error occurs in embedded database access when the ajsembdbsetup command is executed, embedded database connection error information is output to pderr1.trc and pderr2.trc files in the work directory for the ajsembdbsetup command. If you re-execute the command and the command terminates normally, delete these files.

Do not execute ajsembdbsetup command repeatedly in quick succession. If you do so, the following problems might occur:

The scheduler database becomes invalid and can no longer be used.

The ajsembdbsetup command results in an error.

The configuration definition information becomes invalid, disabling further operation of JP1/AJS3.

Actions to be taken if an error occurs

An error may occur during ajsembdbsetup command execution. If an error occurs, correct the cause of the error according to the table below, and then re-execute this script.

Message ID Cause Action taken

Invalid value specified in -ct option. An invalid argument is specified in the argument of the -ct option. Specify an integer, ranging from 0 to 60, in the argument of the -ct option.

KAVS0178-E The table is already created. Make sure that the value of the -tp option is different from a table name prefix that has already been registered. Alternatively, delete the existing tables by executing the command with the same option settings, in addition to the -del option, specified, and then re-execute the command.

KAVS0190-E The specified scheduler service is not defined in the host. Specify an existing scheduler service name in the -F option.

KAVS0985-E The embedded database server cannot be connected to the database. Possible causes for this error are as follows:
The embedded database is not started.
The port number specified in the -p option does not match the port number of the embedded database.
Correct these causes and then re-execute this command.

KAVS0996-E The specified option and value are invalid. Correct the specified option and value.

KAVS1003-E The configuration definition includes an invalid specification. Correct the value specified in the option and then re-execute this command.

KFPA11723-E The embedded database is stopped. Start the embedded database.

KFPA11204-E There is no table. Review the value of the -tp option, and specify a correct table prefix. Then, re-execute the command.

KFPA11563-E
KFPA11732-E Because another user is accessing the embedded database, a lock wait timeout occurred. Stop all accesses to the embedded database, and then re-execute the command.

The embedded DB work directory associated with the setup identifier specified by the -id option is invalid. The embedded database practical directory associated with the setup identifier specified in the -id option is invalid. Specify a correct value for the embedded database practical directory set in the configuration definition and re-execute the script.
To check the registered setup identifiers and embedded database practical directories, execute the ajsembdbidlist command.
For details on the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup.

The setup identifier specified with the -id option is not registered. The setup identifier specified in the -id option is not registered. Specify a setup identifier that is already registered and re-execute the script. To check the registered setup identifiers and embedded database practical directories, execute the ajsembdbidlist command.
For details on the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup.

Failed to register the configuration definition. Registering the configuration definition failed. If advanced setup has been performed, specify also the -del option to delete the existing tables, and then re-execute the command.

For details on the messages beginning with KAVS, see 2.2 Messages beginning with KAVS (Messages about the scheduler) in the manual Job Management Partner 1/Automatic Job Management System 3 Messages 1.

Message ID	Cause	Action taken
Invalid value specified in -ct option.	An invalid argument is specified in the argument of the -ct option.	Specify an integer, ranging from 0 to 60, in the argument of the -ct option.
KAVS0178-E	The table is already created.	Make sure that the value of the -tp option is different from a table name prefix that has already been registered. Alternatively, delete the existing tables by executing the command with the same option settings, in addition to the -del option, specified, and then re-execute the command.
KAVS0190-E	The specified scheduler service is not defined in the host.	Specify an existing scheduler service name in the -F option.
KAVS0985-E	The embedded database server cannot be connected to the database.	Possible causes for this error are as follows: The embedded database is not started. The port number specified in the -p option does not match the port number of the embedded database. Correct these causes and then re-execute this command.
KAVS0996-E	The specified option and value are invalid.	Correct the specified option and value.
KAVS1003-E	The configuration definition includes an invalid specification.	Correct the value specified in the option and then re-execute this command.
KFPA11723-E	The embedded database is stopped.	Start the embedded database.
KFPA11204-E	There is no table.	Review the value of the -tp option, and specify a correct table prefix. Then, re-execute the command.
KFPA11563-E KFPA11732-E	Because another user is accessing the embedded database, a lock wait timeout occurred.	Stop all accesses to the embedded database, and then re-execute the command.
The embedded DB work directory associated with the setup identifier specified by the -id option is invalid.	The embedded database practical directory associated with the setup identifier specified in the -id option is invalid.	Specify a correct value for the embedded database practical directory set in the configuration definition and re-execute the script. To check the registered setup identifiers and embedded database practical directories, execute the ajsembdbidlist command. For details on the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup.
The setup identifier specified with the -id option is not registered.	The setup identifier specified in the -id option is not registered.	Specify a setup identifier that is already registered and re-execute the script. To check the registered setup identifiers and embedded database practical directories, execute the ajsembdbidlist command. For details on the ajsembdbidlist command, see ajsembdbidlist in 2. Commands Used during Setup.
Failed to register the configuration definition.	Registering the configuration definition failed.	If advanced setup has been performed, specify also the -del option to delete the existing tables, and then re-execute the command.

Return values

0 Normal end

Values other than 0 Abnormal end

[Contents][Back][Next]

[Trademarks]