VST field for date/time of last AI extent switch

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
There is no field in _DbStatus or in _ActAILog to show the time stamp of the last AI extent switch. I would like to be able to monitor this as there are situations where the AIMD may stop switching extents, e.g. when it runs out of space in the last aiarcdir. In this situation the DB will eventually run out of empty AI extents and continue to grow the busy extent, putting the client at increased risk of data loss. If I know the date/time of the last switch (in a datetime-tz field, please) I can compare it to the current time and send an alert if the difference exceeds the value of -aiarcinterval.

Continue reading...
 
Status
Not open for further replies.
Back
Top