Sort Activity - QW0095/96

System Parameters - Sort Activity - QW0095/96

The field labels shown in the following sample layout of System Parameters - Sort Activity - QW0095/96 are described in the following section.

MEMBER           : SAU85C    MAX RETURN CODE   :        0  WORKFILES   :     1.00  RECORDS         :    77.00
TOTAL SORTS      :        1  INITIAL WORKFILES :        1  RECORD SIZE :   832.00  SORT TYPE       : ESA
SORT KEYS        :     2.00  SORT COLUMNS      :    50.00  KEY SIZE    :    10.00  MERGE PASSES    :    27.00
AET/SORT         : 20.28794  DATA SIZE         :   822.00  ROWS DELETED:    72.00
PARTITIONING     :       NO  PARTITION TYPE    :     NONE  W-FILES PART:    85.00  PARTIT & SORTING:       NO
KEY SIZE W/ SORTL:    12.00  DATA SIZE W/ SORTL:    36.00

MEMBER

The member name of this Db2.

N/A means this Db2 is not part of a data sharing group.

Install parameter MEMBER NAME on panel DSNTIPK, or ZPARM MEMBNAME in DSN6GRP.

Field Name: QWPAMBRN

MAX RETURN CODE

The sort return code:

0

Successful

4

Empty - sort successful

8

Resource unavailable

12

Sort key too long

16

Error detected by fetch routine during input phase

20

Serious processing error

Field Name: QW0096RC

WORKFILES

The number of work files used for both input and merge phases.

Field Name: QW0096WF

RECORDS

The number of records sorted.

Field Name: QW0096NR

TOTAL SORTS

The total number of sorts that occurred during the reporting period.

Field Name: SQLTOTSO

INITIAL WORKFILES

The number of initial work files. The sorting of records can take more than one work file. The number of work files needed depends on the distribution of sort key values. The maximum number of work files is limited by the buffer pool size.

Field Name: QW0096IR

RECORD SIZE

The sort record size in bytes (the sort key size and the data area size).

Field Name: QW0096WR

SORT TYPE

The type of sort that occurred. The possible values are:

ESA

ORDER BY sort using the ESA sort hardware instructions

ESAG

GROUP BY sort using the ESA sort hardware instructions

ESAT

ESA tag sort using the ESA sort hardware instructions

RCYC

GROUP RECYCLING sort using the ESA sort hardware instructions

REG

Regular sort

NONE

No sort occurred.

Field Name: QW0096TS

SORT KEYS

The number of sort keys.

Field Name: QW0096SK

SORT COLUMNS

The number of sort columns.

Field Name: QW0096SC

KEY SIZE

The sort key size in bytes.

Field Name: QW0096KL

MERGE PASSES

The number of merge passes during sort processing.

Field Name: QW0096MP

AET/SORT

The average elapsed time per sort.

Field Name: SQLAVTSO

DATA SIZE

The sort data area size in bytes.

Field Name: QW0096DL

ROWS DELETED

The number of rows deleted because records were merged for the evaluation of column functions with GROUP BY.

Field Name: QW0096RL

PARTITIONING

Indicates whether the sorted records were partitioned.

Field Name: QW0096PP

PARTITION TYPE

Indicates when partitioning took place:

W

The work file was partitioned at the end of the input phase. No merge occurred.

M

The output was partitioned during the last merge pass.

O

One record was put into one partition.

P

The records were presorted before being partitioned.

N

The work file was not partitioned.

Field Name: QW0096PT

W-FILES PART

The number of work files, equal to the degree of parallelism, that sort has partitioned.

Field Name: QW0096PW

PARTIT & SORTING

Indicates whether the input records were only partitioned or partitioned and sorted:

YES

The records were only partitioned.

NO

The records were partitioned and sorted.

Field Name: QW0096PO

KEY SIZE W/ SORTL

Sort key size with sortl (in bytes).

Field Name: QW0096KZ

DATA SIZE W/ SORTL

Sort data area size with sortl (in bytes).

Field Name: QW0096DZ