maximum_columns

Default: Dependent on the database

The maximum_columns parameter enables you to reduce the column count when a table split occurs because of the maximum column limitation of the relational database. For example, if you want to add a column containing the value of the audit timestamp file to the first table of a split table, you can set the maximum_columns parameter to 1023 instead of 1024. By doing so, you avoid moving an item from a full table to a secondary table to make room for the new column. The table below shows the maximum columns and ranges for different relational databases.

Database

Default

Range

Oracle

1000

1–1000

SQL Server

1024

1–1024

DB2

1000

1–1000