Date posted
Aug
24
Why is it sometimes we see SQL queries that list a table more than once in the same query? There are a number of reasons where this self-joining is...
Read PostTechnical Content
Curated Db2 Content
Date posted
Aug
8
Db2 for z/OS Data Gate (Db2 Data Gate) provides synchronized Db2 data to cloud-based applications reducing read-only operational processing and the...
Read Post
Date posted
Aug
7
You might be struggling with this question – When is the right time to push my organization to take the red pill to have the new Pacemaker...
Read Post
Date posted
Apr
23
A temporary table (in most RDMS) is a place to keep data for the duration of some application process. The data is basically private and only...
Read Post
Date posted
Apr
23
How to use “package” access path information to solve a real-life application issue! Get access path from the “package”!
Read Post
Date posted
Apr
21
Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...
Read Post
Date posted
Apr
19
Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...
Read Post
Date posted
Apr
18
Db2 Z V12 introduced interesting new functionality to the “RECOVERY” utility. This new functionality is called ‘redirected recovery’ and it has...
Read Post
Date posted
Apr
4
Next Generation INsertion (NGIN) was designed to enhance insertion performance and reduce log space usage. The NGIN enhancements mainly covered...
Read Post
Date posted
Mar
28
For many customers, string data dominates storage cost. Frequency-based compression is not effective for high cardinality datasets. So percentage...
Read Post
Date posted
Mar
21
Since Db2 11.5.4 which itself laid a new foundation for how columnar inserts were handled by the columnar data engine (CDE), many new features for...
Read Post