(Jane Man and Jae Lee) This tutorial focuses on a SQL interface recently introduced in DB2 11 for z/OS that allows extraction and retrieval of JSON data from BSON objects and conversion from JSON to BSON. With this new feature, users can manage JSON data without relying on DB2 NoSQL JSON APIs.

(Scott) 94% of our studio audience learned something! Today’s presentations were surprisingly good considering that we had contestants from New Zealand, Mexico, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world.

(Craig S. Mullins) Do you know about the VOLATILE keyword? This keyword was added to DB2 for z/OS back in Version 8. It can be specified on a table using either the CREATE TABLE or ALTER TABLE statement.

(Soloman Barghouthi) This four-part series of videos on IBM API Management together make up an end-to-end demonstration of the product that includes creating a restful API, testing it, publishing it in IBM API Management, and finally using the published API from a mobile application.

(Susan Visser) Another great IBM conference is around the corner. This one is called InterConnect and is focused on cloud and mobile technologies. Since data and analytics play in both areas, you’ll find great sessions to increase your skills and knowledge by attending.

(Ember Crooks) I started out with a DB2 Basics entry on BLU. That starts with the most basic concepts. In this post, I’d like to delve into some of the details of BLU and talk about when BLU is beneficial and when it may be detrimental and why.

(Venkata Gadepalli, Rajeev Gandhi, Addison Goering, Bertrand Portier, Stanley Shieh, Sung-Ik Son and Hendrik Van Run) This IBM Redbooks publication describes and demonstrates common, prescriptive scenarios for setting up disaster recovery for common workloads using IBM WebSphere Application Server,

(Willie Favero) This week I am celebrating APAR Friday on a Monday. For this weeks APAR Friday, I have a couple of APARs that could have on impact on that you do with your subsystem parameters (aka DSNZPARMs). One APAR is even marked HIPER.

(Robert Catterall) A couple of days ago, I received from a DB2 for z/OS professional a question about stored procedures. This individual asked specifically about the STAY RESIDENT option of CREATE PROCEDURE (and ALTER PROCEDURE), and its effect on a native SQL procedure (i.e., a stored procedure tha

(Ranjeeta Pegu) Table partitioning has benefits like the ability to roll in (including data in a table) and roll out (detaching data from a table) and improving query performances, particularly in data warehouse and decision support system environments.