Job Management Partner 1/Software Distribution Setup Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
(1) In Embedded RDB
When Database Manager of Asset Information Manager Subset is used, the following processes are executed:
- Creating the service name (ODBC data source name) that was specified at the Asset Information Manager Subset server setup
- Creating a database
- Initializing the database
To create a new Asset Information Manager Subset database in an Embedded RDB environment:
- In the Database Manager dialog box, choose Create the database and then click the Next button.
The Cluster System Settings dialog box appears.
In this dialog box, set the information required in order to use Asset Information Manager Subset in a cluster system. If you do not use a cluster system, click the Next button.
Figure 10-6 Cluster System Settings dialog box
![[Figure]](FIGURE/RDB0240.GIF)
- Use in a cluster system environment
- If you use Asset Information Manager Subset in a cluster system, select this check box. By default, this check box is not selected. Selecting this check box enables other items to be set.
- Execution mode / Standby mode
- Select Execution mode or Standby mode as the type of installation-target cluster node. The default is Execution mode.
- Logical host name
- Specify the name of the logical host created in the cluster system as 1 to 64 bytes of alphanumeric characters and the following symbols: % - _
- Execution host name
- If you have selected Standby mode in Execution mode / Standby mode, specify the name of the executing host in the cluster system as 1 to 64 bytes of alphanumeric characters and the following symbols:
- % - _
- When Execution mode is selected in Execution mode / Standby mode, this item is disabled.
- Set the items and then click the Next button.
The Basic Database Settings dialog box appears.
In this dialog box, set the connection information needed for creating the database that is used by Asset Information Manager Subset.
Figure 10-7 Basic Database Settings dialog box (for Embedded RDB)
![[Figure]](FIGURE/RDB0250.GIF)
- Port number
- Specifies the port number used by Asset Information Manager Subset to connect to Embedded RDB. Specify a port number that is not in use. The permitted value is from 5001 to 65535. The default is 30010.
- ODBC data source name
- Displays the ODBC data source name.
- To change the ODBC data source name, change the Service name setting in Database Information in the Server Setup dialog box and then restart Database Manager of Asset Information Manager Subset.
- Connection user ID
- Displays the connection user ID used to log on to the Asset Information Manager Subset database.
- To change the connection user ID, change the Login ID setting in Database Information in the Server Setup dialog box, and then restart Database Manager of Asset Information Manager Subset.
- Set the items and then click the Next button.
The Detailed Database Settings dialog box appears.
In this dialog box, set the information required in order to create a database that is used by Asset Information Manager Subset.
Figure 10-8 Detailed Database Settings dialog box (for Embedded RDB)
![[Figure]](FIGURE/RDB0260.GIF)
- Storage folder name
- Specifies the name of the storage folder for the database used by Asset Information Manager Subset. To change the default database storage folder name, click the ... button and then specify a desired database storage directory. The default is JP1/Software-Distribution-Manager-installation-folder\jp1asset\db.
- Specify the path of the database area as 1 to 125 bytes of alphanumeric characters, space, and the following symbols:
- _ \ : . ( )
- Size
- Specifies the maximum size of the database used by Asset Information Manager Subset. The default is the estimate in the Estimate Capacity dialog box. Specify an integer value of 100 or more.
- If the Automatically grow check box is selected, the database size is the initial value. Specify an integer between 100 and 65535.
- Note that the size of a created database cannot be changed. To change the size, you must delete the area and then re-create the database.
- Estimate Capacity button
- You can calculate an estimate of the Asset Information Manager Subset database capacity. The calculated estimate is then entered for Size. For more information on estimating database capacity, see (4) Estimating the database capacity.
- Automatically grow
- Select this check box if you want the size of the Asset Information Manager Subset database to be increased automatically. The default is that this check box is cleared. When this check box is selected, the database size can expand automatically to a maximum of 65,535 MB.
- Management area
- Displays the size required for the Asset Information Manager Subset database management area.
- For the management area, the value set in Size is automatically assigned and then automatically created under Storage folder name.
- Operation area
- Displays the size required for Embedded RDB operation.
- For the operation area, the value required for Embedded RDB operation is automatically assigned and then automatically created under JP1/Software-Distribution-Manager-installation-folder\jp1asset.
- Set the items and then click the Create button.
The Asset Information Manager Subset database is created.
To change the size of Embedded RDB, if necessary, first back up the database to CSV-format files, and then re-create the database.
(2) In Microsoft SQL Server
When Database Manager of Asset Information Manager Subset is used, the following processes are executed:
- Creating the service name (ODBC data source name) specified during the Asset Information Manager Subset server setup
- Creating a database
- Creating a user for database access
- Initializing the database
- Note
- When the Asset Information Manager Subset database is created from the Database Manager dialog box, it is created using the collating sequence set during a custom installation of Microsoft SQL Server (or during a standard installation of Microsoft SQL Server 2008 and Microsoft SQL Server 2005).
- Therefore, if you want to change the collating sequence to one other than the one set during installation, you will need to create the database manually.
To create a new Asset Information Manager Subset database in a Microsoft SQL Server environment:
- In the Database Manager dialog box, choose Create the database and then click the Next button.
The Basic Database Settings dialog box appears.
In this dialog box, set the connection information needed for creating the database that is used by Asset Information Manager Subset.
Figure 10-9 Basic Database Settings dialog box (for Microsoft SQL Server)
![[Figure]](FIGURE/RDB0270.GIF)
- Server
- Specifies the server name and IP address of the database that is used by Asset Information Manager Subset. There is no default.
- The permitted value is 1 to 63 bytes of characters and the following symbols:
- % ~ - _ . / \
- Database name
- Specifies the name of the database used by Asset Information Manager Subset. There is no default.
- The permitted value is 1 to 128 bytes of alphanumeric characters and symbols, except the following symbols and the space:
- \ / * " ' | . < > ?
- ODBC data source name
- Displays the ODBC data source name.
- To change the ODBC data source name, change the Service name setting under Database Information in the Server Setup dialog box and then restart Database Manager of Asset Information Manager Subset.
- Connection user ID
- Displays the connection user ID used to log on to the Asset Information Manager Subset database.
- To change the connection user ID, change the Login ID setting in Database Information in the Server Setup dialog box, and then restart Database Manager of Asset Information Manager Subset.
- Set the items and then click the Next button.
The Authenticate User dialog box appears.
Figure 10-10 Authenticate User dialog box (for Microsoft SQL Server)
![[Figure]](FIGURE/RDB0280.GIF)
- Administrator ID
- Specifies the administrator ID of the Asset Information Manager Subset database.
- There is no default. The permitted value is 1 to 30 bytes of alphanumeric characters and symbols except \.
- Password
- Specifies the password for the administrator ID for the Asset Information Manager Subset database.
- There is no default. The permitted value is 1 to 30 bytes of alphanumeric characters and symbols.
- Specify the administrator ID and password and then click the OK button.
The Detailed Database Settings dialog box appears.
In this step, set information about the data file and transaction log file that are required in order to create the database used by Asset Information Manager Subset.
Figure 10-11 Detailed Database Settings dialog box (for Microsoft SQL Server)
![[Figure]](FIGURE/RDB0290.GIF)
- File Type
- Displays Data file and Transaction log.
- File Path
- Specifies the absolute path of the data file and transaction log file. To change the default file path, click the ... button and then specify a desired file path. Specify the file path as 1 to 255 bytes of alphanumeric characters and space. The following symbols are not permitted:
- " | * < > ? & ^ /
- By default, the path of the data file and transaction log file in the data file storage folder for the connection-target master database is specified. The data file name is AIMDB.mdf and the transaction log file name is AIMDB.ldf.
- Initial Size
- Specifies the initial size of the data file and transaction log file in megabytes. By default, the value set by the capacity estimation is set for the data file and a value of 20 megabytes is set for the transaction log file.
- Automatically grow file
- To extend the sizes of data file and transaction log file, select a file type from the area list and then select this check box. By default, this check box is selected. Selecting this check box enables other items to be set.
- Maximum file size
- Selects one of the following as the maximum file size:
![[Figure]](FIGURE/ZUENG030.GIF)
Unrestricted file growth- Restrict file growth
- The default is Unrestricted file growth.
- If you select Restrict file growth, specify the maximum file size in megabytes. The default is 1.
- Expansion increment
- Selects the unit for expanding file size and then specifies the increment. The default is By percent with a value of 10%.
- In megabytes
- Sets the increment in megabytes. In the input area, specify an integer that is 1 or greater.
- By percent
- Sets the increment by percent. Specify an integer in the range from 1 to 100. The default value for By percent is 10.
- Estimate Capacity button
- Enables an estimate of the capacity of the Asset Information Manager Subset database to be obtained. For details about the capacity estimation, see (4) Estimating the database capacity.
- Set the items and then click the Create button.
The Asset Information Manager Subset database is created.
(3) In Oracle
When Database Manager of Asset Information Manager Subset is used, the following processes are executed:
- Creating the service name (net service name) that was specified at the Asset Information Manager Subset server setup
- Creating a database
- Creating a user for database access
- Initializing the database
To create a new Asset Information Manager Subset database in an Oracle environment:
- In the Database Manager dialog box, choose Create the database and then click the Next button.
The Basic Database Settings dialog box appears.
In this dialog box, set the connection information needed for creating the database that is used by Asset Information Manager Subset.
Figure 10-12 Basic Database Settings dialog box (for Oracle)
![[Figure]](FIGURE/RDB0300.GIF)
- Server
- Specifies the server name and IP address of the database that is used by Asset Information Manager Subset. There is no default.
- The permitted value is 1 to 63 bytes of characters and the following symbols:
- % ~ - _ . / \
- SID
- In Oracle 8i, this item specifies the SID of the database to be connected. In Oracle 9i, specify the service name of the database to be connected. There is no default.
- The permitted value is 1 to 8 bytes of alphanumeric characters.
- Port number
- Specifies the port number used by Asset Information Manager Subset to connect to Oracle. The permitted value is from 1 to 65535. The default is 1521.
- Net service name
- Displays the net service name.
- To change the net service name, in the Server Setup dialog box, change the Service name setting in Database Information and then restart Database Manager of Asset Information Manager Subset.
- Connection user ID
- Displays the connection user ID used to log on to the Asset Information Manager Subset database.
- To change the connection user ID, change the Login ID setting in Database Information in the Server Setup dialog box, and then restart Database Manager of Asset Information Manager Subset.
- Set the items and then click the Next button.
The Authenticate User dialog box appears
Figure 10-13 Authenticate User dialog box (for Oracle)
![[Figure]](FIGURE/RDB0310.GIF)
- Administrator ID
- Specifies the administrator ID of the Asset Information Manager Subset database.
- There is no default. The permitted value is 1 to 30 bytes of alphanumeric characters and symbols except \.
- Password
- Specifies the password for the administrator ID for the Asset Information Manager Subset database.
- There is no default. The permitted value is 1 to 30 bytes of alphanumeric characters and symbols.
- Specify the administrator ID and password and then click the OK button.
The Detailed Database Settings dialog box appears.
In this step, set information about the tablespace that is required in order to create the database used by Asset Information Manager Subset.
Figure 10-14 Detailed Database Settings dialog box (for Oracle)
![[Figure]](FIGURE/RDB0320.GIF)
- File Type
- Displays User tablespace and Temporary tablespace.
- Table Name
- Specifies a name for the Asset Information Manager Subset database area (1 to 30 bytes of characters). Note that the double-quotation mark (") cannot be used. Specify the table name according to the schema and object naming rules provided in the Oracle SQL reference materials.
- File Path
- Specifies the absolute path of the user tablespace and temporary tablespace. To change the default file path, click the ... button and then specify a desired file path. Specify the file path as 1 to 255 bytes of alphanumeric characters and space. The following symbols are not permitted:
- " | * < > ? & ^ /
- By default, JP1/Software-Distribution-Manager-installation-folder\jp1asset\db\asset_db.dbf is specified as the user tablespace and JP1/Software-Distribution-Manager-installation-folder\jp1asset\db\asset_temp.dbf as the temporary tablespace.
- Initial Size
- Specifies the initial size of the user tablespace and temporary tablespace in megabytes. Specify an integer that is 1 or greater. By default, the value set by the capacity estimation is specified.
- Automatically grow file
- To extend the sizes of user tablespace and temporary tablespace, select a file type from the area list and then select this check box. By default, this check box is selected. Selecting this check box enables other items to be set.
- Maximum file size
- Selects one of the following as the maximum file size:
- Unrestricted file growth
- Restrict file growth
- The default is Unrestricted file growth.
- If you select Restrict file growth, specify the maximum file size in megabytes. The default is 1.
- Expansion increment
- Specifies the expansion increment for file size in megabytes. Specify an integer that is 1 or greater. The default is 1.
- Estimate Capacity button
- Enables an estimate of the capacity of the Asset Information Manager Subset database to be obtained. For details about the capacity estimation, see (4) Estimating the database capacity.
- Set the items and then click the Create button.
The Asset Information Manager Subset database is created.
In the Detailed Database Settings dialog box of the Asset Information Manager Subset database manager, clicking the Estimate Capacity button displays the Estimate Capacity dialog box.
In this dialog box, set the information that is required in order to estimate the capacity of the Asset Information Manager Subset database.
Figure 10-15 Estimate Capacity dialog box
![[Figure]](FIGURE/RDB0330.GIF)
- Scale of operations
- Specifies the number of items registered for each information type that is used.
- Estimated capacity requirements
- Displays the estimated capacity of the Asset Information Manager Subset database.
- Default button
- Resets each registration count for scale of operations to the default value.
- Save button
- Saves the registration count specified in Scale of operations to a text file.
- Apply button
- Applies the estimated value to the dialog box used to set the Asset Information Manager Subset database area.
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.