Hi Joerg, You are running into the problem that the old syntax of (time1-time2)seconds works but doesn't produce the same results in V6 as in V5.
In V5 it gave the timestamp difference in seconds (perfect) but in V6 it just gives the difference of the 'seconds portion' of the two timestamps. IBM did not explain/correct this in their migration documentation until much later after the V6.1 release. So now to get the same results you must use the db2 "timestampdiff()" function like this "timestampdiff(2,char(timestamp1-timestamp2))" where 2 is the argument to return seconds. google for the full syntax. Scott. J. Pohlmann wrote: > Has anyone experienced and found a fix for the sample script that measures > session speeds. The sample script q_ses_stats is identical for v5 and v6 and > runs fine on v 5 and v6 - except that on v6.1 and v6.2 it produces > unbelievable numbers (100s of MB/sec received or sent). > > > > Joerg Pohlmann > > 250-585-3711 +---------------------------------------------------------------------- |This was sent by [email protected] via Backup Central. |Forward SPAM to [email protected]. +----------------------------------------------------------------------
