Db2

I recently installed DMC and have been working on getting familiar with the tool. An odd thing I found on the Dashboard , a level of 100% for storage on one of our test servers.


What puzzles me is the database file systems are not full, nor is memory, nor can I find a definition for the storage column. Does anyone know what "Storage" represents on the DMC dashboard?

Thanks in advance for any information.

------------------------------
Bill Ferguson
------------------------------

#Db2

Hi Bill,

May I know the version of your DMC? and is your db a storage group db or not?
This Storage is the percentage of used space to total size of the file system for all database storage group. We get the storage info from table function: ADMIN_GET_STORAGE_PATHS. Can you help execute the following SQL to view the storage information? You can compare the fs_used_size and fs_total_size with the used and size of your file system. Thank you.

select
case when sum(fs_total_size) is null then -1 else sum(fs_total_size)/(1024*1024*1024) end as fs_total_size,
case when sum
(
fs_used_size
)
is null then -1 else sum(fs_used_size)/(1024*1024*1024) end as fs_used_size
from
(
select
distinct fs_id,fs_total_size,fs_used_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2))
)
fetch first 100 rows only with ur

------------------------------
Rui Li
------------------------------

Original Message:
Sent: Wed March 30, 2022 11:45 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

I recently installed DMC and have been working on getting familiar with the tool. An odd thing I found on the Dashboard , a level of 100% for storage on one of our test servers.


What puzzles me is the database file systems are not full, nor is memory, nor can I find a definition for the storage column. Does anyone know what "Storage" represents on the DMC dashboard?

Thanks in advance for any information.

------------------------------
Bill Ferguson
------------------------------

#Db2

The result of your SQL was 6 FST_TOTAL_SIZE and 6 FS_USED_SIZED.

So I run the following and got the following result
select storage_group_name,fs_used_size, fs_total_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2));

STORAGE_GROUP_NAME FS_USED_SIZE FS_TOTAL_SIZE
IBMSTOGROUP                    6741528576       7501512704

So the storage group is not actually 100% used since your sql below truncates the decimals during the division during 
sum(fs_used_size)/(1024*1024*1024) end as fs_used_size

Bottom line, it's not 100% used, more like 89% used, but close enough for DMC using integers to flag 100%. 
Thanks for that information.

------------------------------
Bill Ferguson
------------------------------

Original Message:
Sent: Thu March 31, 2022 04:56 AM
From: Rui Li
Subject: DMC Database dashbaord - Storage column

Hi Bill,

May I know the version of your DMC? and is your db a storage group db or not?
This Storage is the percentage of used space to total size of the file system for all database storage group. We get the storage info from table function: ADMIN_GET_STORAGE_PATHS. Can you help execute the following SQL to view the storage information? You can compare the fs_used_size and fs_total_size with the used and size of your file system. Thank you.

select
case when sum(fs_total_size) is null then -1 else sum(fs_total_size)/(1024*1024*1024) end as fs_total_size,
case when sum
(
fs_used_size
)
is null then -1 else sum(fs_used_size)/(1024*1024*1024) end as fs_used_size
from
(
select
distinct fs_id,fs_total_size,fs_used_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2))
)
fetch first 100 rows only with ur

------------------------------
Rui Li

Original Message:
Sent: Wed March 30, 2022 11:45 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

I recently installed DMC and have been working on getting familiar with the tool. An odd thing I found on the Dashboard , a level of 100% for storage on one of our test servers.


What puzzles me is the database file systems are not full, nor is memory, nor can I find a definition for the storage column. Does anyone know what "Storage" represents on the DMC dashboard?

Thanks in advance for any information.

------------------------------
Bill Ferguson
------------------------------

#Db2

Hi Bill,

Thank you for giving us the comparison data results. This is really a data precision issue. I created a git issue to track this problem: https://github.ibm.com/tools-for-aps/zh/issues/29328.

Thank you again for pointing out this defect!

------------------------------
Rui Li
------------------------------

Original Message:
Sent: Thu March 31, 2022 07:58 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

The result of your SQL was 6 FST_TOTAL_SIZE and 6 FS_USED_SIZED.

So I run the following and got the following result
select storage_group_name,fs_used_size, fs_total_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2));

STORAGE_GROUP_NAME FS_USED_SIZE FS_TOTAL_SIZE
IBMSTOGROUP                    6741528576       7501512704

So the storage group is not actually 100% used since your sql below truncates the decimals during the division during 
sum(fs_used_size)/(1024*1024*1024) end as fs_used_size

Bottom line, it's not 100% used, more like 89% used, but close enough for DMC using integers to flag 100%. 
Thanks for that information.

------------------------------
Bill Ferguson

Original Message:
Sent: Thu March 31, 2022 04:56 AM
From: Rui Li
Subject: DMC Database dashbaord - Storage column

Hi Bill,

May I know the version of your DMC? and is your db a storage group db or not?
This Storage is the percentage of used space to total size of the file system for all database storage group. We get the storage info from table function: ADMIN_GET_STORAGE_PATHS. Can you help execute the following SQL to view the storage information? You can compare the fs_used_size and fs_total_size with the used and size of your file system. Thank you.

select
case when sum(fs_total_size) is null then -1 else sum(fs_total_size)/(1024*1024*1024) end as fs_total_size,
case when sum
(
fs_used_size
)
is null then -1 else sum(fs_used_size)/(1024*1024*1024) end as fs_used_size
from
(
select
distinct fs_id,fs_total_size,fs_used_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2))
)
fetch first 100 rows only with ur

------------------------------
Rui Li

Original Message:
Sent: Wed March 30, 2022 11:45 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

I recently installed DMC and have been working on getting familiar with the tool. An odd thing I found on the Dashboard , a level of 100% for storage on one of our test servers.


What puzzles me is the database file systems are not full, nor is memory, nor can I find a definition for the storage column. Does anyone know what "Storage" represents on the DMC dashboard?

Thanks in advance for any information.

------------------------------
Bill Ferguson
------------------------------

#Db2

Rui,

I was just pointing out the numbers to confirm what I was seeing. Thank you though for creating the defect.

------------------------------
Bill Ferguson
------------------------------

Original Message:
Sent: Fri April 01, 2022 03:33 AM
From: Rui Li
Subject: DMC Database dashbaord - Storage column

Hi Bill,

Thank you for giving us the comparison data results. This is really a data precision issue. I created a git issue to track this problem: https://github.ibm.com/tools-for-aps/zh/issues/29328.

Thank you again for pointing out this defect!

------------------------------
Rui Li

Original Message:
Sent: Thu March 31, 2022 07:58 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

The result of your SQL was 6 FST_TOTAL_SIZE and 6 FS_USED_SIZED.

So I run the following and got the following result
select storage_group_name,fs_used_size, fs_total_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2));

STORAGE_GROUP_NAME FS_USED_SIZE FS_TOTAL_SIZE
IBMSTOGROUP                    6741528576       7501512704

So the storage group is not actually 100% used since your sql below truncates the decimals during the division during 
sum(fs_used_size)/(1024*1024*1024) end as fs_used_size

Bottom line, it's not 100% used, more like 89% used, but close enough for DMC using integers to flag 100%. 
Thanks for that information.

------------------------------
Bill Ferguson

Original Message:
Sent: Thu March 31, 2022 04:56 AM
From: Rui Li
Subject: DMC Database dashbaord - Storage column

Hi Bill,

May I know the version of your DMC? and is your db a storage group db or not?
This Storage is the percentage of used space to total size of the file system for all database storage group. We get the storage info from table function: ADMIN_GET_STORAGE_PATHS. Can you help execute the following SQL to view the storage information? You can compare the fs_used_size and fs_total_size with the used and size of your file system. Thank you.

select
case when sum(fs_total_size) is null then -1 else sum(fs_total_size)/(1024*1024*1024) end as fs_total_size,
case when sum
(
fs_used_size
)
is null then -1 else sum(fs_used_size)/(1024*1024*1024) end as fs_used_size
from
(
select
distinct fs_id,fs_total_size,fs_used_size
from table(ADMIN_GET_STORAGE_PATHS(null,-2))
)
fetch first 100 rows only with ur

------------------------------
Rui Li

Original Message:
Sent: Wed March 30, 2022 11:45 AM
From: Bill Ferguson
Subject: DMC Database dashbaord - Storage column

I recently installed DMC and have been working on getting familiar with the tool. An odd thing I found on the Dashboard , a level of 100% for storage on one of our test servers.


What puzzles me is the database file systems are not full, nor is memory, nor can I find a definition for the storage column. Does anyone know what "Storage" represents on the DMC dashboard?

Thanks in advance for any information.

------------------------------
Bill Ferguson
------------------------------

#Db2