IBM equivalent for IDB2 OTHER READ in the BTACTSML request

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

What is IBM equivalent for OTHER READ in the BTACTSML request?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

There is no field called "OTHER-READ'. If you look at the IQL you would see that the fields are:

% :074 'OTHER READ'
:087 AVG(WAITS-OTHER-READ) (PF=N4.1)
:094 AVG(WAIT-OTHER-READ) (PF='HH:MM:SS.TTTTTT')

IBM DB2 Name for Wait Other Read is (QWACAWTR)