(Scott Hayes) OH WOW! Right now I am slapping myself on my back so hard that it hurts! In an earlier blog post on I/O Optimization and Solid State Disk (SSD), I referenced a recent IBM DM Magazine article and discussed an improved weighting formula for determining which tablespaces would benefit mos
Tag: IBM
IBM Experts on DB2 pureScale – On Demand Webcast
Hear Matt Huras from the IBM Labs and Clair Ross from Triton Consulting talk about IBM DB2 pureScale.
Use DB2 pureXML to implement a healthcare industry data solution
(Amnon Shabo, Mary Desisto, Anna Burla and Yonatan Maman) Interoperability and standards are the latest buzzwords in the healthcare industry today. Use of standards is key to giving hospitals and doctors the capability to interoperate to share patient records better. IBM Research has been investigat
Many New Index Options in DB2 – Version 9 Performance Features – Part 19
(Dave Beulke) Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much ti
DB2 LUW Security Primer
This presentation will quickly refresh your understanding of the DB2 9.5 security capabilities and then bring you up to speed on the latest additions made in DB2 9.7 to help you better meet your regulatory compliance needs such as separation of duties and data-in-transit encryption.
Dimensional analysis in business activity monitoring (BAM), Part 2: Improve performance in WebSphere Business Monitor V6.2 with materialized query tables
(David Enyeart, Art Majtenyi and Yuan Zhao) As IBM WebSphere Business Monitor models remain active for long periods of time, the number of instances in the Monitor database may grow into the millions and more. Managing this kind of growth is common in data warehouse environments, where the database
db2top Database Screen (Part 2)
(Keith McDonald) In the first post of this series on the db2top Database screen, we took a look at the gauges that make up the top part of the screen and saw the additional data about backups that becomes available when the screen widened to 141 columns or wider. In this second post, we will examine
DB2 LUW Performance Diagnostics and Tuning Lab at IDUG
(Scott Hayes) DB2 LUW Database Professionals: If you can only get budget to attend ONE class this DECADE, I strongly encourage you to do whatever it takes to get yourself enrolled in my NEW Ed Seminar DB2 for LUW Performance Analysis and Tuning Workshop being given at IDUG in Tampa, Florida, on 10 M
Old Xephon Articles Still Available
(Troy Coleman) Via the DB2-L list server, I recently discovered a treasure trove of old DB2 articles originally published in Xephon magazine. All this information is currently hosted on cbttape.org, with the permission of the owners of the z/Journal publication, who retain the rights to the Xephon c
db2top Database Screen (Part 1)
(Keith McDonald) The first major screen of db2top that we will examine is the Database screen. This screen gives you the big picture view of your database. You can use this screen to see how busy your database is in terms of the number of applications connected to it and issuing work, the amounts of
