Backing up the database in an Embedded RDB environment

There are two ways to back up the Asset Information Manager Subset database in an Embedded RDB environment. One is by using Database Manager of Asset Information Manager Subset, and the other is by using jamemb_backup.bat.

We recommend that you periodically back up the database so that the database can be recovered in the event of a database failure.

Notes

Before you back up the Asset Information Manager Subset database, stop the services in the following order:

World Wide Web Publishing Service or World Wide Web Publishing
Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from which they were stopped.

If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before backing up the database.

The following describes how to back up the Asset Information Manager Subset database in an Embedded RDB environment.

Organization of this subsection: (1) How to back up the database in an Embedded RDB environment; (2) Using the command to back up the database in an Embedded RDB environment

(1) How to back up the database in an Embedded RDB environment

To back up the Asset Information Manager Subset database in an Embedded RDB environment:

In the Database Manager dialog box, choose Back up Embedded RDB and the click the Next button.
The Back up Embedded RDB dialog box appears.
In this dialog box, specify information, such as the backup file name and comment, for the Asset Information Manager Subset database.

Figure 10-19 Back up Embedded RDB dialog box

Backup file name

Specifies the absolute path name of the backup files of the Asset Information Manager Subset database.

The default is JP1/Software-Distribution-Manager-installation-folder\jp1asset\db\backup.dat. To change the default file path, click the ... button and then specify a desired file path.

To directly specify the file path, express it as 1 to 255 bytes of alphanumeric characters and space. The following symbols are not permitted:

" | * < > ? & ^ /

Comment

Specifies a comment as backup log information.

This item is optional. There is no default setting. The permitted value is 1 to 64 bytes of characters.

Logs

Displays a maximum of 10 entries of backup log information in chronological order.

Selecting an item in the log list applies the information to Backup file name and Comment.
Set the items and then click the Execute button.
The Asset Information Manager Subset database is backed up and the backup files are created.

Note: To restore the backup files created here, the environment must be the same as when the Asset Information Manager Subset database was created (such as the port number and database storage).; If you want to change the environment used to create the Asset Information Manager Subset database and restore the backup files, use Back up the database to CSV files to make a backup. For details about how to back up data using Back up the database to CSV files, see 10.3.3 Backing up the database as CSV files.

(2) Using the command to back up the database in an Embedded RDB environment

This subsection describes the function, format, options, return values, and command execution notes of jamemb_backup.bat, which makes a backup of the Asset Information Manager Subset database in an Embedded RDB environment. Note that jamemb_backup.bat is applicable only to Embedded RDB.

jamemb_backup.bat is stored in the following folder:

Asset-Information-Manager-Subset-installation-folder\exe

(a) Function

jamemb_backup.bat backs up the Asset Information Manager Subset database.

(b) Format

jamemb_backup.bat -b backup-file-path -o result-file-path [-y]

(c) Options

-b backup-file-path: Specifies the full path of the file to which the backup is to be made. Specification of this option is mandatory.

-o result-file-path: Specifies the full path of the file to which the execution results are to be output. Specification of this option is mandatory.

-y: Specifies that backup processing is to start without waiting for a response from the keyboard.; When this option is omitted, command execution waits for entry of a response from the keyboard. You can cancel execution by pressing the Ctrl + C keys.

(d) Return value

Returns one of the following return values:

Return value	Description
0	Normal termination. You can check the results files for the backup details.
11	Invalid option specification.
101 or greater	Terminated with another error.

(e) Notes about command execution

Execute jamemb_backup.bat as a user with administrator permissions.

(f) Execution example

jamemb_backup.bat -b C:\temp\backup\Backup.dat -o C:\temp\backup\kekka.log -y

All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.

10.3.5 Backing up the database in an Embedded RDB environment