Bug #56268 IBMDB2I Engine-Updates from DB2 for i Update Master but Not Replicated to Slave
Submitted: 25 Aug 2010 19:09 Modified: 3 Apr 2011 12:33
Reporter: Jack Collins Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.1.43 OS:IBM i
Assigned to: CPU Architecture:Any
Tags: ibmdb2i, replication

[25 Aug 2010 19:09] Jack Collins
If you make changes (INSERT or UPDATE) to a mysql table using DB2 for i tools such as STRSQL, JDBC or System i Navigator the mysql table will be changed as expected. However, if the mysql server is serving as a master those changes will not be replicated to the slaves.

Changes made directly to the mysql table using the mysql monitor are replicated properly from master to slave.


How to repeat:
1. Create a table using IBMDB2I engine with mysql monitor or any other mysql tool. 
2. Setup MASTER-SLAVE replication to another server that includes the table created in the previous step. 
3. Using mysql monitor, add a record to the table you created. If replication is setup properly the new record will appear on the slave. 
4. Use IBM i5 STRSQL or other tool to insert an additional record. This change will appear on the Master but not on any of the Slaves.
[26 Aug 2010 18:17] Sveta Smirnova
Thank you for the report.

Have you committed records inserted in step 5? Please connect using other client on master and check if you see new rows.
[3 Sep 2010 2:28] Jack Collins
Thank you Sveta. Yes, I have verfied that the rows are committed.
[15 Sep 2010 0:01] Jack Collins
Has anyone else seen this behavior with IBMDB2I & replication? It just looks like updates from the DB2 side are made locally but the replication event is not sent to the slaves. Just a missed step? Replication works fine when using mysql tools to update the IBMDB2I tables.
[2 Nov 2010 17:58] Jack Collins
Changed severity since there is no workaround.
[3 Apr 2011 12:33] Valeriy Kravchuk
Sorry, but IBMDB2I storage engine (and MySQL on System i in general) is no longer supported officially.