Db2 articles, whitepapers, and presentations, curated and reviewed by the International Db2 Users Group (IDUG).
View All Blogs
Consistency of zParms in Db2 Data Sharing Groups Written by: Emil Kotrc, Broadcom I really never paid too much attention to the consistency of zParms in a data sharing group until recently. If you plan read more...
DSNACICS is a useful IBM supplied procedure for Db2. What does DSNACICS do? It allows one to invoke a CICS server program. To be clear. you don’t invoke a CICS transaction. You invoke a CICS program! read more...
Solve Sudoku using SQL!!! This festive season, impress your friends and colleague with your quick Sudoku skills and some clever SQL! How? Using recursive SQL, one can “solve” Sudoku. Just one read more...
Written By: Mark Gillis . Posted By: Tony Andrews New, Final and Old tables are features that have been around in Db2 for several versions, at least back to v9.7, but they don’t seem to get a lot read more...
Case Study #1: The Query: SELECT FROM T1 JOIN T2 ON T1.C1 = T2.C1 AND T1.C2 = T2.C2 WHERE T1.C4 = ‘Something’ AND T1.C6 > 27 The Environment: The only available interesting index on read more...
Written By: Joe Geller Posted By: Tony Andrews SQL Pagination – New Syntax Problem Statement One of the oldest problems in Db2 performance was the efficient processing of pagination. Pagination read more...
Posted By Tony Andrews: Written By Tony Andrews: With every Db2 version since V8, there has been great improvements in Db2 for z/OS. Many of the improvements affect developers specifically, especially read more...
September 2022 has a content committee primary focus on indexes . Indexes are those critical Db2 objects that define uniqueness and/or importantly help us quickly find our data. There have read more...
Indexes perform a critical role in any relational database and Db2 is no exception. Applications expect to receive near instant response when querying multi-billion row tables Indexing tables in a manner read more...
Are you Packaged and Bound for Db2 13? Written by: Julia Carter and Emil Kotrc , Broadcom Package rebinds can sometimes be a real challenge for DBAs when it comes to Db2 upgrades. There read more...
Db2 Version 13 is upon us! After V12, IBM was a bit vague about when a new version number for Db2 would be created. Why? IBM was using Db2 “ continuous delivery ” and function levels to introduce new read more...
Introducing Db2 Click to Containerize Written by George Baklarz and Phil Downey Many customers are looking at modernizing their databases by moving them into a containerized environment such as OpenShift, read more...