Sometimes, a change in the way Db2 for z/OS manages its resources is introduced, and the change “flies under the radar” (i.e, it escapes the notice of most Db2 users) because it is relatively small in terms of scope and impact and is not widely highlighted in the product documentation, and it delivers the intended benefit (e.g., enhances CPU efficiency for data access) and no one thinks about it — BUT, it may have a consequence that pops up in a surprising way, causing, initially, some …read more
Related Articles
How to use SOQL queries to map tables in Toad Intelligence Central server
Learn how to use SOQL queries to map tables in Toad Intelligence Central....
How to create macro for assign domain to attributes
Toad Data Modeler and its behavior can be easily customized in several ways. One of the ways to customize Toad Data Modeler is by creating a macro. Why would you create a macro? Macros help you auto...
Unselective indexes and skewed data distribution
The selectivity of an index is defined as the fraction of rows in a table having the same value for the indexed key. A highly selective index has few rows for each index entry and an unselective inde...
