Started with a 1um / 2pm system. I added a 3rd pm.
1. started a script that continually did a few queries on um1
2. started a script that ran the dbhealth.sh (DDl/DML test) continuely on um1
3. ran ./redistributeDB start // from pm1
So while redistributeDB was running, the scripts were successfully passin, but when it complete, the query started failing with:
In my next test, I added another pm and re-ran with just doing the query script only. This time the query continued to worked after completion... So this means that no ETL DDl DML changes should be made to the DB while the redistributeDB is running.
We could add in the code to suspend/resume database writes during this time, BUT cpimport doesn't look at the setting. only DML/DDLproc do.