1. New Features in Ingres 10S : DBMS Server Enhancements : Command Enhancements
 
Share this page                  
Command Enhancements
The following command flags are added:
Infodb ‑databases lists the database names in the current installation.
Alterdb ‑readonly sets a read-write database to read-only. Alterdb ‑readwrite sets a read-only database to read-write.
ckpdb -keep=n preserves the specified number of last valid checkpoints and deletes all older checkpoints.
Copydb and unloaddb -on_logfull=value adds a SET SESSION WITH ON_LOGFULL=value statement to the generated copy.in file.
Copydb and unloaddb ‑with_blankline generates redundant blank lines after every row in each data file generated. This option applies only when using the –c flag to generate ASCII data files.
Optimizedb and statdump -Ppassword specifies the user password for the database.
Auditdb –maxobuf=n specifies a maximum output buffer size, which can exceed the default of 8192 bytes.
These are documented in the Command Reference Guide.