-->

+

Search Tips   |   Advanced Search

Install and prepare DB2 for z/OS

Use this information to install DB2 for z/OS for use with HCL Digital Experience.

  1. To use DB2 for z/OS as the database software for HCL WebSphere Portal, we must have DB2 for z/OS installed on your z/OS system. Refer to the DB2 for z/OS product documentation for instructions.
  2. Read the Plan for DB2 for z/OS topic before we configure DB2 for z/OS as the HCL WebSphere Portal database.
  3. Check the buffer pool allocations for the system and define the buffer pools as appropriate for the installation and define a large enough size. 

      -db2 display bufferpool(bp2) 
-db2 alter bufferpool(bp2) vpsize(15000)

    1. Repeat for extra buffer pools as needed. For example:

      • bp3
      • bp4
      • bp5
      • bp32k1
      • bp32k2

  4. Update the BP8K0 catalog buffer pool to 35,000 buffers before you transfer the database. Change this value according to the environment. The SYSIBM.SYSDATABASE table is in this buffer pool and is used extensively by DB2 for z/OS for the database transfer.

  5. 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:

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

    1. 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.)

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

  8. Ensure that job DSNTIJMS runs successfully (re-execute binds).

  9. Ensure that job DSNTIJEX runs successfully.
  10. 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, we can recover full backups, but not incremental backups that can be used for point in time recovery. To recover point in time backups, enable LOB logging. For detailed instructions, see technote 1306637, Managing LOB logging in DB2 for z/OS.

  11. Changes to DB2 for z/OS v9.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

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

  1. To use Type 2 driver with DB2 for z/OS v9.1.2, ensure that DB2 for z/OS APAR PK58105 is installed.

  2. If we 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 .

  3. If we 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).\

  4. If we are using the older DB2 Type 2 JDBC driver, install the DB2 Connect client on the HCL WebSphere 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. We can use the wizard to create custom scripts that you or the database administrator can use to configure the database. We 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 we use the Configuration wizard and provide information about the database, consider the following points: