IBM Support

IT38594: DOC: SEC_APPLY_POLLTIME SHOULD NOT BE SET TO A VALUE GREATER THAN 100 ON SECONDARY SERVERS WITHOUT SIGNIFICANT LOAD TESTING

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • The value of SEC_APPLY_POLLTIME, also considering
    OFF_RECVRY_THREADS and Number of CPU VPs, should not be set
    higher than 100, even though the DOCUMENTATION and onconfig.std
    recommend this for systems with more than 16 CPU VPs.
    
    If OFF_RECVRY_THREADS is set to higher than the number of CPU
    VPs, or even a significant proportion, together with
    SEC_APPLY_POLLTIME set to 1000, then the Logical Log Apply may
    thrash mreplay threads causing potentially significant
    performance degradation of Logical Log application on Secondary
    Servers.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Documentation prior to 14.10.xC8 release.                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    To set non zero value for SEC_APPLY_POLLTIME, OFF_RECVRY_THREADS
    onconfig value must be less than CPU VPs configured for the
    database server.
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT38594

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-10-05

  • Closed date

    2022-04-08

  • Last modified date

    2022-04-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
09 April 2022