structure file

[ramyapriyacsit]

Could any one telme what is a strcuture file basically and what is the contents in it ?

and what are the files with extension .b1 and .d followed by "number"


thanks in advance,

regards
ramya

 

[parul]

Structure file is nothing but a text file where you define your database structure.

It is used to CREATE database.

You can get more info in the database administration guide.
http://documentation.progress.com/output/Progress91E/wwhelp/wwhimpl/js/html/wwhelp.htm
Go to Database -> Progress database administration -> Creating a Structure Description File
or alternatively download the pdf from PSDN.

-Parul.

 

[taqvia]

There are different ways of creating a database such as using prodb,graphical interface or using a structure file. While creating a enterprise level database it is adivisable to create using structure file. Structure file contains the database structure. A structure file should should atleast have a BI refernce and schema area.

Eg

#
b /data/bi_01/<dbname>.b1 f 8192( this is a fixed extent for BI)
#
b /data/bi_01/<dbname>.b2 (Always advisable to have one variable extent)
#
d "sport area" 7:64 /data/sc_area/<dbname>.d1

# you can have n number of extents

# Optional definitions include
a /data/ai_01/dbname.a1 f 16384
and so on

Structure file allows to manage area well

now to create a database
prostrct create <dbname> <dbname.st> -blocksize n

default blocksize for winnt is 4096 and for unix is 8192

once the database is created use
procopy empty8(or empty4) <dbname>

Arshad

 

[ramyapriyacsit]

Thanks a lot !