Why does CA Datacom Dataquery show different SELFR and SELNR statistics for equivalent DQL mode FIND versus SQL mode SELECT requests?

Document ID : KB000012531
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Why does CA Datacom Dataquery show different SELFR and SELNR statistics for equivalent DQL mode FIND versus SQL mode SELECT requests?

 

For example, the following DQL query:

FIND ALL PERSONNEL
PRINT NUMBER, NAME, CITY-ADDRESS, STATE-ADDRESS, SOCIAL-SECURITY

Resulting statistics:

Current Dataquery FIND/SELECT Statistics.                               

------------------------------------------------------------------------

DATAQUERY:  FIND STATISTICS                       QUERY NAME:           

------------------------------------------------------------------------

 

     NUMBER REQUESTED: ALL                        COMPLETION DATE: 12/30

     NUMBER FOUND:           200                  COMPLETION TIME: 12:24

                                                                        

     FIND TERMINATED BECAUSE:  NORMAL END OF SEARCH WAS REACHED       

                                                                        

                               OVERALL    OPTIMIZATION     SEARCH       

                               -------    ------------     ------       

     ELAPSED TIME (SECONDS):         0               0          0       

     I/O EVENTS:                    16               0         16       

     SELFR TOTAL:                    2               1          1       

     SELNR TOTAL:                  201                        201       

     TOTAL BYTES:                  264                                  

 

 

While the following SQL query retrieves the same records but shows zero (0) SELFR and SELNR in the statistics:

SELECT NUMBER, NAME, CITY_ADDRESS, STATE_ADDRESS, SOCIAL_SECURITY  FROM SYSUSR.PERSONNEL

 

Resulting statistics: 

Current Dataquery FIND/SELECT Statistics.                                      

--------------------------------------------------------------------------DQEF0

DATAQUERY:  FIND STATISTICS                       QUERY NAME:                  

-------------------------------------------------------------------------------

                                                                               

     NUMBER REQUESTED: ALL                        COMPLETION DATE: 12/30/2016  

     NUMBER FOUND:           200                  COMPLETION TIME: 12:24:51    

                                                                               

     FIND TERMINATED BECAUSE:  NORMAL END OF SEARCH WAS REACHED               

                                                                                

                               OVERALL    OPTIMIZATION     SEARCH              

                               -------    ------------     ------              

     ELAPSED TIME (SECONDS):         0               0          0              

     I/O EVENTS:                     0               0          0              

     SELFR TOTAL:                    0               0          0              

     SELNR TOTAL:                    0                          0              

     TOTAL BYTES:                    0

 

 

Environment:
z/OS
Answer:

The most current CA Datacom® Core - 15.1 at https://docops.ca.com/ca-datacom/15-1/en section "(DQEF0) Query Statistics" at

https://docops.ca.com/ca-datacom/15-1/en/reference/ca-dataquery-reference/ca-dataquery-panels/dqef0-query-statistics states that the statistics shown state that those statistics are from the "FIND".

The CA Datacom Dataquery statistics SELFR and SELNR statistics are only available to Dataquery for DQL mode. 

This is working currently as designed since for Dataquery in SQL mode, all the processing is in done within the Datacom Multi-User (MUF) space.

Additional Information:

In order to get those statistics, you would need to set up and tailor Datacom Accounting to capture the specifics from the MUF.