Command Reference Guide > Command Reference Guide > Using Ingres Commands > 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 existing location.
The extenddb command has the following format:
extenddb -llocation [+user=[authuser]] [-uuser] [dbname...|-nodb]
[-aarea_dir] [-Udata,ckp,jnl,dmp,work|awork] [-rraw_pct]
[-drop] [-alter]
-llocname
Identifies the name of the new or existing location.
+user=[authuser]
Specifies the user name and password used for connection authentication, as described in Standard Flags and Parameters on page 14.
-uuser
Specifies the effective user for the session, as described in Standard Flags and Parameters on page 14.
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.
Note:  On VMS, this option does not create the area.
-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.
-rraw_pct
Specifies, for Raw locations, the percentage of the Raw Area to be allocated to this location. Use this option when creating a new location only. Do not use it when extending a database to an existing location.
-drop
Drops the specified location.
-alter
Modifies a location’s usage to add data, ckp, jnl, dmp, or work areas.
Last modified date: 01/30/2023