Creating Storage Areas

[Renee Crichlow]

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





​

 

[TomBascom]

That information is not terribly useful.

You need to be looking at individual table and index sizes.

Read this Storage Optimization Strategies before you go any further and then ask some questions.

 

[Renee Crichlow]

Hi Tom,

I did go through the slide and presentation but things are still not clear, hence me sending the data statistics. When the Progress 9.1E was first installed, I was not involved in that installation. I was informed that no storage areas were set up either.

Regards,
Renee

 

[TomBascom]

If you went through the presentation then you should have noticed that information about individual TABLE and INDEX sizes drives many decisions about how to create storage areas.

You have provided no information about any tables or indexes. Thus there is no advice that can be offered about what storage areas you might need.

You might want to consider hiring a consultant to help you out with this.

 

[Renee Crichlow]

Hi Tom,

I will go through the presentation again and see what I come up with.

Regards,
Renee

 

[Rob Fitzpatrick]

Hi Renee,

As I suggested in your other thread, you may get more out of the material if you watch the accompanying video, as you will not only see the information on the slides, you will also hear Tom explaining what it all means.

Also, you may want to look through the Progress documentation, in the Database Essentials and Database Administration manuals. There is a fair bit of info there on Type II storage areas.

 

[cj_brandt]

My guess is your company would actually save money by hiring someone to spend some time reviewing the database - maybe even remotely - and then giving you some direction. I think someone could give you a pretty clear idea on what needs to be done in a few hours. From your posts, it appears you could spend over 40 hours trying to figure out how to do this.

Just my 2 cents.

 

[Renee Crichlow]

Hi All,

I spoke to the head of the project and I was told to proceed without implementing the storage areas.

Thanks your assistance.

Regards,
Renee

 

[TomBascom]

That just makes it harder to fix later.

I suppose though, that that is what we consultants get paid for