Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    IBM Readies T Rex Version of DB2

    By
    Lisa Vaas
    -
    May 13, 2003
    Share
    Facebook
    Twitter
    Linkedin

      IBM is launching a beta program for a T Rex version of its DB2 8 database that will run mainframe applications faster, explosively grow potential address storage and revolutionize the alteration of databases.

      The Somers, N.Y., company on Tuesday announced T Rex, its next-generation mainframe. Starting with 32 chips, the eServer z990 will grow to 64 chips by 2004.

      The T Rex version of DB2 includes 100 new or enhanced features that focus on improved performance, scalability, continuous availability, application porting and security, all geared to exploit the new z/OS and zSeries architecture, officials said. Officials also said that this is the first IBM product to engineer an exclusive 64-bit solution for the mainframe.

      Potential address storage space will jump from 2 gigabytes to 16 exabytes. Virtual storage under 64-bit will enable one, large, virtual space, rather than a number of smaller hyperspaces and data spaces in addition to the address space. Limits for storage use have been lifted so that customers can scale farther with more memory and more effectively. Outages are also expected to be reduced, and monitoring is expected to be simplified.

      All this works out to less housekeeping for the DB2 application, freeing it up to do a “lot more real data management, instead of maintenance of spaces and back-and-forthing to the disk,” said Jeff Jones, IBMs director of strategy, Data Management Solutions.

      “Longer table names, longer SQL statement lengths, longer key sizes, longer character strings—a whole bunch of things have grown immensely,” said Jones. Inflating these features means DB2 will be able to bite into gargantuan databases, he said. “Much more can be done in memory in one, big step: difficult queries, large databases can be processed much, much faster.”

      In addition, in this upgrade DB2 acquires Online Schema Evolution, which enables DBAs (database administrators) to alter databases on the fly without bringing them down. Thats a boon for big databases that would otherwise take days to change, as DBAs stop the system, copy data out, change the structure of the database to reflect whatever changes are being done to partitions and, finally, reload the database, Jones said. This new feature can handle schema changes such as adding columns, adding partitions and managing multiple versions of an object in the database at the same time.

      Page 2

      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
      Lisa Vaas is News Editor/Operations for eWEEK.com 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 eWEEK.com, 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.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×