Resetting a database table

In some scenarios, you may need to reset a database table to remove all records. For example, when moving a table from a development environment to a production environment, you may want to start with an empty production table. You may also need to limit the size of files that continually increase in size, such as syslog or msglog.

Warning: Use caution when choosing this option, as resetting removes all records from the table.

Resetting the database and all records

If the records in a dictionary are no longer needed but the file structure is to be retained for later use, perform a file reset.

The Reset option deletes all data records from a dictionary. In most instances, once a system is set up and is in operation, this option is not used. Most often it is utilized when clearing test data from a preimplemented system or test file.

Warning: You should only use this option when you intend to permanently remove data file records. Once a reset is performed, the records cannot be retrieved.

Reset a database table from Database Manager

Applies to User Roles:

System Administrator

In this example we reset the syslog table. Resetting other tables works the same way.

To reset a database table from Database Manager:

  1. Open the syslog form in Database Manager.
  2. Click More or the More Actions icon.
  3. Select Reset.
    Service Manager displays a prompt, asking you to confirm the action and allowing you to schedule the Reset.
  4. From the prompt, you can:
    • Click OK to reset the syslog table.
    • Click Cancel to leave the table intact and return to the blank syslog format.
    • Click Schedule to schedule a time to run the file reset operation, either once or repeatedly at a set interval.

Schedule a reset

Applies to User Roles:

System Administrator

If you chose to schedule a reset by clicking the Schedule button on the reset prompt you are prompted with a schedule dialog, Service Manager displays a schedule form.

To schedule a reset:

  1. Provide a date in a DD/MM/YYYY format in the Date/Time to run field.
  2. Provide a time in an HH:MM:SS format the Date/Time to run field.
  3. Select a Repeat Interval option to reset the file on a regular basis. This setting is optional. The interval period starts from the time and date set in steps 2 and 3.
    • Monthly – reset once a month.
    • Quarterly – reset every three months.
    • Semi-annually – reset every six months.
    • Annually – reset once a year.
    • Other – reset in the specified number of days, at the specified time.

      Use the dd hh:mm:ss format, where dd is the number of days from the initial date and time, and hh:mm:ss is the time of day. For example, 26 10:00:00 schedules the reset to run at 10 a.m., 26 days from the initial reset date and time set in the Date/Time to run field.
  4. Click Schedule to confirm the reset action.

 

Related topics

Regenerate database keys