Gary, The ANR0162W message does include an SQL message, so you can use the DB2 SQL reference info to look it up for a detailed explanation. Here is a link to this message: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql00419n.html
I suspect it occurs due differences between the "legacy" TSM server database engine and the DB2 database engine. At any rate, I'm not sure I understand why you are casting the number of seconds as decimal(18,13). Why would you want all those digits to the right of the decimal point? You could probably get away with using something like decimal(18,1). With the DB2 engine, it looks like it automatically casts the end and start time difference to seconds, so you could do something like: examined / (end_time-start_time) * 3600 Best regards, Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 2011-02-09 14:12:14: > From: "Lee, Gary D." <g...@bsu.edu> > To: ADSM-L@vm.marist.edu > Date: 2011-02-09 14:13 > Subject: Tsm 6.22 server script problem. > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> > > I ported the following script from my tsm server v5.5.4 to the 6.2.2 server. > Wanted to compare expiration performance between the two servers. > However, script errors out with the following message. > > 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 > ). > > > ------------ script follows ---------------- > > > select activity, cast ((end_time) as date) as "Date", - > (examined/cast ((end_time-start_time) seconds as decimal (18,13)) *3600) - > "Objects Examined Up/Hr" from summary where - > activity='EXPIRATION' and days (end_time) -days (start_time)=0 > > > Thanks for any help. > > > > Gary Lee > Senior System Programmer > Ball State University > phone: 765-285-1310 > >
