Job Management Partner 1/Software Distribution Setup Guide

[Contents][Glossary][Index][Back][Next]

7.4.4 Backing up the database

Back up the database that is used by JP1/Software Distribution Manager. The two ways to back up the database are by using Database Manager and by using netmdb_backup.bat command.

The netmdb_unload.bat command is used to back up a database when the database is migrated to a different environment, such as when the PC is replaced. For details about the netmdb_unload.bat command, see 5.3.9(2) netmdb_unload.bat command in the manual Administrator's Guide Volume 2.

If you use the Operation Log List window, it may take time to back up the database depending on the size of the managed operation log information.

To restore from a backup created by Database Manager or by the netmdb_backup.bat command, use Database Manager's Recover the database from backup option.

The following describes how to back up the database.

Organization of this subsection
(1) Backing up the database using Database Manager
(2) Database backup using a command

(1) Backing up the database using Database Manager

Notes
  • Before you back up the database, stop Remote Install Server service by opening Control Panel, and then choosing Administrative Tools, and Services.
  • If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
    1. World Wide Web Publishing Service or World Wide Web Publishing
    2. Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
    3. 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 that listed above.
  • 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.

This subsection describes how to use Database Manager to back up a database.

To back up a database:

  1. In the Welcome dialog box, select Take backup of the database and then click the Next button.
    The Authentication Information of Database dialog box appears.
  2. In the Authentication Information of Database dialog box, specify the password and then click the Next button.
    The Database Backup dialog box appears.

    Figure 7-17 Database Backup dialog box

    [Figure]

    Take a backup of package file
    Specifies whether or not the package files are also to be backed up when the database is backed up. The default is that this check box is not selected.
    Take a backup of software operation log
    Specifies whether or not the operation history storage directory is also to be backed up during the database backup. The default is that this check box is not selected.
    Storage destination directory of backup file
    Specifies the directory for storing the backup files that are created when the database is backed up.
  3. Specify necessary information in the Database Backup dialog box and then click the Next button.
    The Execute Database Backup dialog box appears.

    Figure 7-18 Execute Database Backup dialog box

    [Figure]

  4. Click the Execute button.
    Database backup processing is executed and the backup file is created.
    The backup file is created under the name netmdbbackup in the backup file storage target directory. You can change the name of the backup file.
    Any backup file named netmdbbackup that already exists in the backup storage target directory at the time that backup processing is performed will be overwritten.
    When backing up package files
    The RESOURCE folder is created under the backup file storage target directory to store the package files.
    Any folder named RESOURCE that already exists in the backup storage target directory at the time that backup processing is performed will be overwritten.
    When backing up software operation history
    The MONITORING folder is created under the backup file storage target directory to store software operation history.
    Any folder named MONITORING that already exists in the backup storage target directory at the time that backup processing is performed will be overwritten.

(2) Database backup using a command

This subsection describes the netmdb_backup.bat command that can be used to back up a database. This command is stored in the JP1/Software Distribution Manager installation directory \bin.

Before you back up the database, stop Remote Install Server service by opening Control Panel, and then choosing Administrative Tools, and Services.

Also, if you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.

  1. World Wide Web Publishing Service or World Wide Web Publishing
  2. Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
  3. 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 that listed above.

Note that 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.

Function
This command backs up a database. It can also back up package files and software operation history.

Format
netmdb_backup.bat [/P]
                  [/h]
                   /i JP1/Software-Distribution-Manager-installation-directory
                   /b backup-file-storage-target-directory
                   /o execution-result-output-file-name

Options
  • /P
    Specifies that package files are to be backed up.
  • /h
    Specifies that software operation history is to be backed up.
  • /i
    Specifies the full path of the JP1/Software Distribution Manager installation directory.
  • /b
    Specifies the full path of the backup file storage target directory. We recommend that you specify the directory name as a string of no more than 150 bytes. If the specified path is too long, directory creation may fail. For the storage directory, specify the local drive. Specify the storage directory name as a string of alphanumeric characters, the space, and the following symbols:
    : . \ # @ ( )
  • /o
    Specifies the full path of the file to which the execution result is to be output.

Return code
The following table shows the return codes for the netmdb_backup.bat command:
Return code Description
0 Normal termination
-1 Abnormal termination

Notes
  • Do not change the contents of the BAT file for the netmdb_backup.bat command. If the contents are changed, the database can no longer be backed up.
  • To use the netmdb_backup.bat command to back up a database, the user who executes the command must have Administrator permissions.
  • When database backup is executed, the following file and folders are created in the storage directory:
    [Figure] netmdbbackup file
    [Figure] RESOURCE folder
    [Figure] MONITORING folder
    If any of these items already exist on the specified storage directory path at the time backup processing is performed, the existing file or folders will be overwritten.
  • You must specify the netmdb_backup.bat command's options in the order shown above in Format.
  • Do not execute multiple netmdb_backup.bat commands concurrently.

Example
This example backs up package files and software operation history when the database is backed up.
This example specifies each directory as follows:
  • JP1/Software Distribution Manager installation directory
    C:\Program Files\Hitachi\NETMDM
  • Backup storage directory
    C:\NETMDB
  • Execution result output file name
    C:\NETMDB\backup.txt
Before executing the command, you must create the backup file storage directory and the directory for storing the execution result output file.
The following shows an example of command execution:
netmdb_backup.bat /P /h /i "C:\Program Files\Hitachi\NETMDM" /b C:\NETMDB /o C:\NETMDB\backup.txt