(Kwai Wong) Accurate database statistics allow the DB2 query optimizer to determine efficient access plans. Whether you manage statistics collection yourself or use DB2’s automatic statistics collection facility, a slow RUNSTATS can be a problem. In this article, you will learn how to assess if inde
Tag: IBM
DB2 Locking, Part 17: In Conclusion
(Craig S. Mullins) Today’s blog post concludes our multi-part series on DB2 for z/OS locking and concurrency. We have touched on a great many aspects of locking in this series.
APAR Friday: Use the right index, it should go faster
(Willie Favero) Sounds like a reasonable solution. After all, how many times has that worked for you?
Authorisation using SSL client certificates with IBM Integration Bus V9
(Philip Norton) IBM Integration Bus supports SSL authentication, but often a check is required to determine if the client is authorised to access the requested resource. This article shows you how to authorise clients using a supplied SSL client certificate and LDAP.
Big Data: Part1 – New Data Management Perspectives
(Dave Beulke) With each new trend there is always the hype cycle and the technology readiness level. The new technology or new capability provides a unique way to solve or analyze a business problem. The hype cycle is the sales and marketing by magazine crowd.
Two Worlds of DB2 LUW Performance Monitoring
(Ember Crooks) I generally suggest both my readers and my clients turn on the monitor switches using the DFT_MON* parameters in the DBM CFG. However, I find myself using traditional snapshots less and less. The main time I still use them is when I’m panicked and my older training kicks in. But think
Advanced redaction for better document workflow
(Yasutomo Nakayama and Eisuke Kanzaki) IBM InfoSphere Guardium Data Redaction removes sensitive data from documents that enterprises share across departments or with the public. The product supports various document formats. This article describes several features of InfoSphere Guardium Data Redacti
Programming model support in lightweight Java servers
(Roman Kharkovski) Software developers have a lot of tools at their disposal when building modern applications with Java application servers. One of the many trends is the use of lightweight application servers. There is no strict definition of “lightweight”, but generally speaking these are product
Programming model support in lightweight Java servers
(Roman Kharkovski) Software developers have a lot of tools at their disposal when building modern applications with Java application servers. One of the many trends is the use of lightweight application servers. There is no strict definition of “lightweight”, but generally speaking these are product
Faster DB2 Performance with IBM FlashSystem
(Karen Orlando and Megan Gilge) This IBM Redbooks Solution Guide provides an overview of IBM FlashSystem running in a DB2 environment with a focus on performance and the benefits gained from running DB2 with Flash storage.
