Traveler: How long will it take to defrag a 2GB Derby DB?

HCL Domino Domino Forum
1

The server has about 40 traveler users. I’m just looking for an estimate.

Thanks

2

Subject:

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.

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

3

Subject: Thank you both :slight_smile:

4

Subject: 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

5

Subject: 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: IBM Documentation https://www-304.ibm.com/support/knowledgecenter/SSYRPW_9.0.1/defraggingthedatabaseforimprovedperformance.dita?lang=en

and