Appboard/old/configuration database/example db2

Revision as of 20:48, 27 May 2014 by imported>Andy.hopper (Created page with '{{DISPLAYTITLE:DB2}} This section describes the tasks that must be performed in order to use IBM DB2 with enPortal: === Creating a Database === To create an DB2 database: #Lo…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


This section describes the tasks that must be performed in order to use IBM DB2 with enPortal:

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.
  1. 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.