Job Management Partner 1/Software Distribution Setup Guide

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

7.4.2 Transferring data to a relational database

To transfer data from a JP1/Software Distribution basic database JP1 Version 7i or earlier to a relational database (Embedded RDB), first create the new relational database, then transfer the contents of the basic database to the new relational database.

Organization of this subsection
(1) Configuration limits when transferring data to a relational database
(2) Transferring data to a relational database

(1) Configuration limits when transferring data to a relational database

Relational databases have certain limits, such as the number of group levels that can be created in the database. If the configuration of the JP1/Software Distribution basic database exceeds these limits, the information in the supernumerary sections is not transferred when you transfer the data to a relational database.

Number of levels in the System Configuration window
In the System Configuration window, you can create up to seven hierarchical levels, including the end hosts. The series of host names from the top level can consist of a maximum of 255 bytes including the separators between host names.

Number of levels in the Destination window
In the Destination window, you can create up to seven hierarchical levels including the trailing host name. A series of the destination group names and the trailing host name can consist of a maximum of 255 bytes including the separators at the beginning of each host group name and the separator before the trailing host name.

Number of folder levels in the Job Definition and Job Status windows
You can create up to four levels of folders in the Job Definition and Job Status windows.

(2) Transferring data to a relational database

Note
  • If you changed the package storage directory when you transferred data from a basic database to the relational database, move files from the previous package storage directory to the new package storage directory, and then follow the procedure below.
  • If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
    1. World Wide Web Publishing Service or World Wide Web Publishing
    2. Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
    3. 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 transferring to the relational database.

To transfer data from a JP1/Software Distribution Manager basic database JP1 Version 7i or earlier to the relational database:

  1. In the Welcome dialog box, select Transfer administration file from the file system, and then click the Next button.
    The Authentication Information of Database dialog box appears.
  2. In the Authentication Information of Database dialog box, specify the password, and then click the Next button.
    The Transfer Data to Relational Database dialog box appears.

    Figure 7-10 Transfer Data to Relational Database dialog box

    [Figure]

  3. Click the Execute button.
    Data is transferred from the basic database to Embedded RDB.