Specify the recovery interval and step size in ICU

To configure settings for the data to be recovered, launch PI ICU and go to the rdbodbc > Recovery Parameters tab. Choose input or output processing and specify settings as follows:

• Recovery Mode: Choose TimeStamp.

• Recovery Start Time : Specify the beginning of the period to be recovered.

• Recover End Time: Specify the end of the period to be recovered. If you omit end time, the interface recovers data from the specified start time to the present time and then starts normal data collection. If you specify an end time, the interface recovers data and then exits.

• Input Recovery Step: To control memory consumption, specify the timespan to be processed as a chunk. The default step size is one day (1d). (Input recovery only)

Recovery start and end times can be specified as either absolute or relative times, or you must use the same format for both start and end time; in other words, you cannot specify a relative start time with an absolute end time. To specify an absolute time, use the following format:

start-time [, end-time]

Where the start and end timestamps are specified in the following format:

DD-MMM-YY hh:mm:ss

If you omit the end-time, all data up to the present is recovered. Default end time = "*"

To specify a relative time, use the following format:

[+ | -] #units

Where units is one of the following:

• d: days

• h: hours

• m: minutes

• s: seconds

• t: today at midnight (00:00:00)

• *: now (current date and time)

  Note: The RDBMS interface does not support the following relative start times:

• y: years

• mo: months

• w: weeks

To configure Input Recovery Step, specify units using the #units syntax. For example, to recover one week at a time, specify 1w. Following are examples of recovery time specifications.

As an alternative to specifying an absolute or relative time, you can specify the name of a PI timestamp tag. The snapshot value of the tag is used for the start or end time.