(Kurt Struyf) Availability of data is a must these days. Everything has to be up and running, data outages are becoming few and far between and preferable non-existing.

(Ember Crooks) Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confoun

(Randy Nakagawa and Chris Crone) With all the focus on Db2 12 continuous delivery—with the associated function levels and application compatibility (APPLCOMPAT) levels, it might be difficult to notice changes in Db2 that are not tied to a new function level. However, not every change or enhancement

(Michael Sansoterra) In the tip, Arranging Query Logic in DB2 for i Routines, I addressed a reader’s question about how to create a user-defined table function (UDTF) in DB2 for i that would return the same result set as an existing stored procedure.

(Luke Numrych) DB2 has an “interesting” relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes.

(Jack Vamvas) Question: During a change on a server , I had to do a TSA failover as part of testing .

(Scott Vetter, Ivaylo B. Bozhinov, Anto A John, Rafael Freitas de Lima, Ahmed.(Mash) Mashhour, James Van Oosten, Fernando Vermelho and Allison White) As big data becomes more ubiquitous, businesses are wondering how they can best leverage it to gain insight into their most important business questio

(Craig S. Mullins) Database administration is a tried and true IT discipline with well-defined best practices and procedures for ensuring effective, efficient database systems and applications.

(Ember Crooks) I’ve long been both a proponent and a critic of IBM’s RFE(Request For Enhancement) program.

(Joe Pluta) The IBM midrange platform has always supported multiple languages, typically more consistently than the various devices we connected to it. I remember creating client/server applications for the Japanese market.