Search

1 to 10 of 113
Sort by

Blog Entry
Where has the Db2 Connect Gateway gone?

Abstract The path taken by application requests to reach the Db2 data store on z/OS for many years pivoted around the, “classic” Db2 client and the Db2 Connect gateway. These pieces of software, for Db2, bridged the gap between the “distributed” (Db2 for LUW) environment and the host (Db2 for...


Blog Entry
July Spotlight – Db2 LUW: Types of I/O

July Spotlight – Db2 LUW: Types of I/O Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL...

Martin Hubel's profile image

Blog Entry
Quick start: Integrating Db2 stored procedures and Zowe CLI

Quick start: Integrating Db2 stored procedures and Zowe CLI Richelle Anne Craw Db2 stored procedures by themselves have the benefit of improving programming productivity. What if you combine that with the power of Zowe CLI? Photo by israel palacio on ...


Blog Entry
Jenkins Pipeline H2 Database Integration Testing

Jenkins Pipeline H2 Database Integration Testing By David P. Morris, Jr., Leidos Health Software Development Analyst Introduction An Agile software development principle is continuous delivery and integration of working software. Jenkins software automates this process. As part of the...

David Morris's profile image


Blog Entry
Usar los percentiles con SQL

Nota del editor: Este artículo fue publicado originalmente en inglés. Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. Con las funciones SQL OLAP RANK y DENSE RANK disponibles en programación SQL desde hace un tiempo, resulta bastante...

Tony Andrews's profile image

Blog Entry
Advanced Query Tuning with IBM Data Studio

Advanced Query Tuning with IBM Data Studio by Tony Andrews Do you make any New Year's resolutions? In case you don't have any Db2 related, we have a suggestion for you. What if you start the New Year with improving the performance of your SQL queries? Learn more about the advanced query tuning...

Tony Andrews's profile image

Blog Entry
Lateral join

After a discussion with a friend, I came across an interesting article about the modern SQL in PostgreSQL (sorry the article is in czech). What raised my attention was a mention about the Lateral join . I work mostly on Db2 for z/OS and haven't heard the term in this context. What about you? ...

Emil Kotrc's profile image