CA expedites required DB2 10 upgrades for z/OS

CA Technologies has updated its z/OS management products to handle DB2 10 upgrades

Just in time for what will be a large number of required migrations, CA Technologies has updated its software for managing DB2 databases running on IBM z/OS mainframes.

"DB2 is a very rich environment, and is very specific about how you work with it from an application perspective," said Mark Combs, a CA distinguished senior vice president for mainframe operations. "With DB2 10, IBM introduced a lot of good new features, but it requires work" to upgrade a database to take advantage of them, he said.

CA has updated two of its software packages for managing DB2 on z/OS, namely CA Technologies Database Management Solutions for DB2 for z/OS, now at version 16, and CA Mainframe Chorus for DB2 Management, now at version 2.5. Both packages have been updated to manage DB2 version 10, which IBM released in April.

Gartner has estimated that 75 percent of the DB2 databases running on z/OS will need to be upgraded within the next 18 months. IBM support for DB2 version 8 ended this year and support for version 9 will end in June 2014. "There is a fairly intense push to get people to version 10," Combs said.

Adding to the work of upgrading is the fact that many mainframe administrators tend to be older and close to retirement, which means the upgrade duties may fall to the less-experienced junior staff, who might appreciate helpful tools for getting the job done. "Our tools have been upgraded to easily manage this transition," Combs said.

The CA Technologies Database Management Solutions for DB2 for z/OS is a collection of software applications for managing running copies of DB2 on IBM's mainframe systems. It includes tools for improving performance, backing up DB2 databases and executing routine administration tasks.

With release 16, a number of components have been updated to ease migrations to DB2 10, such as the Plan Analyzer tool. Each DB2 database has something called a plan, which contains instructions for the database on how to access certain sets of data as quickly as possible. To upgrade to a newer version of the database, the administrator has to rebuild, or "rebind," the plan, Combs said. Plan Analyzer can now inspect the current plan and offer suggestions as to the best way to rebind the plan for the upgraded database.

Another feature is for scheduled reboots of the database. DB2 10 allows administrators to make more configuration changes to a database without needing to restart the database immediately. The CA software will keep track of the changes that have been made and can schedule a good time to restart the database, perhaps during a time of minimal use. The software can also analyze the configuration and offer a list of possible changes to speed performance.

Version 2.5 of CA Mainframe Chorus for DB2 Management has a number of DB2 updates as well. The software repackages the traditional mainframe green-screen format into a more user-friendly visually oriented look and feel. The new interface could be useful for younger administrators who may not be as familiar with the traditional ways of the mainframe, Combs said. New features here include better data analysis, improved search capabilities and the ability to tap into external knowledge sources, such as user forums.

The price for each package varies greatly, depending on configuration. Typically implementations will cost "in the tens of thousands of dollars," Combs said.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the PC World newsletter!

Error: Please check your email address.

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?