Try OpenEdge Now
skip to main content
Database Essentials
Database Administration : Ensuring system availability : Database capacity
 

Database capacity

It is important to understand how much data is in your database today, and how much growth is expected. On existing databases, you should first consider the storage area high-water mark. The high-water mark is established by the number of formatted blocks in an area. In an area with many empty (unformatted) blocks, data is allocated to the empty blocks before the system extends the last extent of the area. The goal is to never use the variable extent, but to have it available if necessary.
Plan your excess capacity to be sufficient to cover your desired uptime. Each environment has a different amount of required uptime. Some systems can come down every evening, while 24x7 operations might only plan to be shut down once a year for maintenance. With careful planning you can leave your database up for long periods of time without the needing to shutdown. In most cases, the OpenEdge database does not need to be shut down for maintenance.
Your operating system might need to be shut down more often than your database for maintenance or an upgrade. Examples of operating system maintenance include: clearing memory, installing additional hardware, or modifying the operating system kernel parameters. In Windows, it is generally necessary to reboot the system every 30 to 90 days to avoid problems, while on most UNIX systems once a year is more common. You must plan for growth to cover this period of uptime for your system.