Operation of CLI2MPI
This program initiates the following multi-statement request “MAXTRANS” times:
USING V1 (INT),V2 (INT),V3 (INT),
V4 (INT),V5 (INT)
INSERT INTO MYTABLE2 (F1) VALUES(:V1);
INSERT INTO MYTABLE2 (F1) VALUES(:V2);
INSERT INTO MYTABLE2 (F1) VALUES(:V3);
INSERT INTO MYTABLE2 (F1) VALUES(:V4);
INSERT INTO MYTABLE2 (F1) VALUES(:V5);
UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V1;
UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V2;
UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V3;
UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V4;
UPDATE MYTABLE2 SET F2 = F1+1 WHERE F1=:V5;
Data values are generated by the program. The generated data values are the integers 1,2,...N.
Each request (transaction) inserts and then updates five rows into MYTABLE2.
The following variables are contained within the program and can be adjusted to reset the total number of rows or concurrent sessions:
This particular compilation sets NUMLOG=3 and MAXTRANS=10.