HCL Notes and Domino 9.0 Social Edition Forum - Traveler: How long will it take to defrag a 2GB Derby DB?

Nov 18, 2015, 2:44 PM

20 Posts

For 2GB DB it should take less than 30min to complete but bare in mind that there is no way to define how long it will take as it depends on the amount of data, degree of fragmentation and system capabilities etc.

https://www-01.ibm.com/support/knowledgecenter/SSYRPW_9.0.1/defraggingthedatabaseforimprovedperformance.dita

~Nita Zengerolitnivu

Nov 18, 2015, 3:20 PM

15 Posts

Run Defrag via program document

Hi Nephrops,

create a text file ( for example traveler_defrag.txt ) including:

te traveler q

te http q

lo traveler -defrag

Afterwards create a program document with the following settings:

Program Name: server ( Linux ) / nserver ( Windows )

Command Line: -c "location of text file/traveler_defrag.txt" ( the name of the text file from step 1 )

And then you can schedule the defrag for the Traveler Database in a very easy way. I do this in large environments and it´s working fine !!

BR Rainer

~Vera Xanlu

Nov 19, 2015, 4:18 PM

16 Posts

Thank you both :-)

~Phil Churesatherakol

Nov 25, 2015, 10:28 PM

8 Posts

new Traveler command for defrag

Hello Nephrops,

If your Traveler server is on 9.0.1.8 there is actually a new tell traveler command to perform maintenance on the Derby DB. This command is tell traveler dbmaint run.

Executing this command forces the Traveler to perform maintenance on the next restart of the Traveler server (res ser)

More info here: https://www-304.ibm.com/support/knowledgecenter/SSYRPW_9.0.1/defraggingthedatabaseforimprovedperformance.dita?lang=en

and