hi,
May i know what is the meaning of db extent size? Is it database size or bi size?
I read through some threads on this subject. There are few things which i do not understand.
1. If db block size is 8192, then the max db size is 256GB
2. I also see that if the db size reaches 2GB, then it will crash.
3. Or is it only when the bi size reaches 2GB then it will crash.
Does it mean that when the db reaches 2GB, it will NOT crash becos the max is 256GB? Or it WILL crash as it reached 2GB?
What exactly is the terminology? Anyone can advise?
This is becos my .db has almost reached 2G but my bi file is only 2MB. I do a proutil truncate bi every nite.
Can anyone also help to advise on highwater mark level?
Progress 8.3D Sun Solaris 7.
Database version number: 8275
Database state: Open (1)
Database damaged flags: None (0)
Integrity flags: None (0)
Database block size (bytes): 8192
Total number of database blocks: 233536
Database blocks high water mark: 233527
Free blocks below highwater mark: 0
Record blocks with free space: 45
Before image block size (bytes): 8192
Before image cluster size (kb): 512
After image block size (bytes): 8192
Last transaction number: 48671810
Highest file number defined: 516
Database Character Set: iso8859-1
Database Collation Name: basic
Database created (multi-volume): - -
Thanks.
May i know what is the meaning of db extent size? Is it database size or bi size?
I read through some threads on this subject. There are few things which i do not understand.
1. If db block size is 8192, then the max db size is 256GB
2. I also see that if the db size reaches 2GB, then it will crash.
3. Or is it only when the bi size reaches 2GB then it will crash.
Does it mean that when the db reaches 2GB, it will NOT crash becos the max is 256GB? Or it WILL crash as it reached 2GB?
What exactly is the terminology? Anyone can advise?
This is becos my .db has almost reached 2G but my bi file is only 2MB. I do a proutil truncate bi every nite.
Can anyone also help to advise on highwater mark level?
Progress 8.3D Sun Solaris 7.
Database version number: 8275
Database state: Open (1)
Database damaged flags: None (0)
Integrity flags: None (0)
Database block size (bytes): 8192
Total number of database blocks: 233536
Database blocks high water mark: 233527
Free blocks below highwater mark: 0
Record blocks with free space: 45
Before image block size (bytes): 8192
Before image cluster size (kb): 512
After image block size (bytes): 8192
Last transaction number: 48671810
Highest file number defined: 516
Database Character Set: iso8859-1
Database Collation Name: basic
Database created (multi-volume): - -
Thanks.