My gear:
- Pentaho BI Server 8.0
- AS400 V7
My scenario:
I have two processes that sometimes run at same time in the same table. This table has about 600M rows, so, an update can take long time to finish.
Because I can't predict the time when this ETL finishes updating the rows, I must insert new rows from other process that match the conditions of the update ETL that was running previously.
Until this post, I had to stop both processes and run them manually because they never finish (24h+).
In the simultaneous UPDATE/INSERT scenario, what is the expected behavior from SQL database?, the new incoming rows from the insert are gonna be part of the previous update?, is there a race condition where the update process can process the new inserted rows?, are both processes independent, so, the update process will take in count only the rows that were in the table before the insert?, are gonna get locks activated at row level here by default?