Feeds

Mainframe DB2 emerges from primordial swamp

Columns, memory and Cube Views. Oh my!

  • alert
  • submit to reddit

Gartner critical capabilities for enterprise endpoint backup

IBM's mainframe machine keeps rolling along with the release this week of DB2 Version 8 for the venerable hardware and the z/OS operating system.

With the new version of the database, IBM worked to increase the amount of memory that can be addressed, added new security tools and made the software work better with DB2 for Unix, Linux and Windows. The new database arrives on the heels of a strong quarter for IBM's zSeries mainframe business, proving the old kit still has some legs, even if they have the leathery, green hue of a dinosaur.

First up, IBM has added 64-bit support to DB2 Version 8. Moving from 31-bits, will make it possible to address more memory and many terabytes of storage capacity. IBM has also expanded table name sizes from 18 to 128 characters, upped column name sizes from 18 to 30 characters and bulked up SQL statement length from 32 kilobytes to 2MB. All of this helps customers shed some of the nasty mainframe limitations lingering on from years ago.

A new feature unique to DB2 for the mainframe is row level security. This makes it possible to create barriers between different data sets, giving access to the information to specific users or departments. It also helps to segregate customer information, said Jeff Jones, IBM's director of strategy for DB2.

"This is very broadly applicable security technology not just for top secret government organizations," he said.

Another major addition to DB2 comes in the form of QMF (Query Management Facility) technology that can tap into DB2 Cube Views on Unix, Linux and Windows servers. This lets different versions of DB2 share information and form the Cube Views or graphical pictures of data for customers. IBM is selling the QMF package as an add-on for mainframe DB2 but might build it in as a standard package down the road, Jones said.

Overall, there are about 100 new features in DB2 for z/OS. IBM is touting the release as one of its biggest achievements ever in the database space. All the ins and outs can be found here.

As always, IBM is reluctant to provide public pricing on its mainframe software. There are too many factors and "special builds" in the mainframe world to give some sort of standard pricing model, Jones said.

IBM is still talking up the use of Linux on the mainframe but has certainly toned down the marketing schtick around the effort. Big Blue recently moved to make Linux a standard option on its highest-end Unix boxes, which may account for part of the backtrack.

IBM's mainframe business tends to have fairly dramatic ups and downs quarter by quarter, but the most recent numbers from IDC say the beast is booming. IBM's mainframe biz enjoyed a 33 percent revenue surge in Q4 year-over-year. This comes with rivals such as HP and Sun gunning as hard as they can to move mainframe customers onto high-end Unix gear.

The new database is generally available worldwide on March 26. ®

Related stories

IBM tidies up high-end Unix kit
IBM shows Itanic love with Power4 benchmark
Servers fly in Q4

Secure remote control for conventional and virtual desktops

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
A beheading in EMC's ViPR lair? Software's big cheese to advise CEO
Changes amid rivalry in the storage snake pit
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.