DB2 10.5 for Linux, UNIX, and Windows

Transportable objects

When you transport data from a backup image to a target database, there are two main results. The physical and logical objects in the table spaces that you are restoring are re-created in the target database, and the table space definitions and containers are added to the target database.

The following logical objects are re-created:
  • Tables, created global temporary tables, and materialized query tables
  • Normal and statistical views
  • The following types of generated columns:
    • Expression
    • Identity
    • Row change timestamp
    • Row change token
  • User-defined functions and generated functions
  • Functions and procedures except for external routine executables
  • User-defined types
  • The following types of constraints:
    • Check
    • Foreign key
    • Functional dependency
    • Primary
    • Unique
  • Indexes
  • Triggers
  • Sequences
  • Object authorizations, privileges, security, access control, and audit configuration
  • Table statistics, profiles, and hints
  • Packages
The following components of a schema are not created on the target database:
  • Aliases
  • Column-organized tables
  • Created global variables
  • External routine executable files
  • Functional mappings and templates
  • Hierarchy tables
  • Index extensions
  • Jobs
  • Methods
  • Nicknames
  • OLE DB external functions
  • Range-partitioned tables
  • Servers
  • Sourced procedures
  • Structured types
  • System catalogs
  • Typed tables and typed views
  • Usage lists
  • Wrappers
Important: Expression based indexes are not supported when using the schema transport feature.
Related concepts:
Schemas