(SM-1811) DB2 transparent storage

Owned by SNP
Nov 02, 2018

 Database-server developed by IBM. It supports the relational DB model but was recently extended to support object-relational features and non-relational structures like JSON and XML, too.

Storage Setup

Transaction /DVD/SM_SETUP is used for Storage Management to setup/edit storage. 

For storage type DB2 Transparent Storage (Secondary Database) - SM_TRS_DB2,  there are following configuration parameters:


  • Storage ID: name of the storage
  • Storage Type: type of storage - DB2 in our case
  • Description: short text description


  • DB Connection Name: existing SAP Database Connection. Use the following link for more information.
  • Connection mode: only Open SQL connection mode (option 'o') is supported by DB2 database
  • Tablespace
  • Column Oriented: if selected, tables created using this storage are column-organized.
  • Compression: if selected, adaptive compression is used