Maintenance Page

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 Preferences.
  - 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 Preferences... 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 log: This area indicates the duration of recording log requests, when it is activated. 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) and is stored in the Logs folder of the database. Once the file reaches the size of 10 MB, it is closed and a new file is generated, with an incremented sequential number.
  The Start request log button can be used to generate a new file and activate the recording of requests. Since this may noticeably deteriorate server performance, it is to be reserved for the development phase of the application.
  Once the request log has been activated, the button title changes to Stop request log, so that you can stop the recording of requests at any time. Keep in mind that restarting the request log after stopping it "erases" the previous file.
  Note: It is possible to start and stop the request log by programming via the SET DATABASE PARAMETER command.
  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.