(Gene Cobb) In part 1 of this series, “TechTip: DB2 Web Query and Excel Spreadsheets: Easy as Pie!, Part I,” I provided an introduction on the basic DB2 Web Query output options to Excel spreadsheets. In this TechTip, I expand upon those capabilities and show you how to take advantage of Excel’s mul

(Mihai Iacob and Walid Rjaibi) System administrators are responsible for, among other things, protecting a database against unauthorized access or misuse by authorized database users (for example, inappropriate access to sensitive information within a database). A common requirement to mitigate such

(Craig S. Mullins) In today’s blog entry, part 7 in our on-going series on DB2 locking, we will take a look at lock avoidance… as well as some other related things.

(hollyann) One of the issues that users have raised to me is the impedance mismatch between our web-based tools and our eclipse-based tools, in particular, between InfoSphere Optim Performance Manager (Performance Manager) and InfoSphere Optim Query Workload Tuner (Query Tuner).

(Dr. Alan Hopkins) The use of data analytics promises to deliver a wealth of opportunities that will enable game-changing advances in the level of achievable business insight across all domains of computing applications. As such, organizations are being urged to implement integrated information plat

(Brian Fairchild) One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system. When the application team created the database, it was created using Automatic Storage on the /home filesystem.

(Willie Favero) Copied directly from the Red Alert text…

(Martin) 92% of our studio audience learned something! Dave presented his experiences on implementing a time-constrainted project to implement a 22-billion row data warehouse.

(Dave Beulke) Setting up the correct metrics is vital for measuring anything. Mean, median and a variety of other complex formulas are being used for an assortment of purposes in Big Data projects. The heart of the issue is whether these complex formulas correctly convey correct measurements for t

(Ajith Kumar Punnakula, Rahul Jain and Balaji Kadambi) Business applications commonly need to reuse aggregated or processed data from a set of data sources over a single series of operations. An example for this could be generation of reports for analysis and decision making. In order to support th