Page 2

By Lisa Vaas  |  Posted 2003-05-13 Print this article Print

It cant handle every schema change, Jones said, but should eliminate a "significant" amount of downtime. Depending on the situation, that can mean minutes as opposed to days. DB2 is also picking up built-in data encryption and decryption. Also new is multilevel security by row that allows for the creation of profiles. Such profiles allow for the creation of security level definitions for groups or individual users that can then be assigned to a given row.
The upgrade also includes enhancements in SQL for OLTP (Online Transaction Processing) applications that enable popular Unix and Windows applications to be more easily ported to DB2 on the mainframe. Also, better DB2 for z/OS support for popular languages such as XML, SQL and Java are designed to make the mainframe database environment more conducive for use with diverse applications. The XML support includes the implementation of XML publishing functions, known as SQL XML or SQLX. Also, query enhancements should deliver responses 10 to 100 times faster, officials said.
Martin Hubel, an independent database specialist, said that the 64-bit news is an eyeball-grabber for DB2 users, both in terms of the capabilities it promises and the hardware upgrades it dictates. "Customers have to plan to take their existing machines and get to 64-bit before they use this new operating system and all the other stuff," said Hubel, in Thornhill, Ontario. "Thats the biggest thing that will affect customers: new hardware, new operating systems. To be able to use it at all, youll have to be on the new architecture. That means existing 32-bit machines are going to be outdated." But regardless of how much theyve invested in 32-bit architecture, customers will absolutely gobble up 64-bit, Hubel said, given the growth rate of storage. "In 1985, we had a 24-bit operating system. We had no requirement for extended addressing—31-bit—until we installed DB2. As soon as we did, we had the requirement in spades," he said. Online Schema Evolution is another earth-shaker, Hubel said. "Thats a big thing," he said. "[IBM has] customers that want to create one partition per day for up to 10 years. Thats something like 3,700 partitions. "Online Schema Evolution allows people to add partitions, to rotate partitions on, say, a monthly basis"—all done far more simply and with less downtime, he said. Latest Stories by Lisa Vaas:

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel