DB2 UDB for z/OS Version 8 : (Record no. 76467)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 08635nam a22004813i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC3306706 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240729124920.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2003 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780738427461 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9780738427461 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC3306706 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL3306706 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (CaPaEBR)ebr10112795 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)191662371 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D3 -- D15662 2003eb |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.75/85 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Redbooks, IBM. |
| 245 10 - TITLE STATEMENT | |
| Title | DB2 UDB for z/OS Version 8 : |
| Remainder of title | Technical Preview. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 1st ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Durham : |
| Name of producer, publisher, distributor, manufacturer | I B M, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2003. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2003. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (306 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 The evolution of DB2 UDB for z/OS -- 1.2 Summary of features -- 1.2.1 New DB2 function: msys for set-up DB2 Customization Center -- 1.2.2 No-extra-charge features -- 1.2.3 Charge features -- 1.3 This redbook -- Chapter 2. DB2 UDB for z/OS V8 at a glance -- 2.1 Scalability -- 2.2 Availability -- 2.3 SQL -- 2.4 e-business -- 2.5 Utilities -- 2.6 Performance -- 2.7 Data sharing -- 2.8 Installation and migration -- Chapter 3. Scalability -- 3.1 The 64-bit architecture support -- 3.1.1 The z/OS architecture -- 3.1.2 DB2's virtual storage expansion -- 3.1.3 Moving above the 2 GB bar -- 3.1.4 General performance expectations -- 3.1.5 Storage monitoring and tuning -- 3.1.6 DB2 V8 requires z/Architecture and z/OS V1R3 -- 3.2 More partitions -- 3.3 More tables in join -- 3.4 More log data sets -- Chapter 4. Availability -- 4.1 DB2 V8 partition and index related terminology -- 4.1.1 Table-controlled partitioning -- 4.1.2 Index-controlled partitioning terminology -- 4.1.3 Table-controlled partitioning terminology -- 4.2 Data partitioned secondary indexes -- 4.2.1 Creating a data partitioned secondary index -- 4.2.2 The need for DPSIs -- 4.2.3 DPSI considerations -- 4.3 Online schema changes -- 4.3.1 Online schema changes overview -- 4.3.2 Table data type changes -- 4.3.3 Index changes -- 4.3.4 Versioning -- 4.3.5 Usage considerations -- 4.3.6 New DBET states for online schema changes -- 4.3.7 Impact of online schema changes on user tasks -- 4.3.8 Dynamic partitions -- 4.4 System level point-in-time recovery -- 4.4.1 Backing up the system -- 4.4.2 Restoring the system -- 4.5 Online ZPARMs -- 4.6 Other availability enhancements. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 4.6.1 Control intervals larger than 4 KB -- 4.6.2 Monitor system checkpoints and log offload activity -- 4.6.3 Log monitor long running UR backout -- 4.6.4 Improved LPL recovery -- Chapter 5. SQL -- 5.1 Long names -- 5.2 SQL statements 2 MB long -- 5.3 Dynamic scrollable cursors -- 5.3.1 Cursor positioning and serialization -- 5.3.2 Considerations -- 5.4 Common table expressions and recursive SQL -- 5.4.1 Example of fullselect -- 5.4.2 Example with CREATE VIEW and INSERT -- 5.4.3 Recursive SQL -- 5.5 Multi-row fetch and insert -- 5.5.1 DECLARE CURSOR -- 5.5.2 FETCH -- 5.5.3 INSERT -- 5.6 Get diagnostics -- 5.7 Scalar fullselect -- 5.7.1 Functional description -- 5.7.2 Restrictions -- 5.8 Select from insert -- 5.8.1 Functional description -- 5.9 Qualified column names in INSERT and UPDATE -- 5.10 Expressions in GROUP BY -- 5.11 Multiple DISTINCT -- 5.12 Sequences -- 5.12.1 Usage considerations -- 5.12.2 Using sequences in applications -- 5.13 Identity columns enhancements -- 5.13.1 SQL statements for identity column enhancements -- 5.14 Sequences and identity columns comparison -- 5.15 Multilevel security -- 5.16 MQSeries UDFs -- 5.17 ASCII flag for compile -- Chapter 6. e-business -- 6.1 IBM DB2 Universal Driver for SQLJ and JDBC features -- 6.1.1 IBM JDBC Type 4 driver -- 6.1.2 New IBM JDBC Type 2 driver -- 6.1.3 Java API enhancements -- 6.1.4 SQLJ -- 6.1.5 Nested stored procedure result sets for JDBC and ODBC applications -- 6.1.6 Extended DESCRIBE -- 6.1.7 SQLcancel -- 6.1.8 LOB streaming -- 6.2 Unicode support -- 6.2.1 Unicode parser -- 6.2.2 Program preparation with new Unicode precompiler -- 6.2.3 Utility Unicode parser -- 6.2.4 Multiple CCSIDs per SQL statement -- 6.2.5 ODBC Unicode support -- 6.2.6 Unicode and distributed support -- 6.3 ODBC enhancements -- 6.3.1 ODBC SQLConnect user and password support -- 6.3.2 ODBC Unicode support. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 6.3.3 Cursor extensions -- 6.3.4 SQLCancel support -- 6.4 XML publishing functions -- 6.5 CURRENT PACKAGE PATH special register -- 6.6 DDF communication database enhancements -- 6.6.1 Requester database ALIAS -- 6.6.2 Server location alias -- 6.6.3 Member routing in a TCP/IP network -- 6.7 Enhancements for stored procedures and UDFs -- 6.7.1 Maximum failures -- 6.7.2 Exploit WLM server task thread management -- 6.7.3 Enhancements to SQL stored procedure language -- 6.7.4 COMPJAVA stored procedures no longer supported -- 6.7.5 DB2 established stored procedures -- 6.8 Miscellaneous enhancements -- 6.8.1 RRSAF compatibility for CAF applications -- 6.8.2 Roll up accounting data for DDF and RRSAF threads -- 6.8.3 Improved query and result set processing -- 6.8.4 Time out for SNA allocate conversation requests -- 6.8.5 Data stream encryption -- 6.8.6 DISPLAY LOCATION command -- Chapter 7. Utilities -- 7.1 Online schema changes support -- 7.1.1 More flexibility with partitions -- 7.1.2 Utility support for schema evolution -- 7.1.3 Point-in-time recovery restrictions -- 7.2 Delimited LOAD and UNLOAD -- 7.3 Unicode -- 7.4 Distribution statistics -- 7.4.1 Collecting cardinality and distribution statistics -- 7.4.2 Collecting column correlation statistics -- 7.4.3 Use of work data sets -- 7.4.4 Examples -- 7.5 Backing up and restoring the system -- 7.6 Other changes -- 7.6.1 New default RESTART -- 7.6.2 New defaults SORTDATA and SORTKEYS -- 7.6.3 COPY and RECOVER tape parallelism -- Chapter 8. Performance -- 8.1 Comparing unlike data types -- 8.2 Materialized query tables -- 8.2.1 Creating an MQT -- 8.2.2 Populating and maintaining an MQT -- 8.2.3 Automatic query rewrite using Materialized Query Tables -- 8.2.4 Determining if query rewrite occurred -- 8.3 Multi-row INSERT and FETCH -- 8.4 Cost based parallel sort. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 8.5 Data caching and sparse index usage for star join -- 8.6 Long and variable length keys -- 8.7 Support for backward index scan -- 8.8 Trigger enhancements -- 8.9 Reduced lock contention on volatile tables -- 8.10 Table UDF cardinality option and block fetch -- 8.10.1 Table UDF cardinality clause -- 8.10.2 Table UDF block fetch -- Chapter 9. Data sharing -- 9.1 CF lock propagation reduction -- 9.2 Reduction of overhead costs for data sharing workloads -- 9.3 Batched updates for index page splits -- 9.4 Improved LPL recovery -- 9.5 Resolution of indoubt units of recovery in restart light -- 9.6 Change to IMMEDWRITE BIND option default -- 9.7 Change to -DISPLAY GROUPBUFFERPOOL output -- Chapter 10. Installation and migration -- 10.1 Currency of versions and migration paths -- 10.2 Major changes to installation and migration -- 10.2.1 Before migrating -- 10.3 Installation -- 10.3.1 Major changes to install jobs -- 10.4 Migration -- 10.4.1 Compatibility Mode -- 10.4.2 Enabling New Function Mode -- 10.4.3 ENMF jobs -- 10.4.4 New Function Mode -- 10.5 Catalog changes -- 10.6 msys for Setup DB2 Customization Center -- 10.7 Samples -- Appendix A. Unicode definitions -- A.1 Basic conversions -- A.2 Additional conversions -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Abbreviations and acronyms -- Index -- Back cover. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | IBM Database 2. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | z/OS. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Database management. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Redbooks, IBM |
| Title | DB2 UDB for z/OS Version 8 |
| Place, publisher, and date of publication | Durham : I B M,c2003 |
| International Standard Book Number | 9780738427461 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306706">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=3306706</a> |
| Public note | Click to View |
No items available.