IC68473: IMPORT OF SPACE MANAGED OBJECTS TO 6.1 SERVER FAILS WITH ANR0162W

IBM Tivoli Storage Manager (TSM) server V6.1.4.x interim fix downloads
IBM Tivoli Storage Manager (TSM) server V6.2.1.x interim fix downloads

APAR status

• Closed as program error.

Error description

• Importing Client node data - space managed objects from TSM 5.x
  server to TSM 6.x server fails with ANR0162W message.
  Actlog shows:
   ANR0162W Supplemental database diagnostic information:
  -1:23513:-545 ([IBM][CLI Driver][DB2/AIX64] SQL0545N The
  requested operation is not allowed because a row does not
  satisfy the check constraint "TSMDB1.SPACEMAN_OBJECTS.IMSM_16".
  SQLSTATE=23513). (SESSION: 15, PROCESS: 1)
   ANR0157W Database operation INSERT for table SpaceMan.Objects
  failed with result code 8 and tracking ID: 111c17ab8. (SESSION:
  15, PROCESS: 1)
   ANR0158W Database operation INSERT for table SpaceMan.Objects
  failed with operation code 8 and tracking id 111c17ab8. The data
  for column 0 is: (int32)144. (SESSION: 15, PROCESS: 1)
   ANR0158W Database operation INSERT for table SpaceMan.Objects
  failed with operation code 8 and tracking id 111c17ab8. The data
  for column 1 is: (int32)32. (SESSION: 15, PROCESS: 1)
   ANR0158W Database operation INSERT for table SpaceMan.Objects
  failed with operation code 8 and tracking id 111c17ab8. The data
  for column 2 is: (int8)1. (SESSION: 15, PROCESS: 1)
   ANR0158W Database operation INSERT for table SpaceMan.Objects
  failed with operation code 8 and tracking id 111c17ab8. The data
  for column 3 is: (string,
  len=28)0x000000000A0102D606C36906340BAC608C2D32B26A3CC793C4C5C6C
  1. (SESSION: 15, PROCESS: 1)
   ANR0102E imsmins.c(735): Error 8 inserting row in table
  "SpaceMan.Objects". (SESSION: 15, PROCESS: 1)
   ANR0530W Transaction failed for session 16 for node Node1
  (Server) - internal server error detected. (SESSION: 15,
  PROCESS: 1)
   ANR0690E IMPORT (from Server Server01): Transaction failure -
  server aborted the transaction (1). (SESSION: 15, PROCESS: 1)
   ANR0728E IMPORT (from Server Server01): Processing terminated
  abnormally - internal error. (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> issued message 728 from: (SESSION: 15,
  PROCESS: 1)
   ANR9999D Thread<136> 0x0000000100011ef0 StdPutMsg (SESSION: 15,
  PROCESS: 1)
   ANR9999D Thread<136> 0x0000000100013584 outMsgf (SESSION: 15,
  PROCESS: 1)
   ANR9999D Thread<136> 0x000000010074f1bc PrintImportStats
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x000000010074bb80 XiImport (SESSION: 15,
  PROCESS: 1)
   ANR9999D Thread<136> 0x000000010074b4fc xiServerImport
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x0000000100742d2c DoImportServer
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x00000001007429ec SmServerImportSession
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x0000000100362444 DoAdminGeneral
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x000000010035df24 smExecuteSession
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x00000001000980c8 psSessionThread
  (SESSION: 15, PROCESS: 1)
   ANR9999D Thread<136> 0x0000000100009bb4 StartThread (SESSION:
  15, PROCESS: 1)
  Customer/L2 Diagnostics:
  None
  *NOTE*
  None
  Platforms affected:
  TSM 6.1, 6.2 Unix/Linux
  
  Initial Impact: Medium
  
  Additional Keywords: export import ZZ61 TSM
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM Tivoli Storage Manager      *
  *                 Server V6 importing space-managed objects    *
  *                 from V5.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available.  This     *
  *                 problem is currently projected to be fixed   *
  *                 in server levels 6.1.4.2, 6.1.5, 6.2.1.1,    *
  *                 and 6.2.2.  Note that this is subject to     *
  *                 change at the discretion of IBM.             *
  ****************************************************************
  See Error Description.
  

Problem conclusion

• The problem has been corrected.
  Affected Platforms: AIX, HP-UX, Sun Solaris, Linux, 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:

Modules/Macros

• IMSMINS
  

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