Capacity Planners and Big Data

I was at a regional CMG meeting in Raleigh, North Carolina, giving a presentation on Big Data to a group of about forty Capacity Planners (big turnout for North Carolina a week after Hurricane Matthew hit). The group was interested in understanding the impact the nascent Big Data wave would have on their capacity plans. The answer is—a LOT.

Read More
it's about time

It’s about time!

DB2 z/OS V12 is in the Early Support Program mode. This means the larger Independent Software Vendors (BMC, CA, Compuware, etc.) have a version of DB2 z/OS V12 in house so they can modify their products to support and/or exploit the new features of DB2 z/OS V12. This process can take months, or even up to a year.

Read More

DB2 for z/OS – Taking the Best Data Server on a Transformational Journey

Business transformation and agility are critical in today’s fast moving world. Clients demand insights faster, more often, and with greater accuracy based on up-to-the-second transactional data that is frequently housed in mainframe systems. The dependency on technology and the rate at which information is created and consumed continues growing exponentially. Applications have to rapidly adapt to take account of the dynamic digital business models and environments. All this drives the need for flexible IT infrastructures that are built on a rock solid foundation to deliver consistent dependability, performance, and security in the face of rapid change.

Read More
DB2 Performance Advisor

The DB2 Performance Advisor – SQL Performance Tuning Basics

When asked what is the single most important or stressful aspect of their job, DBAs typically respond “assuring optimal performance.” Indeed, a Forrester Research survey of critical DBA concerns indicates that performance and troubleshooting tops the list of most challenging DBA tasks. With this in mind, let’s take a moment to outline the basic factors that influence the performance of DB2 applications.

Read More
quality assurance

DB2 to the Rescue!

DB2 for z/OS applications continue to be a workhorse for large IT shops. Of course the DB2 applications have Service Level Agreements for availability and performance. These are largely based on requirements that drive customer satisfaction and transaction throughput. Most DBAs are proficient in identifying performance problems and tuning the application SQL and data bases for performance in order to meet the SLAs. However, many DBAs may not be aware of the fact that DB2 is a significant component in the cost of the aWLC (advanced Workload License Charge) Monthly License Charge bill.

Read More
DB2 Performance Advisor

The DB2 Performance Advisor – What is Performance

Assuring optimal application and system performance is one of the most important goals of IT professionals. And for DB2 developers and DBAs, tuning and monitoring are often daily tasks. But there are many factors involved in DB2 optimization and performance monitoring and tuning … too many to do justice to in a single article. And that is why we are introducing this regular column: The DB2 Performance Advisor.  This column will appear regularly on the Planet Mainframe blog, and will cover all facets of performance management regarding DB2 for z/OS.

Read More

Automated SQL Quality Assurance

To leverage available skill sets and to save on costs, many large IT organizations have been moving their DB2 development efforts to off-platform programmers. These programmers are not mainframe developers, and may not even have mainframe logon accounts. They write the applications in JAVA or C, and create SQL that will be run against existing production mainframe DB2 systems.

Read More