Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Monitor / Storage -> Collecting data

    Posted 11/27/20 01:33 PM

    New DMC 3.1.3 setup. 


    Added 1st db, ( db2 AESE 11.1 on linux. ) 

    the Storage / Storage monitor is not working.   Keeps saying "Collecting data" , but never pass this stage. 

    No error is provided in the console to the end user,  .. 
    neither tells if you need to enable some "advanced"  option.  (I believe it should not be required). 




    ------------------------------
    Samuel Pizarro
    ------------------------------

    #Db2


  • 2.  RE: Monitor / Storage -> Collecting data

    Posted 12/02/20 09:33 AM
    Hi Samuel,

    "Storage" monitor data collection is very resource-consuming and time-consuming. That's why there is a message of "collecting data" in the page for user to avoid confusion. May I know how many tables in this DB, and what about the DB workload and performance?

    ------------------------------
    KAI DING
    ------------------------------



  • 3.  RE: Monitor / Storage -> Collecting data

    Posted 12/02/20 10:10 AM

    Hi @KAI DING

    This is a Dev (test) db,  and has minimal workload..   the instance uses no more than 2% of CPU over the time.

    It has few tablespaces and tables:
    ​

    $ db2 "select count(1) from syscat.tablespaces"

1
-----------
         19

  1 record(s) selected.

$ db2 "select count(1) from syscat.tables"

1
-----------
       1172

  1 record(s) selected.





    ------------------------------
    Samuel Pizarro
    ------------------------------

    Original Message


  • 4.  RE: Monitor / Storage -> Collecting data

    Posted 12/04/20 02:35 AM
    ​Hi Samuel,

    Could you provide the monitor log for investigation? thanks.

    ------------------------------
    KAI DING
    ------------------------------

    Original Message


Related Content