(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.
(Eddy Coppens) I was working at a customer who wanted to have a database replicating data bi-directional towards another database by means of InfoSphere Data Replication (IIDR aka CDC), but also wanted to have a failover mechanism in place in conjunction with the bought replication solution.
(Ted Holt) The dates in our database are stored as seven-digit packed-decimal values in the common CYYMMDD format. In 2018 I wrote an SQL query that reported the number of days between two dates, but it quit calculating properly as soon as it started using 2019 dates. Can you tell me the proper way
(Scott) 100% of our HUGE audience learned something! #MindBlown The secrets to analyzing Db2 problems are out! Pavel gave us a fantastic introduction to his top problem determination tricks and techniques! You will learn about db2pd, DB2SLEEP, db2fodc, db2dart, db2pdcfg, db2trc, db2diag, analyzetrac