Fixes are available
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 number
IC68473
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-05-06
Closed date
2010-05-11
Last modified date
2010-09-13
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
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A"}]
Document Information
Modified date:
17 September 2021