PM07865: SQL APPLY - CHANGES TO ASN0999E MESSAGE HANDLING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQL APPLY - changes to ASN0999E message handling.  Current SQL
  apply examines both synchtime and synchpoint and if either value
  is about to be regressed Apply will post ASN0999E.  This apar
  will change the test to only examine the synchpoint.
  Additionally ASN0999E will become ASN0999I (informational rather
  than a hard error).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- SQL Apply                                 *
  *                 2- SQL Q/Capture DB2 V9 NFM                  *
  *                 3- Users that invoke asntdiff in command     *
  *                 line                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Apply log contains ASN0999E message  *
  *                      when register global SYNCHTIME is       *
  *                      lower than previous value               *
  *                      2- After an alter table add column to   *
  *                      a source table in basic row format      *
  *                      (BRF), the capture program inserts      *
  *                      rows into the version table.            *
  *                      3- Using following command: asntdiff    *
  *                      db=tgtdb                                *
  *                      where="target_table='TGtab002'" result  *
  *                      in following errors:                    *
  *                      2009-11-20-20.21.06.866749 ASN4013E     *
  *                      "AsnTDiff" : "ASN" : "Initial" : The    *
  *                      program stopped because the WHERE       *
  *                      clause was not valid. It returned "0"   *
  *                      subscription members or Q               *
  *                      subscriptions.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Apply should not issue ASN0999E message when register global
  SYNCHTIME is lower than previous value
  2- Capture is incorrectly inserting rows in to the version
  tables for tables in BRF
  3- The target table name enclosed in single quotes is errorly
  changed to uppercase. Also values for SCHEMA, DB2_SUBSYSTEM,
  DIFF_TABLESPACE, DIFF_SCHEMA, DIFF is wrongly changed to
  uppercase.
  

Problem conclusion

• 1- Apply stop issuing ASN0999E message when register global
  SYNCHTIME is lower than previous value
  2- Capture will not insert rows into the version table for an
  alter table add column if the table is in BRF.
  3- This fix allows asntdiff to deal with values enclosed by
  single quotes in where clause as case sensitive. Asntdiff also
  deals with values for SCHEMA, DB2_SUBSYSTEM, DIFF_TABLESPACE,
  DIFF_SCHEMA, DIFF as case sensitive no matter it is enclosed in
  double quotes or not.
  

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:

  UK54742 UK54743 UK54744 UK54745

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNAPRS  ASNCAP
  ASNCCMD  ASNLOAD  ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNPRUNE
  ASNQACMD ASNQAPP  ASNQCAP  ASNQCCMD ASNQDEP  ASNQMFMT ASNQXFMT
  ASNRBASE ASNREG   ASNTDIFF ASNTRC   ASNUOW   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY UK54742

     UP10/03/06 P F003

• R911 PSY UK54743

     UP10/03/09 P F003

• R912 PSY UK54744

     UP10/03/06 P F003

• R913 PSY UK54745

     UP10/03/06 P F003

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.