JR33911: REPL ADMIN APAR FOR V97FP1

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• fix POS findings and fvt/svt  defects
  

Local fix

• all fix will be in the fp1 fixpack
  

Problem summary

• Defect: 579871
  Release: V97 FP1
  User Affected: V97 asntdiff users that compare column of type
  TIMESTAMP(0)
  Problem Description: asntdiff could not handle the new format of
  TIMESTAMP(0) column types
  Problem Summary: asntdiff ran into an assertion failure when
  TIMESTAMP(0) columns are involved
  Problem Conclusion: This fix implements TIMESTAMP(0) support in
  SQL statements for asntdiff.
  
  Defect: 580406
  Release: V9.7 FP1
  User Affected: Users that run asntdiff/asntrep with very long
  schema and table names
  Problem Description: Very long schema and table name could
  result in unpredictable asntdiff/asntrep errors
  Problem Summary: The buffers provided in asntdiff/asntrep are
  not big enough to handle SQL statements with very long schema
  and table names
  
  Defect: 575496
  Release: v91f1
  User Affected: Customers who use Q Capture to publish delimited
  messages.
  Problem Description:  Q Capture abends with S0C4 publishing
  delimited messages when its message buffer contains multiple
  rows and there is just enough space remaining in the message
  buffer for one delimited message header.
  Problem Summary:  Q Capture writes one byte beyond the end of
  its message buffer and overlays the next block of memory.
  Problem Conclusion: Modify Q Capture to correct this problem.
  
  Defect: wsdbu00576406
  User Affected: Q Replication users
  Problem Description: The "Next"and "Properties" buttons can't
  work when  creating Q Subscriptions in RC, and asnccmd
  parameters generated incorrectly within RC.
  Problem Summary: Account for federated SP targets and prefill
  area selection filters for SPs. Also properly construct asnccmd.
  Problem Conclusion: SP filter support and asnccmd parameter
  construction fixed.
  
    wsdbu00576089  REPV97FP1:ASNCLP program can't create SQL
  replication CONTROL TABLES FOR CAPTURE SERVER in sybase
  federation DB
  Problem: Problem with create control tables on Sybase because of
  the change to JCC driver.
  Description: The generated script is changed so that commit
  statement is not generated explicitly.
  

Problem conclusion

• fixed in FP1
  

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:

Fix information

• Fixed component name

  REPLICATION SER

• Fixed component ID

  5724N9800

Applicable component levels

• R970 PSY

     UP