Purging Transaction Data from the EZTeller Database

Purging Transaction Data from the EZTeller Database

The purge feature removes transactions from the EZTeller database, which helps to reduce the size of the database.


Warning: The database purge should only be performed by the database administrator.

  • Always back up your database prior to purging information.
  • Never run the purge feature while users are logged onto EZTeller or Superview.
  • Do not cancel a purge after it has started.
  • Keep in mind that the purge uses a lot of server resources, so perform this process when there are no other jobs running on the SQL server.
 
  1. On the SQL server, perform a backup of the EZTeller database. Refer to your SQL Server user's manual.
  2. In Superview, log in with an administrator authority level 20 role.
  3. Select the holding company as your working group.
  4. From the drop-down menu select System > Database Maintenance > Purge Database.
  5. Select EZTeller Data from the menu.
  6. Type a date prior to the date you want data to be purged or click the Select Date button and choose a date on the calendar that is displayed.

Note: If the data has never been purged, you should purge in steps, for example, one year increments, from before January 1, 2003. After that is completed, purge data from before January 1, 2004, and so on.

  1. Select All EZTeller transactions that occurred before the purge date, click OK. 
  2. The Database Purge screen appears. Read the screen and make sure the correct data and branches are listed on the screen.
  3. If you want to continue with the purge, click Yes. The data will be purged. If not, click No, and you will return to the Database Purge screen. 
  4. Repeat steps 6-9 as needed.

ArticleNumber:

000044748

    • Related Articles

    • Removing, Purging, or Deleting Old Data from Servicing Director

      Most data in Servicing Director remains in Servicing Director for auditing, historical, and licensing reasons. Therefore, expect the data stored to continually grow. Since there are few options for removing, purging, or deleting old data from ...

    • Purging Inactive and Expired Alerts in Special Account Monitor (SAM)

      When SAM alerts are deleted or expire the information becomes unavailable to users but it remains on the database. The database purge feature will remove the records from the database. Note: The SAM database purge feature will purge only expired ...

    • Exporting Data from EZTeller Reports

      Superview reports are a tool to monitor user activity, productivity, and identify and analyze for staffing peak periods. You can view, print, or export the data into several different formats. Authority levels authorized to access Superview are ...

    • Viewing Last Transaction in the EZTeller Journal

      You want to view the last transaction that you processed in EZTeller. View Last Transaction is set as a speed key in EZTeller. Click on the speed key or press the corresponding number assigned to the speed key. View last transaction defaults to the ...

    • Processing Transactions in EZTeller Enterprise While Database Disconnected

      EZTeller has lost its connection to the database server, "Database Disconnected" shows in the status bar at the bottom of the screen. When EZTeller Enterprise loses its connection to the database server a message pops up notifying the teller the ...