(Craig S. Mullins) As you write SQL statements to access DB2 data, there are certain very simple, yet important rules to follow to encourage efficient SQL. Of course, SQL performance is a complex topic and to understand every nuance of how SQL performs can take a lifetime to master.

(Jenni Aloi) You might have noticed that developerWorks has been laser focused on IBM Bluemix for the past year. It’s been our goal to educate the broader technical community on IBM’s no-holds-barred entrance into the world of cloud, as well as help developers of all skill levels get their hands dir

(Ember Crooks) I’ve played with the clpplus at least once before, but have generally thought of it as a tool created to satisfy those coming from Oracle and looking for Oracle-like features. One of the features I actually liked about Oracle in the class and certification tests that I took for it was

(Yuke Zhuge) When the DB2 HADR feature is enabled, the primary database’s transaction logs are replicated to one or more standby databases in real time. The replication provides HA and DR protection, at a cost. The replication adds overhead to the primary’s log writing. Applications on the primary m

(Cesar Saavedra) You’ve probably heard the term “co-opetition” before. In my mind, when two companies become partners, there is an implicit understanding that both will work together, i.e. join forces, to help each other become successful in the market place – “the sum is greater than its parts”.

(Scott) 100% of our studio audience learned something! Today’s presentations were GREAT and included topics on package cache analysis, trying IBMBLU acceleration, battles with DB2 LUW license administration, DB2 10.5 BLU Data Skipping, DB2 z/OS SQL tuning via temp tables, DB2 z/OS Stored Procedure A

(Philip Monson, Gord Sissons, Mark Simmonds and Mike Combs) The IBM InfoSphere System z Connector for Hadoop is software that provides fast and seamless point-and-click data integration between mainframe sources and destinations (including Hadoop clusters and other environments).

(David Riou and Gerardo Vega Amabilis) A key strength of IBM PureApplication System platform-as-a-service lies in its support for a wide variety of technologies and products from many different providers. As an example, this tutorial shows you how easy it is to build an Oracle WebLogic pattern for a

(Ember Crooks) GENERATED ALWAYS can be a blessing or a curse. I’m not talking about identity columns here, but about creating a column that is actually a duplicate of some part of the data to boost performance. Sure, in 10.5 we can do indexes on expressions, but for some clients I have trouble just

(Joe Pluta) In the previous article, I showed you how to create a fully functional, working DB2 environment on your PC for no cost. It’s a little unusual for many of us: DB2 10.1 running on a Linux appliance inside of Oracle VirtualBox! Our familiarity with PCs may not extend much past Windows, but