Example 1 of the SORT command
In this example of the DB2® Thread
Sort Specification window, the threads are sorted first by Connection
type in ascending sequence, and next by Thread status in
descending sequence.
DGOMTWSS DB2 Thread Sort Specification
Specify field order by number in range 1 to 15. Enter 1 for Ascending or
2 for Descending sequence.
Column Order Sequence
More: - +
Prim Auth . . . . . . . . . . . __ _
Plan Name . . . . . . . . . . . __ _
Package/DBRM
Collection ID . . . . . . . . __ _
Program Name . . . . . . . . . __ _
Correlation . . . . . . . . . . __ _
Connection ID . . . . . . . . . __ _
Connection type . . . . . . . . 1 1
Requesting location . . . . . . __ _
Thread status . . . . . . . . . 2 2
Request count . . . . . . . . . __ _
Class 1 times
Elapsed . . . . . . . . . . . __ _
CPU . . . . . . . . . . . . . __ _
Class 2 times
Elapsed . . . . . . . . . . . __ _
CPU . . . . . . . . . . . . . __ _
Class 3 time . . . . . . . . . __ _
Command ===> ___________________________________________________________
F1=Help F2=Split F3=Exit F7=Up F8=Down F9=Swap
F12=Cancel F16=Look F17=Collect