Kbase P27308: How to determine the AI blocksize of a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/06/2003 |
|
Status: Unverified
GOAL:
How to determine the AI blocksize of a database?
GOAL:
How to identify the AI blocksize of a database?
FIX:
The After Image Blocksize can be determined by viewing the database log file
(dbname.lg) for the following line:
BROKER 0: After-Image Block Size: 8192. (4255)
This information can also be obtained via promon against the database.
Command syntax:
promon dbname
The promon menu will be displayed:
PROGRESS MONITOR Version 9
Database: dbname
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information
M. Modify Defaults
Q. Quit
Enter your selection:
Enter selection 7. Database Status and the following screen will be displayed:
Database Status:
Database version number: 1115
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: 2982
Free blocks below highwater mark: 0
Record blocks with free space: 7
Before image block size (bytes): 8192
Before image cluster size (kb): 512
After image block size (bytes): 8192 <=========== AI Blocksize information
Last transaction number: 1483
Highest file number defined: 0
Database created (multi-volume): 06/19/03 15:42
Most recent database open: 06/19/03 15:53
Previous database open: 06/19/03 15:53
Local schema cache time stamp: 06/18/03 20:03
Most recent .bi file open: 06/19/03 15:53
RETURN - show remaining, U - continue uninterrupted, Q - quit: