Hi All,
In our environment we running a procedure almost every day
procedure delete the data from the tables based on ondition
nearly 5 tables are there in procedure
before it run 15 min but now it taking nearly one hour

we did reorg and runstats on the tables still we facing the problem
based on db2advice the indexes are present in required columns

Please advise what things need to consider like this situation.

on data studio you can see how long/cost each stmt is taking within a proc.
BTW you havnt mentioned your version and os !!

Review what has changed. Performance degradation almost always go side by side with recent changes. It can be an OS level changes as well.