Hi Bas,

Have you tried using this command?

     vmcli -f db_compact

     
https://www-01.ibm.com/support/knowledgecenter/SS36V9_4.1.1/com.ibm.itsm.fcm.vm.doc/r_fvm_db_compact_command.html?lang=en


It trims expired tasks/details from the Derby DB.  

First, you should make a copy of the DB (copy of the VMCLIDB folder) 
before running 'db_compact'.  

If you don't need the "run" details nor the "run-now" tasks, 
then you can just delete the VMCLIDB altogether.  

VMCLI will recreate the VMCLIDB folder as needed. 


Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 03/02/2016 
09:44:54 AM:

> From: Bas van Kampen <bas AT BVK DOT ME>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 03/02/2016 09:46 AM
> Subject: TSMVE VMCLI Derby Database
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> Hello,
> 
> Does anyone know if it's safe to delete the data in the VMCLI derby
> database from TSM VE. This because we run (run once) tasks with vmcli
> from the command line and the list of tasks on the schedule page won't
> load because there are to many (run once) tasks in the vmcli database.
> 
> Regards,
> 
> Bas van Kampen
>