The Maintenance Page provides information concerning the current operation of the database. It also provides access to basic maintenance functions:

• Last verification: This area indicates the date, time and status of the last data verification carried out on the database. For more information about the data verification procedure, please refer to the Design Reference manual.
  The Verify Records and Indexes button can be used to launch the verification operation directly, without interrupting the server. Note that the server may be noticeably slowed down during the operation.
  All the records and all the indexes of the database are verified. If you want to be able to target the verification or have additional options available, you will need to use the Maintenance and Security Center (MSC).
  After verification, a report file is generated in XML and HTML format on the server in the Logs folder that is placed next to the database structure file. The View Report button (named Download report if the operation was carried out from a client machine) lets you display the file in your browser.
• Last compacting: This area indicates the date, time and status of the last compacting operation carried out on the database data. For more information about the data compacting procedure, please refer to the Design Reference manual.
  The Compact Data... button can be used to launch a data compacting operation directly. This operation requires stopping the server: when you click on this button, the 4D Server database shutdown dialog box appears so that you can choose how to interrupt the operation:

For more information about this dialog box, please refer to the Exiting 4D Server section.

After the actual interruption of the database, 4D Server carries out a standard compacting operation on the database data. If you want to have additional options available, you will need to use the Maintenance and Security Center (MSC).

Once the compacting is finished, 4D Server automatically restarts the database. The 4D users can then be reconnected.

Note: If the request for compacting was carried out from a remote 4D client machine, this machine is automatically reconnected by 4D Server.

A report file is generated in XML and HTML formats on the server in the Logs folder that is placed next to the database structure file. The View Report button (named Download report if the operation was carried out from a client machine) lets you display the file in your browser.

• Uptime: This area indicates the duration of the server operation since the last time it was started (days, hours and minutes).
  The Restart server... button can be used to immediately restart the server. When you click on this button, the 4D Server database shutdown dialog box appears so that you can choose how to interrupt the operation (see the Exiting 4D Server section). After restarting, 4D Server automatically relaunches the database. The 4D users can then be reconnected.
  Note: If the request for restarting was carried out from a remote 4D client machine, this machine is automatically reconnected by 4D Server.
• Last backup: This area indicates the date and time of the last backup of the database and provides information about the next scheduled automatic backup (if any). Automatic backups are configured using the "Scheduler" page of the database settings.
  - Next backup: date and time of next automatic backup.
  - Needed space: estimated space needed for the backup. The actual size of the backup file may vary according to the settings (compression, etc.) and according to variations of the data file.
  - Available space: space available on the backup volume.
  The Start backup button can be used to backup the database immediately using the current backup parameters (files backed up, location of archives, options, etc.). You can view these parameters by clicking on the Settings... button. During a backup on the server, the client machines are "blocked" (but not disconnected) and it is not possible for any new clients to connect.
• Request and Debug logs: This area indicates the log files recording duration (when log files are activated). Log files include:
  
  • the request log file: stores information concerning the requests received by the server (excluding Web requests): time, process number, user, request size, processing time, etc. that can be used to analyze the server operation. This file is named 4DRequestsLog_X (X being the sequential number of the file).
  • the debugging events file: stores each execution of a method, 4D command or plug-in command in a file named “4DDebugLog_X.txt”. Each event is systematically recorded in the file before its execution, which ensures its presence in the file even if the application quits unexpectedly. Note that this file is erased and rewritten each time you launch the application. You can configure this file using the SET DATABASE PARAMETER command.
  • the 4D SMTP log file: stores each exchange between 4D Server and the SMTP Mail server, when a SMTP transporter object is processed on 4D Server. It is named 4DSMTPLog_X.txt. You can configure this file using the SET DATABASE PARAMETER command.
  • the 4D POP3 log file: stores each exchange between 4D Server and the POP3 Mail server, when a POP3 transporter object is processed on 4D Server. It is named 4DPOP3Log_X.txt. You can configure this file using the SET DATABASE PARAMETER command.
    
    Note: Log files are stored in the Logs folder of the database, next to the structure file.

  The Start Request and Debug Logs button starts log files. Since this may noticeably deteriorate server performance, it is to be reserved for the development phase of the application.
  Note: This button only logs operations that are executed on the server. To log operations executed on a remote 4D, you need to use the SET DATABASE PARAMETER command.
  Once the logs have been activated, the button title changes to Stop Request and Debug Logs, so that you can stop recording requests at any time. Keep in mind that restarting the log after stopping it "erases" the previous file.
  The View Report button (named Download report if the operation was carried out from a client machine) lets you open a system window displaying the request log file.