IT45697: WW APAR REVIEW FOR TS015360334 - ABSTRACT: SOME SERVER COMMANDS MAY ADD AN EXTRA NEW LINE CHARACTER IN OUTPUT FILE WHEN USING

8.1.24.000-IBM-SPSRV-WindowsX64-262
8.1.24.000-IBM-SPSRV-Linuxx86_64-262
8.1.24.000-IBM-SPSRV-Linuxs390x-262
8.1.24.000-IBM-SPSRV-Linuxppc64le-262
8.1.24.000-IBM-SPSRV-AIX-262

APAR status

• Closed as program error.

Error description

• The IBM Spectrum Protect FILETEXTEXIT server option specifies a
  file to which enabled events are routed. Especially each event
  being logged there is of fixed-size and a readable line.
  
  
  Some server commands may add an extra new line character in the
  output file :
  
  
  002017 002 00 000000000 002 003 20240202154705 BDE0010D
  ANR2017I Administrator SERVER_CONSOLE issued command: select
  colname,'' from syscat.columns where tabname='STGPOOL_DIRS'
  order by COLNO -comma
  ~
  ===> HERE a new/empty line added <===
  32140-000162 003 00 000000000 002 003 20240202151021 BDE0010D
  ANR0162W Supplemental database diagnostic information:
  -1:42601:-104 ([IBM][CLI Driver][DB2/AIX64]SQL0104N An
  unexpected token 'sessions' was found following 'select * '.
  Expected tokens may include: 'FROM'. SQLSTATE=42601
  32420.~
  
  This makes the output file unusable to further processing like
  for instance with QRadar.
  
  
  
  
  
  
  IBM Spectrum Protect Versions Affected:
  
  All IBM Spectrum Protect server versions on all supported
  platforms
  
  
  
  
  
  
  Additional Keywords:  TSM, "Storage Protect", "Spectrum
  Protect", TS015360334, Filetextexit
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Storage Protect server users.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Added a check for removing extra line.
  

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