Direct links to fixes
8.1.2.000-IBM-SPSRV-AIX
8.1.2.000-IBM-SPSRV-Linuxppc64le
8.1.2.000-IBM-SPCMS-Linuxx86_64
8.1.2.000-IBM-SPCMS-WindowsI32
8.1.2.000-IBM-SPSRV-Linuxs390x
8.1.2.000-IBM-SPCMS-WindowsX64
8.1.2.000-IBM-SPSRV-Linuxx86_64
8.1.2.000-IBM-SPSRV-WindowsX64
8.1.2.000-IBM-SPOC-AIX
8.1.2.000-IBM-SPOC-LinuxPPC64le
8.1.2.000-IBM-SPOC-Linuxs390x
8.1.2.000-IBM-SPOC-Linuxx86_64
8.1.2.000-IBM-SPOC-WindowsX64
7.1.8.000-TIV-TSMSRV-AIX
7.1.8.000-TIV-TSMSRV-HP-UX
7.1.8.000-TIV-TSMSRV-Linuxppc64
7.1.8.000-TIV-TSMSRV-Linuxs390x
7.1.8.000-TIV-TSMSRV-Linuxx86_64
7.1.8.000-TIV-TSMSRV-SolarisSPARC
7.1.8.000-TIV-TSMSRV-WIN
7.1.8.000-TIV-TSMOC-AIX
7.1.8.000-TIV-TSMOC-Linuxx64
7.1.8.000-TIV-TSMOC-Windows
7.1.8.000-TIV-TSMOC-LinuxPPC64
7.1.8.000-TIV-TSMOC-LinuxPPC64le
7.1.8.000-TIV-TSMOC-LinuxS390
IBM Spectrum Protect Server V8.1 Fix Pack 2 (V8.1.2) Downloads
APAR status
Closed as program error.
Error description
Running the following SQL from within an admin command line interface (dsmadmc) produces : select * from paths ANS8001I Return code 4 The following messages are logged within the activity log : ANR0162W Supplemental database diagnostic information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001). ANR0157W Database operation INSERT for table PATHS.SQL failed with result code 2332 and tracking ID: 0000004105902B20. ANR0158W Database operation INSERT for table PATHS.SQL failed with operation code 2332 and tracking id 0000004105902B20. The data for column 0 is: (string,len=7)0x4E54424B504553. ANR0158W Database operation INSERT for table PATHS.SQL failed with operation code 2332 and tracking id 0000004105902B20. The data for column 1 is: (string,len=6)0x534552564552. ANR0158W Database operation INSERT for table PATHS.SQL failed with operation code 2332 and tracking id 0000004105902B20. The data for column 2 is: string,len=16)0x564D574152455F46494C455F4D454E31. ANR0158W Database operation INSERT for table PATHS.SQL failed with operation code 2332 and tracking id 0000004105902B20. The data for column 3 is: (string,len=5)0x4452495645. ANR0158W Database operation INSERT for table PATHS.SQL failed with operation code 2332 and tracking id 0000004105902B20. The data for column 4 is:(int32)139. ANR0102E admsql.c(5794): Error 2332 inserting row in table "PATHS.SQL". The error 2332 means : #define GRC_BAD_COLUMNS 2332 This can be caused by a DIRECTORY entry within the devclasses table being greater than 128 characters. The maximum characters allowed within the devclasses table is 1025 characters, but the maximum allowed within the sql_paths table is 128. If you have a path associated to a file device class which is larger than 128 characters, you will see this issue. This is only seen for shared file libraries as the path is taken from the device class table. Customer/L2 Diagnostics (If Applicable) Obtaining a server trace using classes "adm sql dbstmt dbcmd dbexec" will show messages similar to the following : [admsql.c][4804][TsmSqlPrepareData]:Col 13. [tbtbl.c][1641][tbGetColNameFromRow]:Returning columnName DIRECTORY from table table PATHS.SQL for column 13. [tbtbl.c][1659][tbGetColNameFromRow]:Exit with rc 0. [admsql.c][4917][TsmSqlPrepareData]:Col 13, name DIRECTORY, type ADMITEM_STRING(1). [admsql.c][4983][TsmSqlPrepareData]:Col 13, string "\\12.3.4.567\k$\Pool_048,\\12.3.4.567\k$\Pool_049,\\12.3.4.567\ k$\Pool_050,\\12.3.4.567\k$\Pool_051,\\12.3.4.567\k$\Pool_052,\\ 12.3.4.567\k$\Pool_058,\\12.3.4.567\k$\Pool_059,\\12.3.4.567\k$\ Pool_060,\\12.3.4.567\k$\Pool_061,\\12.3.4.567\k$\Pool_062,\\12. 3.4.567\k$\Pool_063,\\12.3.4.567\k$\Pool_064,\\12.3.4.567\k$\Poo l_065,\\12.3.4.567\k$\Pool_066,\\12.3.4.567\k$\Pool_067,\\12.3.4 .567\k$\Pool_068,\\12.3.4.567\k$\Pool_069,\\12.3.4.567\k$\Pool_0 70,\\12.3.4.567\k$\Pool_071,\\12.3.4.567\k$\Pool_072,\\12.3.4.56 7\k$\Pool_073,\\12.3.4.567\k$\Pool_074,\\12.3.4.567\k$\Pool_075, \\12.3.4.567\k$\Pool_076,\\12.3.4.567\k$\Pool_077,\\12.3.4.567\k $\Pool_078,\\12.3.4.567\k$\Pool_079,\\12.3.4.567\k$\Pool_080,\\1 2.3.4.567\k$\Pool_081,\\12.3.4.567\k$\Pool_082,\\12.3.4.567\k$\P ool_083,\\12.3.4.567\k$\Pool_084,\\12.3.4.567\k$\Pool_085,\\12.3 .4.567\k$\Pool_086,\\12.3.4.567\k$\Pool_087,\\12.3.4.567\k$\Pool _088,\\12.3.4.567\k$\Pool_089,\\12.3.4.567\k$\Pool_090", len 949. [tbcli.c][10871][TraceSetInputParameters]:col=16, name=LAST_UPDATE, type=DATETIME, value=09/28/2016 12:13:34 [tbcli.c][4683][RdbPrepareAndExecuteStmt]:Executing statement 'INSERT INTO "TSMDB1"."PATHS_SQL" (SOURCE_NAME,SOURCE_TYPE,DESTINATION_NAME,DESTINATION_TYPE,HANDL E,LIBRARY_NAME,NODE_NAME,DEVICE,EXTERNAL_MANAGER,ZOSMSERVER,COMM METHOD,LUN,INITIATOR_ID,DIRECTORY,ONLINE,LAST_UPDATE_BY,LAST_UPD ATE) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) --207' submitted from admsql.c(5791). [output.c][7647][PutConsoleMsg]:ANR0162W Supplemental database diagnostic information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001).~ [tbcli.c][3996][RdbCliInsert]:Exiting with rc=2332. [output.c][7647][PutConsoleMsg]:ANR0157W Database operation INSERT for table PATHS.SQL failed with result code 2332 and tracking ID: 000000723CC6D030.~ The above shows that there is a directory with a length of 949 characters which exceeds the directory length in the paths_sql table. This does not affect the workings of the path itself, purely the select output from the paths table. Tivoli Storage Manager Versions Affected: All supported versions of TSM and IBM Spectrum Protect version on all platforms Initial Impact: Low|Medium|High Low Additional Keywords: TSM, Spectrum Protect, IC82409, file devclass, truncate, blank
Local fix
Issue Q PATH to obtain the output required.
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.2. Note that this is * * subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms for reported release: AIX, HP-UX, Solaris, Linux, and Windows. Platforms fixed: AIX, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT17987
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-16
Closed date
2017-02-14
Last modified date
2017-02-14
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
Document Information
Modified date:
01 September 2023