Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

Dell EMC Solutions Enabler 9.2 SRDF Family CLI User Guide

Create a composite group from an RDBMS database

Use the export command to translate the devices of an existing RDBMS database or tablespace to a new or existing composite group.

NOTE:

For SYMCLI to access a specified database, you must set the SYMCLI_RDB_CONNECT environment variable to the username and password of the array administrator's account.

NOTE:

The Bourne and Korn shells use the export command to set environment variables. The C shell uses the setenv command.

Connecting by network

When connecting by the network, add a database-specific variable to the RDB_CONNECT definition.

When connecting through the network in an Oracle environment, Oracle has a network listener process running.

An Oracle connection string such as the Transparent Network Substrate (TNS) is required.

Examples

In the following example, a local connect is used. The export command sets the variable to a username of "array" and a password of "manager".

export SYMCLI_RDB_CONNECT=array/manager

In the following example, the export command adds the TNS alias name "api217":

export SYMCLI_RDB_CONNECT=array/manager@api217

When connecting through the network in an SQL Server 2000 environment, add a string to indicate the ODBC data source administrator.

To add string "HR":

set SYMCLI_RDB_CONNECT=array/manager@HR

Optionally, set the SYMCLI_RDB_TYPE environmental variable to a specific type of database (oracle, informix, sqlserver, or ibmudb) so that you do not have to include the -type option on the symrdb rdb2cg command line.

To set the environmental variable to oracle :

export SYMCLI_RDB_TYPE=oracle

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\