Using CES Database Manager

About CES Database Manager

This section describes the procedure to use CES Database Manager.
 

  • Before running EDM, we recommend that you create an edm profile to set up all the environment variables. Sample values to be defined in this file are as follows:
     

export EDS_HOME=/ds/CESDS/9.1.9 The directory where the CES Database Server is installed.
export PATH=.:/usr/sbin:/usr/java1.5/bin:/usr/local/netscape:${PATH} The system path. Make sure that you have included the following in your path:

location of the lsuser/usr/sbin on most systems.

location of the JRE 1.5/bin directory.

location in which Netscape is installed. This is required to view the online help.
export MOZILLA_HOME=/usr/local/netscape This variable needs to be set on AIX systems only to use Netscape to view the online help.
  • Source the edm profile to set up the environment variables

Database Environment Variables Setup

In Setup Database Environment Variables window, you can define a new database entry or modify an existing database.
 

Field Name

Description

Entry Label

The description for this entry. You can specify any appropriate description here.

Instance Name

The instance which manages the database.

Database Name

The name of the database. (Refer the Note below)

C Compiler Path

The path to the C Compiler.

TCP/IP Port

DB2 Instance TCP/IP port number.

Note: The instance owner must create a directory where DB2 database files will reside. This directory must follow the rules given below:

  • It must be created under $INST_HOME. For example, /${INST_HOME}/${DB_NAME}.

  • It must have file permissions of 755.

  • It must have the same name as the database and can be a maximum of 8 characters in length.

  1. You can create a new database entry or duplicate.

  2. Click New in the left panel and enter the details for the entry you wish to set up on the right panel.

  3. Click OK to save the entry.

  4. To make a duplicate copy of a database entry, select an entry from the left panel and click Duplicate.

    The details of the selected entry are copied and a new entry is created.

  5. To delete a database entry, select an existing entry from the left panel and click Delete to delete the selected entry.

Setting up Server Environment

The root user should create the following user groups and user IDs before performing any database operations.

Group Name

Description

dsinsg

This is an CES instance owner user group. All CES instances are created by the user (dsinst<n>) of this group. The SYSADMIN user called aspadm also belongs to this group.

dsprocg

This is the user group to which the stored procedure user id, dsproc belongs.

cisdbag

This is the user group to which the cisdba user belongs.

dsg

Normally, this is the user group to which the CES Database Server release installer user, ds belongs.

 

User Name

Description

dsinst<n>

This is an instance owner user id. This user belongs to the dsinstg group. For each instance, you must create a separate dsinst<n> user id. This user will have a umask of 027.

aspadm

This user is the SYSADMIN user for all DB2 database instances and databases. This user belongs to dsinstg group.

dsproc

This is a stored procedure user id. This user belongs to user group called dsprocg.

cisdba

This user belongs to the cisdbag group and is used to establish a connection between the CES Database Server and the application. All the CES database objects (tables, views, and so on) are created by this user. In addition, data manipulation activities (such as insert, update, delete and so on) and queries (select) will be done by this user.

ds

This user belongs to the dsg user group and it installs the ds®?™s CES Database Server releases.