How to set the "Compress Yes Adaptive" on a table for DB2 for LUW 11.1? (4292960)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to set the "Compress Yes Adaptive" on a table for DB2 for LUW 11.1?
Description

I have selected Compress Yes Adaptive in the model, what options do I need to select so that "Compress Yes Adaptive" is generated in the script when doing forward engineering for DB2 for LUW 11.1.
Cause

How To
Resolution

The attached sample model shows how to set the "Compress Yes Adaptive".
Right-click the table in the model and select Table Properties. Under General you will see Compress Yes and you can pick Adaptive

(figure 1).
In the Schema Generation Options, Option selection for Table you will have to check on Physical Storage to get that to generate
(figure 2).

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title