3.6.1 Details of database files

(1) Database file storage location

In Windows, if the destination folder is under the default or system-protected folder:

%ALLUSERSPROFILE%\Hitachi\JP1\JP1_DEFAULT\JP1AJS3CSA\database\AJSCSA.db

The default value of %ALLUSERSPROFILE% is system-drive\ProgramData.

Folders protected by the system use the path to one of the following folders:

• Folder in system-drive\Windows

• Folder in system-drive\Program Files

• Folder in system-drive\Program Files (x86)

In Windows, if the destination folder is other than the above:

JP1/AJS3-for-CSA-installation-folder\database\AJSCSA.db

When using cluster operation on Windows:

shared-folder\jp1ajs3csa\database\AJSCSA.db

In Linux:

/var/opt/jp1ajs3csa/database/AJSCSA.db

When using cluster operation on Linux:

shared-directory/jp1ajs3csa/database/AJSCSA.db

To Page Top

(2) Tables in the database

Item number	Table name	Table contents
1	AJSCSADEFINITION	Definition table
2	AJSCSAEXECUTEHISTORY	Execution history table

To Page Top

(3) Database file permissions

In Windows:

"Full Control" in "Administrators"

(Inheritance is disabled, no other users and groups are allowed.)

In Linux:

Permissions: 600 (-rw-------)

Owner: root

Group: root

To Page Top

(4) Temporary file storage location

In Windows, if the installation folder is under the default or system-protected folder:

%ALLUSERSPROFILE%\Hitachi\JP1\JP1_DEFAULT\JP1AJS3CSA\tmp

The default value of %ALLUSERSPROFILE% is system-drive\ProgramData.

Folders protected by the system use the path to one of the following folders:

• Folder in system-drive\Windows

• Folder in system-drive\Program Files

• Folder in system-drive\Program Files (x86)

In Windows, if the installation folder is other than the above:

JP1/AJS3-for-CSA-installation-folder\tmp

In Linux:

/var/opt/jp1ajs3csa/tmp

To Page Top

(5) Maintaining database files

The database files used at JP1/AJS3 for Cloud Service Applications are automatically maintained each time they are registered, edited, or deleted on the Web screen of JP1/AJS3 for Cloud Service Applications.

Database files are maintained in the following order.

1. Maintain execution history tables.

   The execution history tables are maintained (records that have exceeded their retention period are deleted) when database files are automatically backed up.

2. Release invalid space in the entire database files.

3. Back up the entire database files.

While the database files are maintained, the following message log is output to the application server log.

If maintenance is successful

• KNBB3801-I

• KNBB3803-I

• KNBB3805-I

If an error occurs during maintenance

• KNBB3802-W

• KNBB3804-W

• KNBB3806-W

  Note

  Even if maintenance fails, the Web screen does not indicate it. The failure record is kept only in the application server log.

  If an error occurs while the execution history tables are maintained or invalid space in the entire database files is released, no further maintenance is conducted.

To Page Top

(6) Backing up database files automatically

The database files used by JP1/AJS3 for Cloud Service Applications are backed up automatically. The storage location for database file backups is shown below.

In Windows, if the installation folder is under the default or system-protected folder:

%ALLUSERSPROFILE%\Hitachi\JP1\JP1_DEFAULT\JP1AJS3CSA\database\AJSCSA.db.back

The default value of %ALLUSERSPROFILE% is system-drive\ProgramData.

Folders protected by the system use the path to one of the following folders:

• Folder in system-drive\Windows

• Folder in system-drive\Program Files

• Folder in system-drive\Program Files (x86)

In Windows, if the installation folder is other than the above:

JP1/AJS3-for-CSA-installation-folder\database\AJSCSA.db.back

When using cluster operation on Windows:

shared-folder\jp1ajs3csa\database\AJSCSA.db.back

In Linux:

/var/opt/jp1ajs3csa/database/AJSCSA.db.back

When using cluster operation on Linux:

shared-directory/jp1ajs3csa/database/AJSCSA.db.back

To Page Top