26 Januar 2016 16:03:59IBM introduced with IBM Notes Traveler 188.8.131.52 a new tool to get better control of the defragmentation of the used relational state database (Derby in Standalone / DB2 or MS SQL in HA).
Before 184.108.40.206 the periodic defragmentation could be configured by using the notes.ini setting NTS_DEFRAG_INTERVAL_DAYS. This INI-setting is no longer used by Traveler and 220.127.116.11 will show you a warning:
Since 18.104.22.168 you need to configure scheduled defragmentation by using the new DBMAINT-Command:
To check the current config and status:
tell traveler dbmaint show
To enable periodic defragmentation you will have to enable and configure it using this commands:
tell traveler dbmaint set interval 30
tell traveler dbmaint set auto on
From the Traveler documentation:
Running defragmentation on a scheduled basis (22.214.171.124 and later)
To perform defragmentation on a scheduled basis, perform the following procedure:
1 Use the tell command DBMaint set interval in order to set the interval to a number greater than 0. For example, to set an interval of 30 days, enter into the console:tell traveler dbmaint set interval 30
2 Use the tell command DBMaint set auto on to turn on automatic defragmentation.
3 To force a defragmentation, enter the command tell traveler dbmaint run. This sets NTS_DEFRAG_ONCE to 1 and the Derby database will be defragmented the next time the IBM Traveler server restarts.
Running defragmentation on a scheduled basis (126.96.36.199 to 188.8.131.52)
To run defragmentation on a scheduled basis with IBM Traveler server 184.108.40.206 to 220.127.116.11, perform the following procedure:
1 Add NTS_DEFRAG_INTERVAL_DAYS to the notes.ini file. For example, to set an interval of 30 days add: NTS_DEFRAG_INTERVAL_DAYS=30
2 Restart the IBM Traveler server. From that point on, if the IBM Traveler server is restarted and it has been 30 days since the last defragmentation, then the defrag operation will run.
3 To force a defragmentation, simply delete the parameter NTS_LAST_DEFRAG from the notes.ini file and restart the server.
If NTS_DEFRAG_INTERVAL_DAYS is set and there is no last defragmentation timestamp, then the server will perform a defragmentation and reset the NTS_LAST_DEFRAG timestamp.
|DBMaint Run||Immediately performs online maintenance. If the server is standalone, then it will configure maintenance to run on restart.|
|DBMaint Show||Displays various database maintenance scheduling information.|
|DBMaint Fragmentation||Recommends database maintenance based on fragmentation levels.|
|DBMaint Set Interval days||Sets the interval of days in which automatic database maintenance will perform.|
|DBMaint Set Time hh:mm||Sets the time in 24-hour format in which automatic database maintenance will perform.|
|DBMaint Set Day monday-sunday/off||Sets the day of the week on which the first scheduled automatic maintenance will start. Set this to Off if you want the first scheduled maintenance to be based off of the last maintenance time.|
|DBMaint Set Threshold on/off||Configures automatic database maintenance to check fragmentation levels before execution.|
|DBMaint Set Auto on/off||Enables automatic database maintenance. Re-enablement will reschedule maintenance if either the time or interval have changed.|
|DBMaint Set Indexes number||Configures the number of fragmented indexes for the fragmentation threshold.|
|DBMaint Set Ownership||Configures ownership of database maintenance to the executing server. This server will be the only server that can perform automatic database maintenance.|
|DBMaint Set Percent 0-100||Only applicable for SQL Server. Configures the fragmentation percentage of indexes for the fragmentation threshold.|
|DBMaint Set Functions 1-4||Only applicable for DB2. Configures the number of functions that are used to determine if an index is fragmented for the fragmentation threshold.|
- Kommentare