IT23518: SERVER COMMANDS MIGHT FAIL WITH SQLSTATE=428C4, SQLCODE=-216 FROM TABLE AND RC = 9994.

8.1.1.200-IBM-SPSRV-WindowsX64
8.1.1.200-IBM-SPSRV-Linuxx86_64
8.1.1.200-IBM-SPSRV-Linuxs390x
8.1.1.200-IBM-SPSRV-Linuxppc64le
8.1.1.200-IBM-SPSRV-AIX
8.1.5.000-IBM-SPCMS-WindowsX64
8.1.5.000-IBM-SPCMS-WindowsI32
8.1.5.000-IBM-SPCMS-Linuxx86_64
8.1.5.000-IBM-SPOC-WindowsX64
8.1.5.000-IBM-SPOC-Linuxx86_64
8.1.5.000-IBM-SPOC-Linuxs390x
8.1.5.000-IBM-SPOC-LinuxPPC64le
8.1.5.000-IBM-SPOC-AIX
8.1.5.000-IBM-SPSRV-WindowsX64
8.1.5.000-IBM-SPSRV-Linuxx86_64
8.1.5.000-IBM-SPSRV-Linuxs390x
8.1.5.000-IBM-SPSRV-Linuxppc64le
8.1.5.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 5 (V8.1.5) Downloads
IBM Spectrum Protect Server V8.1.1.X interim fix downloads

APAR status

• Closed as program error.

Error description

• A server command might fail with the following error messages
  (here the command INSTR END fails):
  ANR2017I Administrator <ADMIN> issued command: INSTRUMENTATION
  END
  ANR9999D_3831306406 ReportSQLDiagInfo(dbieval.c:1591)
  Thread<77>: Missing sqlState=428C4, sqlCode=-216 from table.
  Returning rc = 9994.
  ANR0162W Supplemental database diagnostic information:
  -1:428C4:-216 ([IBM][CLI Driver][DB2/NT64] SQL0216N  The number
  of elements on each side of a predicate operator does not match.
  Predicate operator is ">". SQLSTATE=428C4).
  ANR9999D_2835836899 InstGetDB2stmtPass2(instr.c:615) Thread<77>:
  Error in fetching DB2 statement stats, rc=9994
  
  DBSTMT trace shows:
  14:02:46.831
  [77][tbrsql.c][2831][PrepareStatement]:psSQLPreparing "SELECT
  stmt_pkg_cache_id, stmt_exec_time, num_executions,
  rows_returned, rows_read, num_log_buffer_full, lock_waits,
  total_section_sorts, deadlocks, sort_overflows, lock_wait_time,
  case when insert_timestamp > (current timestamp - 786,4 seconds)
  then 1 else 0 END, case when length(stmt_text) >= 1024 then
  substr(stmt_text,1,1024) else stmt_text end as stmt_text FROM
  TABLE(MON_GET_PKG_CACHE_STMT( 'D', NULL,
  '<modified_within>14</modified_within>', -2)) WHERE stmt_text
  not like 'DROP%' and stmt_text not like 'CREATE%' and stmt_text
  not like 'drop%' and stmt_text not like 'create%' and stmt_text
  not like 'ALTER%' and stmt_text not like 'CALL REORG%' and
  (NUM_EXECUTIONS > 0 or STMT_EXEC_TIME > 0) and stmt_text like
  '%TSMDB1%' and stmt_text not like '%TABLE_CAT%' and stmt_text
  not like 'WITH%' and stmt_exec_time is not null and
  num_executions is not null and rows_returned is not null and
  stmt_exec_time >= 1000 ORDER BY stmt_pkg_cache_id -- 77" for len
  950.
  14:02:46.844
  [77][dbieval.c][1591][PutConsoleMsg]:ANR9999D_3831306406
  ReportSQLDiagInfo(dbieval.c:1591) Thread<77>: Missing
  sqlState=428C4, sqlCode=-216 from table. Returning rc = 9994.~
  The problematic part of the SQL statement is the following where
  it uses a comma as decimal delimiter:
  "... case when insert_timestamp > (current timestamp - 786,4
  seconds) then 1 else 0 END, ..."
  
    IBM Spectrum Protect Versions Affected: all supported
    Initial Impact: Low
    Additional Keywords: DB2CODEPAGE DB2TERRITORY TSM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available.                           *
  * This problem is currently projected to be fixed in levels    *
  * 8.1.1.100 and 8.1.5.                                         *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  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