IT47216: ANR9999D_1038905726 DBIDBSPACESTATS(RDBDB.C:3885)THREAD<185>: RC 2343 FROM RDBEXECUTESQLTOSTRINGS.

8.1.26.000-IBM-SPSRV-LIC-WindowsX64-073
8.1.26.000-IBM-SPSRV-LIC-Linuxx86_64-073
8.1.26.000-IBM-SPSRV-LIC-Linuxs390x-073
8.1.26.000-IBM-SPSRV-LIC-Linuxppc64le-073
8.1.26.000-IBM-SPSRV-LIC-AIX-073

APAR status

• Closed as program error.

Error description

• IBM Storage Protect server 8.1.23.000 and higher, can report
  several times a day in the activity log:
  
  
  ANR0162W Supplemental database diagnostic information:
  -1:22003:-802 ([IBM][CLI Driver][DB2/NT64] SQL0802N
  Arithmetic overflow or other arithmetic exception
  occurred. SQLSTATE=22003).
  ANR9999D_3044804774 RdbExecuteSQLToStrings(tbnsql.c:1475)
  Thread<185>: rc 2343 from tbSQLExecuteToStrings.
  ANR9999D Thread<185> issued message 9999 from:
  ANR9999D Thread<185> 7ffc7e9aed42 OutDiagToCons()+b2
  ANR9999D Thread<185> 7ffc7e9a7a82 outDiagfExt()+122
  ANR9999D Thread<185> 7ffc7e4062ec RdbExecuteSQLToStrings()+11c
  ANR9999D Thread<185> 7ffc7e44b28c dbiDbSpaceStats()+30c
  ANR9999D Thread<185> 7ffc7e19c0faS tatusMonitorThread()+42a
  ANR9999D Thread<185> 7ffc7dabd913 startThread()+5b3
  ANR9999D Thread<185> 7ffca271fb80 o__realloc_base()+60
  ANR9999D Thread<185> 7ffca36d84d4 BaseThreadInitThunk()+14
  ANR9999D Thread<185> 7ffca6021791 RtlUserThreadStart()+21
  ANR9999D_1038905726 dbiDbSpaceStats(rdbdb.c:3885)Thread<185>: rc
  2343 from RdbExecuteSQLToStrings.
  ANR9999D Thread<185> issued message 9999 from:
  ANR9999D Thread<185> 7ffc7e9aed42 OutDiagToCons()+b2
  ANR9999D Thread<185> 7ffc7e9a7a82 outDiagfExt()+122
  ANR9999D Thread<185> 7ffc7e44b051 dbiDbSpaceStats()+d1
  ANR9999D Thread<185> 7ffc7e19c0fa StatusMonitorThread()+42a
  ANR9999D Thread<185> 7ffc7dabd913 startThread()+5b3
  ANR9999D Thread<185> 7ffca271fb80 o__realloc_base()+60
  ANR9999D Thread<185> 7ffca36d84d4 BaseThreadInitThunk()+14
  ANR9999D Thread<185> 7ffca6021791 RtlUserThreadStart()+21
  
  This warning is from status monitor failing to run a select to
  get information on database space.
  The warnings have no consequence and can be ignored.
  
  IBM Storage Protect Versions Affected:
  IBM Storage Protect Server 8.1.23.000 and higher
  
  | MDVREGR 8.1.23.0-TIV_5698MSV |
  
  
  
  Additional Keywords: SP TSM status monitor dbspace 2343
  TS016534473
  

Local fix

• n/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Storage Protect server users                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.26. Note that this is     *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Platforms fixed:  AIX, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels