You must use Database Manager to upgrade the Asset Information Manager Subset database in the following case:

• Version of the Asset Information Manager Subset component is to be upgraded

For details about how to upgrade a database, see 10.3.2 Upgrading the database in the manual Setup Guide.

In an Embedded RDB, an area from which records have been deleted becomes unusable. As the size of the unusable area increases, the database area usage rate might become poor. You must reorganize the database to make the unusable area usable again.

For details about how to reorganize an Embedded RDB relational databases, see 10.3.7 Reorganizing the database in an Embedded RDB environment in the manual Setup Guide.

For details about reorganizing Microsoft SQL Server or Oracle relational databases, see the RDBMS documentation.

In order to change the size of an Embedded RDB, you must re-create the Asset Information Manager Subset database. This subsection describes how to change the size of an Asset Information Manager Subset database. This method enables you to inherit in the re-created database the database data before the size was changed. If you do not wish to inherit the existing data, perform only step 2, which will only change the size of the Asset Information Manager Subset database.

To change the size of an Asset Information Manager Subset database:

1. Make a backup of the Asset Information Manager Subset database as a CSV file.
   For details about how to make a backup of an Asset Information Manager Subset database as a CSV file, see 10.3.3 Backing up the database as CSV files in the manual Setup Guide.
   
2. Create an Asset Information Manager Subset database.
   Create an Asset Information Manager Subset database with the desired size specified. For details about how to create an Asset Information Manager Subset database, see 10.3.1 Creating a new database in the manual Setup Guide.
   
3. Restore the Asset Information Manager Subset database.
   Restore the CSV backup file made in step 1. For Backup folder name, specify the path of the backup file. For details about how to restore an Asset Information Manager Subset database, see 10.3.6 Restoring the database in an Embedded RDB environment in the manual Setup Guide.
   

Notes

• Before you rename the Embedded RDB host, terminate all Asset Information Manager Subset services, commands, and tasks on the Asset Information Manager Subset server.
• Stop the Asset Information Manager Subset services in the following order:
  
  1. World Wide Web Publishing Service or World Wide Web Publishing
  2. Asset Information Synchronous Service and Asset Information Manager Subset commands and tasks
  3. JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)
  When you use Asset Information Manager Subset after you have renamed the Embedded RDB host, start the services in the reverse order they were stopped.
  

To rename the Embedded RDB host when the Asset Information Manager Subset database being used is Embedded RDB (this method also applies when logical hosts are renamed in a cluster environment):

1. Terminate the Embedded RDB.
   For details about how to terminate the Embedded RDB, see (5) Starting and terminating an Embedded RDB.
   
2. Use a text editor to open the pdsys file that is stored in JP1/Software-Distribution-Manager-installation-folder\jp1asset\aimdb\conf
3. In the pdsys file, change host-name in pdunit -x host-name -u unt1 -d "JP1/Software-Distribution-Manager-installation-folder\jp1asset\aimdb".
   Make sure that every line (other than the last line) ends with a backslash (\) and that no line exceeds 80 bytes. The following shows an example specification:
   

   pdunit -x host-name -u unt1\
   -d "JP1/Software-Distribution-Manager-installation-folder\jp1asset\aimdb"

4. Use a text editor to open the following files that are stored in JP1/Software-Distribution-Manager-installation-folder\jp1asset\aimdb\conf\emb:
   
   • HiRDB.ini
   • reorganization_al.bat
   • reorganization_tb.bat
5. Change host-name in PDHOST=host-name in each file.
6. If a host name is specified in URL for Asset Information Manager on the AIM page of Server Setup for JP1/Software Distribution, change the host-name.
7. Rename the OS host.
8. Restart the OS.

The process for starting and terminating an Embedded RDB is described below. If you execute the Asset Information Manager Subset commands on a 64-bit version of the OS, you must use a 32-bit command prompt to execute the commands. For details about the execution procedure, see 10.11 Notes on using Asset Information Manager Subset on a 64-bit OS in the manual Setup Guide.

1. Start Embedded RDB.
   Execute jamemb_dbstart.bat with a user account that has Administrators priviliages to start Embedded RDB.
   jamemb_dbstart.bat is stored in the following path:
   JP1/Software-Distribution-Manager-installation-directory\jp1asset\exe
   
2. Stop Embedded RDB
   Execute jamemb_dbstop.bat with a user account that has Administrators priviliages to stop Embedded RDB.
   jamemb_dbstop.bat is stored in the following path:
   JP1/Software-Distribution-Manager-installation-directory\jp1asset\exe