Kbase P126907: How to determine the current bi cluster size for a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/10/2009 |
|
Status: Verified
GOAL:
How to identify what the bi cluster size is for a database?
GOAL:
What is my current bi cluster size?
GOAL:
How to determine what my bi cluster size is?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
There are a couple of ways to determine what your current bi cluster size is:
1. Promon can be used against an online database to obtain this value:
Command syntax: promon dbname
Once in promon select option: 7. Database Status
The output of this menu option will provide you various information including the current bi cluster size.
Database Status:
Database version number: 1174
Database state: Not modified since last open (2)
Database damaged flags: None (0)
Integrity flags: None (0)
Database block size (bytes): 1024
Total number of database blocks: 4242
Database blocks high water mark: 2998
Free blocks below highwater mark: 0
Record blocks with free space: 116
Before image block size (bytes): 8192
* Before image cluster size (kb): 512 <===============
After image block size (bytes): 8192
Last transaction number: 1479
Highest file number defined: 0
Database created (multi-volume): 11/13/07 11:55
Most recent database open: 11/13/07 11:55
Previous database open: 11/13/07 11:55
Local schema cache time stamp: 04/14/06 23:55
Most recent .bi file open: 11/13/07 11:55
RETURN - show remaining, U - continue uninterrupted, Q - quit: q
2. The database log file contains a line item that identifies the bi cluster size as well.
The line contains the message number (4250).
Example:
Before-Image Cluster Size: 524288. (4250)
3. Run proutil dbname -C describe.
PROUTIL DESCRIBE provides a basic description of the database and details which features are enabled for the database. BI Clustersize is one of the descriptions.