IBM Support

PH36439: ADD CAPTUREUPTO AS Q CAPTURE STARTUP PARAMETER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Add CAPTUREUPTO as Q Capture startup parameter
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All users                                 *
    *                 2- all SQL Apply users                       *
    *                 3- Users who want to use parameter           *
    *                 CAPTUREUPTO                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- When customer got email alerts they  *
    *                      need to open each email to see the      *
    *                      detail information to see for which     *
    *                      DB/SCHEMA/CONDITION name the warning    *
    *                      message occurs.                         *
    *                      2- SQL Apply high CPU consumption in    *
    *                      ASNAISO after migration to DB2 V12      *
    *                      3- Add CAPTUREUPTO as Q Capture         *
    *                      startup parameter                       *
    ****************************************************************
    1- Customer have to open the email to get details on
    DB/SCHEMA/CONDITION name the for the alert messages.
    2- The CPU costs increased dramatically in apply after
    migration to DB2 V12.
    3- Add CAPTUREUPTO as Q Capture startup parameter
    

Problem conclusion

  • 1- The alert email subject is more detailed to include the
    server alias, schema, condition name and msg code.
    old subject: ASN5134I MONITOR "" : "WorkerThread". Alert
    issued. Msg Code ASN5153W
    new subject: ASN5134I MONITOR "" : "WorkerThread". Alert issued
    for server alias SERVER_ALIAS, schema SCHEMA_OR_QUAL, condition
    CONDITION_NAME. Msg Code ASN5153W
    2- Change query to use INDEXONLY access.
    3- Add CAPTUREUPTO as Q Capture startup parameter
    Note: ASNCLP has been updated from db2_v111m4fp7 s2106251900.
    Function Level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH36439

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2021-04-19

  • Closed date

    2021-06-29

  • Last modified date

    2022-06-10

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

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

    UI76135 UI76136 UI76137 UI76138

Modules/Macros

  • ASN2BASE ASNACMD  ASNADMSP ASNAISO  ASNAPPLY ASNCAP   ASNCATM
    ASNCCMD  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA
    ASNMCMD  ASNMON   ASNMUPDT ASNQACMD ASNQAPP  ASNQCAP  ASNQCCMD
    ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP
    ASNTRC
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI76135

       UP21/07/07 P F107  

  • RB34 PSY UI76136

       UP21/08/02 P F107  

  • RB35 PSY UI76137

       UP21/08/02 P F107  

  • RB36 PSY UI76138

       UP21/07/07 P F107  

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]

Document Information

Modified date:
11 June 2022