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
-uuser
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.