114 Implementing PeopleSoft Enterprise on xSeries and Linux
10.1 Creating the PeopleSoft database
Often consisting of tens of thousands of tables, the PeopleSoft database is at the
core of every PeopleSoft environment. Creating the database is a complex
endeavour, and though PeopleSoft has gone to great lengths to automate the
process, it is still helpful to understand the underlying mechanisms.
10.1.1 PeopleSoft prerequisites
Prior to running the database configuration wizard, you should complete these
steps (some of which are outlined in previous chapters):
Install the database engine on the database server, and verify connectivity
from external clients.
Install PeopleTools with the database server feature on the database server.
Install the PeopleSoft application with the database server feature and the
appropriate PeopleSoft application databases (including the demo database if
you wish to have sample data). This process will create large .db files in your
Set the required DB2 registry settings. These settings were sufficient for our
environment; check the PeopleSoft Installation manual for your platform if you
are installing a multi-language system or for other details.
Table 10-1 Db2 registry settings
Edit the db2cli.ini file, usually found in /opt/IBM/db2/V8.1/cfg, to include the
– DISABLEKEYSETCURSOR=1 (inside the COMMON section of db2cli.ini)
– IGNOREWARNINGS=1 (inside the database-specific section of db2cli.ini)
For example, our file includes:
db2 command Effect
db2set DB2_MIN_DEC_DIV_6=yes Sets the necessary decimal precision
db2set DB2_RR_TO_RS=yes Sets the locking level
db2 set DB2_REDUCED_OPTIMIZATION=yes Reduces automatic optimizations