APAR status
Closed as program error.
Error description
Problem Description: In a Tivoli Storage Manager Server Command Line (dsmadmc) running the following select: ANR2017I Administrator TSMBATCH issued command: select DIRECTORY from DEVCLASSES where DEVCLASS_NAME='FILE_CLASS' could generate the following error: ANR0162W Supplemental database diagnostic information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right truncation.SQLSTATE=22001). ANR0157W Database operation INSERT for table Devclass.SQL failed with result code 2332 and tracking ID: 11ccf05f8. ANR0158W Database operation INSERT for table Devclass.SQL failed with operation code 2332 and tracking id 11ccf05f8. The data for column 0 is: (string, len=16)0x4449534B504F4F4C2D53312D50524F44 ANR0102E admsql.c(5357): Error 2332 inserting row in table . "Devclass.SQL". This is caused by the fact that the column DIRECTORY has 1025 character length while the file device class definition in field directory could contain more than 1025 characters. Customer/L2 Diagnostics : For example here we have a File device class with 1143 character length in the directory field, gathering a trace with flags dbstmt dbexec dbcmd sql, the trace file will shows the following: ------------------------------------------------- 13:59:28.573 [967646][admsql.c][4594][TsmSqlPrepareData]:Col 11, name DIRECTORY, type ADMITEM_STRING(1). 13:59:28.573 [967646][admsql.c][4642][TsmSqlPrepareData]:Col 11, string "/home/app/tsm/tsmadmin/diskvg-s1-01/01/prod,/home/app/tsm/tsmad min/diskvg-s1-01/02/prod,/home/app/t sm/tsmadmin/diskvg-s1-01/03/prod,/home/app/tsm/tsmadmin/diskvg-s 1-01/04/prod,/home/app/tsm/tsmadmin/ diskvg-s1-01/05/prod,/home/app/tsm/tsmadmin/diskvg-s1-01/06/prod ,/home/app/tsm/tsmadmin/diskvg-s1-01 /07/prod,/home/app/tsm/tsmadmin/diskvg-s1-01/08/prod,/home/app/t sm/tsmadmin/diskvg-s1-01/09/prod,/ho me/app/tsm/tsmadmin/diskvg-s1-01/10/prod,/home/app/tsm/tsmadmin/ diskvg-s1-02/01/prod,/home/app/tsm/t smadmin/diskvg-s1-02/02/prod,/home/app/tsm/tsmadmin/diskvg-s1-02 /03/prod,/home/app/tsm/tsmadmin/disk vg-s1-02/04/prod,/home/app/tsm/tsmadmin/diskvg-s1-02/05/prod,/ho me/app/tsm/tsmadmin/diskvg-s1-02/06/ prod,/home/app/tsm/tsmadmin/diskvg-s1-02/07/prod,/home/app/tsm/t smadmin/diskvg-s1-02/08/prod,/home/a pp/tsm/tsmadmin/diskvg-s1-02/09/prod,/home/app/tsm/tsmadmin/disk vg-s1-02/10/prod,/home/app/tsm/tsmad min/diskvg-s1-03/01/prod,/home/app/tsm/tsmadmin/diskvg-s1-03/02/ prod,/home/app/tsm/tsmadmin/diskvg-s 1-03/03/prod,/home/app/tsm/tsmadmin/diskvg-s1-03/04/prod,/home/a pp/tsm/tsmadmin/diskvg-s1-03/05/prod ,/home/app/tsm/tsmadmin/diskvg-s1-03/06/prod", len 1143. 13:59:28.633 [967646][tbcli.c][4234][RdbPrepareAndExecuteStmt]:Executing statement 'INSERT INTO "TSMDB1"."DEVCLASS_SQL" (DEVCLASS_NAME,ACCESS_STRATEGY,STGPOOL_COUNT,DEVTYPE,FORMAT,CAPA CITY,MOUNTLIMIT,MOUNTWAIT,MOUNTRETEN TION,PREFIX,LIBRARY_NAME,DIRECTORY,SERVERNAME,RETRYPERIOD,RETRYI NTERVAL,SHARED,HLADDRESS,MINCAPACITY ,WORM,DRIVE_ENCRYPTION,SCALECAPACITY,PRIMARYALLOC,SECONDARYALLOC ,COMPRESSION,RETENTION,PROTECTION,EX PIRATION,UNIT,LBPROTECT,LAST_UPDATE_BY,LAST_UPDATE) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?) --967646' submitted from admsql.c(5357). 13:59:28.635 [967646][output.c][7227][PutConsoleMsg]:ANR0162W Supplemental database diagnostic information: -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001).~ 13:59:28.636 [967646][tbcli.c][3856][RdbCliInsert]:Exiting with rc=2332 ---------------------------------------------------------------- ------- Tivoli Storage Manager Versions Affected: Tivoli Storage Manager Server version 6.x on all platforms Initial Impact: Low Additional Keywords: zz61 zz62 zz63 anr1062w CLI0109E 2332
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.2.5 and 6.3.3. Note that * * this is subject to change at the discretion * * of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. The current limit for the directory field in the devclass table is 1024 bytes. If this limit is exceeded then the output for this column will be truncated and message ANR2900W will be issued indicating that the output for this column has been truncated. Affected platforms: AIX, HP-UX, Solaris, Linux and Windows.
Temporary fix
Comments
APAR Information
APAR number
IC82409
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-03
Closed date
2012-11-14
Last modified date
2012-11-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
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
14 November 2012