If you are using any of the following relational databases with a JP1 version earlier than 7i, you must upgrade your relational database when you upgrade JP1/Software Distribution to Version 7i:

• Oracle8i R8.1.5 or R8.1.6
• Oracle8
• Microsoft SQL Server 6.5

If you upgrade the relational database when you upgrade JP1/Software Distribution Manager, first upgrade the relational database and then use Database Manager to upgrade the JP1/Software Distribution database.

Upgrading from Microsoft SQL Server version 7.0 or earlier to Microsoft SQL Server 2008 is not supported. You must upgrade the OS and migrate the relational database. For details about migration, see A.2 Changing the database type.

Upgrading from Microsoft SQL Server 2000 or earlier to Microsoft SQL Server 2012 is not supported. You must upgrade the OS and migrate the relational database. For details about migration, see A.2 Changing the database type.

Notes

• If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
  

  World Wide Web Publishing Service or World Wide Web Publishing Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

  To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.
  
• If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before upgrading the database.

To upgrade the database for Microsoft SQL Server:

1. In the Welcome dialog box, choose Relational database system to be used, Upgrade database, and then click the Next button.
   The Select Database dialog box appears.
   
2. Set information about the target relational database and then click the Next button.
   If there is a missing database file, the Set Database Details dialog box is displayed.
   

   Figure 7-37 Set Database Details dialog box

   

   You can set a software operation monitoring log database file.
   
3. Click the Next button.
   The Upgrade Database dialog box appears.
   

   Figure 7-38 Upgrade Database dialog box

   

4. Click the Execute button.
   The system upgrades the relational database.
   

Notes

• If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
  

  World Wide Web Publishing Service or World Wide Web Publishing Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

  To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.
  
• If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before upgrading the database.

To upgrade the database for Oracle:

1. In the Welcome dialog box, choose Relational database system to be used, Upgrade database, and then click the Next button.
   The Specify Data Source dialog box appears. For details about the settings, see 7.5.1(2) Creating a new relational database (Oracle).
   
2. Click the Next button.
   If there is a missing database file, the Specify Table Space dialog box is displayed.
   

   Figure 7-39 Specify Table Space dialog box

   

   Clicking the 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-40 Table Space Details dialog box

   

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

   Figure 7-41 Upgrade Database dialog box

   

4. Click the Execute button.
   The system upgrades the relational database.