I need to decide that do we need commit's in select queries?
I belive with commit, the page is returned to the disk. As in case of select, the data will not change, is commit required? Also we if don't do a commit, what will happen to the rows fetchwd into the bufferpool? How does DB2 clears them from BP?
To undertand these question, i think it's necesary to understand how does a select works.
Please help me with these questions.