@shim
New User
Joined: 28 Oct 2021
Posts: 8
Location: India
|
|
|
|
Hello Experts,
I am looking for your advice/suggestions for the below mentioned scenario -
I have a Table T1 which gets updated by some other processes. I need to scan the table if there are rows with specific criteria, based on that I will select the rows and process them. This scan process runs as a started task and currently scans every half an hour, process the records and then it goes to sleep.
Is there any way, so that the STC will get notified once we have some rows satisfying the selection criteria - basically instead of STC scans, can DB2 notify the STC that it has rows satisfying the criteria.
Any suggestions or approach would be appreciated. Thank you in advance !!
Regards,
AP |
|
