IT06492: "DELETE VOLUME" GETS ANR0104E ERROR 1114 DELETING ROW FROM TABLE "AS.VOLUME.STATUS" AND ANR9999D_2308965227 ON 7.1

IBM Tivoli Storage Manager (TSM) server V7.1.1.x interim fix downloads

APAR status

• Closed as program error.

Error description

• "delete volume" sometimes fails with ANR0104E error 1114
  deleting row from table "AS.Volume.Status" and
  ANR9999D_2308965227 on Tivoli Storage Manager server 7.1
  
  Here is the actlog.
  
  ANR2017I Administrator ADMIN issued command: DELETE VOLUME
  AAAAAAL6 discarddata=y wait=y  (SESSION: ***)
  ANR0984I Process *** for delete volume (disacrddata) started in
  the FOREGROUND at 00:17:02. (SESSION: ***, PROCESS: ***)
  ANR0104E asvol.c(5292): Error 1114 deleting row from table
  "AS.Volume.Status". (SESSION: ***, PROCESS: ***)
  ANR9999D_2308965227 DeleteVolId(asvol.c:4968)  Thread<28936>:
  Failure 9999 deleting orphaned segments for volume ***.
  (SESSION: ***, PROCESS: ***)
  ANR9999D Thread<28936> issued message 9999 from: (SESSION: ***,
  PROCESS: ***)
  ANR9999D Thread<28936>  0x000000010001cc50 StdPutText (SESSION:
  ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x000000010001d6b0 OutDiagToCons
  (SESSION: ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x00000001000098c8 outDiagfExt (SESSION:
  ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x00000001004e6504 DeleteVolId (SESSION:
  ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x00000001004e5800 AsDeleteVol (SESSION:
  ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x00000001006cd070 ssDeleteVolume
  (SESSION: ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x00000001002b92dc bfEndDeleteVol
  (SESSION: ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x0000000100be9824 AdmVolDelThread
  (SESSION: ***, PROCESS: ***)
  ANR9999D Thread<28936>  0x000000010000cb40 StartThread (SESSION:
  ***, PROCESS: ***)
  ANR2225W Discard Data process terminated for volume AAAAAAL6 -
  volume still contains data. (SESSION: ***, PROCESS: ***)
  ANR0986I Process *** for delete volume (discarddata) running in
  the FOREGROUND processed *** items for a total of *** bytes with
  a completion state of  FAILURE at hh:mm:ss. (SESSION: ***,
  PROCESS: ***)
  ANR1893E Process *** for delete volume (discarddata)completed
  with a completion state of FAILURE. (SESSION: ***, PROCESS: ***)
  
  The problem is that in 7.1.0, we introduced a new feature of
  "super aggregate", by default, files bigger than 10G will be
  stored as super aggregates. There are some background threads
  used to delete these kind of objects. There is a timing window
  for the "delete vol" thread between fetching a segment and
  deleting it. A background super aggregate deletion thread could
  delete this same segment in this timing window. This problem
  affects 7.1.0 and above server levers on all supported
  platforms. It's not related to specific volumes but related to
  super aggregates.
  
  Tivoli Storage Manager Versions affected:
  Tivoli Storage Manager Server 7.1 on all supported platforms.
  
  Customer/L2 Diagnostics (If Applicable)
  BFDESTROY, ASVOL and ASDEALLOC trace classes will be helped to
  find the issue.
  
  Initial Impact:
  Middle
  
  Additional Keywords:
  Tivoli Storage Manager, TSM, delete volume
  
  Additional L2 info:
  None.
  

Local fix

• Retry "delete volume".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users of the "DELETE       *
  * VOLUME" command.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This                      *
  * problem is currently projected to be fixed                   *
  * in levels 7.1.1.200 and 7.1.3. Note that this is subject     *
  * to change at the discretion of IBM.                          *
  ****************************************************************
  

Problem conclusion

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

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP