SQL Big Data Performance Tips

After data validation, in most instances SQL performance is the most important big data performance factor in big database applications. Understanding the fine details of DB2 SQL performance tips can make a huge difference in processing time, especially true when going against a big data database. Since every design decision is magnified by tens of . . . → Read More: SQL Big Data Performance Tips

Black Friday Lessons

In the last blog (found here), I talked about the first five of the top 10 ways that can help make your systems bulletproof for holiday processing for reliability, availability, and scalability demands. This week I continue with reliability, availability, and scalability topics from my technology geeky background point of view.

The next five . . . → Read More: Black Friday Lessons

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

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 4

Every mainframe DB2 shop should investigate reducing their costs by offloading workload to an IDAA appliance. By following the steps in this blog series, you can understand how to evaluate and justify an IDAA appliance for your existing environment workloads at no cost. After investigating my daily SQL workload, I discovered millions of mainframe CPU . . . → Read More: Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 4

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 3

Every mainframe DB2 shop should investigate reducing their costs by offloading workload to an IDAA appliance. By investing in an IDAA appliance and sending your SQL workloads to it, you can speed up your processing without making any application changes. After investigating my daily SQL workload, I discovered millions of mainframe CPU MIPS that could . . . → Read More: Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 3

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 2

The benefits of having an IDAA appliance is something that every mainframe DB2 shop should investigate. Investigating and justifying an IDAA appliance can be done at no cost. In the previous blog, I talked about the set up steps for getting an IDAA Virtual Server configured and deployed within your environment.

In this blog, . . . → Read More: Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 2

Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 1

Unbelievably, the IBM DB2 Analytics Accelerator (IDAA) has been available for many years, helping all types of customers improve overall processing, especially their analytical processing.

Many companies do not have an IDAA appliance helping their DB2 for z/OS environments. Since most every shop’s processing would benefit tremendously from an IDAA appliance, every company needs to . . . → Read More: Process to Justify an IBM DB2 Analytics Accelerator (IDAA) Part 1

3 DB2 Critical Design Factors for Big Data Analytics Scalability

Faster, bigger, and better analytical insights. These are the goals that management lays out as the new big data analytics process is talked about during the startup meetings. Looking around the room and listening to the CIO’s comments it becomes abundantly clear that they only know the big data salesmen’s marketing material version not the . . . → Read More: 3 DB2 Critical Design Factors for Big Data Analytics Scalability

3 Critical Programming Performance Criteria

The new year always presents great opportunities after the holiday rush and code freeze-thaw of the holiday year-end. Unfortunately the code freeze-thaw can present wonderful opportunities for growth. Recently these three critical factors came to light during the analysis of performance aspects of the new version of a website.

There must always be a process . . . → Read More: 3 Critical Programming Performance Criteria

3 Critical Factors for Big Data Analytics Performance

With the start of the New Year comes new/revised project schedules, endless list of agile deliverables, new/maintenance projects, and the roulette of implementations. All of these efforts challenge the IT staff as no one talks about the business’ insatiable appetite for big data sliced/diced and where analytics is spread out across the corporation in a . . . → Read More: 3 Critical Factors for Big Data Analytics Performance