Toad World Blog

Db2 12 for z/OS and Insert Algorithm 2: Faster, More-Efficient INSERTs than Ever Before

Jan 22, 2018 2:47:00 AM by Robert Catterall

Near the end of the blog entry I most recently posted prior to this one , I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT throughput and efficiency, in situations where the importance of that objective outweighs that of keeping data rows physically ordered by the target table's clustering key. I also noted that MEMBER CLUSTER sets you up to take advantage of a Db2 12 for z/OS enhancement called (rather cryptically) insert ...read more 

Tags: DB2 z/OS IBM DB2

Robert Catterall

Written by Robert Catterall