(Johanna Angani and Sascha Laudien) When the data you’re monitoring gets too large to be easily displayed with pure WebSphere Business Monitor dimensions functionality without degrading performance and usability, you need a solution to limit the data. In this article, you’ll learn how to implement T
Tag: IBM
APAR Friday: Something for the Optimizer
(Willie Favero) Here’s an interesting APAR that both my DB2 for z/OS Version 8 and DB2 9 for z/OS friends should be interested in. APAR PK62804 fixes a potential problem with a poor access path being picked for range and BETWEEN predicates due to a not that accurate filter factor.
TechTip: Improve Performance When Writing to DB2 for i Tables, Part I
(Fernando Echeveste) If your application inserts a large volume of rows into DB2 for i tables, the following features found on IBM i can influence the performance of your application:
Dimensional analysis in business activity monitoring (BAM), Part 1:: Leverage WebSphere Business Monitor V6.2 to perform dimensional analysis
(David Enyeart, Art Majtenyi and Vani Bhartipudi) In this series, you’ll learn about the dimensional analysis capabilities of WebSphere Business Monitor V6.2, including how to model your data to fully exploit the powerful dimensional analysis capabilities of Monitor dashboards.
Dynamic SQL Causing Lock Escalation?
(Craig Mullins) Lock escalation is the promotion of a lock from a row, page or LOB lock to a table space lock because the number of page locks that are concurrently held on a given resource exceeds a preset limit.
Installing the Ruby driver for DB2 on Mac OS X Snow Leopard
(Antonio Cangiano) Now that Mac OS X 10.6 is out, it’s time to leave the world of 32 bit computing behind. The pre-installed Ruby interpreter will run in 64 bit mode by default, so you may need to pay attention when installing some C-based gems.
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 3: DBMS instances and storage objects
(Matthew J. Margan) This tutorial is the sixth in a series of nine tutorials designed to help you become familiar with all the different aspects of IBM Informix Dynamic Server (IDS) and help you get ready for the IDS Fundamentals Certification exam. In this part, which corresponds with Part 3 of the
Append only DB2 diagnostic log and administration notification log files? No more in DB2 9.7!
How many times have I asked customers for the DB2 diagnostic log file (db2diag.log) only to be told “it’s too large to send” or “it’s taking too long to open.” This is because the DB2 diagnostic files have been append only since time memorial, their growth only restricted by the maximum space availa
Best practices- DB2 9 for z/OS migration
(Roger Miller) Customers are migrating more quickly to DB2 9 this year. The DB2 9 value is helpful for most customers, and the migration experience has been positive. Migration is a broad topic, so I’ll emphasize some keys to success, point to many resources, emphasize some important points and pr
Text Analysis in InfoSphere Warehouse, Part 3: Develop and integrate custom UIMA text analysis engines
(Stefan Abraham, Simone Daum and Benjamin G. Leonhardi) In the first two articles of this series, you learned about IBM InfoSphere Warehouse text analysis capabilities, how to use regular expressions and dictionaries to extract information from text, and how to publish the results with a Cognos repo
