Hi,
on DB2 v8.2 fp11 on Linux I have strange problem using db2 function monthname.

Executing bellow SQL returns error:
db2 select monthname('2008-07-01') from sysibm.sysdummy1
---- error message ----
SQL0443N Routine "SYSFUN.MONTHNAME" (specific name "SQL020703081922408") has
returned an error SQLSTATE with diagnostic text "SYSFUN:03". SQLSTATE=38552
-----------------------
I looked at detailed explanation of error for "SYSFUN:03" and got info:
03 Arithmetic overflow or underflow


By the way I have also tried bellow and getting the same error:
db2 select monthname(date('2008-07-01')) from sysibm.sysdummy1 and

This is very strange, because this SQL is in production environment and it was working fine for few months now.

I know system administrator has changed system time on computer. Can this effect? Is this a bug in DB2?

Any help is greatly appreciated?
Regards,
Grofaty

Hi,
it looks like some kind of bug in v8. I have restarted the instance and now monthname works fine:
db2stop force
db2start

But as I think "db2 force application all" should be enough, because database deactivates (on my system no activate database was executed).

Thanks problem solved,
Grofaty

Grofty... you faced the same problem few years back...
here is the link :-)
http://www.dbforums.com/archive/inde...t-1200944.html

Hi,
I saw that thread too. But I know that was not a proper solution. There's got to be some kind of bug in v8. This problem appears time to time - if I don't mistaken if some sysadm changes system time.
Thanks,
Grofaty