PM76956: 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- non-parallel ASNTDIFF                     *
  *                 2- SQL capture                               *
  *                 3- SQL Capture customers.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1-  When the spill file (2GB at most)   *
  *                      is not large enough, the customer will  *
  *                      get the following message: "asntdiff    *
  *                      fseek errno: : EDC5027I The position    *
  *                      specified to fseek() was invalid.       *
  *                      (errno2=0xC03D0020)".                   *
  *                      2- ASN0070 when trying to register a    *
  *                      table with 2 columns that have very     *
  *                      similar names. The first column is 17   *
  *                      characters and the second column is     *
  *                      the exact same name concatenated with   *
  *                      an 18th character. This only occurs     *
  *                      when there is a before image prefix     *
  *                      specified.                              *
  *                      3-  SQL Capture started specifying      *
  *                      STOP_ON_ERROR = 'N' terminates with     *
  *                      ABENDS0C4 after displaying ASN0011E.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Non-parallel ASNTDIFF requires a spill file for storing key
  values, but the spill file (2GB at most) might be not large
  enough to hold all the key values.
  2- Capture was incorrectly checking for 18 character column
  names and treating them as if 18 were the maximum column name
  length. DB2 V7 had maximum column name lengths of 18.
  3-  SQL Capture stops a source table registration and removes
  the registration information from its memory if it was started
  specifying STOP_ON_ERROR = 'N' and the DB2 compression
  dictionary for the source table no longer exists.  SQL Capture
  terminates with ABENDS0C4 when it references the source table
  registration information it has removed.
  

Problem conclusion

• 1- An ASN message ASN4076E is issued to indicate that the users
  should split and compare the source and target tables.
  2- Capture will correctly load and activate this registration.
  3-  Modify SQL Capture to fix this problem.
  

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:

  PM76957 UK83989 UK83990 UK83991 UK83992

Modules/Macros

• ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNCCPWK ASNCDINS ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD
  ASNQAHKT ASNQAPAG ASNQAPP  ASNQCAP  ASNQCCMD ASNQDEP  ASNQMFMT
  ASNQXFMT ASNRBASE ASNTDIFF ASNTRC   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY UK83989

     UP12/12/13 P F212

• R911 PSY UK83990

     UP12/12/14 P F212

• R912 PSY UK83991

     UP12/12/13 P F212

• R913 PSY UK83992

     UP12/12/13 P F212

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.