Kbase P47580: Empty block type found below highwater mark. error 3916 reported in DBANALYS / TABANALYS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/01/2006 |
|
Status: Verified
SYMPTOM(s):
Empty block type found below highwater mark. Area "" : . (3916)
dbkey = (3910)
DBANALYS / TABANALYS reports error 3916
DBANALYS / TABANALYS reports error 3910 detailing which dbkey the 3916 warning message refers
Not on a Solaris platform
CAUSE:
This message is used as part of the analysis report. It merely warns that there are EMPTY blocks BELOW the highwater mark (HWM , being the last block formatted in the database).
This is known to be caused by:
o Re-loading data back into the /same/ database from which the data was dumped and deleted. The highwater mark can only be re-set through loading into a new database structure.
o If crash recovery is skipped, empty blocks can show up below the high-water mark, because the full recovery mechanism needed to add blocks to the RM-chain was skipped.
o Running dbanalysis or tabanalysis on a database that has not been properly shutdown (eg: database crashed or emergency shutdown issued or run online). When crash recovery is run, the referenced blocks will be added to the free-chain and this warning message will dissapear.
o A block that was initially too full to be included in the RM-chain, then had a record deleted from it and to save time, this block was not added to the RM-chain, which is considered normal behaviour.
FIX:
These are merely a WARNING messages, which on their own, do not indicate database corruption. The empty blocks themselves are harmless, they WILL get re-used through time.