Set Up the Database

The database must be set up by the database administrator. This is not the same as populating the database with tables and/or data. That is a different operation that is covered in the Populate Database section.

This part must be accomplished after the install operation. The install operation creates the file structure that determines where the database will be installed.

There are guidelines for the database administrator in creating the database. They are given in the pds_root README file. The database administrator must give the user the database name, user name, and password. For the example we are showing in this document, these values are:

• database name = epicentre
• user name = db1
• password = db1
  Note: The sample implementation allows the user name to be different from the password. However, other implementations that work with multiple databases require the two to be the same. To be able to use these other implementations, it is highly recommended that the two be the same.

These will show up in the file structure as follows:

 /posc_root/pds_root/data_stores/informix/epicentre/db1

or, in a general sense,
    /root directory/pds_root/data_stores/ db type / db name

It should be noted that this file structure is set up by the script that was run in the Set Up Environment step. I.e., when the script, setup_env.xxx is run, it uses the database type and database name and user name to set up the last three subdirectories. So the proper steps for the database administrator would be to create the database after all the steps defined in the Setting Up The Environment document are done.

There are some basic environment variables that must be set up to use the databases. These environment variables are to be set up by the user when he accesses the database. They are given in the pds_root README file, and are listed here:

• ORACLE_HOME and/or TWO_TASK for Oracle databases.
• SYBASE for Sybase databases.
• INFORMIXDIR, INFORMIXSERVER and a file .odbc.ini(in user's home directory) for Informix databases.

  set path = ($path $ORACLE_HOME/bin)

[Return to Getting Started Introduction]