Since this holiday season is shorter and more people hate the mall crowds, billions will be spent online this season. Unfortunately for management, lack of application development testing, up-to-date standards, and performance procedures will hinder profitability through poor performance of the company website. While the application developers will always blame the database, below are five . . . → Read More: 5 Performance Tips from the 2013 Holiday Rush
As I noted in last week’s blog, there are many things IT organizations can learn from the website problems on Healthcare.gov. Here are five more things we all might learn from this website situation or any problem project that has these types of issues.
Best practices and industry standards work. I have written . . . → Read More: 5 More Things to Learn from the HealthCare.gov Website Problems
Channel surfing the other night I came upon the C-SPAN video replay of the congressional testimony regarding the Healthcare.gov website. Thinking about all the testimony and the political partisan points I was amazed at the project planning comments, lack of understanding of the technological problems, and number of issues that were discussed. . . . → Read More: 5 Things to Learn from the HealthCare.gov Website Problems
The BLU Acceleration technology is coming out and the new DB2 Version 10.5 Kepler performance improvements are game changing and dramatic especially for Big Data. I blogged about these features in a more detailed entry (IBM BLU Acceleration – Best Yet for Big Data!). The Columnar data store, 10x compression, in-memory processing, Single . . . → Read More: Big Data: BLU Acceleration DB2 Version 10.5 Kepler Considerations
Recently I discussed DB2 SQL tips that have provided application performance for decades with my clients’ SQL developers. These DB2 SQL tips provide developers with performance guidelines that can help their application designs and SQL coding get the best performance the first time.
Since clients have many different DB2 SQL tips, I’ve listed below 10 . . . → Read More: DB2 SQL Tips: 10 Performance Guidelines
Hardware continues to get faster, cheaper, and with more capacity. Now UNIX and even Windows systems are trying to handle billions of rows or terabytes of data. Database performance tuning is vital, but continues to get destroyed through wretched designs, poor application practices and maintenance malpractice which dramatically impacts overall database performance. Unfortunately, throwing more . . . → Read More: Database Performance Tuning Is Only Getting More Important
DB2 Clean up – Close Out the Past
As I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week we look into the DB2 Plan and Package settings. These settings can . . . → Read More: DB2 Performance Maintenance – Get All the Cache
DB2 Clean up – Close Out the Past
As I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week it’s recommended that you look into your various program’s plan and package . . . → Read More: DB2 Performance Maintenance – Trust But Verify
DB2 Clean Up – Close Out the Past
Within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. Test systems with unused databases, production jobs that need their schedule tweaked, reorgs for tables or indexes that need . . . → Read More: DB2 Performance Maintenance – Start Off the New Year Right!
Row and Column Access Controls
As I have talked about in previous weeks, another reason to request additional DBA resources are all the security configuration and settings involved with DB2 10 row and column access security. The setup, configuration and monitoring of these row and . . . → Read More: DB2 Security: Row and Column Access Controls