International DB2 Users Group (IDUG) Trip Report - Dave Beulke

Here is my trip report from the annual International DB2 User Group (IDUG) conference held last week. The event was great because of the technical, real world, pragmatic, and easy-to-understand content, especially from the user speakers. The IBMers, consultants, and vendors also provided great material to help make everyone’s DB2 systems and applications perform better . . . → Read More: IDUG DB2 Trip Report

Reliability, Availability, and Scalability Lessons for Holiday Peak Processing

Operational performance is always paramount for applications, websites, and order systems during the busy Christmas holiday shopping season. Keeping holiday peak processing going with good performance is a pains-taking ordeal. Even with the best laid plans of continuous improvement builds, application code freezes, massive end-to-end testing, and continuous monitoring of systems application and programs fail, . . . → Read More: Reliability, Availability, and Scalability Lessons for Holiday Peak Processing

3 Use Cases for Optim Workload Replay

The complexity of the systems, databases and applications continues to get worse. Getting a clear understanding of all the existing applications’ processing, dependencies, and workloads only gets more complicated and difficult to understand. As more complexity gets added to your in-house applications, or new versions of packaged applications are leveraged for their new features, the . . . → Read More: 3 Use Cases for Optim Workload Replay

DB2 11 SQL Performance Improvements

DB2 11 for z/OS SQL performance improvements help make your applications go faster. DB2 11 also helps address some of the latest coding problems provided by the latest Java and other development coding. The following two items highlight some of the improvements that come straight out of the box in DB2 11 for z/OS and . . . → Read More: DB2 11 SQL Performance Improvements

Big Data: Five Simple Database Design Performance Tips

Doing performance consulting, database system and application tuning exposes me to many different database designs. There are many different aspects to properly analyze a database schema design. The following five simple database design performance tips are the first five critical aspects that can be quickly analyzed and evaluated especially in the early stages of development.

. . . → Read More: Big Data: Five Simple Database Design Performance Tips

Big Data: DB2 SQL Performance Is Faster Using OLD TABLE

Processing rows inside the DB2 engine is always faster than trying to do the same processing within an application program or outside of DB2. A common program performance mistake is executing two SQL statements and then matching or merging the data inside the application. The DB2 engine processes the data faster through a single SQL . . . → Read More: Big Data: DB2 SQL Performance Is Faster Using OLD TABLE

Big Data: 3 Keys for Effective Big Data Success

Companies are more stressed and looking for every advantage or differentiator to gain the competitive advantage. Working with Big Data is in IT fashion as a way to gain new insights from customers, suppliers and partners for delivering the best products, customer service and profits. Executing these Big Data initiatives is always an interesting opportunity . . . → Read More: Big Data: 3 Keys for Effective Big Data Success

3 Big Data Issues: Security, Governance and Archiving

When companies and projects are considering their Big Data applications, it seems that everyone forgets the decades of advancement, computing platforms and databases technologies have gone through. Platform and database are critical to the success of your company’s Big Data initiative and choosing a mature technology can help your project succeed and give your processing . . . → Read More: 3 Big Data Issues: Security, Governance and Archiving

Big Data: IBM’s Mainframe Customers Base Grows

IBM announced its fourth quarter 2012 earnings and they discussed them last week at IBM Software kickoff that I attended with a few other Gold Consultants last week. The numbers speak for themselves and show that IBM’s Big Data solutions are being embraced by companies worldwide and probably your competitors. The discussion showed that Information . . . → Read More: Big Data: IBM’s Mainframe Customers Base Grows

DB2 Performance Lessons from the Facebook IPO Failures

Watching the Facebook IPO and followed by all the Morgan Stanley, NASDAQ and other parties bickering, pointing fingers and preparing lawsuits reminds me of many of the struggling IT projects that I have assisted with as a DB2 consultant. The failures of the Facebook IPO show how having unaligned interests always leads to failure. Even . . . → Read More: DB2 Performance Lessons from the Facebook IPO Failures