Binding Function

RFDPURD

Binding ID

PURGE_DATA_USING SQL

Binding Description

Purge Transactional Data using SQL Stored Procedure

Purpose

This is a universal binding that is used to purge RFID logging and transactional Data from the TagNet Database. This is executed via scheduled tasks and can be run on a regular basis. The parameters to specify what data to purge and retention periods can be found here in Object Maintenance. This binding can also be referenced at the Physical Reader level whereas if the Reader Profile is deleted, it will purge any associated RFID logging.

Logic

Processes the file selections specified in Object Maintenance and purges the data:

❖This binding requires a SQL Stored Procedure being installed, see below on how to setup.

❖Supports Email Notification exceptions

❖This topic is also listed on the on the Stratum Support site

Restrictions

At this time it is recommended to use these features during non-production hours and ensure you have a quality backup strategy. If your logging tables exceed several million rows it is also recommended to purge these files in batches using dates/cutoff parameters listed below. Attempting to delete a large amount of logging data may result in extended locks on your TagNet database and/or filling up your SQL transaction logs

Files Updated

RFDLOCIH (Transaction History) and RFDLOHAR (Archive for RFDLOCIH -Insert only) ** Note that RFDLOCIN Inventory is NOT purged.

RFDPHLOG/RFDLOLOG (RFID Tag base logging) and associative RFDPHLGP/RFDPHLGT

RFDEPCEH (EPC Event History)

RFDSESPI/LOCPI (PI Count Sessions)

When deleting Reader Profile (RFDPHLOG, RFDPHLGP, RFDPHLGT, RFDPHRPL, RFDZONER

Comments

Program Name

URI set to RFDPURD

Binding Setup

Binding Properties