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:23 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.

    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/14/20 05:49 PM
    Hi Karsten,

    We will investigate this and get back to you.

    Thanks.


    ------------------------------
    Jason Sizto
    ------------------------------



  • 3.  RE: Pruning Repository Tables

    Posted 04/15/20 02:39 AM

    Hi Karsten,

    It seems that you submitted the same question in two threads. We are asking for log file form you. Thanks.



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