The below SQL executes some times and does not execute at other times but fails with SQL0440N error.

select row_number() over(order by last_reset_timestamp) as number, snapshot_timestamp, last_reset_timestamp, table_schema, table_name, table_type, rows_read, rows_written, overflow_accesses, page_reorgs from snapshot.snapshot_table order by last_reset_timestamp;

Any idea why?

TIA.

The SQL fails after the system clock of the database server is changed to about 1 year before the current date. After the system clock is switched back to current date, the SQL succeeds.

Gnanaraj, Thanks for taking time to update the forum.

Your thoughfulnesss is much appreciated.

Sathyaram