Create new area

[Anemia]

Hello masters of Progress. I have one stupid question.

[Progress 10.1 A, Desktop - Windows 7]

I created local database on my HDD, using empty database empty4 from C:\Progress\OpenEdge\prolang\utf.

1. How to add new area for example "MyNew Area" (i have default named "Schema Area") ?

2. Which documents (Progress .pdf's) are full of db administration informations ?

tnx in advance

 

[RealHeavyDude]

I think that's the one you're looking for: http://communities.progress.com/pcom/docs/DOC-828

The information you are looking for in particular can be found in chapter 1 and 14. Nevertheless I recommend you reading the whole guide to get an understanding of what is involved to administer Progress databases.

Heavy Regards, RealHeavyDude.

 

[Rob Fitzpatrick]

Hello masters of Progress. I have one stupid question.

[Progress 10.1 A, Desktop - Windows 7]

1. How to add new area for example "MyNew Area" (i have default named "Schema Area") ?

Look up the section on creating databases in the Database Administration manual, and in particular the prostrct add command. While you're reading that material, make sure you understand the concept of Type I versus Type II data storage areas. Add your new areas as Type II, i.e. with blocks-per-cluster values of 8, 64, or 512.

Keep your tables and indexes in separate areas, and don't store any storage objects (tables, indexes, LOB columns) in the Schema Area.