The load scenario user is using is Test SQL for Scalability, then user is using the Create Custom user scenario. User is working with Benchmark Factory using UDB v8.x on Windows XP. User is testing BMF and using basic sample queries. User initially test it with hard coded values in BMF and compare the results to those from DB2. If user uses hard coded variables it gets correct results in BMF. If user uses parameter values, as user hopes to do in a more realistic situation, user gets incorrect results.
For example:
CREATE TABLE PRV_IP(
RP_NO CHARACTER(3) NOT NULL,
PRV_IP_OP CHARACTER(1) NOT NULL)
Query 1:
SELECT *
FROM PRV_IP
WHERE
RP_NO = '001'
AND PRV_IP_OP = '1'
/* hard coded values*/
Query 2:
SELECT *
FROM PRV_IP
WHERE
RP_NO = '001'
AND PRV_IP_OP= ?
/* using parameters/bind variables where ? = ‘1’
Parameter: 1; Type: STRING; Value: 1*/
Query 3:
SELECT *
FROM PRV_IP
WHERE
RP_NO = ?
AND PRV_IP_OP= '1'
/*using parameters/bind variables where ? = ‘001’
Parameter: 1; Type: STRING; Value: 1*/
These all run and return correctly from DB2… but only query 3 with the bind variable of ‘001’ does not return the correct results in BMF.x`
WORKAROUND:
Use $BFFileArray to apply parameters. See Solution SOL23532 for further information about using $BFFileArray.
STATUS:
This issue is fixed in Benchmark Factory 5.5. This version can be downloaded from here.
