DB2 UDB for z/OS Version 8 : Technical Preview.

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.

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.

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.

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.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.