(Henrik Loeser) Today’s blog entry is about an old topic: Who I am, why I am and what I am (allowed) to do? Users and their privileges are at the core of database security.

(Troy L Coleman) The MERGE statement has been around awhile. It was actually among the first topics I covered upon launching DB2utor in 2007.

(Jane Man) XMLModify function is introduced in DB2 10 for z/OS to do sub-document update, without reparsing the whole document. There is a big performance saving if the change is small (say an attribute value) when comparing to the size of the document.

(Dr. Alfio Gliozzo, Chris Ackerson, Rajib Bhattacharya, Addison Goering, Albert Jumba, Seung Yeon Kim, Laksh Krishnamurthy, Thanh Lam, Angelo Littera, Iain McIntosh, Srini Murthy and Marcel Ribas) The Building Cognitive Applications with IBM Watson Services series is a seven-volume collection that i

(Jack Vamvas) I cannot drop the database and getting the error message SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

(Lockwood Lyon) Many initial big data implementations are designed or purchased and installed without formal testing.

(Prabhakar Mynampati) The face of integration—that is your enterprise data, applications, and services—changes frequently as your business needs grow. They must adapt to new business models to sustain competition with your market peers in today’s digital world. Their requirements can also change for

(Scott) 100% of our audience learned something! Ember took us on a deep dive journey through DB2 LUW Explain information including how to get it, how to interpret it, how to make the most of it, and much more. You will learn about db2exfmt, DB2 Explain from Actuals, IBM DSM, dsmtop, db2top, other to

(Rafael Victoria-Pereira) Last time around, I explained how to install SQuirreL SQL, and most of the readers’ feedback was very positive. For those of you who tried and failed to install this tool, here’s a little tip: Before trying to install this tool, update your Java Runtime Engine (JRE) to the

(Lockwood Lyon) With the enterprise data warehouse tuned it’s not time to consider your big data application.