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.

Browser not supported