Old data access for DBC.ResSpsView

Database

Old data access for DBC.ResSpsView

Hi I am using view (i.e DBC.ResSpsView), but the problm is that the view reffers to "DBC.ResUsageSPS" table and this "DBC.ResUsageSPS" contains one day data only, so I can't access data older than one day through this view. Is htere any way to use this view to access old data of "DBC.ResUsageSPS" table, older than about one month.

1 REPLY
N/A

Re: Old data access for DBC.ResSpsView

There is probably some housekeeping on this table which moves the data to some history database and then deletes it.

You should ask your dba or search dbc.TablesV for a TableName LIKE 'ResUsageSPS%'

Dieter