Salesforce

Does dbscan repair database blocks?

Information

 
TitleDoes dbscan repair database blocks?
URL NameP97847
Article Number000149457
EnvironmentAll Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge 11.x
Question/Problem Description
Does dbscan repair database blocks?
Reading the output of "proutil <db> -C dbscan"
What is a line with just a number (<num>) within dbscan report?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
The command "proutil <db> -C dbscan" will never fix a block. It scans the database and reports regularly what block, identified by its dbkey, is currently checked as per the messages:

Scan @ dbkey <dbkeyX>
Scan @ dbkey <dbkeyY>

At the end of the scan it reports the message:

<time> Database Repair session end. (334)


The following messages are possible errors reported by dbscan:

Can't find Blk <block#> (dbkey#)

** Bad Frag <recidX> for rec <recidY> Error <number>

Workaround
Notes
It might happen that the message 334 is sent before the list of "scan @ dbkey" is ended. The messages reporting the blocks scanned are not finished to be written when the process is finished and the order of the messages is not respected within the output. This can happen on machines where reading is very fast.

In the following case:
        Scan @ dbkey 1966080
        Scan @ dbkey 1998848
        Scan @ dbkey 2031616
        Scan @ dbkey Database Repair session end. (334)
        2064384
        Scan @ dbkey 2097152
        Scan @ dbkey 2129920
        Scan @ dbkey 2162688
"2064384" was the part missing of the message "scan @ dbkey" displayed prior to the message 334; it is NOT the dbkey of a database block  fixed by dbscan.
Keyword Phrase
Last Modified Date9/13/2015 10:07 AM

Powered by