ADSM-L

[ADSM-L] sample script q_ses_stats on v6 servers produces unbelievabl

2010-07-05 17:00:06
Subject: [ADSM-L] sample script q_ses_stats on v6 servers produces unbelievabl
From: mccambly <tsm-forum AT BACKUPCENTRAL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 5 Jul 2010 16:56:56 -0400
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 mccambly AT unopsys DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

<Prev in Thread] Current Thread [Next in Thread>