5 Database Utilities

The dbvolchange utility

Introduction

dbvolchange [options] volume_file_name

-v

Specifying the -v option will cause dbvolchange to output additional information during processing.

-d flags

Set debug flags. This is used to debug dbvolchange and is normally not used.

-c cfg

Specifies the server configuration file name.

-e size

Extension size (in MB). When the volume is getting full it will be extended of size MB. If size is 0, the volume will not be extended automatically by the server.

-m size

Maximum volume size (in MB).

-f flag

Define volume flags. The volume flags define the database behaviour. The following flags are supported:

[no]dsync - When set, this causes the operating system to force all changes related to database volumes to be written to disk. The dsync flags is disabled by default.

[no]lsync - When set, this causes the operating system to force all changes related to database log volumes to be written to disk on every commit operation. The lsync flag is disbled by default.

The dsync and lsync flags improve database consistency in case of a hardware failure or a power loss but have an impact on the runtime performance, because additional disk i/o operations need to be performed.

volume_file_name

The name of the volume file.