JR30554: REPLICATION CENTER RUNNING ON DB2 V9.5 FP2 CREATES IBMQREPVERNODE AND IBMQREPVERTIME IN UPPER CASE (NOT MIXED CASE)

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• REPLICATION CENTER RUNNING ON DB2 v9.5 FP2 CREATES
  ibmqrepVERNODE and ibmqrepVERTIME in UPPER CASE (not mixed case)
  
  Prior to FP2 Qcapture only recogonises mixed case.
  So if v9.5 FP2 Replication center is used to create Peer to Peer
  Q subscriptions, the alters to the base tables will have upper
  case IBMQREPVERNODE and IBMQREPVERTIME columns and pre-FP2
  QCAPTURE will fail.
  

Local fix

• Manually modify the script generated by repcenter to use mixed
  case before running when creating the q subscription or
  us pre-FP2 Replication center to generate script.
  

Problem summary

• AS DESC IN APAR
  

Problem conclusion

• FIXED IN API TO CREATE UPPERCASE COL ONLY IF
   THE DB2 LEVEL IS >=V95FP2
  

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

  WS Q-REPLIC LUW

• Fixed component ID

  5724N9801

Applicable component levels

• R950 PSY

     UP