Warning 1009142

" %1 SortMerge0: %2 records, PhaseI=%3 Secs, %4 runs total, %5 pgs=%6 M, runlen=%7, %8 est. phases"

Item Description

SQLCode

1009142L

Constant

EMSG_SORT_INFOMERGED0

SQLState

QSB39

ODBC 2 State

OK

ODBC 3 State

OK

Sybase Error Code

21067

Severity Code

1

Parameter 1

What is being sorted.

Parameter 2

How many records are being sorted.

Parameter 3

Time taken in Phase I.

Parameter 4

How many runs to be merged.

Parameter 5

How many pages of data to be sorted.

Parameter 6

How many Mbytes of data to be sorted.

Parameter 7

Average number of pages in a run.

Parameter 8

Estimated number of merge phases.

Probable cause

This information is provided after the Phase I radix sorting is complete and the Phase II merge-sorting is about to begin. Each run consists of a sequence of pages that have been radix sorted in Phase I. These runs are merged together in Phase II to finish the sort.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com