Kbase P112415: How to add database extents online ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2009 |
|
Status: Verified
GOAL:
How to add database extents online ?
GOAL:
Can a database storage area be added online?
GOAL:
Can database data extents be added online?
GOAL:
Can database ai extents be added online?
GOAL:
Can database bi extents be added online?
GOAL:
Can prostrct be run online?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
OpenEdge Database Category: Maintenance
FIX:
Progress OpenEdge 10.1x introduces the option to create new Storage Areas or add extents to existing Storage Areas while the database is online. The "PROSTRCT ADDONLINE" utility allows the database administrator to add data areas and extents, before-image extents, and after-image extents without incurring downtime.
Restrictions:
1. Only one instance of prostrct addonline can execute at a single moment in time.
2. All connected users must have sufficient privileges to access the newly created extents. If the currently connected users dol not have sufficient privileges to access the new extents, these users must be disconnected before the addonline can be completed.
Adding extents is essentially the same as adding extents offline:
a. create a .st file describing the new Storage Area/extent information
b . run the following command :
$ prostrct addonline <dbname> newextentsfile.st [-validate]
The -validate option can be use to determine if the amount of space in the file system is enough to handle the new added files. Please do not use prior to OpenEdge 10.1B01 refer Solution P119375, "Adding Areas online fails with error 12867"
There is no functionality to REMOVE extents online, even if the last variable extent is empty. Existing variable extents will become FIXED extents at their current size.