data_engine Status button - 'Quality of Service Type Status' window displays no QOS data

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe

Issue/Introduction

In the Infrastructure Manager, after opening the data_engine GUI and clicking the data_engine Status button it returns no data. It just displays an empty/white window.

This view normally reveals where all the QOS data is coming from, e.g., which probes/QoS.

Environment

- UIM 8.5x, 9.2x, 20.4x

Cause

- underlying query not accounting for bigint data type

Resolution

If the Status window remains empty, you can run the queries below to manually generate the same results.

--Uncomment and run the create table first

--create table #t (id bigint, name varchar(max), rname varchar (max), hname varchar(max), dname varchar(max), bname varchar(max), rrows bigint, hrows int, drows int, brows int, rsize int, hsize int, dsize int, bsize int) insert #t (name,rname,rrows,id, hname, dname, bname) SELECT sqd.name, object_name(i.object_id), sum(p.rows) as rowCnt, sqd.qos_def_id, replace(object_name(i.object_id),'RN','HN'), replace (object_name(i.object_id),'RN','DN'), replace(object_name (i.object_id),'RN','BN') FROM sys.indexes i INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN s_qos_definition sqd on sqd.qos_def_id = cast(replace(object_name (i.object_id),'RN_QOS_DATA_','') AS int) WHERE object_name(i.object_id) like 'RN_QOS_DATA_%' AND i.index_id <= 1 GROUP BY sqd.name,i.object_id, i.[name], sqd.qos_def_id

-- Then run the select statement

SELECT sqd.name AS 'QoS Name', object_name(i.object_id) AS 'Raw Data Table', sum(p.rows) as rowCnt, sqd.qos_def_id, replace(object_name(i.object_id),'RN','HN'), replace (object_name(i.object_id),'RN','DN'), replace(object_name (i.object_id),'RN','BN') FROM sys.indexes i INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id INNER JOIN s_qos_definition sqd on sqd.qos_def_id = cast(replace(object_name (i.object_id),'RN_QOS_DATA_','') AS int) WHERE object_name(i.object_id) like 'RN_QOS_DATA_%' AND i.index_id <= 1 GROUP BY sqd.name,i.object_id, i.[name], sqd.qos_def_id ORDER BY rowCnt DESC

Example results:

Once the above queries are run, you can decide what QOS you want to continue collecting, or disable, or change the monitoring interval for, so it doesn't collect specific QOS, or collect it as frequently.