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