Toad World Blog

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 more

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

Robert Catterall

Written by Robert Catterall