Quick Beginnings for DB2 Connect Enterprise Edition

Planning to Use the SPM

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

Software Prerequisites for the SPM

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

• AIX SNA connectivity:

  • SNA Server for AIX Version 2.1 or higher must be installed on the system where DB2 Connect Enterprise Edition 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)
    

• OS/2 SNA connectivity:

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

  • Windows NT SNA Connectivity:

    • IBM Communications Server for Windows NT Version 5.01 or higher must be installed on the system where DB2 Connect Enterprise Edition is installed or on the DB2 Universal Database server that has SPM support installed.

  • 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
      Apply ESO tape 9802 (February, 1998)
      Exclude the following PTFs from ESO tape 9802:
        UQ12940
        UQ12897
        UQ13903
      Install the following additional PTFs:
        UQ15503
        UQ15036
      Install the fix for APAR PQ15977
     
    OS/390 TCP/IP
      PTF PQ14253 (V3R3, V3R4)
      PTF PQ14383 (V3R3)
     
    

  • 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, if SNA connectivity is being used, for the SNA product. 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. If TCP/IP connectivity is being used with the host system, ensure this name is unique in your network.

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

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 if you are using SNA connectivity. See "Setting up SNA Communications for the DB2 Syncpoint Manager (SPM)" for further information about what actions may be required in your installation.

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

3. Ensure that your host databases are syncpoint-enabled. Contact your database administrator. For example, when using DB2 for MVS/ESA or DB2 for OS/390 and SNA connectivity, 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 ]