To create a new relational database using Microsoft SQL Database:

1. In the Welcome dialog box, choose Relational database system to be used, Create new database, and then click the Next button.
   The Select Database dialog box appears.
   

   Figure 7-27 Select Database dialog box

   

   Database server

   Specify the name of the relational database server.

   If you are using TCP/IP sockets as the network protocol, specify the server name. If you are using Named pipes, specify the computer name.

   If you use named instances, specify the host name in the following format:

   database-server-host-name\instance-name

   Database name

   Specify the database name that was specified at the JP1/Software Distribution Manager setup.

   Administrator ID

   Specify the ID of the system administrator (SA) of the relational database. By setting the administrator ID and password, you can prevent access to the relational database by unauthorized users.

   Password

   Specify the password for the administrator ID. For security purposes, the password is displayed as a series of asterisks (*).

   Host name or IP address

   Select Host name or IP address for the type of information to be used for node identification.

2. Specify the items and then click the Next button.
   The Set Database Details dialog box appears.
   

   Figure 7-28 Set Database Details dialog box

   

   In this dialog box, you can specify for each file the path to the database file, initial size, and maximum size.
   To browse files to specify a file path, click the adjacent [...] button.
   Note that if the OS being used is a 64-bit version of Windows Server 2012, Windows Server 2008 (x64) or Windows Server 2003 (x64), a path under the %Systemroot%\system32 directory cannot be set. If you are creating a database on a different machine from the one on which the database manager has been installed, make sure that the specified database file path actually exists. If a nonexistent path is specified, database creation will fail.
   For details about how to determine each size, see 5.4 Estimating disk space requirements for the database in the Description and Planning Guide. The following table shows the default values.
   

   Table 7-4 Default values for the detailed database settings (for Microsoft SQL Server)

   Type of file	Path	Initial size (MB)	Maximum size (MB)#1	Growth increment#2
   Database file	C:\Program Files\Hitachi\NETMDB\MSSQL\DB.mdf	3,250	0	10%
   Transaction log file	C:\Program Files\Hitachi\NETMDB\MSSQL\LOG.ldf	20	0	10%
   Software package database file	C:\Program Files\Hitachi\NETMDB\MSSQL\PACK.ndf	200	0	10%
   Software operation monitoring log database file#3	C:\Program Files\Hitachi\NETMDB\MSSQL\MONITOR.ndf	2,000	0	10%

   #1

   If you specify 0, the system may expand the file until the disk becomes full.

   #2

   Specify the size increase for one increment in either MB units or as a percentage (%). If you specify only a number, MB units is assumed. If you add % after a number, percentage is assumed.

   #3

   If the Operation Log List window is not used with the software operation monitoring facility, it is advisable to specify a small size because the software operation monitoring log file is not used.

   
   In Microsoft SQL Server, the area for managing security updates is included in Database file.
   
3. Click the Next button.
   The Create Database dialog box appears.
   

   Figure 7-29 Create Database dialog box

   

4. Click the Create button.
   The system creates the relational database. If files to be used by the relational database already contain data, a message is displayed asking you to confirm whether the data is to be initialized.
   

To create a new relational database using Oracle:

1. In the Welcome dialog box, choose Relational database system to be used, Create new database, and then click the Next button.
   The Specify Data Source dialog box appears.
   

   Figure 7-30 Specify Data Source dialog box

   

   Data source

   The data source name is predetermined; you cannot specify this item.

   User ID

   If you have created a user, specify the user name. Before specifying the user name, check that the DBA Role permission has been granted to the user you created. If you did not create a user, specify system.

   Password

   If you have created a user, specify the password for the user. Otherwise, specify the password for the system user.

   Net Service Name

   Specify the net service name in the following format: NETM_name-of-connection-destination-server

   Do not include the DNS name in the connection destination server name.

   The following example is for the connection destination server name dmp380.Hitachi.co.us:

   NETM_dmp380

2. Specify the item, and then click the Next button.
   The Specify Table Space dialog box appears.
   

   Figure 7-31 Specify Table Space dialog box

   

   In the Specify Table Space dialog box, specify the name of the table space to be created.
   

   User table space

   Specify the name of the user table space. The default is NETM_USER_DATA.

   Index table space

   Specify the name of the index table space. The default is NETM_INDEX_DATA.

   Temporary table space

   Specify the name of the temporary table space. The default is NETM_TEMP_DATA.

   Rollback table space

   Specify the name of the rollback table space. The default is NETM_ROLLBACK_DATA.

   Software operation monitoring log table space

   Specify the name of the software operation monitoring log table space. The default is NETM_MONITOR_DATA.

   Security update management table space

   Specify the name of the security update management table space. The default is NETM_OSPATCH_DATA.

   Details button

   Displays the Table Space Details dialog box that enables you to set the path of the database file as well as the initial and maximum sizes.

   Figure 7-32 Table Space Details dialog box

   
   

   To browse files to specify a file path, click the adjacent [...] button.
   Note that if the OS being used is Windows Server 2003 (x64), a path under the %Systemroot%\system32 directory cannot be specified. If you are creating a database on a different machine from the one on which the database manager has been installed, make sure that the specified database file path actually exists. If a nonexistent path is specified, database creation will fail.
   For details about how to determine each size, see 5.4 Estimating disk space requirements for the database in the Description and Planning Guide. The following table shows the default values.
   

   Table 7-5 Default values for the detailed table space settings (Oracle)

   Type of table space	Path	Initial size (MB)	Maximum size (MB)
   User table space	C:\Program Files\Hitachi\NETMDB\oracle\USER.DAT	30	150
   Index table space	C:\Program Files\Hitachi\NETMDB\oracle\INDEX.DAT	20	100
   Temporary table space	C:\Program Files\Hitachi\NETMDB\oracle\TEMP.DAT	20	100#1
   Rollback table space	C:\Program Files\Hitachi\NETMDB\oracle\ROLLBACK.DAT	30	100#2
   Software operation monitoring log table space#3	C:\Program Files\Hitachi\NETMDB\oracle\MONITOR.DAT	2,320	11,600
   Security update table space	C:\Program Files\Hitachi\NETMDB\oracle\OSPATCH.DAT	3,200	12,800

   #1

   Normally specify 60% of the user table space.

   #2

   Normally specify 10% of the user table space.

   #3

   If the Operation Log List window is not used with the software operation monitoring facility, it is advisable to specify a small size because the software operation monitoring log file is not used.

   
   
3. Click the Next button.
   The Create Database dialog box appears.
   

   Figure 7-33 Create Database dialog box

   

4. Click the Create button.
   The system creates the relational database. If files to be used by the relational database already contain data, a message is displayed asking you to confirm whether the data is to be initialized.