Kbase 18858: How To Calculate The Size Of Extents When Making A Procopy From A Single Volume Database To A Multi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/17/2003 |
|
Status: Unverified
GOAL:
How to calculate the size of extents when making a procopy from a single volume database to a multi volume database.
FIX:
Below is an example against the sports database:
sports database size = 245.760
convert: 245.760 / 1024 = 240
How many extents you want?: 2 + 1 free
240 / 2: 120
Convert to multiple of 32: 120 / 32 = 3.75 around: 4
4 * 32 = 128
spdev = 2 extents 128 + 1 free
d /usr1/tsx/dal/PARIS/vol1/db/spdev.d1 f 128
d /usr1/tsx/dal/PARIS/vol3/db/spdev.d2 f 128
d /usr1/tsx/dal/PARIS/vol5/db/spdev.d3
b /usr1/tsx/dal/PARIS/vol2/bi/spdev.b1
a /usr1/tsx/dal/PARIS/vol4/ai/spdev.a1
a /usr1/tsx/dal/PARIS/vol4/ai/spdev.a2
create multi-volume database spdev :
prostrct create spdev spdev.st
copy database sports (single-volume) to database spdev (multi-volume):
procopy sports spdev.