Create database libraries and users for DB2 for i5/OS

Portal Express, Version 6.0
Operating systems: i5/OS, Linux, Windows

Create database libraries and users for DB2 for i5/OS

+
Search Tips | Advanced Search

Schemas logically group SQL objects...

Library
Journal
Journal receiver
Catalog
Data dictionary (optional)

Tables, views, and system objects (such as programs) can be created into any system library.

Create a database library on a local database
Create a database library on a remote database
Create user profiles
Next step

Create a database library on a local database

After you install WebSphere Portal Express, use...
WPSconfig.sh -profileName profile_root create-all-db

...to create the local or remote database libraries on the DB2 for i5/OS database. Create the user profile to own the database before running configuration.
You only need to manually configure the local and remote database libraries for the product if you do not use the Portal scripts or the Create WebSphere Portal Express wizard.
Before creating local database libraries, make sure you have installed all required software.

IBM recommends using distinct database library names for each domain in WebSphere Portal Express.
Defaults...

release *LOCAL/REL60
customization *LOCAL/CUST60
community *LOCAL/COMM60
jcr *LOCAL/JCR60
wmm *LOCAL/DBUser
Replace DBUser with the value in wpconfig_dbdomain.properties file
feedback *LOCAL/FDB60
likeminds *LOCAL/LKM60

To create the database libraries locally...
Start a 5250 session on the machine where WebSphere Portal Express is installed.
Run...
STRQSH

...or...
SBMJOB CMD(STRQSH)

Use SBMJOB to submit the Qshell script as a batch job to run in *BASE pool when *INTERACT pool does not have 1G or more of allocated memory.
Verify property values in the configuration properties files.
Create all the domain database libraries.
cd portal_server_root/config
WPSconfig.sh -profileName profile_root 
             create-all-db  
             -Drelease.DbPassword=password 
             -Dcustomization.DbPassword=password 
             -Dcommunity.DbPassword=password 
             -Djcr.DbPassword=password 
             -Dwmm.DbPassword=password 
             -Dfeedback.DbPassword=password 
             -Dlikeminds.DbPassword=password 
Create a database library on a remote database

The same rules apply for a remote database and remote database libraries with two exceptions.

The user ID and password used must have the authority to create database libraries on the remote System i5 machine.
For every property instance of a database that uses *LOCAL/schema, replace it with HostName/schema.

For example, the default database and database library name for WebSphere Portal Express release domain is:

release.DbName=wpsdb

If you wanted to create this database library on a remote database, change the default value to this value:

release.DbName=hostname/wpsdb

To create all the domain database libraries...
Start a 5250 session on the remote database machine.
Type the i5/OS command WRKRDBDIRE to display the Relational Database Directory Entry for Remote Location *LOCAL and make a note of the value displayed.
Sign off from the 5250 session.
Start a 5250 session on the local machine where WebSphere Portal Express is installed.
Create a Relational Database Directory Entry on the local system for the remote system using...
WRKRDBDIRE

Add an entry with the following values:

Relational database: Remote relational database
Use the value noted from the prior step
Relational database alias: Hostname
Use the short TCP/IP hostname of the remote system
Remote location: Domain qualified hostname
Use the full TCP/IP hostname of the remote system
Type: IP
Port number or service name: DRDA
Remote authentication method: Preferred method: ENCRYPTED
Allow lower authentication: ALWLOWER

Temporarily change the CCSID for jobs to 37 (an example for US English environment) by running the following command: CHGJOB CCSID(37)
Create the required DB2 packages on the remote database machine by running...
JAVA CLASS(com.ibm.db2.jdbc.app.DB2PackageCreator) PARM('rdb_alias' 'userid' 'password') PROP((jdbc.drivers 'com.ibm.as400.access.AS400JDBCDriver'))

...where...

rdb_alias Name of the Relational Database Entry created in step 2.
userid Database administrator user ID on the remote machine
password Database administrator password on the remote machine.

The output should be:
Java program completed

Press F3 to exit Java Shell Display.
Sign off from the 5250 session.
Start a 5250 session on the remote database machine.
Verify the required DB2 packages were created by running the following command:
WRKOBJ OBJ(QGPL/QSQCL*) OBJTYPE(*SQLPKG)

The output should be:
Opt  Object      Type      Library     Attribute   Text                        
     QSQCLIPKGA  *SQLPKG   QGPL        PACKAGE                                 
     QSQCLIPKGC  *SQLPKG   QGPL        PACKAGE                                 
     QSQCLIPKGL  *SQLPKG   QGPL        PACKAGE                                 
     QSQCLIPKGN  *SQLPKG   QGPL        PACKAGE                                 
     QSQCLIPKGS  *SQLPKG   QGPL        PACKAGE
Set property values in the configuration properties files as detailed in Preparing for creation of databases.
Start a 5250 session on the local machine where WebSphere Portal Express is installed.
Execute...
STRQSH
cd portal_server_root/config
WPSconfig.sh -profileName profile_root create-all-db -Drelease.DbPassword=password -Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password -Dwmm.DbPassword=password -Dfeedback.DbPassword=password -Dlikeminds.DbPassword=password
Create user profiles

The user profile for the database owner (the one specified in the wpconfig_dbdomain.properties file as DbUser and wmm.DbUser, for example) should be different from the Administrator user profile used to perform the installation. The Administrator user profile may have more authority than is required and usually belongs to an individual, where as the database user profile may have minimal authority and could be shared. You may also want to create a database user profile that does not require a password change over a period of time. If the password for the database user profile changes, WebSphere Portal Express must be re-configured to use the new password.

Next step

You have completed this step. Continue to the next step, which is Transferring DB2 for i5/OS.

Parent topic:
Configuring DB2 for i5/OS

Previous topic
Preparing for creation of databases

Next topic
Transferring DB2 for i5/OS

release	*LOCAL/REL60
customization	*LOCAL/CUST60
community	*LOCAL/COMM60
jcr	*LOCAL/JCR60
wmm	*LOCAL/DBUser Replace DBUser with the value in wpconfig_dbdomain.properties file
feedback	*LOCAL/FDB60
likeminds	*LOCAL/LKM60

Relational database:	Remote relational database Use the value noted from the prior step
Relational database alias:	Hostname Use the short TCP/IP hostname of the remote system
Remote location:	Domain qualified hostname Use the full TCP/IP hostname of the remote system
Type:	IP
Port number or service name:	DRDA
Remote authentication method:	Preferred method: ENCRYPTED Allow lower authentication: ALWLOWER

rdb_alias	Name of the Relational Database Entry created in step 2.
userid	Database administrator user ID on the remote machine
password	Database administrator password on the remote machine.