Skip to Main Content
Cloud Management and AIOps


This is an IBM Automation portal for Cloud Management, Technology Cost Management, Network Automation and AIOps products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Submitted
Created by Guest
Created on Feb 23, 2026

JDBC gateway in audit mode is unable to record DELETE in historical DB automatically at present when custom field is used in FILTER WITH clause in the table replication file

At present, JDBC gateway provides flexibility about sending events to Historical DB in audit mode based on changes in a custom field (instead of default StateChange field). This can be achieved by modifying FILTER WITH condition in table replication file to look for matching custom field value so that the gateway reads alarms from Objectserver which are matching with the custom flag field and then send record to Historical DB. Further changes to the alarm also can be flagged using custom flag field using following technote to forward those changes to Historical DB.

https://www.ibm.com/support/pages/using-flag-field-track-updated-events-reporter-database-archival

However the current JDBC gateway configuration/binary doesn't allow to send record to Historical DB automatically (as a ACTIONCODE "D") just prior to deletion of alarm in Objectserver. 

Is it possible to achieve this i.e. send DELETE record with ACTIONCODE "D" by JDBC gateway (in audit mode) to Historical DB automatically just before alarm deletion in Objectserver? This requirement is quite similar to current mechanism of JBDC gateway in audit mode in which it sends record to Historical DB automatically as ACTIONCODE "D" but only when it is reading alarms from Objectserver based on StateChange field i.e. any change on the alarm in Objectserver is immediately forwarded to Historical DB as an individual record.

This feature will help other customers too by allowing full flexibility in using custom field in FILTER WITH condition of table replication file. By default, the gateway reads from Objectserver based on StateChange field i.e. any change INSERT/UPDATE/DELETE to alarm in Objectserver is forwarded to Historical DB as an individual record.
 

Idea priority High