OGG-02454Trail Not Found in Checkpoint File When Migrating a Coordinated ReplicatWhen migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat,
Rename a GoldenGate Extract with the REST API
In a previous blog, I went through the full procedure of renaming a GoldenGate extract from the adminclient. I included all necessary steps to avoid missing transactions. Doing this by hand is
The GoldenGate REST API Python client is now on pip
In a previous post, I shared the OGGRestAPI Python client I built for the GoldenGate REST API. Since then, I kept using it on production deployments, fixing it and adding new features along the way.
MongoDB DMK 2.6.0 : pymongo integration and new features
In this blog, I will present the new features introduced with the latest release (2.6.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having
Rename a GoldenGate Extract Without Missing Transactions
Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions. In this
GoldenGate DB2 z/OS Upgrade Checklist
Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a
NGINX Secured Distribution Path with GoldenGate REST API
In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI. But GoldenGate
GoldenGate 26ai out-of-place patching with Python
I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive. Let's do the exact same
Checking Long Running Transactions in GoldenGate
When doing complex operations with GoldenGate, checking for long running transactions is mandatory if you don't want to miss transactions. Let's look at two ways of retrieving such information, first
DB2 SQL1598N Licensing Error When Upgrading GoldenGate
While upgrading GoldenGate to 26ai for a DB2 z/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (*CLI Driver, in short) alongside it. Since I realized that DB2 driver know-how