IT29563: ANR0162W CLI0109E STRING DATA RIGHT TRUNCATION. SQLSTATE=22001

8.1.10.000-IBM-SPOC-WindowsX64
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads

APAR status

• Closed as program error.

Error description

• A backup session which is either from from a lan-free client or
  a proxy could display the following messages in the activity log
  :
  
  ANR0162W Supplemental database diagnostic
  information:-1:22001:-99999 ([IBM][CLI Driver] CLI0109E String
  data right truncation. SQLSTATE=22001). (SESSION: 987654)
  ANR0399I Session 12345 for node
  12345_XYZ_SOMENODENAME123_ABCDEF_1234_ABC has ended a proxy
  session for node 12345_XYZ_SOMENODENAME123_ABC
  
  The length combined is longer than the 64 characters allowed in
  a node name causing the truncation warning whilst attempting to
  get the platform for this node.
  
  Customer/L2 Diagnostics (If Applicable)
  Obtain a server trace using classes adm sql dbstmt dbcmd dbexec
  to determine the node name being queried.
  
  Example of the output seen :
  
  11:03:38.220 [2007833][tbcol.c][2694][TbPrintColToTrace]:
  no name( 0):STRING
  0x2084537a8(12345_XYZ_SOMENODENAME123_ABC
  (12345_XYZ_SOMENODENAME123_ABCDEF_1234_ABC)) len=71
  11:03:38.232 [2007833][tbrsql.c][1456][tbRegExecEx]:About to
  execute SELECT platform from TSMDB1.nodes where nodename=?
  11:03:38.554 [2007833][tbrsql.c][1540][tbRegExecEx]:exit,
  rc=TBRC_BAD_COLUMNS, wasExecd=False
  
  
  There are a few different symptoms, but these problems only
  happen if the backup session is either from a lan-free client or
  from a proxy.
  
  1 - Length of the node name plus the length of the storage agent
  or the length of the proxy node exceeds 64 characters in length.
  
  2 - The dsmffdc.log displays :
  
  (admutil.c:8917) Could not execute sql to get platform name in
  Nodes for node=12345_XYZ_SOMENODENAME123_ABC
  (12345_XYZ_SOMENODENAME123_ABCDEF_1234_ABC), 2332
  
  The node name in the example above shows that message is the
  concatenation of the node name and either the storage agent name
  or the proxy node name in parenthesis.
  This problem will happen in all cases of using the lan-free or
  proxy node backup.
  
  3 - Based on symptom example #2, it can also mean a
  determination cannot be made if the bytes in the backup are in a
  reasonable range for ransomware monitoring for that node.
  
  Initial Impact:
  Low
  
  IBM Spectrum Protect versions affected:
  Server  8.1.5 and higher on all supported platforms
  
  | MDVREGR 8.1.5.0-TIV_5698MSV |
  
  Keywords:
  TSM  TS002074457 ANR0162W Truncation SQL SQLSTATE=22001 sessions
  lan-free client proxy  proxied backup.
  

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 level 8.1.10. 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

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP