Dec 31, 2017 3: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: Toad for IBM DB2 IBM DB2 DB2 z/OS
Written by Robert Catterall
We use cookies to improve your experience with our site. By continuing to use this site, you consent to our use of cookies. Learn more.