Steps to add blocks

L

Luis Leite

New Member
Hello,
I need some help to perform necessary steps for adding blocks to an database using file .st
In that case i have blocks with 500MB and the last one (grouwing block) have already 1.5GB. So, if I had some blocks to the .st file, how can create new blocks supposing that the last block [1.5GB] should be an block with 500MB like all the others?
I use "prostrct add [dbname] [file.st]" for creating additional block, but I don't keep the actual size of the last one... How can i do?
Thanks for help...
By
LL
 
Hello,
I'm not sure I understand your problem. Progress uses 2 types of extents: fixed and variable. In my opinion you should always have fixed extents and 1 variable, however never use the variable one. With "prostrct statistics <db> > db.stat" you get an overview how many empty blocks are left. My procedure of adding extents will be:
"prostrct remove <db> d" (removing last variabel/empty extent)
"prostrct add <db> add.st" (adding some fixed and 1 variable extent).
Regards,
John
 
Thanks John. Well, supose that i have a database with 3 blocks, with 500 MB, 500 MB and last one 750 MB (variable extent). When add 2 more blocks, the new configuration could be 500, 500, 750, 500, 500 when add using prostrct add <>.st, but if want to be 500, 500,500,500,500, may I have to create a new database with this structure and make a procopy. Is the only method? Thanks.
 
Just add extents with st file

You can add extents in one step if you wish. Just perform the proutil add step and in the *.st file increment the extent names. If you add 3 more extents leave the last one a variable extent. The current last variable extent will be conferted to a fixed extent at the larger size. To make all fixed extents the same size, one option is to do a dump and load, which is a little more work.
 
You must log in or register to reply here.
Back
Top