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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

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

Resolution

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.