Db2 for z/OS: Opportunities for CPU Efficiency When Data Clustering is not a Priority

    Dec 31, 2017 4:31:00 PM by Robert Catterall

    Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clustering index, and he wanted to know how he could get Db2 to act, with regard to INSERT operations and also with regard to executions of the REORG utility, as though the table had no clustering index. In other words, the DBA had a table for which INSERT and REORG CPU efficiency mattered more than having rows physically ordered per a clustering key. That's understandable ...read more

    Tags: DB2 z/OS IBM DB2 Toad for IBM DB2

    Robert Catterall

    Written by Robert Catterall