Data Protection Software

 View Only
Expand all | Collapse all

q status -> arithmetic overflow SQLSTATE 22003?

  • 1.  q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu October 10, 2024 04:16 AM

    Hi,

    I recently updatet ISP to v8.1.24.0.

    I just checked the OPCenter (also on v8.1.24.0) and see a lot of these errors:

    Oct 8, 2024, 11:07:41 AM ANR8592I Session 203736 connection is using protocol TLSV13, cipher specification TLS_AES_256_GCM_SHA384, certificate TSM Self-Signed Certificate. (SESSION: 203736)
    Oct 8, 2024, 11:07:41 AM ANR0840I Session 203736 started for administrator MERKUX (WinNT) (SSL SPOCENTER.acegas.loc[172.26.68.98]:55371) on etabeta-v64.acegas:1500. (SESSION: 203736)
    Oct 8, 2024, 11:07:41 AM ANR2017I Administrator MERKUX issued command: QUERY STATUS (SESSION: 203736)
    Oct 8, 2024, 11:07:41 AM ANR0162W Supplemental database diagnostic information: -1:22003:-802 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003). (SESSION: 203736)
    Oct 8, 2024, 11:07:41 AM ANR9999D_3044804774 RdbExecuteSQLToStrings(tbnsql.c:1475) Thread<502609>: rc 2343 from tbSQLExecuteToStrings. (SESSION: 203736)

    Internet came up with this IBM doc

    Does this apply here? Should I open a case with IBM Support?

    Thanks, Igor



    ------------------------------
    Igor P. Merkù
    ------------------------------


  • 2.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu October 10, 2024 04:27 AM
    Edited by Igor P. Merkù Thu October 10, 2024 04:31 AM

    There are many other errors of this kind, triggered by sql statements (that run for years now without a problem).

    Did something change in DB2 with 8.1.24.0 update?

    Thanks, Igor



    ------------------------------
    Igor P. Merkù
    ------------------------------

    Original Message


  • 3.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu October 10, 2024 06:10 AM

    This is a SQL statement that apparently runs under my admin name, but I do not have the slightest idea where this comes from.

    Oct 10, 2024, 12:05:02 PM ANR2017I Administrator MERKUX issued command: SELECT sum(BYTES/1024) COL0 FROM SUMMARY where activity in ('BACKUP','RESTORE','ARCHIVE','RETRIEVE') and timestampdiff(2, char(current_timestamp-end_time))<=300 union select sum(bytes_sent+bytes_received)/1024 COL0 from sessions (SESSION: 287955)

    I have some scripts running with SQL selects that generate csv output for a dashboard like website to see what's up with the ISP Server, but none run every 5 min.

    How do I search for something like this ...

    Thanks for any hint.

    Igor



    ------------------------------
    Igor P. Merkù
    ------------------------------

    Original Message


  • 4.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu October 10, 2024 08:56 AM

    Opened case TS017552365



    ------------------------------
    Igor P. Merkù
    ------------------------------

    Original Message


  • 5.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Mon November 11, 2024 11:36 AM

    Any luck with your case? I am seeing similar errors. 



    ------------------------------
    Kevin Kettner
    ------------------------------

    Original Message


  • 6.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Tue November 12, 2024 08:58 AM

    Hi Igor

    We have seen this error from release 8.1.23 on several of our instances, but we haven't investigated further. Neither we have created any PMR's, because we are using a lot of time with several other PMR's, regarding storage pool replication errors.

    So I'm interested too, in hearing the outcome of your PMR.

    Thanks,

    Ivan



    ------------------------------
    Ivan Lauritzen
    System Programmer
    JN Data
    Roskilde
    ------------------------------

    Original Message


  • 7.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Tue November 12, 2024 08:58 AM

    Hi Igor

    We have seen this error on several instances since release 8.1.23, but we haven't created any PMR's on that, due a lot of other PMR's, regarding errors on storagerule replication issues.

    So I'm interested too, in hearing the outcome of your PMR.

    Thanks,

    Ivan



    ------------------------------
    Ivan Lauritzen
    System Programmer
    JN Data
    Roskilde
    ------------------------------

    Original Message


  • 8.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu November 14, 2024 03:20 AM

    Hi Igor and others,

    It seems that IBM is also aware of this now, or maybe it's because of Igor's PMR.

    https://www.ibm.com/support/pages/apar/IT47216?myns=swgother&mynp=OCSSGSG7&mync=E&cm_sp=swgother-_-OCSSGSG7-_-E

    Regards,

    Ivan



    ------------------------------
    Ivan Lauritzen
    System Programmer
    JN Data
    Roskilde
    ------------------------------

    Original Message


  • 9.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Thu December 12, 2024 09:17 AM

    Hi all,

    eFix 8.1.23.008 is providing a fix for APAR IT47216.

    Regards, Uwe



    ------------------------------
    Uwe Schreiber
    ------------------------------

    Original Message


  • 10.  RE: q status -> arithmetic overflow SQLSTATE 22003?

    Posted Tue December 17, 2024 05:45 AM

    But unfortunately it seems, that the new 8.1.25.000 is not handling this APAR IT47216.

    Regards,

    Ivan



    ------------------------------
    Ivan Lauritzen
    System Programmer
    JN Data
    Roskilde
    ------------------------------

    Original Message