Direct links to fixes
APAR status
Closed as program error.
Error description
When performing a cross platform migration between AIX and Linux x86_64, the DSMSERV INSERTDB step can fail with an error ANR0100E tbinsert.c(8543): Error 1115 creating table "Export.Objects". In some cases, it will fail with one or more of these messages instead ANR0101E tbinsert.c(4574): Error 1115 opening table "Export.Sessions". ANR0101E tbinsert.c(4574): Error 1115 opening table "Export.Objects". ANR0101E tbinsert.c(4574): Error 1115 opening table "Export.Filespaces". The errors occur when a restartable server-to-server export/import session was suspended on the source server before starting the cross platform migration. Tivoli Storage Manager Versions Affected: Tivoli Storage Manager server 7.1.5. Initial Impact: Medium Additional Keywords: TSM IBM Spectrum Protect Tivoli Storage Manager DSMSERV EXTRACTDB and DSMSERV INSERTDB utilities to migrate from IBM AIX to Linux x86_64 121983 Migrating_Tivoli_Storage_Manager_from_one_OS_to_another.pdf
Local fix
First work around: Manually create the missing Export tables on the target server before running DSMSERV INSERTDB. Steps to accomplish this are: - On the source server, use 'db2look' to extract DDL for the three export tables to a file. db2look -d tsmdb1 -e -t EXPORT_FILESPACES EXPORT_OBJECTS EXPORT_SESSIONS -z tsmdb1 >export.ddl - On the target server, after running DSMSERV LOADFORMAT, use the DDL to create the tables db2start db2 -c -f export.ddl -t; db2stop - Run DSMSERV INSERTDB as normal Second work around: Empty out the export_objects table by canceling any suspended export sessions. - Issue QUERY EXPORT to confirm that there are suspended sessions - Issue CANCEL EXPORT * to cancel all suspended sessions - Issue either RUNSTATS ALL or RUNSTATS Export.Objects (in dsmadmc) to rebuild statistics for the table - Stop server and perform EXTRACTDB/LOADFORMAT/INSERTDB to load the updated database into target server
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager server users of the cross * * platform migration utilities. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in level 7.1.7. 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 number
IT15809
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-21
Closed date
2016-06-21
Last modified date
2016-06-21
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
[{"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":"7.1.3"}]
Document Information
Modified date:
26 September 2021