Job Management Partner 1/Software Distribution Setup Guide

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

4.2.1 Database Environment page

Use the Database Environment page to change relational database settings, if necessary.

The settings displayed on the Database Environment page depend on the relational database in use.

When you are using Asset Information Manager Subset, in order to change the relational database settings from the Database Environment page, you must reset Create Data Source/Net Service for Asset Information Manager Subset. For details about the creation of a data source/net service, see 10.3.8 Creating a data source or a net service.

Organization of this subsection
(1) Database Environment page (for Embedded RDB)
(2) Database Environment page (for Microsoft SQL Server or Oracle)

(1) Database Environment page (for Embedded RDB)

This subsection describes how to specify the settings on the Database Environment page when Embedded RDB is used.

The settings available on the Database Environment page when Server core facility has been installed differ from when only Remote Installation Manager has been installed.

Figures 4-2 and 4-3 show the Database Environment page when Server core facility has been installed and when only Remote Installation Manager has been installed, respectively.

Figure 4-2 Database Environment page (when Server core facility has been installed)

[Figure]

Figure 4-3 Database Environment page (when only Remote Installation Manager has been installed)

[Figure]

Port number
Specify the port number to be used for connecting the database, in the range from 5001 to 65535. The default is the port number specified in the Database Settings dialog box.
If you have changed the port number from the default setting, you must perform the following operations after completion of setup in order to apply the new settings:
  1. Stop the Remote Install Server service.
  2. Execute the netmdb_setup.bat command that is stored in JP1/Software-Distribution-installation-directory\BIN.
    Normally, when the netmdb_setup.bat command terminates, it waits for an entry from the keyboard. To enable the command to terminate without receiving an entry from the keyboard, execute the command with the /nopause option specified.
  3. Start the Remote Install Server service.

Administrator ID
Specify the administrator ID to be used to log on to the database. The default is the administrator ID that was specified during installation.
This item is enabled when only Remote Installation Manager has been installed.

Password
Specify the password to be used to log on to the database. The default is the password specified during installation.
This item is enabled when only Remote Installation Manager has been installed.

(2) Database Environment page (for Microsoft SQL Server or Oracle)

This subsection describes how to specify the settings on the Database Environment page when Microsoft SQL Server or Oracle is used.

The settings on this page are not applicable to a PC on which only Remote Installation Manager has been installed. The system assumes for the connection-target PC the settings on the Database Environment page that were specified when the Remote Installation Manager was installed or started.

Figure 4-4 Database Environment page (for Microsoft SQL Server or Oracle)

[Figure]

Host name of the database server
Specify the name of the host that will function as the database server.
If named instances are used, specify the host name in the following format:
database-server's-host-name\instance-name

Database name
Specify the name of the database. This must be the same name you specified in Database Manager. Specify this item only when Microsoft SQL Server is used for the relational database.

SID
Specify four alphanumeric characters as the database system identifier (SID) that indicates an Oracle database instance. The default is NETM. Specify this item only when Oracle is used for the relational database.

Administrator ID and Password
Enter the user ID and password of the user who has access permission to the JP1/Software Distribution database. The system uses the administrator ID that you enter here when it connects to a Packager and to clients. If you will be using Oracle as the relational database, UNLIMITED TABLESPACE permission must be granted as the system permission for this Administrator ID.