Progress RDBMS Administration Topic: Adding extent to your databse.

Here is a quick and simple way to add extent to your Progress RDBMS:

Assuming you are running a Progress V9 RDBMS with the following structure:

production.db
production_7.d1 (Fixed 200MB)
production_7.d2 (variable 300MB)
production_8.d1 (Fixed 400MB)
production_8.d2 (Variable 600MB)

You want to fix the production_8.d2 since it is getting quit large now for a single file. Here is a simplest way to to it.

Step 1: create a add_extent.st file with the following entries:

#add_extent.st - structure file for adding extent
d "your area":8,32 production_8.d3 F 5000
d "your area":8,32 production_8.d3

step 2: shut down the database and do a probkup (always good to back up).

step 3: prostrct add production add_extent.st You will be adding 2 extents to your database.

That's it. Start your database and you are up and running again. Total down time is less than 10 minutes (excluding backup).