Warning 1009144

" %1 SortMergeDone: Ave mem %2 M, %3 Secs, %4 passes, %5 reads, %6 M data= %7 pgs, %8 phases, %9 M on disk"

Item	Description
SQLCode	1009144L
Constant	EMSG_SORT_INFOMERGED2
SQLState	QSB41
ODBC 2 State	OK
ODBC 3 State	OK
Sybase Error Code	21069
Severity Code	1
Parameter 1	What is being sorted.
Parameter 2	Time-average number of pinned page buffers used by Phase II of the sort.
Parameter 3	Time taken for Phase II of the sort.
Parameter 4	Total number of passes in Phase II.
Parameter 5	Total number of page reads in Phase II.
Parameter 6	Total Mbytes of data sorted.
Parameter 7	Total number of pages of data sorted.
Parameter 8	Number of merge phases in the merge sort of Phase II.
Parameter 9	Total Mbytes of physical reads in Phase II.

Probable cause

This information is provided at the end of Phase II to summarize the resource usage of the whole merge sort. The last pass of the sort is separately reported on by an EMSG_SORT_INFOMERGED1 message.