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

Obtain the fix for this APAR.

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