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.  Pruning Repository Tables

    Posted 04/14/20 10:13 AM
    ​Hi DMC team, 
    I have a question about pruning the data in the repository tables.

    The tables in the repository are constantly growing.     Especially the table IBMCONSOLE.SQL_FACT.

    Persistence is switched on. With a maximum of 28 days.
    The oldest data in the IBMCONSOLE.SQL_FACT table is from the day of installation in November.

    Why isn't the data cleaned up?

    Regards


    ------------------------------
    Karsten Wilhelm
    ------------------------------

    #Db2


  • 2.  RE: Pruning Repository Tables

    Posted 04/15/20 02:29 AM
    Edited by System Admin 01/20/23 04:46 PM

    Hi Karsten,

    Would you please send us the log file under install path, so our developers can do further investigation?

    You can attach the log file here or send me privately. Thanks.



    ------------------------------
    Li Hui Yan (Autumn Yan)
    From DMC Team
    ------------------------------



  • 3.  RE: Pruning Repository Tables

    Posted 04/29/20 07:30 AM
    ​Hi,

    is there anything new from the developers?

    Regards

    ------------------------------
    Karsten Wilhelm
    ------------------------------

    Original Message


  • 4.  RE: Pruning Repository Tables

    Posted 05/15/20 03:33 PM
    Hello,
    Yes, we have identified the problem, and the issue is being tracked by APAR
    IT32625 Large amount of data in IBMCONSOLE.SQL_FACT table

    https://www.ibm.com/support/pages/node/3152541

    The fix is planned to be available in the next release of DMC.

    I hope that helps!
    Thanks, Cintia.

    ------------------------------
    Cintia Ogura
    ------------------------------

    Original Message


Related Content