alterdb Command—Set Database Characteristics

Permission required: DBA or a privileged user running as the DBA.

The alterdb command sets journaling and other characteristics for a database. You can use alterdb to halt journaling for a specified database. To restart journaling, you must use the ckpdb +j command.

For further details about journaling options, see the Database Administrator Guide.

[-init_jnl_blocks=n] [-jnl_block_size=n] [-next_jnl_file]

[-target_jnl_blocks=n] [-delete_invalid_ckp] [-n|-i[ucollation_name]]

[-keep=n] [-disable_mvcc] [-enable_mvcc] [-enable_mustlog]

[-disable_mustlog] [‑readonly|‑readwrite] [-verbose] [-help]

Halts journaling immediately, regardless of whether users are connected to the database.

Note: A side effect of using alterdb 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 checkpoint.

Deletes the oldest available checkpoint, including related journals and dump files. The request fails if you attempt to delete the only remaining valid checkpoint.

Specifies the size of the first journal file created after a checkpoint is taken (with the ckpdb command), where 0 <= n <= current target journal size.

The target journal size is displayed by infodb and is the parameter set by the -target_jnl_blocks flag.

Specifies the size of each journal file block for the database, where n = 4096, 8192, 16384, 32768, or 65536 bytes. The current size can be obtained by the infodb Journal block size parameter.

Specifies the number of journal blocks to be used for the database’s journal file, where 32 <= n <= 65536. The current size can be obtained by the infodb Target journal size parameter.

If using Ingres Cluster Solution, this option has no effect on journal files created as part of a cluster merge.

Deletes all invalid checkpoints. Where there is a previous valid checkpoint, the journal and dump files associated with the invalid checkpoint are retained. For invalid checkpoints with no previous valid checkpoint, associated journal and dump files are removed.

Converts a non-Unicode database to a Unicode database with Normalization Form D (NFD). If no collation name is specified, the default collation (udefault) is used.

Converts a non-Unicode database to a Unicode database with Normalization Form C (NFC). If no collation name is specified, the default collation (udefault) is used.

Preserves the specified number of last valid checkpoints and deletes all older checkpoints, valid or invalid.

Rejects requests for MVCC lock levels the next time the database is opened.

Accepts requests for MVCC lock levels the next time the database is opened.

Indicates that all operations on this database must be logged. Attempts to use SET NOLOGGING on this database will be rejected.

Disables the directive to log all operations on this database.

Sets a read-write database to read-only, or sets a read-only database to read-write.

Displays system commentary to the standard output device as the alterdb operation continues. This parameter can be used with any one other alterdb parameter.

Specifies the database name, as described in Standard Flags and Parameters (see page Standard Flags and Parameters). Specify one database name only. If required, identify the server_class.