MQSeries.net :: View topic

WBI_user · Posted: Thu Dec 13, 2001 9:52 pm Post subject:

I am helping my customer to do MQSI performance measurement. They have a standard request/reply transaction (from PC to MVS/CICS back to PC). Two MQSI flow is involved with this backend CICS transaction.
The flow is:
Request flow
I/P->MQSI->MQ/MVS->CICS
Reply flow
CICS->MQ/MVS->MQSI->O/P

We are using MQSI 202 csd1, on NT.
We will take the timestamp in the first compute node after the I/P node and the time stamp in the last compute node before the O/P node and calculate the elapse time.
The time stamp taken at the input is carried as a XML field all the way to the output.

So in the first compute node just after the input we have

DECLARE T1 TIMESTAMP;
SET T1 = CURRENT_TIMESTAMP;
SET OutputRoot.XML.MSG.TIME_IN = T1;

This XML field will be in the message all the way until Output.

In the last compute node for the reply flow just before the MQOutput node we have

DECLARE T2 TIMESTAMP;
SET T2 = CURRENT_TIMESTAMP;
DECLARE T1 TIMESTAMP;
SET T1 = InputRoot.XML.MSG.TIME_IN;
SET OutputRoot.XML.MSG.TIME_OUT = T2;
SET OutputRoot.XML.MSG.TIME_ELAPSED = (T2-T1) SECOND;
MQSI nail me with a syntax error with the pointer between (T2-T1) and SECOND

If I remove SECOND, the syntax error goes away. But my flow will fail with
"When two datetime values are subtracted, an interval qualifier must be given."

According to mqsi V202 ESQL reference p.86
(CURRENT_TIME -TIME '00:00:00')MINUTE TO SECOND would return the age of the day in minutes and seconds.
I should be able to subtract two timestamps and MQSI should give me the difference in seconds (with my ESQL).
I cannot see anything that I did wrong here.
Can some one help ?

I have a second question here. I am not sure if InputRoot.XML.MSG.TIME_IN is still of datatype TIMESTAMP after it is inserted into a XML field. If not, the statement
SET OutputRoot.XML.MSG.TIME_ELAPSED = (T2-T1) SECOND; will not work because I don't think I can subtract a non timestamp datatype from a timestamp datatype.