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" <[email protected]> wrote on 03/02/2016
09:44:54 AM:
> From: Bas van Kampen <[email protected]>
> To: [email protected]
> Date: 03/02/2016 09:46 AM
> Subject: TSMVE VMCLI Derby Database
> Sent by: "ADSM: Dist Stor Manager" <[email protected]>
>
> 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
>