Data Protection Software

 View Only

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

    Posted 17 hours ago

    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 17 hours ago
    Edited by Igor P. Merkù 16 hours ago

    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 15 hours ago

    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 12 hours ago

    Opened case TS017552365



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

    Original Message