Job Management Partner 1/Software Distribution Setup Guide

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

7.5.3 Transferring resources from the database to the file system (Microsoft SQL Server)

This option is disabled if Oracle was selected during server installation.

Note
  • When you transfer the package data storage destination to the file system, you must first use the maintenance wizard to change the package data storage destination from the relational database to the file system.
  • 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 resources from the database to the file system.

To transfer resources from the database to the file system:

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

    Figure 7-35 Select Database dialog box

    [Figure]

  2. Specify information about the relational database from which data is to be transferred, and click the Next button.
    The Transfer Data to File System dialog box appears.

    Figure 7-36 Transfer Data to File System dialog box

    [Figure]

    To change the package storage directory, click the ... button for the item.
  3. Click the Execute button.
    The package storage directory is transferred from the relational database to the file system.