(Lockwood Lyon) Another area for analysis is that of database access. It is typical during peak season to have high transaction rates and high volumes of data to store. To mitigate against slowdowns in data access the DBA should plan for the following.

(Troy L Coleman) In 2012 I wrote about new DB2 10 support for temporal tables. Just recently, while reading the DB2 11 for z/OS Application Programming and SQL Guide, I came across this disturbing paragraph found on Page 4 in Chapter 1, under the sub-topic, “Views, materialized query tables, and SQL

(Jordan T Moore, Mamoun A Hirzalla, Richard Osowski, Srinivas Chowdhury and Vasfi Gucer) Many types of web applications are running on the Internet today. There are also as many ways to manage and maintain the infrastructure that powers those applications. IBM Bluemix delivers quick and easy cloud c

(Fred Sobotka) An under-appreciated set of ANSI SQL functions introduced over a decade ago could dramatically reduce application chattiness and improve response times.

(Aparna Srinivasan) This tutorial describes some of the best practices to help you configure and troubleshoot secure network communications and single sign-on authentication for the SAP Connector on WebSphere Cast Iron.

I’ve been reading your SQL articles in hopes of finding a solution to a problem. I need to insert the same data into two tables at the same time in detail form to one table and in summary form to the other. Is such a thing possible?

(John Campbell) In Version 11, IBM DB2 for z/OS makes it easier to bring analytic components closer to the core operational data—reducing latency, complexity, and costs while improving data quality and governance. Improved query, fast analytics, and reporting facilities can improve competitiveness,

(Henrik Loeser) Today I wanted to try out using DB2 optimization profiles for a statement impacted by the statement concentrator. In part 1 I gave the background, showed how I created an optimization profile and that a simple explain statement didn’t return what I expected.

(Ember Crooks) Current statistics are vital to performance. If I’m encountering a database I haven’t regularly been supporting, and don’t know the maintenance plans and schedules, I frequently query to get an idea of how current they are.

(Tong Li, Brad Topol and Vince Brunssen) Among the many cloud services, cloud object storage has perhaps experienced the most growth. It is commonly used for storing photographs, images, documents, and audio and video files.