User Guide > User Guide > A. Command Reference > extenddb Command--Extend Database to New Location
Was this helpful?
extenddb Command--Extend Database to New Location
The extenddb command extends databases to a new or an 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] [-P]
-llocation
Identifies the name of the new or existing location
+user=[authuser]
Specifies or prompts for the user name and password used for connection authentication. See Standard Flags and Parameters for details.
-uuser
Specifies the effective user for the session, as described in the Standard Flags and Parameters section
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.
Note:  ckp,jnl,dmp are only valid in conjunction with -nodb and -alter.
-drop
Drops the specified location
-alter
Modifies a location’s usage to add data, ckp, jnl, dmp, or work areas
-P
Specifies the user password. Use it along with the -uuser flag to specify an alternate user for the session. If you are not a database administrator, you must specify both flags.
Last modified date: 12/19/2024