Feeds

Mainframe DB2 emerges from primordial swamp

Columns, memory and Cube Views. Oh my!

  • alert
  • submit to reddit

Internet Security Threat Report 2014

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

Beginner's guide to SSL certificates

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
'Urika': Cray unveils new 1,500-core big data crunching monster
6TB of DRAM, 38TB of SSD flash and 120TB of disk storage
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
SDI wars: WTF is software defined infrastructure?
This time we play for ALL the marbles
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
Oracle hires former SAP exec for cloudy push
'We know Larry said cloud was gibberish, and insane, and idiotic, but...'
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
Win a year’s supply of chocolate
There is no techie angle to this competition so we're not going to pretend there is, but everyone loves chocolate so who cares.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.