Kbase P50310: What does the Size value indicate in a prorest -list?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2003 |
|
Status: Unverified
GOAL:
What does the Size value indicate in a prorest -list?
GOAL:
What does prorest -list do?
FIX:
From the documentation, prorest -list provides -
a description of all application data storage areas contained within a database backup. Use the information to create a new structure description file and database so you can restore the backup.
The Size value requires some interpretation. It is actually the maximum dbkey that was available for the area at the time of the backup. The value is calculated on the basis of the total blocks for the area, and not for the High Water Mark.
The following example uses 9.1D06 on RedHat 2.4.
1. probkup sports sportsbak0
2. prodel sports
3. prorest dummy sportsbak0 -list shows:
Area Name: Schema Area
Size: 20480, Records/Block: 32, Area Number: 6
Area Name: Info Area
Size: 2560, Records/Block: 32, Area Number: 7
Area Name: Order Area
Size: 2560, Records/Block: 32, Area Number: 8
4. In order to get the actual required size for the restore -
4.1 divide the Size by the Records/Block, e.g. 20480/32 = 640
4.2 multiply that result by the database blocksize, e.g. 640 * 1 = 640
You then have the total size in kilobytes that is required by the restore. You must specify at least this value if defining a new st file for the target database. Thus -
5. /* sports.st *./
#
b .
#
d "Schema Area":6,32 . f 640
#
d "Info Area":7,32 . f 80
#
d "Order Area":8,32 . f 80
6. prostrct create sports
(In this example if the created file sizes are compared with the file sizes of the source database they can be seen to be the same.)
7. prorest sports sportsbak0 restores ok.