PM76957: SQL CAPTURE ABEND0C4 AFTER PERMANENT COMPRESSION DICTIONARY ERROR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If SQL capture detects a permanent compression dictionary error,
  ASN0011E with RC 00C90064 and option stopOnError=N capture
  deletes the table registration from memory without unlinking
  the table registration.  Capture will then issue abend0c4 when
  it attempts to locate another table in memory.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Capture                                   *
  *                 2- Q Capture                                 *
  *                 3- A Apply                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- ASN0633W message is continually      *
  *                      issued until the capture program is     *
  *                      restarted.                              *
  *                      2- If the heartbeat_interval is less    *
  *                      than zero, it sends heartbeats every    *
  *                      500ms.                                  *
  *                      3- Q Apply failed to load from a        *
  *                      source table with 2.5 billion rows due  *
  *                      to sqlcode -802                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Capture is not detecting the commit for a transaction in the
  log
  2- Q Capture does not validate heartbeat_interval.
  3- Q Apply failed with sqlcode -802 because the internal host
  variable is not big enough to hold more than 2.1 billion rows
  

Problem conclusion

• 1- Capture is changed to also detect the BEGIN COMMIT2 log
  record to prevent missing transaction commits
  2- Q Capture will issue ASN7262W and disable heartbeats if the
  heartbeat_interval is less than zero
  3- Change the Q Apply host variable from a 4-byte int to a
  8-byte bigint to hold the number of rows
  

Temporary fix

Comments

APAR Information

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

  PM76956

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

  UK91278 UK91279 UK91281 UK91282

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD ASNQAPP  ASNQASUB
  ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT ASNQXFMT
  ASNQ1001 ASNRBASE ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RA10 PSY UK91278

     UP13/02/07 P F302

• RA11 PSY UK91279

     UP13/02/08 P F302

• RA12 PSY UK91281

     UP13/02/07 P F302

• RA13 PSY UK91282

     UP13/02/07 P F302

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.