IBM Support

JR25854: CANNOT USE THE REPLICATION CENTER TO REMOVE THE VALUE IN SEARCH_CONDITION IN ASN.IBMQREP_SUBS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running replication center with DB2 V8 fixpak 9 (also same
    problem with fixpak 11) on Windows.  A subscription set has a
    value for SEARCH_CONDITION in ASN.IBMQREP_SUBS.  Cust attempts
    to remove it by using
    RC->
     Q Replication->
       Definitions->
        Q Capture Servers ->
          Q  Capture Schemas->
            Q Subscriptions->
              Properties->'
                Subsetting' tab -> click on button for 'Rows'->
    change to 'All source table rows' -> ok.
    Cust expects a SQL statement to be generated, but he gets the
    following message - "The action did not generate any SQL scripts
    because the metadata already reflects the value to be updated."
    instead.  He has to work around the problem by issuing the SQL
    statement himself.
    
    Fix will be in fixpak 13.
    

Local fix

  • Removed the value using SQL outside of the replication center
    

Problem summary

  • AS DESCRIPED IN THE APAR
    

Problem conclusion

  • FIXED
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR25854

  • Reported component name

    WS Q-REPLIC LUW

  • Reported component ID

    5724N9801

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-02-01

  • Closed date

    2007-02-01

  • Last modified date

    2007-02-01

  • APAR is sysrouted FROM one or more of the following:

    JR23916

  • 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

  • R910 PSY

       

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 January 2022