Configuration - Sybase iDataAgent

Once the Sybase iDataAgent is installed, configure the Sybase Server and subclient as follows:

  1. From the CommCell Browser, navigate to Client Computers | <Client>.

    Right-click Sybase, point to All Tasks, and then click New Sybase Server.

  2. In the Server Name box, type the Sybase server name. The Sybase server name should exactly be the same as the name existing in interface file and sysservers table.

    For Unix:

    In the SA User Name box, type the Sybase administrator user name.

    In the Account Password box, type the account password for the Sybase administrator user account.

    In the Confirm Password box, re-type the password.

    For Windows:

    In the User Name box, type the name of the local administrator with Sybase sysadmin role privileges in the following format:

    • Domain\user (if domain exists) or
    • Computer name\user” (where user is a local administrator).

      Type the password in the Account Password box and retype the password in Confirm Password box.

      Click OK.

  3. In the Sybase Home box, type the path to the directory where the Sybase application files reside. Alternatively, click Browse to select the location.

  4. In the Sybase ASE box, type the directory name where you installed Adaptive Server Enterprise (ASE) environment variable.

    You can view the path to the ASE directory in .env file residing in the Sybase home directory.

  5. In the Sybase OCS box, type the Sybase Open Client Server (OCS )environment variable.

    You can view this variable in sybase.env file residing in home directory.

  6. In the Configuration File box, type the path to the configuration file. Alternatively, click Browse to select the location.

  7. In the Shared Memory Directory box, type the location of the directory where you specify the shared memory file name. When you start an Adaptive Server, it creates a shared memory file that resides in the home directory. for example: /opt/sybase/ASE-15_0. Alternatively, click Browse to select the location.

  8. Specify a value in the Block Size box.

  9. In the Default Database Storage Policy box, select the storage policy name.

  10. For Unix:
    • In the User Name box, type the name of the local administrator with Sybase sysadmin role.
    • Click OK.

    For Windows:
    • In the User Name box, type the name of the local administrator with Sybase sysadmin role privileges.
    • In the Account Password box, type the password for the user account.
    • In the Confirm Password box, re-type the password.
    • Click OK.

  11. From the CommCell Browser, navigate to Client Computers | <Client> | Sybase iDataAgent.

    Right-click the <Instance>, and then click Properties.

  12. Select the Backup Server from the list.

    Click OK.

  13. Select Enable Auto Discovery to ensure that all the databases are accounted for on a regular basis for backups. If any new databases are added after a previous backup, these newly added databases will also be automatically discovered on the default subclient when you perform a backup job. However, for a user-defined subclient, you need to  manually discover the databases prior to running any backup job. See Manually Discovering Databases for additional information.

  14. From the CommCell Browser, navigate to Client Computers | <Client> | Sybase | <Instance>.

    Right-click the default Subclient, and then click Properties.

  15. Click the Storage Device tab.
    • In the Storage Policy box, select the storage policy.
    • In the Number of streams for transaction log box, enter the number of backup streams to use for transaction log backups.
    • In the Number of streams for data log box, enter the number of backup streams to use for data backups.

      Note: The restore operation uses the same number of streams configured for the backups. If the streams are not available, the backup fails. For more information, see Restore Fails because of a Stream Error.

    • Click OK.

    Proceed to the next page.

    If you do not have Storage Policy created, follow the step given below to create a storage policy.

  16. In the Backup Schedule dialog box, click Do Not Schedule, and then click OK.
  17. Click Create Storage Policy.

    Follow the prompts displayed in the Create Storage Policy Wizard. The required options are mentioned below:

    • Select the Storage Policy type as Data Protection and Archiving and click Next.
    • Enter the name in the Storage Policy Name box and click Next.
    • From the Library list, click the name of a disk library to which the primary copy should be associated and then click Next. Ensure that you select a library attached to a MediaAgent operating in the current release.
    • From the MediaAgent list, click the name of a MediaAgent that will be used to create the primary copy and then click Next.
    • For the device streams and the retention criteria information, click Next to accept default values.
    • Select Yes to enable deduplication for the primary copy and then click Next.
    • From the MediaAgent list, click the name of the MediaAgent that will be used to host the Deduplication Database.
    • In the Location box, type the name of the folder in which the deduplication database must be located, and then click Next.
    • Review the details and click Finish to create the Storage Policy.