Hi Del,

Thank you for the answer.

db_compact didn't work, but I will delete the database, that works for us.

Regard,

Bas


On 3-3-2016 13:10, Del Hoobler wrote:

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