Fixes are available
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 number
JR33911
Reported component name
REPLICATION SER
Reported component ID
5724N9800
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-05
Closed date
2010-02-26
Last modified date
2010-02-26
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
Document Information
Modified date:
12 October 2021