Renee Crichlow
Member
Good morning,
I recently converted a database from version 9.1E to 10.2. Another member advised me to create storage areas however I am totally new to this stuff.
How should I go about creating storage areas based on the data below?
I ran dbanalysis and got the information below:
374896 RM block(s) found in the database.
89.18% of the RM block space is used.
101011 index block(s) found in the database.
Size key:
B = bytes
K = kilobytes
M = megabytes
G = gigabytes
T = terabytes
0 free block(s) found in the database.
0 index table block(s) found in the database.
1 sequence block(s) found in the database.
62 empty block(s) found in the database.
475974 total blocks found in the database.
database analysis complete Thu Dec 01 10:33:52 2011
Storage Utilization Statistics
Database: bdostest
Primary data block size: 4096
BI block size: 8192
AI block size: 8192
Database Physical structure information
Statistics for Area: Control Area
Files in Area: Control Area
E:\data\loanstest\mwtest\d\bdostest.db 32768
Database Block Usage for Area: Control Area
Active blocks: 5
Data blocks: 5
Free blocks: 0
Empty blocks: 3
Total blocks: 8
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Statistics for Area: Primary Recovery Area
Files in Area: Primary Recovery Area
e:\data\loanstest\mwtest\d\bdostest.b1 2228224
Statistics for Area: Schema Area
Files in Area: Schema Area
e:\data\loanstest\mwtest\d\bdostest.d1 1949564928
Database Block Usage for Area: Schema Area
Active blocks: 475907
Data blocks: 475907
Free blocks: 0
Empty blocks: 61
Total blocks: 475968
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Database Block Usage Summary
Active blocks: 475912
Data blocks: 475912
Free blocks: 0
Empty blocks: 64
Extent blocks: 2
Total blocks: 475976
I recently converted a database from version 9.1E to 10.2. Another member advised me to create storage areas however I am totally new to this stuff.
How should I go about creating storage areas based on the data below?
I ran dbanalysis and got the information below:
374896 RM block(s) found in the database.
89.18% of the RM block space is used.
101011 index block(s) found in the database.
Size key:
B = bytes
K = kilobytes
M = megabytes
G = gigabytes
T = terabytes
0 free block(s) found in the database.
0 index table block(s) found in the database.
1 sequence block(s) found in the database.
62 empty block(s) found in the database.
475974 total blocks found in the database.
database analysis complete Thu Dec 01 10:33:52 2011
Storage Utilization Statistics
Database: bdostest
Primary data block size: 4096
BI block size: 8192
AI block size: 8192
Database Physical structure information
Statistics for Area: Control Area
Files in Area: Control Area
E:\data\loanstest\mwtest\d\bdostest.db 32768
Database Block Usage for Area: Control Area
Active blocks: 5
Data blocks: 5
Free blocks: 0
Empty blocks: 3
Total blocks: 8
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Statistics for Area: Primary Recovery Area
Files in Area: Primary Recovery Area
e:\data\loanstest\mwtest\d\bdostest.b1 2228224
Statistics for Area: Schema Area
Files in Area: Schema Area
e:\data\loanstest\mwtest\d\bdostest.d1 1949564928
Database Block Usage for Area: Schema Area
Active blocks: 475907
Data blocks: 475907
Free blocks: 0
Empty blocks: 61
Total blocks: 475968
Extent blocks: 1
Records/Block: 32
Cluster size: 1
Database Block Usage Summary
Active blocks: 475912
Data blocks: 475912
Free blocks: 0
Empty blocks: 64
Extent blocks: 2
Total blocks: 475976