User Guide : 6. Working with Databases : Altering Databases : Alter Database Dialog
 
Share this page                  
Alter Database Dialog
The Alter Database dialog lets you set options for backup, logging, Unicode, and journaling. This dialog contains the following pages:
General
Output Log
These pages are described in the following sections.
Most options on the Alter Database dialog are mutually exclusive, meaning you may choose only one for alteration.
For more information, see Alter a Database.
General Page
This page lets you select one of the following options. Options are mutually exclusive, and only one action is performed per invocation of the utility.
Delete the Oldest Backup
Deletes the oldest available backup, including related journals and dump files. If you attempt to delete the only remaining valid backup, the request fails.
Delete All Invalid Backups
Deletes all invalid backups. Where there is a previous valid backup, the journal and dump files associated with the invalid backup are retained. For invalid backups with no previous valid backup, associated journal and dump files are removed.
Preserve a Number of Backups
Preserves the number of last valid backups that you specify and deletes all older backups, valid or invalid
Default: 10
Range: 1–256
Disable MVCC (Multiversion Concurrency Control)
Rejects requests for MVCC lock levels the next time the database is opened
Enable MVCC (Multiversion Concurrency Control)
Accepts requests for MVCC lock levels the next time the database is opened
Disallow SET NOLOGGING
Disables the directive to log all operations on this database
Allow SET NOLOGGING
Indicates that all operations on this database must be logged. Attempts to use SET NOLOGGING on this database will be rejected.
Normalization (Unicode)
Converts a non-Unicode database to a Unicode database with the normalization form you select:
NFD
Specifies Normalization Form D, more useful for internal processing
NFC
Specifies Normalization Form C, the best form for generated text
If no collation setting is specified, the default collation (udefault) is used.
Collation
When Normalization is specified, sorts results according to collation weights specified in the Unicode standard:
udefault—Unicode version 6.0.0
udefault5—Unicode version 5.0
Start a New Journal File
Starts a new journal file for this database
Halt Journaling Immediately
Halts journaling immediately, regardless of whether users are connected to the database.
Note:  A side effect of using the alteration operation to disable journaling is that incorrect journaling status is displayed for tables. Tables display journaling as enabled—although journaling is disabled for the database—where you would expect enabled after next backup.
Set Initial Journal Size
Specifies the size of the first journal file created after a backup is made (with the ckpdb command (see Back Up a Database)), where 0 <= n <= current target journal size.
Target Journal Size is displayed on the Backups page of the Database Properties dialog (see Viewing Database Properties) and is set by the following parameter.
Default: 256
Set Size of Each Block
Specifies the size of each journal file block for the database: 4096, 8192, 16384, 32768, or 65536 bytes. You can obtain the current size from the Journal Block Size parameter on the Backups page of the Database Properties dialog (see Viewing Database Properties).
Default: 4096
Set Target Number of Blocks
Specifies the number of journal blocks to be used for the database's journal file, where 32 <= n <= 65536. You can obtain the current size from the Target Journal Size parameter on the Backups page of the Database Properties dialog (see Viewing Database Properties) (see View Database Properties (see View Database Properties)).
If using Ingres Cluster Solution, this option has no effect on journal files created as part of a cluster merge.
Default: 256
Verbose Mode, Print Information as the Alter Proceeds
Displays system commentary to the standard output device as the alteration operation progresses
Output Log Page
The Output Log page displays the output of the alteration process based on the options you have selected on the General page.