(Robert Catterall) In my DB2 for z/OS-related work over the past 25 years, I’ve done a lot in the way of performance analysis, looking at individual queries and at DB2-accessing application programs (both transactional and batch in nature).

(Rafael Victoria-Pereira) This TechTip will tell you all you need to know about the BLOB. No, we’re not talking about the 1958 Steve McQueen movie or the Marvel villain. We’re going to revisit a fairly old concept, with a new twist: the Binary Large OBject. I’ll explain how and why you can use it in

(Rajath Ramesh and Manjunatha D) IBM WebSphere Cast Iron introduced two activities, Read JSON and Write JSON to work with JSON data. Part 1 of this article series shows how to configure JSON handling activities to invoke JSON-based REST APIs and to create your own JSON-based REST APIs.

(Craig S. Mullins) There are many different types of development mistakes that can be made when you are coding a complex application system. But probably the most pervasive mistakes being made when developing an application using DB2 for z/OS are SQL mistakes… well, actually, that statement is pro

(Thuan Bui) In this overview video, you learn how to use InfoSphere Optim Performance Manager to: configure a database for monitoring, navigate through dashboards to view key performance metrics for a database, set a baseline performance level for comparisons, and analyze statements in stored proced

(Bill Cole) In a previous post, I wrote about our System/370 dangling from a crane. It was a simpler time where loss of computing wasn’t the business-collapsing event it can be today. If you believe one of the adverts regarding disaster recovery, a significant number of businesses don’t recover.

In-memory, columnar databases are all the rage because they can help improve analytic query performance. Attend this Tech Talk discussion to get a unique perspective on competitive advantages IBM DB2 with BLU Acceleration technology can provide.

(Paolo Bruni, Tom Crocker, Elaine Morelli and Richard Schaufuss) IBM DB2 tools for z/OS support and exploit the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and optimization of data performance.

(Dave Beulke) Big Data analytics are all in fashion these days, but there are many issues with how analytics are used, and how developing the appropriate analytics takes a correct and thorough data model. As I talked about in my previous Big Lies, Big Damn Lies and Statistics blog post, there are m

(Troy Coleman) I just came across a treasure trove of SQL knowledge. The content area on IDUG.org now includes a presentation on advanced SQL by Sheryl Larsen. Sheryl recently accepted a position with IBM and has donated portions of her educational materials to IDUG for use by its members.