Fixes are available
APAR status
Closed as program error.
Error description
Local fix
Problem summary
The following Replication Server admin problem has been fixed in DB2 LUW V9.5 FP8: . 834013:REPCENTER generates an invalid DDL when registering a view created with "JOIN... ON" clause as replication source . Problem Description: REPCENTER and ASNCLP cannot handle a view created with a "JOIN.. ON" clause. An invalid DDL is generated in the generated script. IBM CLI Driver DB2/NT SQL0104N An unexpected token "IDX" was found following ") AS SELECT CAT JOIN". Expected tokens may include: "FROM". SQLSTATE=42601 . Problem Conclusion: Modified the view parser logic to check if the view is defined with a JOIN clause, and if there is, obtain the dependent views information correctly.
Problem conclusion
Refer to the previous section.
Temporary fix
Comments
APAR Information
APAR number
JR38794
Reported component name
WS Q-REPLIC LUW
Reported component ID
5724N9801
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-31
Closed date
2011-08-08
Last modified date
2011-08-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC75832
Fix information
Fixed component name
WS Q-REPLIC LUW
Fixed component ID
5724N9801
Applicable component levels
R950 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.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 August 2011