(Mike Cavanaugh and Thomas Atwood) This article provides practical concepts, tips, and examples to help you troubleshoot and fix problems with badly formed data on the mainframe, enabling your Classic data server to convert legacy data seamlessly to the relational SQL formats that your business requ

(YeeKai Lai) Learn how to take advantage of the Time Travel Query feature and temporal tables with DB2 for Linux, UNIX, and Windows V10.

(Henrik Loeser) About a week ago I had asked how you typically find information about DB2 fixpacks. With the new DB2 10.1 Fix Pack 2 and Data Studio 3.2 just released (and I back from travel), here is the way I usually trying to stay in the loop.

(Willie Favero) It’s the end of the year, the fourth quarter of 2012, and DB2 land has just “published” the last updates to the “Diagnosis Guide and Reference” (LY37-3220 for DB2 10 and LY37-3218 for DB2 9).

(YeeKai Lai) Hate “guesstimating”? IBM’s recently announced InfoSphere Optim Query Capture Replay (QCR) captures production workloads and replays them

(Kiran Jogu) This article describes a solution that is based on integration of the IBM InfoSphere DataStage with IBM InfoSphere Change Data Capture that ensures you capture the changed operational data and transmit it in real-time to the data warehouse, keeping it in an updated state at every moment

(Heath Kath) Do you struggle to keep track of countless, nearly identical queries that differ only in selection criteria like region, department, and date range? Runtime prompts help you stay organized by allowing different users and departments to run the same views but return unique, tailored resu

(Shishir Narain, Shashi B. Pahwa and Deepak Sumani) Previous installments of this series introduced the Modern Batch feature of IBM WebSphere Application Server and described the compute intensive and transaction batch programming models. The latest release of WebSphere Application Server, Version 8

(Serge Rielau) Have you ever seen: “SQL0670N The row length of the table exceeded a limit of “” bytes. (Table space ““.)”

(Martin Hubel) 100% of our studio audience learned something! Willie talked about Explain, sort, bufferpools and other topics. The information was experience-based and invaluable.