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
Does your SQL code satisfy SQL formatting standards?
How many times have you created a database object without the option to check if the SQL code satisfied the SQL formatting standards? With ApexSQL Enforce that may never happen again. Watch an intr...
How to use Toad Data Point to solve data preparation issues
This short series discusses many of the often-overlooked issues surrounding data preparation for business analysts. Toad Data Point is the perfect tool for making data preparation easy. This blog wil...
Toad for Oracle – Monitor SQL Executed on Databases (SQL Tracker)
Quest SQL Tracker monitors SQL statements issued by Windows applications and services that access Oracle....
