Backing up the database as CSV files

There are two ways to back up the Asset Information Manager Subset database as CSV files. One is by using Database Manager of Asset Information Manager Subset, and the other is by using jamdbexport.bat.

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

A backup can be used not only for error recovery but also for the following purposes:

When you upgrade the OS or replace your PC, you can migrate the database by restoring the backup file using Database Manager of Asset Information Manager Subset.
In the case of an Embedded RDB, to expand the database capacity, use Database Manager of Asset Information Manager Subset to re-create the database and then restore the backup file.

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 as CSV files.

Organization of this subsection: (1) How to back up the database as CSV files; (2) Using the command to back up the database as CSV files

(1) How to back up the database as CSV files

To back up the Asset Information Manager Subset database as CSV files:

In the Database Manager dialog box, choose Back up the database to CSV files and then click the Next button.
The Back Up the Database to CSV Files dialog box appears.
In this dialog box, specify information, such as the folder name for storing backup files and a comment, when the Asset Information Manager Subset database is backed up.

Figure 10-17 Back Up the Database to CSV Files dialog box

Backup folder name

Specify the absolute path name of the folder that stores the backup files of the Asset Information Manager Subset database.

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

To directly specify a folder path, express it as 1 to 223 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. 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 folder name and Comment.
Set the items and then click the Execute button.
The Asset Information Manager Subset database is backed up and backup CSV files are created.

(2) Using the command to back up the database as CSV files

This subsection describes the function, format, options, and command execution notes of jamdbexport.bat, which executes from the command line at the Asset Information Manager Subset server the same backup as does the method using the Database Manager dialog box.

jamdbexport.bat is stored in the following folder:

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

(a) Function

jamdbexport.bat makes a backup of the Asset Information Manager Subset database and outputs all data to CSV files. When jamdbexport.bat is executed, the contents of the Asset Information Manager Subset database are stored in the backup folder.

(b) Format

jamdbexport.bat backup-folder-path [-rp]

(c) Options

backup-folder-path

Specifies the full path of the backup folder. Allocate sufficient free space to the drive that is specified for the backup folder. When you specify a path, note the following:

Do not include any spaces in a folder name.
Do not enclose the folder name in double-quotation marks (").
Do not specify an existing folder name.

If the path is omitted, Asset-Information-Manager-Subset-installation-folder\backup is set.

-rp: 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) Notes about command execution

If you specify the -rp option, the command prompt closes when processing terminates, making it impossible to determine whether or not an error occurred.
Do not change the name or contents of the CSV files acquired by jamdbexport.bat. If such a change is made, the Asset Information Manager Subset database can no longer be restored.