User Guide : A. Command Reference : extenddb Command--Extend Database to New Location
 
Share this page                  
extenddb Command--Extend Database to New Location
The extenddb command extends databases to a new or existing location.
The extenddb command has the following format:
extenddb -llocation [+user=[authuser]] [-uuser] [dbname...|-nodb]
[-aarea_dir] [-Udata,ckp,jnl,dmp,work|awork] [-drop] [-alter]
-llocname
Identifies the name of the new or existing location.
+user=[authuser]
Specifies or prompts for the user name and password used for connection authentication, as described in Standard Flags and Parameters.
-uuser
Specifies the effective user for the session, as described in Standard Flags and Parameters.
dbname…|-nodb
Specifies the list of databases to be extended. If no databases are to be extended, use the –nodb flag. This flag allows for the creation of a location without extending databases to it.
-aarea_dir
Specifies the directory (area_dir) that the new location will point to. This option creates the full directory path below the ingres root location. Use this option when creating a new location only. Do not use it when extending a database to an existing location.
-Udata,ckp,jnl,dmp,work|awork
Specifies the usage for the new location. Valid usages include data (database), ckp (checkpoint), jnl (journal), dmp (dump), work (work), and (awork) auxiliary work.
-drop
Drops the specified location.
-alter
Modifies a location’s usage to add data, ckp, jnl, dmp, or work areas.