IBM Support

IT15809: DSMSERV INSERTDB CAN FAIL WITH ANR0100E TBINSERT.C(8543): ERROR 1115 CREATING TABLE "EXPORT.OBJECTS"

Subscribe

You can track all active APARs for this component.

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



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT15809

Modified date: 21 June 2016