IFCID 027 - Sort Workfile Records

This topic shows detailed information about Record Trace - IFCID 027 - Sort Workfile Records.

MPEUSER 'BLANK'  RRS         16:05:01.16505224      5   1  27 SORT WORKFILE  NETWORKID:  DEIBMIPS  LUNAME:  IPSAQB11  LUWSEQ:  1511
B2PM    'BLANK'              N/P                               RECORDS                                                             
        |......................................................................................................................... 
         RECORDS IN NEW WORKFILE ......:                     3            SPARSE INDEX SPACE USED (KB) .:                         1         
         ESTIMATED SIZE ALL IN-MEM (KB):                    39            ESTIMATED RECORDS IN SP INDEX :                       400         
                                                                                                                                   
         SKIP FACTOR ............. :          1    RECORDS IN IN-MEMORY PART :          3   RECORDS IN WORKFILE PART .:           0
         DATA AREA SIZE (BYTES) ...:         88    KEY SIZE SP IDX (BYTES)   :          4   TOTAL NR OF IDX IN QUERY .:           1
         CURRENT IDX IN PROCESS . :          1                                                                                     
                                                                                                                                   
         TYPE OF RECORD ..........:          H          
                                             INDICATES SPARSE INDEX HASH USED (IN-MEMORY WORKFILE ONLY)           

RECORDS IN NEW WORKFILE

The number of records in the new work file.

Field Name: QW0027NR

SPARSE INDEX SPACE USED (KB)

The size of the in-memory work file in kilobytes (KB).

Field Name: QW0027OZ

ESTIMATED SIZE ALL IN-MEM (KB)

The APS estimated size of all sparse indexes in a query if they are all in the in-memory part (in KB).

Field Name: QW0027TZ

ESTIMATED RECORDS IN SP INDEX

The APS estimated number of records in the current sparse index.

Field Name: QW0027IR

SKIP FACTOR

The skip factor if sparse index records are found in the work file. It shows a value of 1 if found in the in-memory part.

Field Name: QW0027SF

RECORDS IN IN-MEMORY PART

The number of records in the in-memory part of the sparse index.

Field Name: QW0027IE

RECORDS IN WORKFILE PART

The number of records in the work-file part of the sparse index.

Field Name: QW0027WE

DATA AREA SIZE (BYTES)

The data area size for a sparse index (in bytes).

Field Name: QW0027DS

KEY SIZE SP IDX (BYTES)

The key size for a sparse index (in bytes).

Field Name: QW0027KS

TOTAL NR OF IDX IN QUERY

The total number of sparse indexes in the query.

Field Name: QW0027TS

CURRENT IDX IN PROCESS

The current sparse index that is processed.

Field Name: QW0027SC

TYPE OF RECORD

The type of record. Possible values are:

B

Indicates that a sparse index combination of hash and work file is used (both in-memory and physical work file).

H

Indicates a sparse index hash is used (in-memory work file only).

O

Indicates that a sparse index binary is used (in-memory work file only).

S

Indicates that no sparse index is used because of storage constraints.

T

Indicates that a sparse index work-file is used.

W

Indicates that no sparse index is used.

Field Name: QW0027SP