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
9 blogs to help tune your most challenging SQL Statements
Better SQL statements. Verse 9 in the 12 Days of … Our gift to you this season is wrapping up our favorite blogs about a product into a collection, with a song to go with each! Each week in December, ...
Encrypt data in the Oracle 18c data dictionary
Do you need to encrypt sensitive credential data? Here’s how you can do so in the Oracle 18c data dictionary. Oracle Database has two main tables where credential data is stored: SYS.LINK$ and SYS.SC...
