I've been trying to update an old expiration performance reporting script to run on tsm v6.2.2.
I figured out that at the end of each expire run, a summary line is given with an entity of '' However I still get the error below. Anyone out there with any ideas? My db2 admin here is stumped. tsm: TSM01>run expexp ANR0162W Supplemental database diagnostic information: -1:42911:-419 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0419N A decimal divide operation is not valid because the result would have a negative scale. SQLSTATE=42911 ). ANR0516E SQL processing for statement select activity , cast ( ( end_time ) as date ) as "Date" , ( examined/cast ( SECOND ( end_time - start_time) as decimal ( 18 , 13 ) ) *3600 ) "Objects Examined/Hr" from summary where activity = 'EXPIRATION' and entity = '' and days ( end_time ) -days ( start_time ) = 0 failed. ANR1463E RUN: Command script EXPEXP completed in error. ANS8001I Return code 4. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310