2.6.5 Database settings that are set up in JP1/AJS3

An embedded database environment is configured when you set it up during a new installation of JP1/AJS3 - Manager or when you execute a setup command after installation.

The following table provides an overview of embedded databases that are created during the extended setup process.

Table 2‒50: Overview of embedded databases that are created during the extended setup process
Settings	When a new installation is performed	When the jajs_setup command is executed	When the jajs_setup_cluster command is executed	When the jajs_migrate command is executed
Database model	Small-scale^#1	Small-scale^#1	Small-scale^#1	Small-scale^#1
Embedded database practical directory	Windows: `JP1/AJS3-installation-folder\embdb\_JF0` UNIX: `/opt/jp1ajs2/embdb/_JF0`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier` UNIX: `/opt/jp1ajs2/embdb/setup-identifier`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier` UNIX: `/opt/jp1ajs2/embdb/setup-identifier`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier` UNIX: `/opt/jp1ajs2/embdb/setup-identifier`
Data area storage directory	Windows: `JP1/AJS3-installation-folder\embdb\_JF0\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/_JF0/dbarea`	Physical host environment Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea` Logical host environment Windows: `folder-specified-in-the-D-option\jp1ajs2\embdb\setup-identifier\dbarea` UNIX: `directory-specified-in-the-D-option/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `folder-specified-in-the-d-option\jp1ajs2\embdb\setup-identifier\dbarea` UNIX: `directory-specified-in-the-d-option/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea`
System file area storage directory	Windows: `JP1/AJS3-installation-folder\embdb\_JF0\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/_JF0/dbarea`	Physical host environment Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea` Logical host environment Windows: `folder-specified-in-the-D-option\jp1ajs2\embdb\setup-identifier\dbarea` UNIX: `directory-specified-in-the-D-option/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `foder-specified-in-the-d-option\jp1ajs2\embdb\setup-identifier\dbarea` UNIX: `directory-specified-in-the-d-option/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea`
Work area directory	Windows: `JP1/AJS3-installation-folder\embdb\_JF0\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/_JF0/dbarea`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: Physical host environment `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea` Logical host environment `/opt/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/opt/jp1ajs2/embdb/setup-identifier/dbarea`	Windows: `JP1/AJS3-installation-folder\embdb\setup-identifier\dbarea` UNIX: `/var/opt/jp1ajs2/embdb/setup-identifier/dbarea`
Setup identifier	`_JF0`	`_JF0`-`_JFZ`^{#2, #3}	The value of the `-I` option	`_JF0`-`_JFZ`^#2
Port number	22220	22220-22239^{#2, #4}	The value of the `-P` option	22220-22239^#2
Database area auto-increment	Enabled^#7	Enabled^#7	Enabled^#7	Enabled
System log auto-increment	Enabled^#7	Enabled^#7	Enabled^#7	Enabled
Automatic log unload functionality	Disabled	Disabled	Disabled	Disabled
Duplication of system logs	Disabled	Disabled	Disabled	Disabled
Reuse start points for the reuse free space functionality	Small-scale^#1	Small-scale^#1	Small-scale^#1	Small-scale^#1
Backup enhancement function^#5	Disabled	Disabled^#6	Disabled^#6	Disabled

#1

For a new installation, the database is configured by using the database model specified during installation.

When the -M option of the jajs_setup and jajs_setup_cluster commands or the -s option of the jajs_migrate command is specified, the database is configured with the database model specified by the option.

#2

A value in this range is automatically assigned.

#3

When you add a scheduler service and specify the setup identifier of a configured embedded database in the -I option, a scheduler service database is created in the embedded database configured with the specified setup identifier. If a setup identifier that has not been configured is specified in the -I option, a new embedded database is configured and the scheduler service database is created.

#4

If you specify the -P option, the value specified in the -P option will be set.

#5

To use the backup enhancement function, you must specify this function when you set up the embedded database. For details about the backup enhancement function, see 5.2.5 Backing up and recovering an embedded database by using the backup enhancement function.

#6

The database is configured as specified by the -B option.

#7

If a large-scale database model is specified, it will become disabled.

If you configure an embedded database environment during a new installation, you can only specify the database model. For details about how to do this, see 2.2.3(1) New installation in the JP1/Automatic Job Management System 3 Configuration Guide.

If you skip configuring an embedded database environment during a new installation or if you specify the -S option in the jajs_migrate, jajs_setup, or jajs_setup_cluster command, an embedded database environment is not configured. In this case, see the description of the setup in 23.4 Advanced setup of an embedded database in the JP1/Automatic Job Management System 3 Configuration Guide or 23.5 Advanced setup for the embedded database (in a cluster configuration) in the JP1/Automatic Job Management System 3 Configuration Guide, and then configure an embedded database environment.

If you want to configure an embedded database by using different settings from those in Table 2-50, perform setup as described in the following sections, and then configure an embedded database environment: 23.4 Advanced setup of an embedded database in the JP1/Automatic Job Management System 3 Configuration Guide or 23.5 Advanced setup for the embedded database (in a cluster configuration) in the JP1/Automatic Job Management System 3 Configuration Guide.

If you want to change the settings of an embedded database that has been configured, you need to set up the embedded database environment again. For details, see 23.4.1(6) Setting up an embedded database again in the JP1/Automatic Job Management System 3 Configuration Guide.

To Page Top