IBM Support

PH20050: Q CAPTURE DELIMITED EP DOES NOT INCLUDE THE DAY FOR A TIMESTAMP WITH TIME ZONE COLUMN VALUE.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Q Capture delimited EP does not include the day for a TIMESTAMP
    WITH TIME ZONE column value if the day is December 31.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All SQL Apply users                       *
    *                 2- All Event Publication customers           *
    *                 3- All Event Publication customers           *
    *                 4- All Q Capture Proxy customers using Db2   *
    *                 V12 Function level 502 or higher.            *
    *                 5- All Q Capture customers                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- SQL Apply should perform TRUNCATE    *
    *                      of target table before fullrefresh if   *
    *                      its DATA CAPTURE CHANGES attribute is   *
    *                      not set                                 *
    *                      2- Q Capture delimited EP does not      *
    *                      include the day for a TIMESTAMP WITH    *
    *                      TIME ZONE column value if the day is    *
    *                      December 31.                            *
    *                      3- Q Capture delimited EP does not      *
    *                      prefix negative decimal column values   *
    *                      with a minus sign if the source table   *
    *                      CCSID is 37 or 500 and the              *
    *                      IBMQREP_SENDQUEUES MESSAGE_CODEPAGE is  *
    *                      the same as the source table CCSID.     *
    *                      4- Q Capture running in proxy mode      *
    *                      saves the SYSIBM.SYSTABLES schema in    *
    *                      its version tables as version 0. Q      *
    *                      Capture is unable to decode a Db2 V12   *
    *                      Function level 502 or higher            *
    *                      SYSIBM.SYSTABLES log records using      *
    *                      version 0 schema information.           *
    *                      5- Q Capture displays ASN0725W plus     *
    *                      diagnostic data and continues           *
    *                      executing after its log reader detects  *
    *                      out of order log records.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Currently SQL Apply always perform DELETE of target table
    before fullrefresh, regardless of the DATA CAPTURE CHANGES
    attribute of the target table.
    2- Q Capture delimited EP should always include the day for a
    TIMESTAMP(integer) WITH TIME ZONE column values.
    3- Q Capture delimited EP should prefix negative decimal column
    values with a minus sign.
    4- Q Capture running in proxy mode should delete old
    SYSIBM.SYSTABLES schema information from its version tables if
    activating a Db2 V12 Function level adds a column to
    SYSIBM.SYSTABLES.
    5- Q Capture will display ASN0725W plus diagnostic data,
    rollback uncommitted MQ transactions and reinitialize after its
    log reader detects out of order log records if its
    REINIT_LOGRECORDER is 'Y' (default). Q Capture will displays
    ASN0725W plus diagnostic data and continue executing after the
    log reader detects out of order log records if its
    REINIT_LOGRECORDER is 'N'.
    

Problem conclusion

  • 1- SQL Apply will determine how to delete the target table
    before a fullrefresh, based on the DATA CAPTURE CHANGES
    attribute of the target table.
    2- Q Capture delimited EP has been changed to always include
    the day for a TIMESTAMP WITH TIME ZONE column value.
    3- Q Capture delimited EP has been changed to prefix negative
    decimal column values with a minus sign.
    4- Q Capture has been changed to save the latest
    SYSIBM.SYSTABLES schema information in its version tables as
    the correct version.
    5- The Q Capture REINIT_LOGRECORDER parameter has been added to
    prevent data loss the log reader detects out of order log
    records
    Note: ASNCLP has been updated from db2_v111m4fp6 n2002110100.
    Functional level: 1140.103
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH20050

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-06

  • Closed date

    2020-02-20

  • Last modified date

    2020-04-02

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

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

    UI68024 UI68025 UI68026 UI68027

Modules/Macros

  •    ASNAAPP  ASNACMD  ASNACMP  ASNADMSP ASNAFET
    ASNAISO  ASNAMAN  ASNAPPLY ASNAPRS  ASNAWPN  ASNCAP   ASNCATM
    ASNCCMD  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA
    ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQASUB ASNQBRWZ ASNQCAP
    ASNQCCMD ASNQCTLZ ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE
    ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI68024

       UP20/03/04 P F003

  • RB34 PSY UI68025

       UP20/03/05 P F003

  • RB35 PSY UI68026

       UP20/03/04 P F003

  • RB36 PSY UI68027

       UP20/03/04 P F003

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":"B33","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 March 2020