Kbase P7472: Considerations concerning .st-file creation in v. 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What is the best organizational strategy in terms of upgrading to Progress 9 by using new structure description-file?
FIX:
-a general advise is to put items (tables, indexes) that are reasonably big (>500-700 Megabytes)into their own areas.
-ensure db integrity by creating all db storage areas on local disks.
-protect against disk failures, by creating the after-image storage area on a separate disk from the disks storing the database control and primary recovery areas.
-improve performance by creating the primary recovery area on a seperate disk from the disk storing the database control area and its extents. Never store the primary recovery area extents on the same disk as the after-image extents.
-if using two-phase commit, create the transaction log area on the same disk as the database control area.