IC71471: WHEN DRIVE NAME AND DEVICE NAME TOGETHER TOTAL MORE THAN 61 CHARACTERS , ANR0162W AND CLI0109E WILL OCCUR

APAR status

• Closed as program error.

Error description

• During dismount activity, the server will insert a record in
  activity_summary table.
  If the drive and device name totalled together are more than 61
  characters, the following will be reported:
  
  ANR8468I Volume 123456 dismounted from
  drive ABC_12340
  (/dev/lin_tape/by-id/1IBM_ULTRIUM-TD3_01234567891_-IBMtap-en) in
  library LIB_NAME. (SESSION: 123)
  
  ANR0162W Supplemental database
  diagnostic information: -1:22001:-99999 ([IBM][CLI Driver]
  CLI0109E
  String data right truncation. SQLSTATE=22001). (SESSION: 123)
  
  
  Diagnostics:
  
  "accnt adm ic db dbexec dbstmt" server trace shows:
  
  
  [131][tbcli.c][4168][RdbPrepareAndExecuteStmt]:Executing
  statement 'INSERT INTO "TSMDB1"."ACTIVITY_SUMMARY"
  (START_TIME,UNIQUE,END_TIME,ACTIVITY_NUM,ACTIVITY,OWNER,OBJECTS_
  EXAMINED
  ,OBJECTS_AFFECTED,OBJECTS_FAILED,BYTES_AFFECTED,IDLE_SECONDS,MED
  IAW_SECO
  NDS,THREADS_USED,RETURN_CODE,COMM_METH,COMM_ADDR,SCHEDULE,MOUNT_
  NAME,LIB
  RARY_NAME,DRIVE_NAME,MOUNT_INT_USE,COMM_WAIT_TIME)
  VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) --131'
  submitted
  from admactlg.c(663).
  
  [131][dbieval.c][609][DbiEvalSQLOutcomeX]:SQLSTATE
  22001,
  SQLCODE -99999, SQLMsg=[IBM][CLI Driver] CLI0109E  String data
  right
  truncation. SQLSTATE=22001.
  
  
  TSM Versions Affected:
  Tivoli Storage Manager server V6.1 and V6.2
  on all platforms.
  
  Initial Impact: Low
  
  Additional Keywords:
  zz61 zz62 drive name device ANR0162W CLI0109E
  

Local fix

• Use drive and device name that totals less than 61 characters
  or on Unix, link the current device name to a shorter name and
  update the path to use the new name.
  

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.1.5 and 6.2.3. Note that this is *
  *                                                              *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Sun Solaris, 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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP