Maintaining Environments

Example: Creating a Remote Warehouse Environment

This example summarizes how to create a remote Warehouse Environment--an Environment whose metadata repository is not stored on the SAS/Warehouse Administrator host.

A remote Environment might be appropriate if you require concurrent read/write access to Environments by multiple SAS/Warehouse Administrator hosts. In that case, you must create a remote Environment and put its metadata repository under the control of a SAS/SHARE server that is remote to the SAS/Warehouse Administrator hosts. For an example of such a configuration, see Remote Metadata: PC Client to Windows NT Server.

The following sections describe the metadata and methods that are used to achieve the desired results. The appropriate preparation is assumed to have taken place, as described in Preparing to Create Local or Remote Warehouse Environments. Some additional preparation for remote Environments is described in the next section.

SAS/SHARE Server Preparation

On the SAS/SHARE server host,

create a directory structure for the Environment
assign a SAS libref to the directory that corresponds to the _MASTER library for the Environment; do this in such a way that the library is under the control of the SAS/SHARE server.

For example, suppose that you created the following directory structure on the SAS/SHARE server host,

.\Project-2\_env 
.\Project-2\_wh1

where .\Project-2\_env is the directory that corresponds to the _MASTER metadata repository for the Environment that you will create. You would then assign a libref to that directory in such a way that the library is under the control of the SAS/SHARE server.

Note: Because this is a SAS/SHARE libref and not a SAS/Warehouse Administrator libref, you are not restricted to _MASTER as the libref. For example, to the SAS/SHARE server, the .\Project-2\_env directory could have a SAS/SHARE libref of ENV1. (The SLIBREF option would then have to be used in the Warehouse Environment's metadata, as described in Define Warehouse Environment Properties.) [cautionend]

Note: If you use a relative pathname such as .\Project-2\_env for the Environment library, be sure that the SAS/SHARE server can resolve the pathname. [cautionend]

SAS/Warehouse Administrator Client Preparation

Verify that your local SAS session can access the remote library that will ultimately become the metadata repository for the Environment that you are creating. One way to do that is to submit a LIBNAME statement for that library. Here is an example of such a statement,

libname _MASTER server=host2.dwshare slibref=ENV1;

where _MASTER is the local libref for the Warehouse Environment's metadata repository, host2 is the name of the remote host, dwshare is the name of the SAS/SHARE server, and slibref=ENV1 is the remote server's libref for the Warehouse Environment's metadata repository.

If you can successfully execute such a statement, then SAS/Warehouse Administrator can successfully generate code for the remote Warehouse Environment.

Define Warehouse Environment Properties

If you have not done so already, display the SAS/Warehouse Administrator desktop. Run SAS on a machine where SAS/Warehouse Administrator has been installed. Type dw on the SAS command line, and press RETURN.

The next display illustrates a SAS/Warehouse Administrator desktop that does not have any Warehouse Environments defined:

[untitled graphic]

Position the cursor on an empty area on the desktop, click the right mouse button, select Add Item, then Data Warehouse Environment. A properties window for the Environment displays for you to enter the appropriate information, which is described as follows:

Engine	specify a SAS engine appropriate for the current Environment.
Options	specify any LIBNAME options appropriate for the current Environment.

[untitled graphic]

In the current example, you do not enter a physical path in the Path field because the _MASTER library will be accessed through the SAS/SHARE server, which uses a libref to access this library.

The Engine field specifies that the remote SAS engine will be used to access the _MASTER library for this Environment.

The Options field specifies the SERVER= option required to access the _MASTER library for this Environment, where host2 is the name of the remote host, dwshare is the name of the SAS/SHARE server, and slibref=ENV1 is the remote server's libref for the Warehouse Environment's metadata repository.

After specifying the appropriate values, click OK.

If you are creating a new Environment, you will be prompted to enter a Name and a Description. After specifying a name and description, click OK. The new Environment is added to the SAS/Warehouse Administrator desktop.

The next display illustrates a SAS/Warehouse Administrator desktop that has the Toy Store Environment defined:

[untitled graphic]

You are finished defining the properties for this Environment. To ensure that you can start SAS with a configuration file and an autoexec file appropriate for this Environment, see Creating a Start Method for an Environment.

Top of Page