(SM-2002) DB2 Transparent Storage

Owned by SNP
Dec 04, 2019

DB2 transparent storage is a database-server developed by IBM. It supports the relational DB model, but was recently also extended to support object-relational features and non-relational structures like JSON and XML.

Supported versions

The minimal supported version is 10.05.0004.

Storage setup

Use the transaction /DVD/SM_SETUP for Storage Management to setup a storage. 

For the storage type DB2 transparent storage (secondary database) - SM_TRS_DB2, fill in the following configuration parameters:


  • Storage ID: name of the storage
  • Storage Type: type of storage. In our case DB2 enter SM_TRS_DB2.
  • Description: short text description

Storage parameters

  • DB Connection Name: existing SAP Database Connection.
  • Connection mode: only Open SQL connection mode (option 'O') is supported by DB2 database.
  • Tablespace: table space. For more information, see DB2 table spaces.
  • COLUMN ORIENTED: if selected, tables created using this storage are column-organized.
  • Compression: if selected, adaptive compression is used.