Location of dynamically added logical log files

The database server allocates log files in dbspaces, in the following search order. A dbspace becomes critical if it contains logical-log files or the physical log.

Pass

Allocate log file in

1

The dbspace that contains the newest log files

(If this dbspace is full, the database server searches other dbspaces.)

2

Mirrored dbspace that contains log files (but excluding the root dbspace)

3

All dbspaces that already contain log files (excluding the root dbspace)

4

The dbspace that contains the physical log

5

The root dbspace

6

Any mirrored dbspace

7

Any dbspace

If you do not want to use this search order to allocate the new log file, you must set the DYNAMIC_LOGS parameter to 1 and run onparams -a -i with the location you want to use for the new log. For details, see Monitor events for dynamically added logs.