Kbase P10826: How to use prostrct create ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/01/2003 |
|
Status: Unverified
GOAL:
How to use Prostrct create ?
FIX:
The PROSTRCT Utility allows us to create the database file structure and modify it and repair it as desired by the DBA.
To create a database structure we use PROSTRCT CREATE, this utility reads the information from the <dbname>.st file where the information of the location for all the extent files of the database is set by the DBA.
A typical .st file must have the following structure :
Type token,Storage Area:Area Num,Records per Block,Extent Path,Extent Length
Sample :
sports.st
b /bipath/sports.b1 f 2048
b /bipath/sports.b2
#
d "Schema Area":6,32 /dbpath/sports.d1 f 1024
d "Schema Area":6,32 /dbpath/sports.d2 v 3145728
#
d "User Area":7,128 /dbpath2/sports_7.d1 f 2048
d "User Area":7,128 /dbpath2/sports_7.d2
In this case we have two areas for data and one for the BI , the first column identifies the type of extent that will be created.
'b' indicates a Before-Image extent
'd' iindicates a Database extent
'a' indicates an After-Image extent
't' indicates a Transaction Log extent.
The second Columns indicate the Area Name, Area Number and optionally the amount of records per block; The BI,AI an TL areas does not requires this information.
The next column indicates the physical location of the files the name of the file could be or not included in the definition of the file and we must make sure first that the file system structure can handle our definitions.
The last column indicates the size of the files, if we use the 'f' (fixed length) flag, this will preformat the assigned disk space for the file but if no size will be assigned then we can leave this column with no value this will let this file grow up to 2 GB, if we want to limit its growth for larger file support we can use the 'v' (variable length) flag and specify the desired limit for the file.
Once the <dbname>.st file is created we just need to use the following command:
prostrct create dbname.st
This will create the structure for our database and will prepare this structure to be filled up with our table metaschema.