PH64273: SQL APPLY FAILED WITH SQLSTATE 42601 during fullrefresh

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQL APPLY FAILED WITH SQLSTATE 42601 during fullrefresh
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- all Capture users                         *
  *                 2- SQL Apply users                           *
  *                 3- All Capture users                         *
  *                 4- Users running Java 21                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Need a new Capture message when the  *
  *                      flag QW0306CDDSN is set                 *
  *                      2- SQL APPLY FAILED WITH SQLSTATE       *
  *                      42601 during fullrefresh                *
  *                      3- Change the default for capparm       *
  *                      IFI_FILTER_PARTS to N                   *
  *                      4- Validate that ASNCLP can run on      *
  *                      Java 21                                 *
  ****************************************************************
  1- When IFI306 encounters a log record that should have its
  expansion dictionary in the CDDS but for some reason it cannot
  be found, the Db2 QW0306CDDSN flag is set. Capture should
  report  ASN7895W  msg once for each partition of the table
  space for which it did not use CDDS.
  2- SQL Apply running on zos failed with SQLSTATE 42601 when
  executing a TRUNCATE SQL statement with the RESTRICT WHEN
  DELETE TRIGGER option during fullrefresh and the target table
  is on LUW server.
  3- Default for IFI_FILTER_PARTS  is set to N. Customer needs to
  change it to Y if they use SUBS by partition.
  4- ASNCLP should work with  Java 21.  Please see the 2 updated
  samples, asnclpev and asnclpb.
  

Problem conclusion

• 1- Capture message asn7895 will be issued if the Db2
  QW0306CDDSN flag is set
  2- To get around the problem, SQL Apply program needs to
  specify the IMMEDIATE keyword.
  3- Change the default for capparm IFI_FILTER_PARTS to N.
  4- Successfully ran ASNCLP on Java 21 using the JVMPRC21 proc.
  Please see the updated Samples asnclpev and asnclpb.
  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:

  UO02364 UO02365 UO02366 UO02367

Modules/Macros

• ASN2BASE ASN2DBCN ASN2ZOSC ASNAAPP  ASNACMD  ASNADMSP ASNAPPLY
  ASNCAP   ASNCATM  ASNCCMD  ASNCDINS ASNCLPB  ASNCLPEV ASNDBCON
  ASNMCMD  ASNMON   ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW
  ASNQASUB ASNQBRWZ ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ
  ASNQMFMT ASNQP2PA ASNQP2PI ASNQSPIL ASNQXFMT ASNRBASE ASNTDIFF
  ASNTDSP  ASNTRC   ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UO02364

     UP25/03/11 P F503

• RB34 PSY UO02365

     UP25/03/12 P F503

• RB35 PSY UO02366

     UP25/03/11 P F503

• RB36 PSY UO02367

     UP25/03/11 P F503

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.