Appboard/2.4/admin/configuration database/example db2: Difference between revisions
imported>Jason.nicholls m (1 revision) |
imported>Jason.nicholls |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{DISPLAYTITLE:DB2}} | {{DISPLAYTITLE:DB2}} | ||
[[Category:AppBoard 2.4]] | [[Category:AppBoard 2.4]] | ||
==Overview== | |||
This document covers an example installation of IBM DB2 for use with AppBoard 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: | To create an DB2 database: | ||
#Log onto the DB2 server via an account with administrative privileges or the DB2 instance user account. | #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: | #* Run the command ''db2'' run the following DB command at the db2 prompt: | ||
<tt>create database portal pagesize 32768</tt> | #*: <tt>create database portal pagesize 32768</tt> | ||
#* Type ''exit'' to return to the UNIX shell. | #* Type ''exit'' to return to the UNIX shell. | ||
# 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. | # 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 == | |||
# 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. | # 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. | ||
Latest revision as of 11:26, 18 July 2014
Overview
This document covers an example installation of IBM DB2 for use with AppBoard 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:
- 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.
- Run the command db2 run the following DB command at the db2 prompt:
- 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
- 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.
