We have a table in DB2 LUW, which gets updated at some time between 4:00 pm to 4:30 pm. However, we don't have any script running during that time. And that particular query, which run around 4:00 updates/touches the old (year 2020) records of the table. So, we are facing 2 issues.
- We are not aware of any script running during that time (4:00 pm to 4:30 pm).
- We don't update any old records We need to find out which queries are running between 4:00 pm and 4:30 pm and touching or updating old records. Db2top is giving me a SQL_Statement HashValue, but i need a full query. Please let me know command which gives an actual query.