Errors checking Expiration via SQL query on 7.1.5

sandragon

ADSM.ORG Member
Joined
Aug 26, 2014
Messages
52
Reaction score
0
Points
0
PREDATAR Control23

I've attempted to run the SQL select that should show me expiration speed and objects to process against my currently 7.1.5 server. I get back an SQL error. This select query came out of the How Tos section here.

TSM01>
select activity,cast ((end_time) as date) as "Date",(examined/cast ((end_time-start_time) seconds as decimal (18,13))*3600) "Obj/Hr" from summary where activity='EXPIRATION' and days (end_time) - days (start_time) = 0
ANR0162W Supplemental database diagnostic information: -1:42911:-419 ([IBM][CLI Driver][DB2/AIX64] SQL0419N A decimal divide operation is not valid because the result would have a negative scale. SQLSTATE=42911~).

Is this select specific to 6.x versions? I've been looking through the forums and haven't run across this problem.
 
Top