Author Archives: Julian

Bringing Business Analytics to Big Iron

Traditionally DB2 for z/OS was considered to be primarily an OLTP data server, with the DB2 for Linux, Unix and Windows variant being a more common choice for analytics and data warehousing duties. This approach is often dictated by cost … Continue reading

Posted in DB2, DB2 10, System Z | Tagged , , , , | Leave a comment

DB2 10 for z/OS – New feature announcement

DB2 10 for z/OS has been GA since October 2010, but one or two features weren’t quite ready at that time. One of the more eagerly awaited enhancements extend the access path management capabilities of DB2 10, via the APREUSE … Continue reading

Posted in DB2, DB2 10, z/OS | Tagged , , , , , | Leave a comment

DB2 10 for z/OS – Why IT Executives Need to Take Note

This release of DB2 10 for z/OS should make IT executives sit up and listen when their technical teams come to them with their upgrade justifications and this is why…. At the end of October 2010 IBM launched the latest version … Continue reading

Posted in CIO, DB2, DB2 10, System Z, z/OS | Tagged , , , | Leave a comment

APAR UPDATE – INSERT performance in critical DB2 9 for z/OS tables

Are you trying to improve INSERT performance in your critical DB2 9 for z/OS tables? Many DB2 experts have given excellent presentations on this important subject, and there are several good techniques you can use to reduce the elapsed time for … Continue reading

Posted in DB2, DB2 9, System Z | Tagged , , , | 1 Comment

Database Journal – IBM Information Management Trends

In his latest article for Database Journal Julian Stuhler shares his pick of the most important current trends in the world of IBM Information Management. Some are completely new and some are evolutions of existing technologies, and he’s betting that every … Continue reading

Posted in CIO, IBM, Information Management, Julian Stuhler | Tagged , , | Leave a comment

Justifying the Upgrade to IBM DB2 10 for z/OS

In his column for Database Journal Julian Stuhler looks at how an upgrade to DB2 10 can be justified. Under current economic conditions IT professionals are being asked to give short-term business benefit cases before any major infrastructure upgrade is agreed. … Continue reading

Posted in CIO, DB2, DB2 10, Julian Stuhler, System Z | Leave a comment

How many DB2 for z/OS Stored Procedures?

As always, the answer to this is “it depends”! However, here are some basic rules of thumb that you may find useful: • Define an application environment specifically for your Java stored procedures. This should have NUMTCB set to a … Continue reading

Posted in DB2, DB2 Support, Julian Stuhler, System Z | Tagged , , , , | Leave a comment

Julian Stuhler’s Guest Blog on “Getting the Most out of DB2 for z/OS and System z”

I’d like to follow up on a topic last mentioned in this very column last November, on the subject of “Not Accounted” time (link here ). The list of possible explanations for not accounted time that Willie referred to was … Continue reading

Posted in DB2, System Z | Tagged , , , | Leave a comment

Techie Tip – Real Time Statistics (RTS) feature

If you make use of RTS and DEFINE NO, you might want to review your processes to ensure that you’re picking up all of the tablespaces you should be…… Since V7 of DB2 for z/OS, IBM has provided a Real … Continue reading

Posted in DB2, DB2 9, DB2 Support, IBM, System Z | Tagged , , , , , , , | Leave a comment

Performance and profitability don’t have to suffer as a result of high CPU usage

Managing performance and cost has become a significantly more difficult job with capacity planners and performance analysts being asked to defer hardware and software upgrades due to squeezed budgets. Many large IT departments have also seen loss of staff due … Continue reading

Posted in DB2, Julian Stuhler, System Z, capacity planning, zTune | Tagged , , , , , , | Leave a comment