Reporting on the number of table reads, inserts, deletes and updates

Products

• Datacom/DB
• Datacom/AD
• Datacom

Issue/Introduction

How to create a report showing the number of Datacom table reads, insert, deletes and updates and including the area dataset name.

Environment

Release: 15.1

Resolution

The information can be obtained from the dynamic system tables.
MUF_TABLE_STATS contains the table statistics.
DIR_DATASET contains the area dataset name.

Run DBSQLPR with the following input to report on the table statistics and the area dataset name.

//SYSIN DD * 
SELECT A.MUF_NAME, A.DBID, A.AREA_NAME, B.DATASET_NAME,   
A.TABLE_NAME, A.TOTAL_DELETES,                            
A.TOTAL_READS, A.TOTAL_REQUESTS, A.TOTAL_UPDATES          
FROM  SYSADM.MUF_TABLE_STATS A, SYSADM.DIR_DATASET B      
WHERE A.AREA_NAME = B.AREA_NAME                           
AND A.DBID = 2; 
/*

This will produce a report on the stats from the time when the MUF was started to when the job is run.
The data can be selected by DBID as in the example or other criteria as required.

Additional Information

See Datacom documentation section MUF_TABLE_STATS (MFT) and DIR_DATASET (DRZ).