Quick Beginnings

Planning to Use SPM

This section describes important planning considerations that you should take into account before attempting to install and use the SPM.

Software Prerequisites for SPM

The following minimum software levels are required to support the SPM. Refer to the README file for any additional PTFs that may be be required.

• With AIX:

  • SNA Server for AIX Version 2.1 or higher must be installed on the system where DB2 Connect Enterprise Edition for Version 5.0 is installed or on the DB2 Universal Database server that has SPM support installed.

  • The following PTFs are also required:

    AIX SNA Server/6000 2.1 PTFs
      PTF U437491 (fixes for APAR IX50393)
      PTF U437840 (fixes for APAR IX51831)
      PTF U440157 (fixes for APAR IX54025)
     
    AIX SNA Server/6000 2.2 PTFs
      PTF U437857 (fixes for APAR IX50393)
      PTF U440318 (fixes for APAR IX51831)
      PTF U444012 (fixes for APAR IX54025)
     
    AIX SNA Server/6000 3.1 PTFs
      PTF U440156 (fixes for APAR IX54025)
    

• With OS/2:

  • IBM Communications Server for OS/2 Warp Version 4 or higher must be installed on the system where DB2 Connect Enterprise Edition for Version 5.0 is installed or on the DB2 Universal Database server that has SPM support installed.

• With DB2 for MVS/ESA or DB2 for OS/390:

  All DB2/MVS V3.1 systems
    PTFs UN73393 and UN76673  (fixes APARs PN67179 and PN70102)
   
  All DB2/MVS V4.1 systems
    PTF UN76674 (fixes APARs PN70102 and PQO3146)
   
  All DB2 for OS/390 systems
    PTF UN76674 (fixes for APAR PQ03146) 
  

• With DB2 for AS/400:

  All DB2/400 V3R1 systems
    PTF SF27513 (fixes for OS/400 V3R1M0, product 5763SS1)
   
  All DB2/400 V3R6 systems
    PTF SF31329 (fixes APAR SA46917)
    PTF SF31329 (fixes for APAR SA48935)
  

• With DB2 for VSE & VM:

  The following APAR fixes are required:
    PQ01680
    PQ03829
    VM60922
    VM61072
    VM61194
  

Database Manager Configuration Parameters for SPM

The following database manager configuration parameters are required in order to use SPM, on workstations where a DB2 Connect Enterprise Edition is installed:

SPM_LOG_FILE_SZ

Determines the size of the SPM log file, in 4K pages. For more information about SPM logging, see "SPM Logging". The default value is 256.

SPM_MAX_RESYNC

Determines the number of SPM agents that can simultaneously perform resync operations. The default is 20.

SPM_NAME

Identifies SPM to both DB2 and SNA. This parameter must be set in order for SPM to start when the database manager is started. The default value for this parameter is NULL.

See "Configuring Communications Server for OS/2" for additional information about the use of this parameter with OS/2.

See "Configuring SNA Server for AIX" for additional information about the use of this parameter with AIX.

For more details about these parameters, see the Administration Guide.

Other Requirements

1. In addition to having the correct software prerequisites installed, additional planning is required in order to assign LU names for use by the SPM and its partners. See "Setting up Communications for the SPM" for further information about what actions may be required in your installation.

2. On AIX, the SNA Server list of Trusted Group Names should be updated to include the groups which will be able to start SPM. To list the trusted group name, use SNA Defaults.

3. Additional planning may also be required prior to defining your transaction manager database, and arranging for database manager configuration parameters to be set accordingly at application requesters and application servers.

4. Ensure that your DRDA2 host databases are syncpoint-enabled. Contact your database administrator. For example, when using DB2 for MVS/ESA or DB2 for OS/390, the VTAM APPL statement that defines the DDF LU must include SYNCLVL=SYNCPT. See "Sample VTAM APPL Definition for OS/390" and the DB2 Connectivity Supplement.

[ DB2 List of Books | Search the DB2 Books ]