IC67179: NAS BACKUP WITH TOC=YES CAN FAIL WITH ANR0158W DATABASE OPERATION INSERT FOR TABLE NDMP.NODES(TEMP)

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

APAR status

• Closed as program error.

Error description

• ANR0162W Supplemental database diagnostic information:
  -1:22001:-99999 ([IBM][CLI Driver]
  CLI0109E STRING DATA RIGHT TRUNCATION. SQLSTATE=22001).
  (SESSION: 98765, PROCESS: 123)
  ANR0102E tbcli.c(2036): Error 8 inserting row in table
  "NDMP.Nodes(TEMP)". (SESSION: 98765, PROCESS: 123)
  ANR0157W Database operation INSERT for table NDMP.Nodes(TEMP)
  failed with result code 8 and tracking ID: 0000000011FBE628.
  (SESSION: 98765, PROCESS: 123)
  ANR0158W Database operation INSERT for table NDMP.Nodes(TEMP)
  failed with operation code 8 and tracking id 0000000011FBE628.
  The data for column 0 is: (int64)9459956. (SESSION: 98765,
  PROCESS: 123)
  ANR0158W Database operation INSERT for table NDMP.Nodes(TEMP)
  failed with operation code 8 and tracking id 0000000011FBE628.
  The data for column 1 is: (int64)3972885. (SESSION: 98765,
  PROCESS: 123)
  ANR0158W Database operation INSERT for table NDMP.Nodes(TEMP)
  failed with operation code 8 and tracking id 0000000011FBE628.
  The data for column 2 is: (string,
  len=10)0x48525F4C656974756E67. (SESSION: 98765, PROCESS: 123)
  ANR0102E tocbuild.c(902): Error 8 inserting row in table
  "NDMP.Nodes(TEMP)". (SESSION: 98765, PROCESS: 123)
  ANR0515I Process 60 closed volume VOLUMENAME. (SESSION: 98765,
  PROCESS: 123)
  ANR8336I Verifying label of NAS volume VOLUMENAME in drive
  DRIVENAME (rst1a). (SESSION: 98765, PROCESS: 123)
  ANR8468I NAS volume VOLUMENAME dismounted from drive DRIVENAME
  (rst1a) in library LIBRARYNAME. (SESSION: 98765, PROCESS: 123)
  ANR1104E NAS Backup process 123 terminated - NDMP session errors
  encountered. (SESSION: 98765, PROCESS: 123)
  [...]
  ANR2032E BACKUP NODE: Command failed - internal server error
  detected. (SESSION: 98765, PROCESS: 123)
  
  Versions Affected:
  Tivoli Storage Manager server 6.1. on all supported platforms
  
  Initial Impact:
  Medium
  
  Additional Keywords:
  zz61 ndmp netapp nas toc tocbuild tocread trace
  

Local fix

• Run the NAS backup without TOC until a fix is available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager users             *
  *                 performing a NAS backup with TOC=Yes         *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels 6.1.4 and 6.2.2. 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