Setting up Active Storage Manager: SQL Server

This section discusses how to set up Active Storage Manager for SQL Server. For information on how to set up Active Storage Manager for Oracle, see Setting up Active Storage Manager: Oracle.

Note: Active Storage Manager expects the TableSpace to follow the IEE Standard TableSpace Naming Conventions. The TableSpace Naming Conventions can be found in the AddReadingPartitions.pls script delivered with the 10.3 Installer. TableSpace names are case insensitive and are always stored as uppercase even if referenced in mixed case. For more information, see Active Storage Manager in the IEE MDM Help.

General Constraints, Assumptions, Dependencies, and Guidelines

Storage locations are accessible to move the database files.
Two instances of Active Storage Manager cannot be run at the same time.

Prerequisites

Setting up IEE Active Storage Manager requires the following prerequisites:

Database user configuration to run the task should have sufficient privileges.
File systems are provisioned with sufficient storage space for Storage Tier 2 (and Storage Tier 3, if desired).

Use the following procedure to configure the IEE Active Storage Manager task template:

Open the IEE Rich Client application.
Go to System Operations > Task Management > Task Templates.
From the Task Type dropdown menu, choose Active Storage Manager.
Enter desired values for the DefaultActiveStorageManager template. Refer to Configuring the task template and parameters: SQL Server for definitions and requirements for the parameters.

Important! Currently, IEE Active Storage Manager only supports using the DefaultActiveStorageManager template. Do not create any additional templates.
Specify the file system location (physical or network path) with sufficient storage space and access rights for Tier-2 (and Tier-3, if configured).
Click Save.