Db2 On Premise and Cloud

 View Only
  • 1.  DMC Database dashbaord - Storage column

    InnerCircle
    Posted Wed March 30, 2022 01:49 PM
    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
    ------------------------------


  • 2.  RE: DMC Database dashbaord - Storage column

    Posted Thu March 31, 2022 04:57 AM
    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
    ------------------------------



  • 3.  RE: DMC Database dashbaord - Storage column

    InnerCircle
    Posted Thu March 31, 2022 07:58 AM
    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
    ------------------------------



  • 4.  RE: DMC Database dashbaord - Storage column

    Posted Fri April 01, 2022 03:34 AM
    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
    ------------------------------



  • 5.  RE: DMC Database dashbaord - Storage column

    InnerCircle
    Posted Fri April 01, 2022 10:51 AM
    Rui,

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

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