Results 1 to 2 of 2
-
10-26-2012, 02:25 PM #1Member
- Join Date
- Apr 2005
- Posts
- 24
- Thanks
- 0
- Thanked 0 Times in 0 Posts
SQL "cast" rounding for tsm v 5 vs v6
Hello ,
I am running the following script to get the nodes throughput within a time interval
SELECT cast(a.entity AS varchar(9)) AS "Node name", -
CAST(sum(a.bytes/1024/1024) AS decimal(8,2)) AS "MB Xfer ", -
CAST(sum(a.bytes/1024/1024/1024) AS decimal(8,2)) AS "GB Xfer " -
FROM summary a, nodes b WHERE a.entity=b.node_name and a.activity='BACKUP' AND -
a.start_time> current_timestamp - $1 hours GROUP BY a.entity
Somehow when I run this on tsm v6 the results are rounded up and there are zeros after the decimal point
Node name MB Xfer GB Xfer
---------- ----------- -----------
AUSORAFIN 50160.00 47.00
CHR7Z035 2365.00 2.00
CHR7Z036 1332.00 1.00
While similar report on the V5 does produce the fractions
Node name MB Xfer GB Xfer
--------- ---------- ----------
USCP3005 917.69 0.89
USCP3006 883.84 0.86
USUS3001 1411.19 1.37
Is there a way to get the fraction work in V6?
Thank you ,
Alex
-
11-11-2012, 06:54 PM #2Member
- Join Date
- Jun 2012
- Posts
- 32
- Thanks
- 3
- Thanked 2 Times in 2 Posts
SELECT cast(entity AS varchar(9)) AS "Node name", -
CAST(DEC(sum(bytes))/1024/1024 AS decimal(8,2)) AS "MB Xfer ", -
CAST(DEC(sum(bytes))/1024/1024/1024 AS decimal(8,2)) AS "GB Xfer " -
FROM summary WHERE activity='BACKUP' AND -
start_time> current_timestamp - $1 hours GROUP BY entity
Similar Threads
-
SQL2025N An I/O error "-72" occurred on media "TSM" on DB2 onoline backup
By AjM in forum DB2Replies: 2Last Post: 10-18-2012, 12:45 PM -
SQL2025N An I/O error "155" occurred on media "TSM"
By rchoudarapu in forum Backup / Archive DiscussionReplies: 3Last Post: 06-13-2008, 12:55 PM -
SQL2025N An I/O error "12" occurred on media "TSM".
By ajmense in forum Administrative ClientReplies: 1Last Post: 11-13-2007, 02:00 PM -
SQL2025N An I/O error "12" occurred on media "TSM"
By bprrajeev in forum TDP/Application Layer BackupReplies: 2Last Post: 05-02-2007, 02:13 AM -
TDP for SQL: Backups changing DB recovery mode from "normal" to "simple"?
By c.j.hund in forum TDP/Application Layer BackupReplies: 1Last Post: 09-12-2006, 04:29 AM


Reply With Quote