FileNumberHeadroom

Integer

2048

Purpose

The FileNumberHeadroom parameter specifies by how much the highest allocated file number can be increased in the current database server session (in the JADE development environment or by using the jadload or jadloadb program) without restarting the database server.

The highest database file number cannot be greater than 65,484.

Parameter is read when …

The database server node is initialized; for example, when you restart the database server.

Hint

If you anticipate that you will add database files that would increase the highest‑used file number by more than the default value of 2,048 in the current work session, increase this value so that you do not have to restart the database server. (Exception 3003 is raised when the value defined for this parameter is exceeded in a work session.)