Kbase P131774: dbanalys when ran online shows zeros for record block summary for all non-metaschema tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2010 |
|
Status: Verified
SYMPTOM(s):
dbanalys shows zeros for record block summary for all non-metaschema tables
dbanalys was run while the database was online
Command: proutil dbname -C dbanalys > filename
Idxanalys portion of dbanalys is missing in the output file
Index Block Summary header is the last item displayed in the output file.
Warning message 6740 is being displayed during chanalys output.
<name> Block <dbkey> with invalid chain type <number> on RM chain (6704)
<name> Block <dbkey> with invalid chain type 1 on Free chain (6704)
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
Workaround:
1. Run dbanalys against the database when the database is offline.
2. Restore a copy or backup of the database onto another machine. Modify the structure file to identify where the extents are located now. Perform a prostrct repair dbname to update the information within the database. Then perform the dbanalys against this copy of the database that is offline.
3. Run tabanalys and idxanalys individually using the commands: proutil dbname -C tabanalys or idxanalys.
4. Run dbanalys against individual areas instead of the entire database. Command: proutil dbname -C dbanalys areaname