Scan Activity

This block shows the total scan activity for each object, performed by the event.

The database name and page set name for each scan are printed if they are available. These do not usually occur in DB2® trace records. The decimal database ID (DBID) and object ID (OBID) occur instead. When possible, OMEGAMON® XE for DB2 PE translates the DBID and OBID into database names and page set names. If the translation does not work, the DBID or OBID decimal number is printed instead.

Scan Activity Workload Block Example

Here is an example of the Scan Activity Workload Block.

--- SCAN ACTIVITY ------------------------------------------------------------------------------------------------------------    
                            ------ROWS------  --QUALIFIED AT--  ----------ROWS-----------         --PAGES- ---------RI--------    
DATABASE  PAGESET   SCANS   PROCESS  EXAMINE  STAGE 1  STAGE 2  INSERTS  UPDATES  DELETES          SCANNED     SCANS  DELETES     
MEMBER    TYPE              FST INS  N-PIPE   PIPE RE  INS WAIT                                                                                                      
DAPSTEST  SAPSCL        1     63792    63792    63792       33        0        0        0             2942         0        0     
N/P       SEQD                    0        0        0        0                                                                        
DAPSTEST  6            33        33        0       33       33        0        0        0               56         0        0     
N/P       INDX                    0        0        0        0                                                                                                    
DAPSTEST  6            33        33       33        0        0        0        0        0               32         0        0     
N/P       SEQD                    0        0        0        0                                                                                                     
309       2             2    127584   127584   127584        2        0        0        0             5884         0        0     
N/P       SEQD                    0        0        0        0                                                                                                   
309       6             2         2        0        2        2        0        0        0                4         0        0           
N/P       INDX                    0        0        0        0                                                                                                    
309       6             2         2        2        0        0        0        0        0                2         0        0           
N/P       SEQD                    0        0        0        0                                                                                                         
TOTAL                  73    191446   191411   191411       70        0        0        0             8920         0        0    
TOTAL                             0        0        0        0

Field description

Here is a description of the field labels shown in the Scan Activity Workload Block.

DATABASE

The database name.

If the name is not available, the decimal DBID is printed.

If IFCID 058 is not present, DBID information is not available and therefore the field is left blank.

MEMBER

The name of the DB2 member within the DB2 data sharing group. This field shows N/P in a non-data-sharing environment.

PAGESET

The page set name.

Note: If the value shown in the TYPE column is INDX, this column shows the index name if provided by DB2.

TYPE

Indicates whether the scan performed by the data manager is an index file (INDX), a sequential data file (SEQD), or a sequential work file (SEQW).

SCANS

The total number of scans performed by the data manager.

ROWS PROCESS

Number of rows of all record types processed by a scan. As an example:

  SELECT A1 FROM TABLE_A WHERE A1=3

Where the table space that contains TABLE_A also contains TABLE_B and TABLE_C. Note that this does not include partitioned table spaces because a partitioned table space can have only one table.

For a simple table space, this is a count of all scanned rows from all three tables.

This field is identical to ROWS EXAMINE when the table space is segmented, or when the scan is an index scan.

FST INS

The number of rows inserted using the fast insert algorithm. This value is usually 1, but it is more than 1 for insert with subselect. End of change

ROWS EXAMINE

The number of rows of a specific record type processed by the scan. If the table space contains more than one table, scanned rows from the specific table only are counted.

For index scans, this value represents the number of index entries processed.

For a table space containing only one table, the value of ROWS EXAMINE is the same as the value of ROWS PROCESS.

N-PIPE

The number of times that fast insert could not be used for the insert operation, so a non-pipe insert algorithm was used instead. End of change

QUALIFIED AT STAGE 1

The total number of rows that were qualified at stage 1.

PIPE RE

The number of times that the fast insert pipe was refilled for the insert operation. End of change

QUALIFIED AT STAGE 2

The total number of rows that were qualified at stage 2. The value in this field cannot be greater than the value in QUALIFIED AT STAGE 1.

INS WAIT

The number of times that the insert operation waited for the fast insert pipe to fill. End of change

ROWS INSERTS

The number of rows inserted by the data manager.

ROWS UPDATES

The number of rows updated by the data manager.

ROWS DELETES

The number of rows deleted by the data manager.

PAGES SCANNED

The number of Getpage requests the data manager issued to the buffer manager. For an index scan, the field shows the number of Getpage requests on index pages. End of change

RI SCANS

The number of additional Getpage requests the data manager issued to the buffer manager to enforce referential constraints.

RI DELETES

The number of additional rows deleted or set to null due to referential integrity.

Feedback