PH38468: Q Capture messages to diagnose log reading in Db2 proxy mode

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR consists of the following changes:
  .
  a) Issue message ASN7327W on the first indication of no
     progress in reading log records.
  .
  b) Modify message indicating that progress has resumed to
     include the LRSN.
  .
  c) Validate that the partition number calculated for a
     log record for this particular tablespace only is
     correct and if it is not then take an abend dump.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: QCapture proxy mode users                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Add Q Capture messages to diagnose log  *
  *                      reading in Db2 proxy mode               *
  ****************************************************************
  Add Q Capture messages to diagnose log reading in Db2 proxy mode
  

Problem conclusion

• 1. Issue a message when no beginUR log record is returned in
  proxy mode
  2. Issue ASN7327W "no progress" on first occurrence and every
  100 occurrences thereafter; instead of after the 5th
  occurrence.  Issue ASN9999W instead of ASN7328D when log
  reading is making progress again, and report current LRSN and
  endscope LRSN
  3. For subscriptions by partitions on compressed tablespaces, Q
  Capture verifies that the partition number derived from the
  page number is the same as the partition number returned by Db2
  in the log record header (requires a Db2 usermod) and issues a
  diagnostic message if they are not the same.
  4. Issue a message reporting the last LSN read and the number
  of rows read so far for long running transaction that exceed
  the 'STALE' limit (default 1 hour), in addition to issuing
  message ASN0633W
  ASNCLP was not updated.
  Function 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:

  UI76241 UI76242 UI76243 UI76244

Modules/Macros

• ASN2BASE ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM  ASNCCMD
  ASNMCMD  ASNMON   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 UI76241

     UP21/07/13 P F107  

• RB34 PSY UI76242

     UP21/07/13 P F107  

• RB35 PSY UI76243

     UP21/07/13 P F107  

• RB36 PSY UI76244

     UP21/07/13 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.