(Jack Vamvas) Question: How can I check load status in DB2 LUW?
Tag: IBM
Selecting Appropriate Data Architecture Technologies
(John Maenpaa) One of the more difficult parts of developing a data architecture for a new project is choosing which technologies to use. You’ll have application developers that have their opinions, management with a different view, and legacy technology already in place.
IBM Cloud: Some fun with Python and Cloud Foundry Logging
(Henrik Loeser) Last month, after receiving user questions, I blogged about how to decipher Cloud Foundry log entries. Today, I want to point you to a small Cloud Foundry Python app I wrote.
Managing IBM Db2 Analytics Accelerator by using IBM Data Server Manager
(Sowmya Kameswaran, Tyler Condon, Jason Yao and Rita Zimmer) IBM Data Server Manager is a web-based, integrated database management tools platform that manages IBM Db2 and IBM Db2 for z/OS databases. With IBM Data Server Manager, you can manage and administer IBM Db2 Analytics Accelerator (Accelerat
DB2 Native REST API 5 – BLOBs, CLOBs and Stored Procedures
(James Gill) In the previous blogs in this series, we’ve seen that the process of creating and consuming REST services with DB2 for z/OS V11 and V12 can be managed easily with PHP.
The Evolution of Compression: Db2 9
(Troy L Coleman) Last week I discussed many of the data compression benefits delivered with Db2 8. That release included perhaps the most significant development in data compression in the past decade: since Version 8, Db2 has handled data compression using hardware, not software.
Practical RPG: APIs, Part 3 – Complex Parameters
(Joe Pluta) As the APIs become more powerful, they need more complex parameters to control their behavior, and this article shows how to build those complex parameters.
NULL in SQL: Indicating the Absence of Data
“Every [SQL] data type includes a special value, called the null value,”0 “that is used to indicate the absence of any data value”.1
SQL Tuning for Developers – Part 2 Explain Output
(Tony Andrews) In Db2 the best way for any developer writing SQL queries to know how a query is gathering the data for a result set is through the Db2 explain tool. I find too many developers do not know what to do or where to start when it comes to SQL tuning, program tuning, or application tuning.
Db2 12 SQL Enhancement: Temporal Logical Transactions
(Robert Catterall) Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent releases of the DBMS. Temporal data support comes in two flavors (which can both be utilized for a single table): business-time temporal and syst