Appboard/2.4/admin/configuration database/example db2 - Revision history

imported>Jason.nicholls: /* Creating a Database */

2014-07-18T11:26:46Z

Creating a Database

← Older revision		Revision as of 11:26, 18 July 2014
Line 11:		Line 11:
	#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.

imported>Jason.nicholls at 11:26, 18 July 2014

2014-07-18T11:26:26Z

← Older revision		Revision as of 11:26, 18 July 2014
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.

	~~This section describes~~ the ~~tasks that must be performed in order to use IBM~~ DB2 ~~with enPortal:~~		In this example it is assumed the DB2 software is already installed on a system.

	~~=== Creating~~ a ~~Database ===~~

			== Creating a Database ==
	To create an DB2 database:		To create an DB2 database:

Line 14:		Line 15:
	# 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 ===		== 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.

imported>Jason.nicholls: 1 revision

2014-07-18T11:16:36Z

1 revision

← Older revision	Revision as of 11:16, 18 July 2014
(No difference)

imported>Jason.nicholls at 09:19, 18 July 2014

2014-07-18T09:19:05Z

New page

{{DISPLAYTITLE:DB2}}
[[Category:AppBoard 2.4]]

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:

#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:
<tt>create database portal pagesize 32768</tt>
#* 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.

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