Create a test Database.

[maday15]

I am very new to Progress, and have only been a DBA (DB2) for 11 months, I just wanted that out there to start. I was assigned the task of building a temporary test database and would like to know how to go about doing it. I have the .st file saved to my C: drive as a text file. The reason for this test is that we want to go from 1 storage area (Schema Area) to multiple storage areas (not sure how many yet), and we just want to test out how it is done, at the moment I am not worried about getting data into the different storage areas just creating the new DB with the different storage areas. We are on a Progress V9 database.

Thanks in advance for your help,
Brian

 

[Casper]

Edit the structure file to get the area's you desire.
(e.g. d "Area Name":Area number,rpb path_to_extent/extentname (optional f size))

Create a void database:

prostrct create <databasename> <structuredescriptionfile> -blocksize size db blocks in bytes.

Copy the appropiate empty blocksize database to the just created void database:

procopy $DLC/emptyn.db < just created void databasename>.

And voila you have an empty database with the desired storage area's.

HTH,

Casper.