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

Db2 12 for z/OS SQL Enhancements: a Better MERGE
Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the series described piece-wise DELETE and result set paginatio...

Video Series: Importing and Exporting in Toad Data Point
With Toad Data Point you can import data into a data source or you can export data from a data source to a file outside data point. These videos will help you get started: Exporting to Excel Automa...

SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved...
This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the ini...