Transcription
DB2 DB2 Version 9for Linux, UNIX, and WindowsWhat’s NewSC10-4253-00
DB2 DB2 Version 9for Linux, UNIX, and WindowsWhat’s NewSC10-4253-00
Before using this information and the product it supports, be sure to read the general information under Notices.Edition NoticeThis document contains proprietary information of IBM. It is provided under a license agreement and is protectedby copyright law. The information contained in this publication does not include any product warranties, and anystatements provided in this manual should not be interpreted as such.You can order IBM publications online or through your local IBM representative.v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/orderv To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/planetwideTo order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU(426-4968).When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in anyway it believes appropriate without incurring any obligation to you. Copyright International Business Machines Corporation 1993, 2006. All rights reserved.US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.
ContentsAbout this book . . . . . . . . . . . viiWho should use this book .How this book is structured . vii. viiPart 1. What’s new for Version 9.1 . . 1Chapter 1. Highlights of Version 9.1 . . . 3Highlights of Version 9.1 summary . . . . . .Information as a service (native XML data store) .More agile development . . . . . . . . .Autonomic computing . . . . . . . . . .Improved large database management using tablepartitioning . . . . . . . . . . . . .Secure and resilient . . . . . . . . . . .Manage your business, not your database . . .Hardware and operating system support . . . 3. 6. 9. 10.12151517Chapter 2. DB2 Connect enhancements 19DB2 Connect enhancements summary . . .DB2 Client easier to upgrade to DB2 ConnectPersonal Edition . . . . . . . . . . .32-bit DB2 Connect instance support changes . 19. 21. 22Chapter 3. Product, packaging, andterminology changes . . . . . . . . 25Product, packaging, and terminology changessummary . . . . . . . . . . . . . . .New name for DB2 Universal Database for Linux,UNIX, and Windows . . . . . . . . . . .New names for DB2 Information Integratorproducts . . . . . . . . . . . . . . .DB2 Version 9.1 component replacements and namechanges. . . . . . . . . . . . . . . .DB2 product-line changes . . . . . . . . .Distribution key terminology change . . . . . .252525262727Chapter 4. Native XML data storesupport . . . . . . . . . . . . . . 29Native XML data store support summary . . . .XML schema, DTD, and external entity managementusing the XML schema repository (XSR) . . . . .XQuery language support . . . . . . . . .XQuery builder . . . . . . . . . . . . .DB2 Net Search Extender support for the XML datatype . . . . . . . . . . . . . . . . .Application development support - native XML datastore . . . . . . . . . . . . . . . . .Application development support summary native XML data store . . . . . . . . . .Application programming language support forXML. . . . . . . . . . . . . . . .XML data type support in SQL and externalprocedures . . . . . . . . . . . . .XML support in Developer Workbench . . . . Copyright IBM Corp. 1993, 200629303031323232323334XML support in SQL statements and SQL/XMLfunctions . . . . . . . . . . . . . .XML support in SQL Assist . . . . . . . .Annotated XML schema decomposition . . . .Performance enhancements - native XML data storePerformance enhancements summary - nativeXML data store . . . . . . . . . . . .Indexes over XML data . . . . . . . . .Performance guidelines for XML indexing . . .RUNSTATS command support for the nativeXML data store . . . . . . . . . . . .Optimizer support for the native XML data storeAdministration tools support - native XML datastore . . . . . . . . . . . . . . . . .Administration tools support summary - nativeXML data store . . . . . . . . . . . .Control Center support for native XML data storeExplain and Visual Explain support forSQL/XML and XQuery statements . . . . .Command line processor (CLP) and command linetool support - native XML data store . . . . . .Command line processor (CLP) and commandline tool support summary - native XML datastore . . . . . . . . . . . . . . . .DB2 command line processor support for thenative XML data store . . . . . . . . . .db2batch command changes for native XML datastore . . . . . . . . . . . . . . . .db2look command changes for native XML datastore . . . . . . . . . . . . . . . .Import and export utility support for the nativeXML data store . . . . . . . . . . . .35373737373838383939393940404041414142Chapter 5. Application developmentenhancements . . . . . . . . . . . 43Application development enhancements summaryBINARY, VARBINARY, and DECFLOAT data typesupport in .NET and CLI client applications . . .Client support for trusted connections to DB2 forz/OS databases . . . . . . . . . . . . .Command line processor (CLP) 64 KB limit for SQLstatements has been removed . . . . . . . .DB2 .NET Data Provider enhancements and supportfor the .NET Framework 2.0 . . . . . . . . .Developer Workbench replaces the DevelopmentCenter . . . . . . . . . . . . . . . .External table function support across databasepartitions . . . . . . . . . . . . . . .IBM Database Add-Ins for Microsoft Visual Studio2005 enhancements . . . . . . . . . . . .Java routine class loader enhancements . . . . .JDBC and SQLJ enhancements . . . . . . . .New and changed development software supportNew samples . . . . . . . . . . . . . .SAMPLE database enhancements . . . . . . .43434545454749495052535556iii
TRIM and STRIP scalar functions added . 57Chapter 6. Backup, logging, andrecovery enhancements . . . . . . . 59Backup, logging, and recovery enhancementssummary . . . . . . . . . . . . . . .Continue a recover operation that ended during therollforward phase . . . . . . . . . . . .Redirected restore operation using an automaticallygenerated script . . . . . . . . . . . . .Rebuild database function provides new restoreoptions . . . . . . . . . . . . . . . .Tivoli Storage Manager support added (Windowsx64) . . . . . . . . . . . . . . . . .5959596061Chapter 7. Client and connectivityenhancements . . . . . . . . . . . 63Client and connectivity enhancements summary . .Connection timeout support for databaseapplications added . . . . . . . . . . . .A single client (DB2 Client) is provided forapplication development and administration . . .DB2 Runtime Client enhancements (Windows) . .Internet Protocol Version 6 (IPv6) support added . .ODBC and CLI applications can now run without aDB2 client . . . . . . . . . . . . . . .Chapter 8. Federation enhancements6364646565. 67. 67. 68. 68Chapter 9. Installation, migration, andfix pack enhancements . . . . . . . . 69Installation, migration, and fix pack enhancementssummary . . . . . . . . . . . . . .Coexistence of multiple DB2 versions and fix packsenhancements (Linux and UNIX) . . . . . .Coexistence of multiple DB2 versions and fix packsnow supported (Windows) . . . . . . . .Installation of DB2 products without using anAdministrator user ID now supported (Windows)Manual installation enhancements (Linux andUNIX) . . . . . . . . . . . . . . .Migration resources for DB2 database systemsadded . . . . . . . . . . . . . . .New DB2 product uninstall features using thedb2unins command (Windows) . . . . . . .Response file enhancements . . . . . . . .Update capabilities added to the DB2 InformationCenter . . . . . . . . . . . . . . . 69. 69. 70. 72. 73. 73ivWhat’s New.80818181828283848485Chapter 11. National languageenhancements . . . . . . . . . . . 87National language enhancements summary . . .Unicode support added for character-based stringfunctions . . . . . . . . . . . . . . 87. 87Chapter 12. Performanceenhancements . . . . . . . . . . . 89Performance enhancements summary. . . . . .Enhanced query performance using statistical viewsFaster data loading using SOURCEUSEREXITcustomizable user exit . . . . . . . . . . .Load from cursor with remote fetch . . . . . .Materialized query table (MQT) enhancements . .Online processing of the SET INTEGRITY statementOptimizer registry variables and keywords addedRow compression support added . . . . . . .64 KB page size support added for POWER5 processors (AIX) . . . . . . . . . . . . .Chapter 13. Scalability enhancements89899090909191929395Scalability enhancements summary . . . . . .Increased maximum number of index columns andmaximum size of index keys . . . . . . . .Larger system and user temporary tables . . . .Table size limits increased to 1.1 trillion rows and 16terabytes . . . . . . . . . . . . . . .95959596. 74. 74Chapter 14. Security enhancements . . 97. 75. 97Chapter 10. Manageabilityenhancements . . . . . . . . . . . 77Manageability enhancements summary .Adaptive, self-tuning memory allocationALTER TABLE statement enhancements .78796367Federation enhancements summary . . . . .User mapping retrieval from an external repositoryis supported . . . . . . . . . . . . .Statement level isolation for nicknames . . . .Two-phase commit for multivendor data sources .Automated evaluation of object maintenancepolicies by the DB2 UDB for z/OS health monitor .Automatic storage enhancements . . . . . . .Automatic table and index reorganizationenhancements . . . . . . . . . . . . .Buffer pool identifiers displayed in databasememory output . . . . . . . . . . . . .Copy schema support . . . . . . . . . . .Enhanced access to DB2 administration commandsthrough SQL . . . . . . . . . . . . . .EXEC SQL utility support for loading data into DB2UDB for z/OS tables . . . . . . . . . . .Fast communications manager (FCM) enhancementsFirst Steps interface enhancements . . . . . . .Identifier length limits increased to 128 bytes foradditional objects and names . . . . . . . .Load support for partitioned tables added . . . .New SQL Monitor Area (SQLMA) for monitoringinformation flow in partitioned databaseenvironments . . . . . . . . . . . . . . 77. 77. 78Security enhancements summary . . . . . .Data access security improved through label-basedaccess control (LBAC) . . . . . . . . . .RESTRICT option added to CREATE DATABASEstatement . . . . . . . . . . . . . .Security administrator (SECADM) authority addedto centralize security privileges . . . . . . .SETSESSIONUSER privilege added . . . . .TRANSFER OWNERSHIP SQL statement added. 97. 98. 99. 99100
Chapter 15. Troubleshooting andproblem determination enhancements. 101Troubleshooting and problem determinationenhancements summary . . . . . . . . . .Data collection improvements for database systemfailures . . . . . . . . . . . . . . .High water mark option added for db2pd -fcmcommand . . . . . . . . . . . . . .Trace mask support added to the db2trc command101101101102Part 2. What’s changed fromVersion 8.2 . . . . . . . . . . . . 103Chapter 16. Changes in existingfunctionality . . . . . . . . . . . . 105Changes in existing functionality summary . . .Installation, migration, and fix pack changes . . .Installation, migration, and fix pack changessummary . . . . . . . . . . . . . .Application and routine migration changes . .db2 deinstall command parameter changes(Linux and UNIX) . . . . . . . . . . .DB2 install images package format changes(Linux and UNIX) . . . . . . . . . . .Documentation updates are available betweenproduct releases . . . . . . . . . . .Installation CD changes for national languageversions of DB2 products (Linux and UNIX) . .Licensing support changes . . . . . . . .Locally installed Information Center installationrestrictions . . . . . . . . . . . . .Migration support changes during installation(Windows) . . . . . . . . . . . . .Migration support changes for DB2 databasesystems . . . . . . . . . . . . . .Multiple CD installation now required for someproducts (Linux and UNIX). . . . . . . .Database setup changes . . . . . . . . . .Database setup changes summary . . . . .Authority required to start the databasemanager has changed (Windows) . . . . . .Automatic configuration of prefetchers and pagecleaners enabled by default . . . . . . . .Automatic self-tuning memory enabled bydefault during database creation . . . . . .Automatic statistics collection enabled bydefault during database creation . . . . . .Automatic storage enabled by default duringdatabase creation . . . . . . . . . . .Configuration Advisor enabled by defaultduring database creation. . . . . . . . .Configuration parameters default value changesDatabases require additional space . . . . .database memory configuration parameterchange . . . . . . . . . . . . . .Increased log, table space, and memoryrequirements due to larger record identifiers(RIDs) . . . . . . . . . . . . . . .Lock lists require additional space . . . . 13113114115116117119119120120Registry and environment variables defaultvalue changes . . . . . . . . . . . .32-bit DB2 database instance support changesAdministration changes . . . . . . . . . .Administration changes summary . . . . .Application ID format changed . . . . . .Backup image naming convention has changed(Windows) . . . . . . . . . . . . .Catalog table changes in support of tablepartitioning . . . . . . . . . . . . .Collating sequence IDENTITY replaces BINARYin command output . . . . . . . . . .Data movement utilities changes . . . . . .db2mtrk command changes (Windows). . . .DMS table space type default value changed toLARGE . . . . . . . . . . . . . .Handling of new database connections haschanged . . . . . . . . . . . . . .Load from cursor incompatibilities withprevious releases . . . . . . . . . . .Location of diagnostic messages for automaticmaintenance . . . . . . . . . . . . .New DB2 agents may affectMAX CONNECTIONS configuration andapplication monitor output . . . . . . . .REORGCHK command output changes . . .ROLLFORWARD DATABASE output haschanged . . . . . . . . . . . . . .SET SESSION AUTHORIZATION requiresSETSESSIONUSER privilege . . . . . . .sheapthres shr parameter change . . . . . .Table space-level point-in-time rollforwardoperations restrictions . . . . . . . . .TSM management class no longer used forfiltering when restoring or retrieving logs . . .Write-to-table event monitor changes . . . .Application development changes . . . . . .Application development changes summary . .Application and routine feature support changesChanged parameters and output for thedb2batch command . . . . . . . . . .Cursor blocking is disabled in SQL proceduresDB2 Embedded Application Server updated . .IBM Software Development Kit (SDK) for Java5.x support added (AIX, Linux, and Windows) .Removal of mutating table conflicts whencalling procedures from triggers . . . . . .Reverse scans enabled by default for indexes,primary keys and unique keys . . . . . .Sample build scripts updated . . . . . . pter 17. Deprecated functionality139Deprecated functionality summary . . . . .Check pending table state is replaced andiCheckPending parameter is deprecated . . .CLISchema CLI keyword no longer supported .COLNAMES column in SYSCAT.INDEXES isdeprecated . . . . . . . . . . . . .db2ilist command options are deprecated (Linuxand UNIX) . . . . . . . . . . . . .DB2LINUXAIO registry variable is deprecated . 139. 139. 140. 140. 140. 141Contentsv
db2secv82 command is deprecated . . . . .External routines now require an explicit entrypoint specification . . . . . . . . . . .Database logging using raw devices is deprecatedSome SQL administrative routines have beenreplaced . . . . . . . . . . . . . .ADD PARTITIONING KEY clause of the ALTERTABLE statement is deprecated . . . . . .DROP PARTITIONING KEY clause of the ALTERTABLE statement is deprecated . . . . . .Type 1 indexes are deprecated . . . . . . .DB2 JDBC Type 2 driver is deprecated . . . .The -w option of the db2icrt, db2ilist, anddb2iupdt commands is ignored . . . . . . 141. 141142. 143. 143. 144. 144. 145What’s New152153153153154Appendix A. DB2 Database technicalinformation . . . . . . . . . . . . 155150150151Appendix B. Notices . . . . . . . . 165Chapter 18. Discontinued functionality 147vi152Overview of the DB2 technical information . . .Documentation feedback . . . . . . . .DB2 technical library in hardcopy or PDF formatOrdering printed DB2 books . . . . . . . .Displaying SQL state help from the command lineprocessor . . . . . . . . . . . . . . .Accessing different versions of the DB2Information Center . . . . . . . . . . .Displaying topics in your preferred language in theDB2 Information Center . . . . . . . . . .Updating the DB2 Information Center installed onyour computer or intranet server . . . . . . .DB2 tutorials . . . . . . . . . . . . .DB2 troubleshooting information . . . . . . .Terms and Conditions . . . . . . . . . . 145Discontinued functionality summary . . . . .Alternate FixPak images are discontinued (UNIX)Autoloader utility (db2atld) is no longer supportedAudio, Image, and Video (AIV) Extenders are nolonger supported . . . . . . . . . . . .Data Links Manager no longer supported . . . .The Data Warehouse Center and the InformationCatalog Center are no longer included . . . . .db2reg2large utility for converting DMS table spacesize is discontinued . . . . . . . . . . .db2profc and db2profp utilities are discontinuedDB2 SCATTERED IO registry variable isdiscontinued (Linux) . . . . . . . . . . .Desktop icon and folder making utilities are nolonger supported (Linux) . . . . . . . . .Extended Storage option for buffer pools isdiscontinued . . . . . . . . . . . . .Fast communications manager (FCM) no longeruses virtual interface (VI) architecture . . . . .NetBIOS and SNA communication protocols are nolonger supported . . . . . . . . . . . .DB2 Administration Tools are no longer supportedon some platforms . . . . . . . . . . .Text Extender is no longer supported . . . . .Type 3 JDBC support is discontinued . . . . .Vendor load API (sqluvtld) is discontinued . . .VSE and VM objects are no longer supported inthe DB2 Control Center . . . . . . . . . .147147148148148150151Trademarks .155155156158159160160161163163164. 167151Index . . . . . . . . . . . . . . . 169152Contacting IBM. . . . . . . . . . 181
About this bookThis book provides information about the new and changed functionality in DB2 Database for Linux , UNIX , and Windows Version 9.1 and DB2 Connect Version 9.1.Who should use this bookThis book is for database administrators, application programmers, and other DB2database users who want to quickly find out what new enhancements are availablein DB2 Database for Linux, UNIX, and Windows Version 9.1 and DB2 ConnectVersion 9.1, and what differences exist between this version and Version 8.2 ofthose products. This book provides overview information and does not containdetailed instruction for using the features described. To get additional information,you should use the references that are provided.If you are interested in features and enhancements introduced in Version 9.1, youshould read Part 1, “What’s new for Version 9.1,” on page 1.If you are interested in changed, deprecated, or discontinued functionality, youshould read Part 2, “What’s changed from Version 8.2,” on page 103. Thisinformation will point out important changes that you need to know before usingVersion 9.1.How this book is structuredThe following topics are covered:Part 1, What’s new for Version 9.1Chapter 1, “Highlights of Version 9.1”This chapter introduces important new features and enhancements in DB2Version 9.1.Chapter 2, “DB2 Connect enhancements”This chapter describes the several enhancements and changes in DB2Version 9.1 which affect the functionality and capabilities of DB2 Connect.Chapter 3, “Product, packaging, and terminology changes”This chapter describes the product, packaging and terminology changesintroduced in Version 9.1, including component replacements, namechanges, and product-line changes.Chapter 4, “Native XML data store support”The native XML data store enables well-formed XML documents to bestored in their hierarchical form within columns of a table. This chapterintroduces the new XML data type and related native XML data storesupport available in Version 9.1.Chapter 5, “Application development enhancements”This chapter describes the enhancements introduced in Version 9.1 tosimplify database application development.Chapter 6, “Backup, logging, and recovery enhancements”This chapter describes the backup, logging, and recovery enhancements,which will help you ensure the availability of your data. Copyright IBM Corp. 1993, 2006vii
Chapter 7, “Client and connectivity enhancements”This chapter describes enhancements that ensure that you have flexible andeffective methods of accessing data from client systems and applications,such as Internet Protocol Version 6 (IPv6) communication protocol support,support for running ODBC and CLI applications without a DB2 Client, andconnection timeout support.Chapter 8, “Federation enhancements”This chapter describes the federation enhancements introduced in DB2Version 9.1. With federation, you can send distributed requests to multipledata sources using a single SQL statement.Chapter 9, “Installation, migration, and fix pack enhancements”This chapter describes the new features and enhancements, such ascoexistence of multiple DB2 database system versions and fix packs onWindows and support for concurrent copies of DB2 database systems onLinux and UNIX, that allow your IT staff to spend more time supportingbusiness goals and less time installing and configuring database systems.Chapter 10, “Manageability enhancements”This chapter introduces several new features, including default enablementof autonomic computing features, automatic storage support formulti-partition databases, and support for copying schemas betweendatabases. These features and others will allow you to spend less timemanaging your databases and more time managing your business.Chapter 11, “National language enhancements”This chapter describes the enhancements for national languages, includingUnicode support for character-based string functions.Chapter 12, “Performance enhancements”This chapter describes the enhancements that ensure the highestperformance when accessing and updating data, including data rowcompression, enhanced query performance using statistical views, andfaster data loading capabilities.Chapter 13, “Scalability enhancements”This chapter introduces enhancements that provide the scalability you needfor your growing business, such as larger system temporary tables,improved fast communications manager (FCM), and indexes that you candefine on a greater number of columns.Chapter 14, “Security enhancements”This chapter describes security enhancements and other features that helpyou protect and manage your sensitive data.Chapter 15, “Troubleshooting and problem determination enhancements”This chapter describes enhancements that provide increased control overthe set of diagnostic information produced when you encounter problems.Part 2, What’s changed from Version 8.2Chapter 16, “Changes in existing functionality”This chapter outlines the changes to existing DB2 database systemfunctionality, including changes related to installation, migration, and fixpacks; database setup; database administration; and applicationdevelopment.Chapter 17, “Deprecated functionality”This chapter lists the deprecated functionality, which refers to specificviiiWhat’s New
functions or features that are supported but are no longer recommendedand might be removed in a future release.Chapter 18, “Discontinued functionality”This chapter lists functions and features that are no longer supported inDB2 Version 9.1.Additional informationAppendix A, “DB2 Database technical information”This appendix contains information about accessing and using the latestdocumentation for your DB2 database system.Appendix B, “Notices”This appendix contains the legal requirements and limitations for using theDB2 database product and its documentation.About this bookix
xWhat’s New
Part 1. What’s new for Version 9.1Read this part if you are interested in features and enhancements introduced inVersion 9.1.This part covers the following topics:Chapter 1, “Highlights of Version 9.1”This chapter introduces important new features and enhancements in DB2Version 9.1.Chapter 2, “DB2 Connect enhancements”This chapter describes the several enhancements and changes in DB2Version 9.1 which affect the functionality and capabilities of DB2 Connect.Chapter 3, “Product, packaging, and terminology changes”This chapter describes the product, packaging and terminology changesintroduced in Version 9.1, including component replacements, namechanges, and product-line changes.Chapter 4, “Native XML data store support”The native XML data store enables well-formed XML documents to bestored in their hierarchical form within columns of a table. This chapterintroduces the new XML data type and related native XML data storesupport available in Version 9.1.Chapter 5, “Application development enhancements”This chapter describes the enhancements introduced in Version 9.1 tosimplify database application development.Chapter 6, “Backup, logging, and recovery enhancements”This chapter describes the backup, logging, and recovery enhancements,which will help you ensure the availability of your data.Chapter 7, “Client and connectivity enhancements”This chapter describes enhancements that ensure that you have flexible andeffective methods of accessing data from client systems and applications,such as Internet Protocol Version 6 (IPv6) communication protocol support,support for running ODBC and CLI applications without a DB2 Client, andconnection timeout support.Chapter 8, “Federation enhancements”This chapter describes the federation enhancements introduced in DB2Version 9.1. With federation, you can send distributed requests to multipledata sources using a single SQL statement.Chapter 9, “Installation, migration, and fix pack enhancements”This chapter describes the new features and enhancements, such ascoexistence of multiple DB2 database system versions and fix packs onWindows and support for concurrent copies of DB2 database systems onLinux and UNIX, that allow your IT staff to spend more time supportingbusiness goals and less time installing and configuring database systems.Chapter 10, “Manageability enhancements”This chapter introduces several new features, including default enablementof autonomic computing features, automatic storage support formulti-partition databases, and support for copying schemas between Copyright IBM Corp. 1993, 20061
databases. These features and others will allow you to spend less timemanaging your databases and more time managing your business.Chapter 11, “National language enhancements”This chapter describes the enhancements for national languages, includingUnicode support for character-based string functions.Chapter 12, “Performance enhancements”This chapter describes the enhancements that ensure the highestperformance when accessing and updating data, including data rowcompression, enhanced query performance using statistical views, andfaster data loading capabilities.Chapter 13, “Scalability enhancements”This chapter introduces enhancements that provide the scalability you needfor your growing business, such as larger system temporary tables,enhancements to fast communications manager (FCM), and indexes thatyou can define on a greater number of columns.Chapter 14, “Security enhancements”This chapter describes security enhancements and other features that helpyou protect and manage your sensitive data.Chapter 15, “Troubleshooting and problem determination enhancements”This chapter describes enhancements that provide increased control overthe set of diagnostic information produced when you encounter problems.2What’s New
Chapter 1. Highlights of Version 9.1Highlights of Version 9.1 summaryDB2 Version 9.1 for Linux, UNIX, and Windows delivers new features that addressthe needs of your business today, whether those needs are integrating businessdata from across your organization, reducing IT costs, focusing limited IT resourceon creating business value, or providing a secure and resilient informationmanagement system for your company’s valuable information assets. To meet yourbusiness needs, DB2 Version 9.1 introduces important new features andenhancements.Information as a service, using new hybrid relational and XML data server:New features include:v A new XML data type that allows you to store well-formed XML documents intheir hierarchical form within columns of a table.v Support for the XML data type in SQL statements and SQL/XML functions.v Support for the new XQuery language developed by the World Wide WebConsortium (W3C). DB2 Version 9.1 allows you to invoke the XQuery languagedirectly, calling functions that extract XML data from DB2 tables and views.v New tools such as XQuery builder to create queries against XML data.v Support for indexing over XML data, which improves the efficiency of queriesthat you issue against XML documents.v Access and management of XML data by the DB2 data server. Existing DB2 toolssuch as the Control Center, command line processor (CLP), the db2lookcommand, and Visual Explain are enhanced to support XML data.v XML support in SQL and external procedures.v Support for XML in many DB2-supported programming languages, whichenables applications to combine XML and relational data access and storage.For more information, see “Information as a service (native XML data store)” onpage 6.More agile application development, using an enhanced
Tivoli Storage Manager support added (Windows x64).61 Chapter 7. Client and connectivity enhancements.63 Client and connectivity enhancements summary.63 Connection timeout support for database applications added.63 A single client (DB2 Client) is provided for application development and administration.64 DB2 Runtime Client .
