Immutable Table Function

Should DB2 have an Immutable Table Function?

I love hearing about Blockchain; if you are involved in Fintech, then surely by now you have heard a lot about it, and that it holds a tremendous amount of promise for Internet business. Fundamentally, it guarantees the validity of a transaction.  Blockchain is a ledger of all transactions; a ledger cannot be changed, making the requirement for a third party to process transaction payments unnecessary.

Read More

What’s waiting round the mainframe corner?

Anyone who has been working on mainframes for any length of time knows that things are always changing. Many people can remember when DB2 was new (1983), the client-server period, and the need for Service-Oriented Architecture (SOA). And, I’m sure, can come up with a much longer list. I don’t want to look backwards at old ideas, I want to take a whirlwind look at what’s coming soon to (at least) a presentation near you.

Read More
software urbanization

Software Urbanism: A challenging but highly rewarding strategy

Information Technology (IT) is rather young in human history. If you compare this sector with industry, IT is just at the beginning of its development. To illustrate this infancy, let’s consider the evolution of IT jobs. With the multiplication of tasks and jobs left to IT, teams grew in number but also in complexity. New fields of expertise emerged to cover these growing needs. Nowadays, a Fortune 500 company has hundreds of software products running on its infrastructure. More and more data are collected, processed, stored, combined, analyzed, distributed… The amount has grown by a factor of 10 in only 6 years.

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 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

IDUG in Austin TX shows us that DB2 z/OS is alive and well

I visited IDUG (International DB2 Users Group) in Austin, Texas, the week of May 23. We had a booth and had good traffic. Our presentations and party were well attended. It was “old home week” for me as many friends and previous colleagues dropped by to say hi.

Many of the visitors to our booth were DB2 LUW professionals and quickly lost interest in our z/OS offerings. However, there were plenty of DB2 z/OS folks who dropped by to talk and who understood our offerings.

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

IDUG EMEA 2015 Takeaway

IDUG EMEA took place mid November (15th to 20th) in Dublin, Ireland this year. As a resident IDUG attendee, I’ve noticed that this year there was an even higher concentration of big data talk. But the difference now includes the battle of where the big data analytics should take placewithin z, in the cloud where the rest of the data sits, within the storage component of a third-party analytics solution. The debate goes on and on…

Read More