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.

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:

Open

• Storage ID: name of the storage

• Storage Type: type of storage. In our case DB2 enter SM_TRS_DB2.

• Description: short text description

• 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.