HI try to set up a query to give me the daily backup results per node in MB. But the query errors
any help appreciated
thanks
Treds
Server/Version
Linux/x86_64
Server Version 7, Release 1, Level 1.100
SQL query
SELECT substr(entity,1,20) AS "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB Bkp" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity order by 2 desc
Error
ANR0162W Supplemental database diagnostic information: -1:22003:-413 ([IBM][CLI
Driver][DB2/LINUXX8664] SQL0413N Overflow occurred during numeric data type
conversion. SQLSTATE=22003
).
ANR0516E SQL processing for statement SELECT substr ( entity , 1 , 20 ) AS
"Node" , CAST ( sum ( bytes/1024/1024 ) AS decimal ( 8 , 2 ) ) AS "MB Bkp" FROM
summary WHERE activity = 'BACKUP' AND start_time >= current_timestamp - 24 hours
GROUP BY entity order by 2 desc failed.
ANS8001I Return code 3.
any help appreciated
thanks
Treds
Server/Version
Linux/x86_64
Server Version 7, Release 1, Level 1.100
SQL query
SELECT substr(entity,1,20) AS "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB Bkp" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity order by 2 desc
Error
ANR0162W Supplemental database diagnostic information: -1:22003:-413 ([IBM][CLI
Driver][DB2/LINUXX8664] SQL0413N Overflow occurred during numeric data type
conversion. SQLSTATE=22003
).
ANR0516E SQL processing for statement SELECT substr ( entity , 1 , 20 ) AS
"Node" , CAST ( sum ( bytes/1024/1024 ) AS decimal ( 8 , 2 ) ) AS "MB Bkp" FROM
summary WHERE activity = 'BACKUP' AND start_time >= current_timestamp - 24 hours
GROUP BY entity order by 2 desc failed.
ANS8001I Return code 3.