IBM Support

PK44946: QCAPTURE CAN FLOOD THE IBMQREP_IGNTRANTRC TABLE CAUSING PROBLEMS DURING PRUNE PROCESS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Qcapture when using the ignore transaction feature can flood
    the IBMQREP_IGNTRANTRC table.  Qcapture inserts a row into the
    IBMQREP_IGNTRANTRC for each transaction ignored.  Qcapture
    ignores transactions that satisfy criteria set by the customer
    in the IBMQREP_IGNTRAN table.  If the critera causes Qcapture
    to ignore thousands of rows then thousands of rows are inserted
    into the IBMQREP_IGNTRANTRC as documentation.
    This APAR will provide an option to tell Qcapture whether or not
    to insert rows into the IBMQREP_IGNTRANTRC.
    Qcapture can appear unresponsive as it goes into a
    prune cyle of the IBMQREP_IGNTRANTRC.
    The option to insert rows into IBMQREP_IGNTRANTRC
    will be made available through a new column in the
    IBMQREP_IGNTRAN table.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- Q Capture customers who use the ignore    *
    *                 transaction feature                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Q Capture inserts a row into its     *
    *                      IBMQREP_IGNTRANTRC table each time it   *
    *                      ignores a transaction.  Q Capture       *
    *                      ignores transactions that satisfy       *
    *                      exclusion criteria which is specified   *
    *                      in its IBMQREP_IGNTRAN table.  Q        *
    *                      Capture inserts thousands of rows into  *
    *                      its IBMQREP_IGNTRANTRC table if its     *
    *                      exclusion criteria causes it to ignore  *
    *                      thousands of transactions.              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Q Capture should insert rows into its IBMQREP_IGNTRANTRC
    table on a transaction exclusion criteria basis.
    

Problem conclusion

  • 1- Provide an option to specify whether or not Q Capture will
    insert a row into its IBMQREP_IGNTRANTRC table each time it
    ignores a transaction.  The option will be specified using a
    new IBMQREP_IGNTRAN table column.
    
    The ALTER TABLE syntax:
    ALTER TABLE ASN.IBMQREP_IGNTRAN ADD IGNTRANTRC CHAR(1) NOT NULL
    DEFAULT 'Y';
    
    For each row in the IBMQREP_TRAN table, specify 'Y' for the
    IGNTRANTRC column to enable tracing for the ignored transaction
    based on the criteria. Otherwise, specify 'N' to disable
    tracing.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK44946

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-05-10

  • Closed date

    2007-05-12

  • Last modified date

    2007-06-01

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

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

    UK25040 UK25041 UK25042 UK25043

Modules/Macros

  •    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
    ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD ASNQAPP  ASNQCAP
    ASNQCCMD ASNQDEP  ASNQMFMT ASNQXFMT ASNRBASE ASNSQLCF ASNTDIFF
    ASNTRC   ASNTREP  ASNTXS
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • R820 PSY UK25040

       UP07/05/23 P F705

  • R821 PSY UK25041

       UP07/05/23 P F705

  • R822 PSY UK25042

       UP07/05/23 P F705

  • R823 PSY UK25043

       UP07/05/23 P F705

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.

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

Document Information

Modified date:
01 June 2007