Use this information to install DB2 for z/OS for use with HCL Digital
Experience.
Before you begin
- Review the database considerations.
- Ensure the database that you plan to use is supported
by this version of HCL.
Refer to the list of supported databases in the HCL detailed system requirements.
- The DB2® subsystem
must be on a supported z/OS operating system.
- Ensure that Java Database Connectivity requirements
are met. Consult the following references:
- If the current version of HCL Portal and an earlier
version coexist with the same DB2 for z/OS® subsystem, the
database user IDs for the current version must be different from the
earlier version to avoid conflicts during installation. If the two
versions of HCL Portal connect
to two different DB2 for z/OS
subsystems, using the same user ID does not cause conflict.
- Except, when you migrate to a new release of HCL Portal, using the same DB2 for z/OS subsystem for
two independent lines of production must be avoided. Each line of
production of HCL Portal must
use a subsystem of DB2 for z/OS that
is dedicated exclusively to this installation. Because the DB2 for z/OS database catalog
is shared, complications might occur in a shared environment.
Procedure
- To use DB2 for z/OS as
the database software for HCL Portal, you must have DB2 for z/OS installed on
your z/OS system.
Refer to the DB2 for z/OS product
documentation for instructions.
- Read the Planning for DB2 for z/OS topic before you configure DB2 for z/OS as the HCL Portal database.
- Check the buffer pool allocations for your system and define
the buffer pools as appropriate for your installation and define a
large enough size.
-db2 display bufferpool(bp2)
-db2 alter bufferpool(bp2) vpsize(15000)
- Repeat for extra buffer pools as needed.
For
example:
- bp3
- bp4
- bp5
- bp32k1
- bp32k2
- Update the BP8K0 catalog buffer pool to 35,000 buffers
before you transfer the database. Change this value according to your
environment. The SYSIBM.SYSDATABASE table is in this buffer pool and
is used extensively by DB2 for z/OS for
the database transfer.
-
Change the Common Service Area (CSA) setting to 3500,350000.
Read the appropriate
DB2 for z/OS topic for complete
information about calculating and setting CSA:
- During database transfer from Derby to DB2 for z/OS, a supporting
low-order byte table space is created for the database tables that
store documents. The PRIQTY and SECQTY for the table space are assigned
with the default values. If you plan to store many documents, use
an automatic class selection (ACS) routine to allocate the DB2 for z/OS data sets with
a primary and secondary space allocation of at least 10 cylinders.
Or, specify a large enough value for PRIQTY and SEQTY in
the DB2 DSNTIJUZ
member. The table spaces can be identified by their name, having
a structure like JCRDB.Sxxxxxxx, where xxxxxxx is
a system-assigned combination of seven numbers and characters.
- Also, in member DSNTIJUZ, update the following parameters
and then verify DSNTIJUZ runs successfully.
- edmdbdc = 204800
- edmpool=409600
- edmstmtc=204800
- rrulock=no
- rrulock=yes
- cachedyn=yes (prepared, dynamic SQL
statements are cached)
- dbacrvw=yes (to allow database
administrators to create Views)
- +++tbsbpxml=BP16K1 (to explicitly create
an XML table space. This value can be changed to any valid 16 K buffer pool where the Administrative
User has the USE privilege.)
- Ensure that the job DSNTIJSG ran to create the objects
that are needed for the DB2
JDBC and ODBC metadata methods. See the DB2 Installation Guide
Enabling stored procedures and tables for JDBC and ODBC support.
- Ensure that job DSNTIJMS runs successfully (re-execute
binds).
- Ensure that job DSNTIJEX runs successfully.
- Because large objects are stored in columns
that can become large, logging changes to these columns requires a
huge amount of log space. For this reason, large object (LOB) logging
is disabled by default for table spaces that contain such data. With
LOB logging disabled, you can recover full backups, but not incremental
backups that can be used for point in time recovery. To recover point
in time backups, you must enable LOB logging. For detailed instructions,
see technote 1306637, Managing LOB logging in DB2 for z/OS.
- Changes to DB2 for z/OS Version 9.1 that
is related to defaults buffer pools affect the CREATE LOB TABLESPACE
in that version of DB2 for z/OS.
The CREATE LOB TABLESPACE takes its default
buffer pool from ZPARM field TBSBPLOB if the
buffer pool is not explicitly specified, rather than taking the buffer
pool from the database.
LikeMinds
-
If you intend to run the LikeMinds sample, increase the NUMLKTS and NUMLKUS parameters: Ten times the
default is sufficient, more depending on your usage of the sample.
For example, if NUMLKTS=1000 and
NUMLKUS=10000 are the installation default
values, then update these values to NUMLKTS=10000 and NUMLKUS=100000.
Type 2 driver configuration
- If you are planning to use Type 2 driver with DB2 for z/OS Version 9.1.2,
ensure that DB2 for z/OS APAR
PK58105 is installed.
- If you are using the older DB2 Type 2 JDBC driver, enable
extended shared memory usage with the following commands:
export EXTSHM=ON
db2set DB2ENVLIST=EXTSHM
db2start
For permanent changes, add the environment variable to the
profile.env file:
DB2ENVLIST='EXTSHM'
in
/home/db2inst/sqllib/userprofile add:
export EXTSHM=ON
Note: The shell must be reopened before you restart DB2 for z/OS.
- If you are using the older DB2 Type 2 JDBC driver, configure
your DB2 Connect
client with the following commands:
db2 update dbm cfg using tp_mon_name WAS
db2 update dbm cfg using spm_name hostname
where
hostname
is the host name for the server where
the
DB2 Connect client is installed (same as portal
server).\
- If you are using the older DB2 Type 2 JDBC driver, install
the DB2 Connect
client on the HCL Portal server
to connect to the remote database.
What to do next
Use the Configuration
Wizard to set up and configure the database to work with HCL. You can use the wizard
to create custom scripts that you or your database administrator can
use to configure the database. You can also use the wizard to automatically
set up and configure the database. The wizard creates instructions
and scripts that are based on your selections and provided data.
When
you use the Configuration Wizard and provide information about your
database, consider the following points:
If you plan to use a single DB2 for z/OS subsystem to
hold data for more multiple installations, use the same user name
but a separate schema name for each database domain. For Member Manager, the user name
must match the schema; the same database user cannot be used for the Member Manager databases of two
distinct portal installations.
Each portal installation must be in separate
and distinct WebSphere® Application Server cells.
If the portals are installed in the same file system, each must be
installed in a separate and unique directory. If the portals are
installed in different file systems, the same directory name can be
used.
In a remote database environment, HCL Portal and DB2 Connect are installed
on one server (the local server) and the DB2 for z/OS server is installed
on a separate server (the remote server).
- Before you enter your database name (
dbdomain.DbName
) in the Configuration Wizard,
check your database documentation for restrictions on character length.
- You cannot use the Database Transfer option in the
Configuration Wizard to assign custom table spaces on your database server. You can perform manual
steps to assign custom table spaces. Go to Assigning custom table spaces for
more information.