Category Archives: SQL

A step back: A DB2 optimization term, then and now


The terms “sagable” and “non-sagable” became common place in the very first releases of DB2. However, the terms most commonly used today are indexable, stage 1, and stage 2. Since I have been dying to write about something (anything) since retiring, this seemed like a fun subject to attack. Continue reading

Advertisements
Posted in DB2 for z/OS, Performance, SQL | Tagged , , , , , , , | Leave a comment

Synonyms go UN-deprecated in DB2 11


Posted Saturday, April 16, 2016 My Blogs “Getting the Most Out of DB2 for z/OS” “Musings of a Life-long Mainframe Guy” Did you happen to read my blog post back on Jan 27, 2016 “ What are your plans for … Continue reading

Posted in DB2 11, DB2 for z/OS, SQL | Tagged , , , , , , | Leave a comment