Prepare to Install › Central Management Server Database Requirements and Preparation › Use a Supported Database Server › Set up an Empty Database for the CMS › DB2 Database Requirements › Verify DB2 Native Connectivity Through a Database Alias (UNIX Only)

Verify DB2 Native Connectivity Through a Database Alias (UNIX Only)

To verify DB2 native connectivity through a database alias

1. Log in to the UNIX server with the user account and password which you will use to do your install.

   Note: This account should already be set up. See Create an Account, a Home Directory, and a Login Environment for more information about setting up a UNIX account to use when you install BusinessObjects Enterprise.

2. Echo the following environment variables and ensure that their values correspond to your database client software installation.
   • DB2INSTANCE

     This variable defines the current DB2INSTANCE DB2 database instance.

   • INSTHOME

     This variable contains the path to the root directory of your DB2 client installation.

   • 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 and Linux, and LIBPATH on AIX) 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:/ex
   port/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 accountname 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 account has permission to create tables:

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

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

   drop table sampletable
   

7. Type terminate.

MySQL Database Requirements

If you are using your own MySQL installation for the CMS or auditing database, use a Unicode character set, such as UTF-8. Once the database is created, you must prepare it for the BusinessObjects Enterprise installation.