| By Dave Beulke, on August 30th, 2017 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 By Dave Beulke, on August 2nd, 2017 The announcement last week of IBM’s new mainframe server z14 discusses how the new hardware brings more capacity and flexibility to computing than ever before. The new z14 mainframe server is a technology behemoth and has so many features that it takes a huge amount of documentation that details the specifics. Being the nerd that . . . → Read More: New z14 IBM’s Mainframe Server By Dave Beulke, on June 7th, 2017 Recently on the REDDIT DB2 forum someone raised a question (found here) about DB2’s future in application development. The question and answers talked about the database industry and the reason DB2 is positioned in the upper right quadrant in the latest Gartner Magic Quadrants found here. To address some of those concerns, here . . . → Read More: Five Ways to Make your DB2 Data Delicious By Dave Beulke, on March 29th, 2017 Tuning DB2 LUW systems, databases, and applications can be sometimes a long drawn out research effort requiring examination of every variable involved. Sometimes the key to the performance is examining the DB2 LUW system installation, its configuration, and the database configuration. This why I call this blog “DB2 Install Next Steps” because if the SYSADMIN . . . → Read More: DB2 Install Next Steps: Part 1 By Dave Beulke, on July 27th, 2016 Working with big data performance everyday takes the “big” out of it. The big data is just a bigger data beast that your procedures and processes need to plan for and deal with. Every big data decision is just another decision, but a bit more interesting and intensified because the outcome is more impactful and . . . → Read More: 3 Big Data Performance: Building Analytical Consensus By Dave Beulke, on March 23rd, 2016 Last week was Part 2 of the discussion on DB2 Commit Scope considerations (found here) which followed Part 1 from the week before (here). This week the DB2 commit scope programming discussion continues with DB2 SQL considerations. The following addresses some of the DB2 SQL web and batch program requirements and considerations for . . . → Read More: Criteria for Determining the Commit Scope Performance (part 3) By Dave Beulke, on March 9th, 2016 Last week was part 1 of the discussion on DB2 Commit Scope considerations found here. This week the DB2 commit scope programming considerations discussion continues with batch process considerations. The following addresses some of the program requirement discussions that are needed to determine the best DB2 commit scope practices for achieving the best performance . . . → Read More: Criteria for Determining the Commit Scope performance (part 2) By Dave Beulke, on February 24th, 2016 A couple of weeks ago I discussed three critical programming performance criteria, where I talked about the importance of DB2 commit scope, data integrity, and programming languages. This brought in some interesting email comments/questions about what DB2 commit scope criteria needs to be evaluated and what factors come into consideration. The evaluation of a . . . → Read More: Criteria for Determining the Commit Scope Performance (Part 1) By Dave Beulke, on February 10th, 2016 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 By Dave Beulke, on January 27th, 2016 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 | |