Providing and verifying connectivity to the CMS database

To create tables and write data to your new CEcms database, the installation scripts need to establish a connection to the database server. That is, when you log on to UNIX with the user name crystal to perform the installation, the default shell environment must include the appropriate database environment variables and/or initialization files. Only then can the installation script access the CEcms database using your database client software.

The environment variables and/or files required by the installation scripts depend upon the type of database server you are running:

• If you choose to connect to Oracle through a native connection, the installation searches the current shell for the ORACLE_HOME environment variable. This standard Oracle environment variable must be set in order for the setup.sh script to utilize the Oracle client software.
• If you choose to connect to DB2 through a native connection, the installation searches the current shell for the DB2INSTANCE environment variable. This standard DB2 environment variable must be set in order for the setup.sh script to utilize the DB2 client software.
• If you choose to connect to Sybase through a native connection, the installation searches the current shell for the SYBASE and SYBASE_OCS environment variables. These standard Sybase environment variables must be set in order for the setup.sh script to utilize the Sybase client software.

Additional database environment variables must be set in order for the installation script to use the database client software properly. Before running the installation script, test the shell environment of the new crystal user to verify database connectivity and privileges. See the procedure that corresponds to your database.

Note:    Consult your database documentation and/or your database administrator if the crystal user's shell environment has not yet been set up for your database client software, or if you are unable to connect successfully to the database.

To verify Oracle native connectivity through a TNS

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   ORACLE_HOME	This variable contains the path to the root directory of your Oracle client installation (one level above the Oracle bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your Oracle client installation.
   PATH	The search path must include the bin directory of your Oracle client installation.

   This example checks the required variables and shows sample output values.

   $ echo $ORACLE_HOME
   

   /opt/oracle/817
   

   $ echo $LD_LIBRARY_PATH
   

   /opt/oracle/817/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/opt/oracle/817/bin
   

3. Issue the following command to run the Oracle SQL tool and connect to the appropriate service name:

   sqlplus crystal/password@tnsname

   Replace password and tnsname with the appropriate values. If the shell environment has been configured correctly, you are connected to Oracle.

4. Issue the following command to ensure that the crystal user account has permission to create tables:

   create table sampletable (field1 char(10));

5. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable;

6. Type exit

To verify DB2 native connectivity through a database alias

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   DB2INSTANCE	This variable defines the current DB2 database instance.
   DB2DIR	This variable contains the path to the root directory of your DB2 installation (one level above the DB2 bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your DB2 client installation.
   PATH	The search path must include the bin directory of your DB2 client installation.

   This example checks the required variables and shows sample output values.

   $ echo $DB2INSTANCE
   

   db2inst1
   

   $ echo $DB2DIR
   

   /opt/IBMdb2/V7.1
   

   $ echo $LD_LIBRARY_PATH
   

   /export/home/db2inst1/sqllib/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/export/home/db2inst1/sqllib/adm:/export/home/db2inst1/sqllib/misc
   

3. Issue the following command to run the DB2 SQL tool:

   db2

4. Issue the following command to connect to the desired database alias:

   connect to db_alias user crystal using password

   Replace db_alias and password with the appropriate values. If the shell environment has been configured correctly, you are connected to DB2.

5. Issue the following command to ensure that the crystal user account has permission to create tables:

   create table sampletable (col_fld char(10) not null)

6. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable

7. Type terminate

To verify Sybase native connectivity through a server name

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   SYBASE	This variable contains the path to the root directory of your Sybase client installation (one level above the SYBASE_OCS version directory).
   SYBASE_OCS	This variable contains the name of the Sybase version directory (one level above the Sybase bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your Sybase client installation.
   PATH	The search path must include the bin directory of your Sybase client installation.

   This example checks the required variables, and shows sample output values:

   $ echo $SYBASE
   

   /opt/sybase/12.0
   

   $ echo $SYBASE_OCS
   

   OCS-12_O
   

   $ echo $LD_LIBRARY_PATH
   

   /export/home/sybase/12.0/OCS-12_0/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/export/home/sybase/12.0/OCS-12_0/bin
   

3. Issue the following command to run the Sybase SQL tool and connect to the database server:

   isql -U user -P password -S servername

   Replace user, password, and servername with the appropriate values. If the shell environment has been configured correctly, you are connected to Sybase.

4. Issue the following command to ensure that the crystal user account has permission to create tables:

   use aps
   

   go
   

   create table sampletable (def_field char(10))
   

   go
   

   sp_help sampletable
   

   go
   

5. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable
   

   go
   

   sp_help sampletable
   

   go
   

6. Type quit