Performance Features in DB2 V9 for z/OS – Part 18

New DB2 9 for z/OS Utilities

Within the IBM Z Summit road show that was recently in Washington DC, the DB2 presentations highlighted a number of DB2 utilities improvements. All of these DB2 utilities improvements are integrated into the new DB2 10 but there were many that can be incorporated into . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 18

Performance Features in DB2 V9 for z/OS – Part 17

New APARs Bring Features into V8 and V9 NOW!

Some of the new tablespace partitioning choices and features in DB2 Version 8 and now DB2 Version 9 for z/OS that I talked about last week are getting extra enhancements. During the recent IBM System Z Summit road . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 17

Performance Features in DB2 V9 for z/OS – Part 16

DB2 V9 Tablespace and Partitioning Choices

Some of the new tablespace partitioning choices and features in DB2 Version 8 and Version 9 for z/OS are making everyone realize there are a number of table design choices to fit any application access type.

In DB2 V8, the first of the . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 16

Performance Features in DB2 V9 for z/OS – Part 15

No Locking Issues within DB2

Some of the new performance features in DB2 Version 9 for z/OS are built into the software. To leverage some of these functions and features, system maintenance DBAs and application DBAs need to coordinate their efforts to realize the benefits.

A couple of these . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 15

Performance Features in DB2 V9 for z/OS – Part 14

CLONE Tables

As I have talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard application performance; improve application response time and overall availability of your systems and data.

Another one of the great features . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 14

Performance Features in DB2 V9 for z/OS – Part 13

Lucky 13 -Making Buffer Pool Changes with WLM

With all those year-end jobs running and the system already at 100% utilization there are not too many options for getting things to run faster.

In DB2 Version 9, one of the new features that can be leveraged to make things run faster is increasing . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 13

Performance features in DB2 V9 for z/OS – Part 12

Happy Holidays – Three Cheers for Online Reorgs!

Given the snowstorm and the extra time in airports, I thought it was perfect time to do a blog entry. In the early releases of DB2, we had to work the holidays to do the Reorgs because that was the only time during the . . . → Read More: Performance features in DB2 V9 for z/OS – Part 12

Performance Features in DB2 V9 for z/OS – Part 11

While talking with clients and friends at the recent conferences, I noticed that everyone seemed to like the blog entries I’ve done about the performance features of DB2 v9 for z/OS. Some have even implemented some of the features previously mentioned and have already reduced their costs and overall processing elapsed times. So, with DB2 . . . → Read More: Performance Features in DB2 V9 for z/OS – Part 11

Connect with your DB2 Performance

Recently working with a client’s SOA environment showed several interesting performance issues. One performance issue that was quite stunning was the large number of connections that the .Net and Java application were making to DB2 and other systems. Researching the system and application further uncovered a wide disparity in the handling, and the amount of . . . → Read More: Connect with your DB2 Performance

zIIP and zAAP Your DB2 Performance

Many years ago, IBM System Z announced the introduction of additional new specialty processors. The first System Z specialty engine introduced for data sharing was the internal coupling facility (ICF), next the integrated facility for Linux (IFL), next the application assist processor (zAAP) and the latest is the integrate information processor (zIIP). All of these . . . → Read More: zIIP and zAAP Your DB2 Performance