Configure the File Copy Method

Use the File Copy method for Microsoft SQL Server databases.

Before you begin

Before you configure the File Copy method, you must

  • create a shared directory on the database server
  • provide the IBM® Controller administrator with read and write access permissions to the shared folder on the database server, or create a local account with read and write access permissions to the shared folder on the database server
  • set read and write access permissions on the shared folder for the database server
  • for Microsoft SQL Server databases, enable the Bulk Insert Administrators server role for the Controller database owner

    In addition, set the Controller database owner as the owner of tempdb and model.

  • configure reports to use Enhanced Reporting Optimization

Procedure

  1. To configure reports to use enhanced reporting optimization, in Microsoft Excel, in the first worksheet in the report, position your cursor in cell A1.
  2. From the Insert menu, click Name, Define.
  3. In the Define Name box, under Names in workbook, type Optimise2, and then click OK.

    You are now ready to configure the file copy method.

  4. To configure the file copy method, from the Start menu, start IBM Controller Configuration.
  5. In the Explorer window, click Enhanced Reporting Optimizations.
  6. In the Enhanced Reporting Optimizations window, in the Select Connection drop-down list, select a database.
  7. Under Connection Optimizations, in the File Mode box, click the drop-down arrow and select File Copy.
  8. In the Server box, type the computer name for the server on which you created the shared directory.
  9. In the Share box, type the name of the share you created in Step 1.
  10. If the database is in another domain, in the User ID and Password boxes, type the logon user name and password for the domain user.

    The password is encrypted with IBM Controller standard encryption.

  11. From the File menu, click Save.