PH25794: QCAPTURE CAPMON TABLE CURRENT_LOG_TIME VALUE IS 1900-01-01-00.00.00.000000

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The current_log_time in IBMQREP_CAPMON table is
  1900-01-01-00.00.00.000000
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All replication users                     *
  *                 2- All SQL Apply users                       *
  *                 3- All Capture users                         *
  *                 4- All Q Capture users                       *
  *                 5- All Q Capture users                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Capture ZOS retries MQCMIT, MQPUT    *
  *                      and MQBACK when the first call returns  *
  *                      error code, which causes message lost,  *
  *                      as the second call may return OK        *
  *                      2- SQL Apply ASNLOAD UID does not       *
  *                      conform with underscore character       *
  *                      3- Capture is causing contention over   *
  *                      DSNDB01.SPT01                           *
  *                      4- Q Capture issued message ASN7181E    *
  *                      incorrectly                             *
  *                      5- The current_log_time in              *
  *                      IBMQREP_CAPMON table is                 *
  *                      1900-01-01-00.00.00.000000              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Messages may get lost because the error return code of MQ
  API is over written by a OK return code of second call and
  capture cannot detect it.
  2- When the Apply qualifier included an underscore '_'
  character, ASNLOAD failed because it passed an invalid UID
  (which is made up of Apply Qualifer and timestamp) to Db2 LOAD
  utility.
  3- Q Capture worker thread is selecting from sysibm.systables
  and not committing. This is causing issues in the maintenance
  of this table.
  4- ASN7181E is changed to an 'informational' message and the
  message text is updated.
  5- The CURRENT_LOG_TIME value in the IBMQREP_CAPMON table is
  not updated when the Q capture server is restarted.
  

Problem conclusion

• 1- With this fix, capture only tries MQCMIT, MQPUT and MQBACK
  once.
  2- SQL Apply ASNLOAD user exit should remove any underscore
  character before using the apply qualifier as part of the UID
  when calling the Db2 LOAD utility.
  3- Q Capture is changed to execute COMMIT to free locks on DB2
  system catalogs.
  4- Q Capture is changed to issue ASN7181I message only once
  when retrying the log read error.
  5- Use a new set of variables to keep track of log read
  information.
  ASNCLP was not updated.
  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:

  UI70363 UI70364 UI70365 UI70366

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM
  ASNCCMD  ASNLOAD  ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQCAP
  ASNQCCMD 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 UI70363

     UP20/07/10 P F007

• RB34 PSY UI70364

     UP20/07/11 P F007

• RB35 PSY UI70365

     UP20/07/10 P F007

• RB36 PSY UI70366

     UP20/07/10 P F007

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.