IBM Support

JR23916: 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

    JR23916

  • Reported component name

    WS II REPLICATI

  • Reported component ID

    5724C7415

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-05-15

  • Closed date

    2006-07-31

  • Last modified date

    2006-07-31

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

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

    JR25854

Fix information

  • Fixed component name

    WS II REPLICATI

  • Fixed component ID

    5724C7415

Applicable component levels

  • R820 PSY

       UP

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

Document Information

Modified date:
06 October 2021