Direct links to fixes
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 number
IT45697
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-03-13
Closed date
2024-07-31
Last modified date
2024-07-31
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
[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81A"}]
Document Information
Modified date:
27 September 2024