Hi Joachim,
Thanks for the feedback! Really appreciate it. For your first suggestion, we have DB Size/Capacity under IO - Table spaces(y) and it is from this query
SELECT
DB_SIZE as DB_SIZE,
DB_CAPACITY as DB_CAPACITY
FROM
SYSTOOLS.STMG_DBSIZE_INFO
Can you please check and see if it is what you want? (It might require you to grant EXECUTE permission on SYSTOOLS)
For tablespace status, there is a column in IO - Table spaces(y) which shows the
TBSP_STATE from MON_GET_TABLESPACE . Can you please check if it is what you expect to have? (https://www.ibm.com/docs/en/db2/11.5?topic=functions-mon-get-tablespace-get-table-space-metrics)
We will definitely look into HADR value issue.
Thanks again for your feedback!
Best,
------------------------------
Yao Wu
Software Engineer
IBM
San Jose CA
------------------------------
Original Message:
Sent: Mon July 12, 2021 04:14 AM
From: Joachim Müller
Subject: Improvements and corrections for DMC
Hello DMC and dmctop Support Team,
Here are some improvements and corrections for dmctop:
- Good to see the whole Database size like db2top in t (Tablespaces) Value: DB Size 14.3T/15.3T (example)
- Tablespace Status as a column in t (Tablespaces) or (Storage - Table space utilization) in dmctop
- In HADR there is a wrong value for Peer Window: 90000.00s
Best regards,
Joachim
------------------------------
Joachim Müller
------------------------------
#Db2