APAR status
Closed as program error.
Error description
Rows in the IBMQREP_SIGNAL table are not pruned when Q Capture for Oracle is running against Oracle 11g and higher.
Local fix
Problem summary
The rows in the IBMQREP_SIGNAL are not pruned because the state is never updated to indicate a completion of the signal processing. The update fails because the SIGNAL_TIME is collected from the log record and Oracle had a bug in LogMiner that omitted the sub-second precision in Oracle 10g (all versions). The employed workaround in Q Capture retrieved the sub-second precision from the SIGNAL_TIME contents in the IBMQREP_SIGNAL as 0 to allow for matching to a timestamp value from the log record. Because the value returned in the log record with Oracle 11g contains the sub-second precision correctly the SIGNAL_TIME value does not match anymore and hence the state update does not occur.
Problem conclusion
Q Capture for Oracle query to update the signal state has been fixed. It works now for Oracle versions 10 and above. The fix will be available in DB2 LUW V9.7 FP8.
Temporary fix
Comments
APAR Information
APAR number
JR45635
Reported component name
WS Q-REPLIC LUW
Reported component ID
5724N9801
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-02-04
Closed date
2013-02-04
Last modified date
2013-02-04
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
WS Q-REPLIC LUW
Fixed component ID
5724N9801
Applicable component levels
R970 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 February 2013