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
Related Articles
Viewing the SQL Alternatives and Execution Run Time Statistics
This tip explains how you can view the SQL alternatives generating in the Batch Optimizer in the Tuning Lab. After a SQL statement has been optimized in the Batch Optimizer in Quest SQL Optimizer for...
Speaking at the Annual Hotsos Symposium
I’ll be speaking at the annual Hotsos Symposium in Dallas TX February 27th and 28th. To quote their website: Hotsos is the best conference in the Americas devoted to Oracle system performance. The co...
How to connect to an Oracle Cloud Database
In my previous blog post, I described how to create an Oracle Cloud Database. Before we continue, you should have private key file. Whoever made the database should have given it to you. There ...
