Is there a parameter to set the DB size???

saravanakumar

saravanakumar

Member
Hi Everybody,
1) Do we have any parameter to set the Progress DB Size (i.e. increase or decrease the size of Database). :dizzy:
2) Can we restrict the maximum number of records to be available in a table (in other words can we set the size of a table separately)???

Can someone help me out in this regard. Thanks in advance.
 
1- No, but i Really wonder how you would think a parameter would work to decrease the size of the database....
2- No, maximum number of records is only per area and is in current releases unreachable. Again I am wondering how you would tell your customer that he can't store any records from a particular table anymore because you restricted the maximum number of possible records. In earlier releases there was a maximum of 2 billion rows per table/area.

FWIW, the following numbers are for OpenEdge 10.1B+:

A progress database consists of area's. There is a limit of 32000 area's for a Progress database. The maximum size of an area is apporx. 1PB.
An area consists of extents, there is a maximum of 1024 extents per area.
Each extent has a maximum size of 1TB (that is if -EnableLargeFiles is activated.)

Since you cannot split a table across more then 1 area, the maximum size of a table is approx 1PB.

Regards,

Casper.
 
Thanks for your valuable information Casper. Just want to know if any parameter is available to either increase or decrease the DB size.

Thanks for your valuable information...
 
No not a parameter. You mean the shrinking (for decrease) option in e.g. SQL Server? And adding "free space" on-the-fly (also in SQL Server)?

I would call these options "parameters", and if you mean those than the answer is no for Progress db. You can only add free space with the prostrct add (online) option or at db creation.

Also, if you backup a database, the free space is removed from the database in the backup. So, if you restore the database according to another .st file which contains extents of a total size approximately the size of the backup, you can actually "shrink" the free space in a progress database. Of course you can not cut away more than the free space :p.

All the above is not a parameter but an actual action you have to perform and none is on-the-fly, except the prostrct add online option (OE 10 +).
 
You must log in or register to reply here.
Back
Top