|
|
|
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.
The alterdb command has the following format:
alterdb [-delete_invalid_ckp] [-n|-i[ucollation_name]] dbname[/server_class]
[-target_jnl_blocks=n |-jnl_block_size=n |-next_jnl_file|-init_jnl_blocks=n |
-disable_journaling | -delete_oldest_ckp] [-verbose] [-help]
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.
Specifies the database name, as described in Standard Flags and Parameters. Specify one database name only. If required, identify the server_class.
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.
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.
Journaling must be off when issuing this command.
Causes Ingres to start a new journal file for this database.
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.
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.
Displays system commentary to the standard output device as the alterdb operation continues. This parameter can be used with any one other alterdb parameter.
Displays command syntax online.