" %1 SortMergePass: Merged %2 runs, %3 Secs, %4 runs remaining, %5 reads = %6 M, runlen=%7, phase %8, %9 M on disk"
Item | Description |
---|---|
SQLCode |
1009143L |
Constant |
EMSG_SORT_INFOMERGED1 |
SQLState |
QSB40 |
ODBC 2 State |
OK |
ODBC 3 State |
OK |
Sybase Error Code |
21068 |
Severity Code |
|
Parameter 1 |
What is being sorted. |
Parameter 2 |
How many runs were merged in this merge pass.. |
Parameter 3 |
Time taken in this merge pass. |
Parameter 4 |
How many runs still to be merged. |
Parameter 5 |
How many page reads done in this pass. |
Parameter 6 |
How many Mbytes of data read in this pass. |
Parameter 7 |
Average length of runs in pages, this pass. |
Parameter 8 |
Fractional phase number reached. |
Parameter 9 |
How many Mbytes of data physically read in this pass. |
This information is provided after each merge pass. One merge pass merges a certain number of runs, using one pinned buffer page per run plus one pinned buffer for the output run. Note that there can be several passes in a merge phase. One merge phase reads all the sort data and produces a new set of runs that provide input to the next phase.