A few weeks ago, I was playing with the Change Data Capture API that became available with IDS 11.50.xC3. The API is used through a database connection using the informix user.
With this API, you can read logs and decide what to do with them. The types of records provided include:CDC_REC_BEGINTX: Begin TransactionCDC_REC_COMMTX: Commit TransactionCDC_REC_RBTX: Rollback TransactionCDC_REC_INSERT: Insert rowCDC_REC_DELETE: Delete rowCDC_REC_UPDBEF: Update row before imageCDC_REC_UPDAFT: Update row after imageCDC_REC_DISCARD: Discard log records after LSNCDC_REC_TRUNCATE: Truncate tableCDC_REC_TABSCHEM: Format of I/U/D recordsCDC_REC_TIMEOUT: Read timeoutCDC_REC_ERROR: Error description
This API opens the door to a lot of possibilities. You could monitor specific tables that contain sensitive information and generate alerts based on what appens. You could take some insert and send them to another system through the mechanism of your choice Lots of possibilities.
What about if you don't want to write a program to manipulate the logs? No problem! Take a look at the InfoSphere Change Data Capture software. You could replicate information to another system even using message queues. For more information, take a look at the following URL:
Till next time!