IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR30554

  • 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

    2008-09-22

  • Closed date

    2008-11-07

  • Last modified date

    2008-11-07

  • 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

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"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:
07 November 2008