Enportal/5.4/admin/configuration database/example db2

Revision as of 11:40, 18 July 2014 by imported>Jason.nicholls (1 revision)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Overview

This document covers an example installation of IBM DB2 for use with enPortal as an external configuration database.

In this example it is assumed the DB2 software is already installed on a system.

Creating a Database

To create an DB2 database:

  1. Log onto the DB2 server via an account with administrative privileges or the DB2 instance user account.
    • Run the command db2 run the following DB command at the db2 prompt:
      create database portal pagesize 32768
    • Type exit to return to the UNIX shell.
  2. Determine and make note of the IP or hostname of the DB2 server and the specific TCP port that DB2 is bound for incoming connections.

Creating a User

  1. In some environments it will make sense to associate a new user account with the portal database. Because DB2 associates operating system users with DB2 user credentials, the creation of users and database permissions is a variable task: refer to the OS-Specific DB2 documentation for instructions for creating users and assigning database permissions.