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