Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: "Arithmetic overflow or underflow" using db2 function monthname

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    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

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Grofty... you faced the same problem few years back...
    here is the link :-)
    http://www.dbforums.com/archive/inde...t-1200944.html
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •