2. Using Ingres Commands : 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 [-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.
-uuser
Specifies the effective user for the session, as described in Standard Flags and Parameters (see page 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.
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.