REPORT 1: History executions under different isolation levels and database systems. No primary key and no indexes were used.

file
ora.RC
ora.SR
db2.UR
db2.CS
db2.RS
db2.RR
insphan
A
B
A
A
A
C+
insphan2
A
A
A
A
A
B+
delphan
A
A
A
A
B+
B+
delphan_2
A
B
A
A
C+
C+
keyran1
A
B
A
A
A
C+
keyran2
A
A
A
A
A
B+
keyran3
A
A
A
A
A
B+
keyran3_2
A
B
A
A
A
C+
keyran4
A
A
B
B
B
C+
keyran4_2
A
B
C
C
C
D+
skew
A
A
B+
B+
C+
C+
si1
A
B-
A
A
C+
C+

TABLE 1. Displays the clustering history executions. The column FILE contains the names of the input files. The rest of the columns show how the outputs of the same history are different under several Isolation Levels and Database products (ora: ORACLE 8, db2:DB2-5). If fields on the same row contain the same letter the corresponding outputs had identical results. The fields link to these outputs. The plus (+) is an indication that the history did not finish properly because a TIMEOUT occured. The minus (-) is an indication that a serialization error occured.





*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
1. 11/12/99. File: insphan.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History that inserts a phantom.
;
;

0,pred,P1,recval>0
1,pr,P1;sum(recval);all,
1,i,reckey;recval,20100;100
1,c,,
2,pr,P1;sum(recval);0,
3,i,reckey;recval,20200;200
3,c,,
2,pr,P1;sum(recval);all,
2,pr,P1;sum(recval);all,
2,c,,






::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
2. 11/12/99. File: insphan.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200))
(3, c)
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, pr, (P1,sum(recval),all), (aggr=201000300, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
3. 11/12/99. File: insphan.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200))
(3, c)
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
4. 11/12/99. File: insphan.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200))
(3, c)
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, pr, (P1,sum(recval),all), (aggr=201000300, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
5. 11/12/99. File: insphan.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200))
(3, c)
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, pr, (P1,sum(recval),all), (aggr=201000300, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
6. 11/12/99. File: insphan.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200))
(3, c)
(2, pr, (P1,sum(recval),all), (aggr=201000100, count=1, reckey=0))
(2, pr, (P1,sum(recval),all), (aggr=201000300, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
7. 11/12/99. File: insphan.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P1,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,recval), (20200,200)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
8. 11/12/99. File: insphan2.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History similar to the Insert Phantom Example
;
; In this case the predicates of transactions 2 and 3 do not overlap
;

0,pred,P1,recval>0
0,pred,P2,c50=0
1,pr,P1;sum(recval);all,
1,i,reckey;recval,20100;100
1,c,,
2,pr,P2;sum(recval);0,
3,i,reckey;c2;c50;recval,20200;10;1;200
3,c,,
2,pr,P2;sum(recval);all,
2,pr,P2;sum(recval);all,
2,c,,






::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
9. 11/12/99. File: insphan2.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200))
(3, c)
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
10. 11/12/99. File: insphan2.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200))
(3, c)
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
11. 11/12/99. File: insphan2.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200))
(3, c)
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
12. 11/12/99. File: insphan2.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200))
(3, c)
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
13. 11/12/99. File: insphan2.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200))
(3, c)
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, pr, (P2,sum(recval),all), (aggr=3040000, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
14. 11/12/99. File: insphan2.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(pred, P2, c50=0)
(1, pr, (P1,sum(recval),all), (aggr=201000000, count=1, reckey=0))
(1, i, (reckey,recval), (20100,100))
(1, c)
(2, pr, (P2,sum(recval),0), (aggr=0, count=0, reckey=0))
(3, i, (reckey,c2,c50,recval), (20200,10,1,200)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
15. 11/12/99. File: delphan.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History to demonstarte a delete phantom.
;

0,pred,P1,recval>0
1,pr,P1;count(*);all,
1,c,,
2,pr,P1;count(*);0,
3,d,reckey=100,
3,c,,
2,pr,P1;count(*);all,
2,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
16. 11/12/99. File: delphan.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
17. 11/12/99. File: delphan.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
18. 11/12/99. File: delphan.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
19. 11/12/99. File: delphan.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
20. 11/12/99. File: delphan.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100)) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
21. 11/12/99. File: delphan.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),0), (aggr=0, count=0, reckey=0))
(3, d, (reckey=100)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
22. 11/12/99. File: delphan_2.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History to demonstarte a delete phantom.
;

0,pred,P1,recval>0
1,pr,P1;count(*);all,
1,c,,
2,pr,P1;count(*);all,
3,d,reckey=100,
3,c,,
2,pr,P1;count(*);all,
2,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
23. 11/12/99. File: delphan_2.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=199, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
24. 11/12/99. File: delphan_2.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
25. 11/12/99. File: delphan_2.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=199, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
26. 11/12/99. File: delphan_2.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100))
(3, c)
(2, pr, (P1,count(*),all), (aggr=199, count=1, reckey=0))
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
27. 11/12/99. File: delphan_2.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100)) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
28. 11/12/99. File: delphan_2.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, recval>0)
(1, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(1, c)
(2, pr, (P1,count(*),all), (aggr=200, count=1, reckey=0))
(3, d, (reckey=100)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
29. 11/12/99. File: keyran1.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History similar to Key-Range Locking 1 Example
;

0,pred,P1,reckey=20100 and k4=0
1,pr,P1;count(recval);all,
2,i,reckey;recval;k4,20100;999;0
2,c,,
1,pr,P1;count(recval);all,
1,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
30. 11/12/99. File: keyran1.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0))
(2, c)
(1, pr, (P1,count(recval),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
31. 11/12/99. File: keyran1.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0))
(2, c)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
32. 11/12/99. File: keyran1.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0))
(2, c)
(1, pr, (P1,count(recval),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
33. 11/12/99. File: keyran1.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0))
(2, c)
(1, pr, (P1,count(recval),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
34. 11/12/99. File: keyran1.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0))
(2, c)
(1, pr, (P1,count(recval),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
35. 11/12/99. File: keyran1.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=20100 and k4=0)
(1, pr, (P1,count(recval),all), (aggr=0, count=1, reckey=0))
(2, i, (reckey,recval,k4), (20100,999,0)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
36. 11/12/99. File: keyran2.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History similar to example: Key-Range Locking 2
;

0,pred,P1,reckey=19700
0,pred,P2,reckey between 19500 and 19900 and k2=0
1,d,reckey=19700,
1,c,,
2,pr,P1;COUNT(recval);all,
2,c,,
3,pr,P2;recval;1,
4,i,reckey;k2,19700;0
3,pr,P2;recval;1,
3,pr,P2;recval;1,
3,c,,
4,c,,




::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
37. 11/12/99. File: keyran2.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0))
(3, pr, (P2,recval,1), (last=1990000, count=1, reckey=19900))
(3, pr, (P2,recval,1), (last=0, count=0, reckey=0))
(3, c)
(4, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
38. 11/12/99. File: keyran2.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0))
(3, pr, (P2,recval,1), (last=1990000, count=1, reckey=19900))
(3, pr, (P2,recval,1), (last=0, count=0, reckey=0))
(3, c)
(4, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
39. 11/12/99. File: keyran2.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0))
(3, pr, (P2,recval,1), (last=1990000, count=1, reckey=19900))
(3, pr, (P2,recval,1), (last=0, count=0, reckey=0))
(3, c)
(4, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
40. 11/12/99. File: keyran2.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0))
(3, pr, (P2,recval,1), (last=1990000, count=1, reckey=19900))
(3, pr, (P2,recval,1), (last=0, count=0, reckey=0))
(3, c)
(4, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
41. 11/12/99. File: keyran2.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0))
(3, pr, (P2,recval,1), (last=1990000, count=1, reckey=19900))
(3, pr, (P2,recval,1), (last=0, count=0, reckey=0))
(3, c)
(4, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
42. 11/12/99. File: keyran2.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=19700)
(pred, P2, reckey between 19500 and 19900 and k2=0)
(1, d, (reckey=19700))
(1, c)
(2, pr, (P1,COUNT(recval),all), (aggr=0, count=1, reckey=0))
(2, c)
(3, pr, (P2,recval,1), (last=1950000, count=1, reckey=19500))
(4, i, (reckey,k2), (19700,0)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
43. 11/12/99. File: keyran3.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

1,d,reckey=200,
2,i,reckey;recval,200;2000
2,c,,
1,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
44. 11/12/99. File: keyran3.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
45. 11/12/99. File: keyran3.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
46. 11/12/99. File: keyran3.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
47. 11/12/99. File: keyran3.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
48. 11/12/99. File: keyran3.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
49. 11/12/99. File: keyran3.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
50. 11/12/99. File: keyran3_2.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

0,pred,P1,reckey=200
1,d,reckey=200,
2,i,reckey;recval,200;2000
2,c,,
1,pr,P1;count(reckey);all,
1,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
51. 11/12/99. File: keyran3_2.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, pr, (P1,count(reckey),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
52. 11/12/99. File: keyran3_2.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, pr, (P1,count(reckey),all), (aggr=0, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
53. 11/12/99. File: keyran3_2.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, pr, (P1,count(reckey),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
54. 11/12/99. File: keyran3_2.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, pr, (P1,count(reckey),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
55. 11/12/99. File: keyran3_2.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000))
(2, c)
(1, pr, (P1,count(reckey),all), (aggr=1, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
56. 11/12/99. File: keyran3_2.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(1, d, (reckey=200))
(2, i, (reckey,recval), (200,2000)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
57. 11/12/99. File: keyran4.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History similar to example: Key-Range Locking 4
;

0,pred,P1,reckey=200
0,pred,P2,reckey between 100 and 300
1,d,reckey=200,
2,pr,P2;reckey;1,
2,pr,P2;reckey;1,
2,pr,P2;reckey;1,
2,c,,
1,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
58. 11/12/99. File: keyran4.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=200, count=1, reckey=200))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
59. 11/12/99. File: keyran4.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=200, count=1, reckey=200))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
60. 11/12/99. File: keyran4.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
61. 11/12/99. File: keyran4.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
62. 11/12/99. File: keyran4.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, c)
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
63. 11/12/99. File: keyran4.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
64. 11/12/99. File: keyran4_2.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History similar to example: Key-Range Locking 4
;

0,pred,P1,reckey=200
0,pred,P2,reckey between 100 and 300
0,pred,P3,reckey between 400 and 600
1,d,reckey=200,
2,pr,P2;reckey;1,
2,pr,P2;reckey;1,
2,pr,P2;reckey;1,
2,d,reckey=500,
2,c,,
1,pr,P3;count(reckey);all,
1,c,,



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
65. 11/12/99. File: keyran4_2.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=200, count=1, reckey=200))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, d, (reckey=500))
(2, c)
(1, pr, (P3,count(reckey),all), (aggr=2, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
66. 11/12/99. File: keyran4_2.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=200, count=1, reckey=200))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, d, (reckey=500))
(2, c)
(1, pr, (P3,count(reckey),all), (aggr=3, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
67. 11/12/99. File: keyran4_2.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, d, (reckey=500))
(2, c)
(1, pr, (P3,count(reckey),all), (aggr=2, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
68. 11/12/99. File: keyran4_2.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, d, (reckey=500))
(2, c)
(1, pr, (P3,count(reckey),all), (aggr=2, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
69. 11/12/99. File: keyran4_2.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=100, count=1, reckey=100))
(2, pr, (P2,reckey,1), (last=300, count=1, reckey=300))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0))
(2, d, (reckey=500))
(2, c)
(1, pr, (P3,count(reckey),all), (aggr=2, count=1, reckey=0))
(1, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
70. 11/12/99. File: keyran4_2.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(pred, P1, reckey=200)
(pred, P2, reckey between 100 and 300)
(pred, P3, reckey between 400 and 600)
(1, d, (reckey=200))
(2, pr, (P2,reckey,1), (last=0, count=0, reckey=0)) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
71. 11/12/99. File: skew.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History skew writes
;
; r1(x)r2(y)w1(y)w2(x)c1c2
;

1,r,x,
2,r,y,
1,w,y,9999
2,w,x,3333
1,c,,
2,c,,
3,r,x,
3,r,y,
3,c,,





::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
72. 11/12/99. File: skew.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999])
(2, w, x [=100], 3333 [=3333])
(1, c)
(2, c)
(3, r, x [=100], [=3333])
(3, r, y [=200], [=9999])
(3, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
73. 11/12/99. File: skew.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999])
(2, w, x [=100], 3333 [=3333])
(1, c)
(2, c)
(3, r, x [=100], [=3333])
(3, r, y [=200], [=9999])
(3, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
74. 11/12/99. File: skew.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999])
(2, w, x [=100], 3333 [=3333]) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
75. 11/12/99. File: skew.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999])
(2, w, x [=100], 3333 [=3333]) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
76. 11/12/99. File: skew.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999]) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
77. 11/12/99. File: skew.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(1, r, x [=100], [=10000])
(2, r, y [=200], [=20000])
(1, w, y [=200], 9999 [=9999]) TIMEOUT



*********************************************************************
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
78. 11/12/99. File: si1.in Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

;
; History si1 - si anomaly without phantoms
;
; r2(z)w3(z)w3(y) c3 r1(x)r1(y) c1 w2(x) c2
;

2,r,z,
3,w,z,4444
3,w,y,9999
3,c,,
1,r,x,
1,r,y,
1,c,,
2,w,x,7777
2,c,,





::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
79. 11/12/99. File: si1.ora.RC Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444])
(3, w, y [=200], 9999 [=9999])
(3, c)
(1, r, x [=300], [=30000])
(1, r, y [=200], [=9999])
(1, c)
(2, w, x [=300], 7777 [=7777])
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
80. 11/12/99. File: si1.ora.SR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444])
(3, w, y [=200], 9999 [=9999])
(3, c)
(1, r, x [=300], [=30000])
(1, r, y [=200], [=9999])
(1, c)
(2, w, x [=300], 7777 [=7777]) SQL error -8177: ORA-08177: can't serialize access for this transaction



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
81. 11/12/99. File: si1.db2.UR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444])
(3, w, y [=200], 9999 [=9999])
(3, c)
(1, r, x [=300], [=30000])
(1, r, y [=200], [=9999])
(1, c)
(2, w, x [=300], 7777 [=7777])
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
82. 11/12/99. File: si1.db2.CS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444])
(3, w, y [=200], 9999 [=9999])
(3, c)
(1, r, x [=300], [=30000])
(1, r, y [=200], [=9999])
(1, c)
(2, w, x [=300], 7777 [=7777])
(2, c)



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
83. 11/12/99. File: si1.db2.RS Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444]) TIMEOUT



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
84. 11/12/99. File: si1.db2.RR Setup: no_prkey_no_index
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

(2, r, z [=100], [=10000])
(3, w, z [=100], 4444 [=4444]) TIMEOUT