A new option is added to the CREATE and MODIFY statements for DATABASE, USER, and PROFILE to allow setting a default table-level retentiondays value. This default is automatically applied when new tables are created under the corresponding database, user, or profile, unless a table explicitly specifies its own retentiondays.
The updated syntax is shared here:
DEFAULT RETENTIONDAYS = { retention_days | NULL }
Where retention_days represents table-level retention days for an OFS or MOTF table. It is an unsigned integer value between 1 and 90.