Glossary

Advantages:

No cursor close/reopen overhead at each checkpoint (can be significant for complex cursor queries) - Simpler code — no need to reposition the cursor after each COMMIT - DB2 can maintain internal positioning, potentially avoiding index lookups on each reopen

Learn More

Related Terms