Install DB2 for z/OS

 

+
Search Tips   |   Advanced Search

 

You are here

  1. Planning for DB2 for z/OS
  2. Installing DB2 for z/OS (Current task)
  3. Creating databases and users for DB2 for z/OS
  4. Transferring DB2 for z/OS manually or Transferring between databases manually
  5. Verifying database connections

This section explains some important notes and prerequisites to consider before installing IBM DB2 Universal Database™ for z/OS for use with IBM WebSphere Portal.

 

Before you begin

 

Install

To use DB2 for z/OS as the database software for WebSphere Portal, have DB2 for z/OS installed on the z/OS system. Refer to the product documentation at http://www.ibm.com/software/data/db2/os390/library.html for instructions. The following prerequisites must exist separately from the WebSphere Portal installation.

  • Configure the 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 machine where the DB2 Connect client is installed (same as portal machine).

  • Enable extended shared memory usage with the following commands: 

    export EXTSHM=ON
db2set DB2ENVLIST=EXTSHM
db2start
    To make the change permanent, add the environment variable by adding the following to the profile.env file: 

    DB2ENVLIST='EXTSHM'
    in /home/db2inst/sqllib/userprofile add: 

    export EXTSHM=ON

    The shell must be reopened before restarting DB2.

  • The DB2 Connect client must be installed on the same machine as WebSphere Portal. This is because WebSphere Portal currently only supports the DB2 Legacy Type 2 JDBC driver. This driver requires DB2 Connect be installed on the same machine as WebSphere Portal to connect to the remote database.

  • The DB2 subsystem must be on a z/OS or OS/390 platform.

Verify the readiness of the DB2 for z/OS configuration before database transfer Do the following to ensure the DB2 for z/OS configuration is ready for database transfer:

  • Run the RUNSTATS utility on the SYSCAT.

  • For DB2 for z/OS version 8, increase the 8K buffer pool to 10000 pages. The following is a sample command: 

    ALTER BUFFERPOOL (BP8K0) VPSIZE(10000)

  • For DB2 for z/OS version 7, increase the 4K buffer pool to 5000 pages. The following is a sample command: 

    ALTER BUFFERPOOL (BP0) VPSIZE(5000)

 

Next steps

You have completed this step. Continue to the next step by choosing one of the following topics:

 

Related information

 

Parent topic:

Install databases