HPL and ER
Posted in 1999
I am trying to us HPL with ER running. Here are my test scenarios and I hope
someone can explain to me what is happening.
CMD Row count server1
Row count server2
Onpload -j load_cc -p load_cc -flc 1000
0
Begin work;delete from tab1;commit work 0 0
Onpload -j load_cc -p load_cc -fl 1000
0
Ontape -s -L 0 1000
0
Begin work;update tab1 set pin1=pin1;commit work 1000
1000
Begin work;delete from tab1;commit work 0 0
Onpload -j load_cc -p load_cc -flcN HANGS
Onpload -j load_cc -p load_cc -flN HANGS
I would have thought the onpload(deluxe) would replicate. I would have
thought that onpload(express) would fail needing an exclusive lock on the
table.
I have an open case but I thought I might use some of intelligence of the
user community and Informix support staff.
Version: 7.30.uc6
OS:AIX 4.3.2
TIA
David Link