You use Database Manager, one of the components of JP1/Software Distribution, to create or maintain a relational database to be used by JP1/Software Distribution. To start Database Manager, from the menu, choose Software Distribution Manager, and then Database Manager.
You should note the following about using Database Manager:
- First, you must exit all applications that use JP1/Software Distribution's relational database.
- Before starting Database Manager, stop Remote Install Server by opening Control Panel, choosing Administrative Tools, and then Services.
- Only users who have Administrator permissions can use Database Manager.
When Database Manager starts, the Welcome dialog box is displayed, enabling you to select a Database Manager operation.
Figure 7-3 Welcome dialog box
![[Figure]](FIGURE/EMB0290.GIF)
- If you are using Microsoft SQL Server or Oracle, different items are displayed in the Welcome dialog box. For details about how to use Database Manager when Microsoft SQL Server or Oracle is used, see 7.5 How to use Database Manager (for Microsoft SQL Server or Oracle).
Select the operation you want to perform with Database Manager.
- Create new database
- Creates a new relational database. After installing JP1/Software Distribution Manager, you must select this item to create a new database.
- Transfer administration file from the file system
- Migrates the basic database of JP1/Software Distribution JP1 Version 7i or earlier to a relational database (Embedded RDB). To select this option, a relational database must have been created previously.
- Upgrade database
- Upgrades the relational database. Select this option if you have upgraded your JP1/Software Distribution or migrated JP1/Software Distribution Manager Embedded RDB Edition JP1 Version 7i to JP1/Software Distribution Manager JP1 Version 8.
- Select this option also when you wish to change the size of an existing database area.
- Take backup of the database
- Backs up a database. Select this item when you perform periodic database backup.
- Recover the database from backup
- Restores a database from its backup file. Select this item to restore the backup that is obtained using the Take backup of the database menu.
- Reorganize the database
- When a database's usage factor exceeds 80%, you should reorganize the database. You can determine whether or not the database usage factor has exceeded 80% by checking the messages in the event log. For details about the messages that are displayed, see 7.4.6 Reorganizing the database.
- Change database password
- Changes the password needed in order to log on to the database.
- Delete unnecessary inventory information from the database
- Deletes unneeded inventory information from the database in order to increase available database space.
Selecting a desired operation and then clicking the Next button displays the Authentication Information of Database dialog box.
Figure 7-4 Authentication Information of Database dialog box
![[Figure]](FIGURE/EMB0295.GIF)
Enter the password for logging into the database. User authentication is required in order to manipulate a database from Database Manager.
The following subsections describe each operation after user authentication.
- Organization of this section
- 7.4.1 Creating a new database
- 7.4.2 Transferring data to a relational database
- 7.4.3 Upgrading the database
- 7.4.4 Backing up the database
- 7.4.5 Recovering the database from a backup
- 7.4.6 Reorganizing the database
- 7.4.7 Changing the database password
- 7.4.8 Deleting unneeded inventory information from the database
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.