Configuring Your System
In Levels of Data Protection, we discussed various levels of data security.
When you configure your system, there are some additional questions to be answered:
- How do I divide the workload over several disks to get the best performance?
TRANSDBand its shadows should preferably be on fast disks, see Performance Aspects of Shadowing.
- How much disk space do I need for shadowing?
In general, you will have problems if
LOGDBrun out of disk space. When this happens the system cannot continue. Therefore, it is important to make sure that there is enough space for these databanks.
TRANSDBgrows depends on the number of transactions and how fast the background threads are able to perform the transactions on the shadows. When the transactions are performed on the shadows, the space in
TRANSDBwhere they were stored is released.
LOGDBgrows depends on whether the
LOGoption is used and how often backups are taken and
DROP LOGis performed, since
LOGDBand releases space (but the file size remain unchanged).
- Note: Try and keep the length of time the shadows are offline to a minimum. If you do not, you risk
TRANSDBgrowing and filling the disk to capacity.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40