OE Database Reorganization
Introduction to prostrct
Introduction to prostrct 2
OpenEdge Storage Areas
• A Table, Index, or LOB can be placed in any data area.
• Data Areas can contain a mixture of indexes, tables, and LOBs.
• An Area can be dedicated to one object.
• Objects cannot span areas.
OpenEdge Structure File
When the data cluster (DC) size is greater than 1, the storage area is a Type II storage area.
• A DC is a set of contiguous Index (IX) or Data (RM) database blocks.
• A DC is e8, 64, or 512 blocks.
• A DC can only contain a specific Object (table, index, or LOB), so Scatter Factors should be lower.
QAD does not support changing the storage areas to a type different from the default (Type I). Type II storage area only shown for informational purposes.
Building a New Database
Make the blocksize 4k on Windows, 4k or 8k on Linux, and 8k on UNIX (based on historical performance benchmarks).
Copying the QAD Databases
The default empty databases to copy need:
• The QAD schema and base data loaded
• The relevant field-level help data loaded
• The QAD licenses entered
Viewing Structure Data
proenv>prostrct statistics admempty
WARNING: Before-image file of database admempty is not truncated. (1552)
Storage Utilization Statistics
Database: admempty
Primary data block size: 8192
BI block size: 8192
AI block size: 8192
Database Physical structure information
Statistics for Area: Control Area
Files in Area: Control Area
/dr01/admempty.db 655360
Database Block Usage for Area: Control Area
Active blocks: 5
Data blocks: 5
Free blocks: 0
Empty blocks: 75
Total blocks: 80
Extent blocks: 1
Records/Block: 64
Cluster size: 1
Statistics for Area: Primary Recovery Area
Files in Area: Primary Recovery Area
/dr01/admempty.b1 21102592
Statistics for Area: Schema Area
Files in Area: Schema Area
/dr01/admempty.d1 2752512
Database Block Usage for Area: Schema Area
Active blocks: 320
Data blocks: 320
Free blocks: 0
Empty blocks: 16
Total blocks: 336
Extent blocks: 1
Records/Block: 64
Cluster size: 1
Statistics for Area: GUI
Files in Area: GUI
/dr01/admempty_7.d1 38404096
Database Block Usage for Area: GUI
Active blocks: 4684
Data blocks: 4684
Free blocks: 0
Empty blocks: 4
Total blocks: 4688
Extent blocks: 1
Records/Block: 64
Cluster size: 1
Statistics for Area: GUI_IDX
Files in Area: GUI_IDX
/dr01/admempty_8.d1 12451840
Database Block Usage for Area: GUI_IDX
Active blocks: 1508
Data blocks: 1077
Free blocks: 431
Empty blocks: 12
Total blocks: 1520
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Statistics for Area: COMPCONF
Files in Area: COMPCONF
/dr01/admempty_9.d1 1310720
Database Block Usage for Area: COMPCONF
Active blocks: 159
Data blocks: 159
Free blocks: 0
Empty blocks: 1
Total blocks: 160
Extent blocks: 1
Records/Block: 64
Cluster size: 1
Statistics for Area: COMPCONF_IDX
Files in Area: COMPCONF_IDX
/dr01/admempty_10.d1 262144
Database Block Usage for Area: COMPCONF_IDX
Active blocks: 21
Data blocks: 21
Free blocks: 0
Empty blocks: 11
Total blocks: 32
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Statistics for Area: ADM_LOB
Files in Area: ADM_LOB
/dr01/admempty_11.d1 3014656
Database Block Usage for Area: ADM_LOB
Active blocks: 360
Data blocks: 360
Free blocks: 0
Empty blocks: 8
Total blocks: 368
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Database Block Usage Summary
Active blocks: 7057
Data blocks: 6626
Free blocks: 431
Empty blocks: 127
Extent blocks: 7
Total blocks: 7184
NO FULL BACKUP HAS BEEN DONE. (6943)
Changing Scripts to Use the New Database
Changing Scripts to Use the New Database 2
Advanced: prostrct add
Online version of prostrct add:
• Only one instance at a time
• Checks users have privilege to access new extents
• Creates extents
• Rechecks user privileges
• Locks admin area
• Adds extents
• Unlocks admin area
Advanced: prostrct repair
Always have a valid structure listing file.
