(Kshitij Kohli and Amyris Rada) This tutorial helps you learn the skills required to manage DB2 database servers, instances and databases. Furthermore, you will get introduced to DB2 autonomic computing capabilities and you will learn to use IBM data Studio to perform database administration tasks s

(Willie Favero) This is the continuation of my Data Studio post from yesterday, Monday, November 11, 2013. Yesterday we discussed setting up the connectivity to your DB2 for z/OS subsystem on the Mainframe. Now that you’ve established that working connection, today we’ll sign-in (connect) to DB2

(Marc Hebert) Application sprawl has become a common problem among businesses for a variety of reasons. The explosion of data, for example, has not only contributed to large volumes of stored information, but it has created increasingly data-intensive applications. In addition, there are a number of

(Chris Eaton) In a previous blog posting I wrote about how we do compression and encoding in DB2 BLU Acceleration and in that video we spoke about how DB2 pre packs encoded data into register length “chunks” on the database pages.

(Dave Beulke) Channel surfing the other night I came upon the C-SPAN video replay of the congressional testimony regarding the Healthcare.gov website. Thinking about all the testimony and the political partisan points I was amazed at the project planning comments, lack of understanding of the techn

(Henrik Loeser) An “ancient” but not yet well-known feature in DB2 is the support of MySQL/PostgreSQL-style LIMIT and OFFSET in SELECT statements and searched UPDATE/DELETE. Unfortunately, it is not really documented and I am working on getting some more documentation added (think about the “mostly

(Willie Favero) It’s true, I do have (and have had for a long time) a kind of odd obsession with DB2’s subsystem parameters, or what are more commonly, and incorrectly, referred to as DSNZPARMs. This obsession has been going for a very long time. In fact, I think it all started when I heard Dave F

(Jeannie Cramer and Terrence O’Donnell) In addition to IBM DB2 Version 11 for z/OS data management, IBM announced the recent release of DB2 Analytics Accelerator for z/OS Version 4.1. When combined with related prerequisite hardware and prerequisite software, this solution offers high-performance te

(Ember Crooks) A friend recently asked me what I thought of certification. I have a number of DB2 related certifications, and even one Oracle certification. I thought I would share my opinions.

(Chris Eaton) I was asked the other day by a client if DB2 10.5 with BLU Acceleration was optimized for AIX or for Linux. My answer was YES! 🙂 Of course the code has optimizations built in for both Power/AIX and Intel/Linux platforms and the code knows which platform it is running on and how t