IBM Books

What's New

Table of Contents

Welcome to DB2 Universal Database and DB2 Connect Version 5.2

  • Who Should Read This Book
  • How This Book Is Structured
  • Conventions

    • Chapter 1. DB2 Universal Database and DB2 Connect Upgrades

  • What's New in Version 5
  • What's New in Version 5.2
  • Year 2000 Ready
  • Books Updated for Version 5.2

    • Chapter 2. Accessibility

  • DB2 Connect Enhancements
  • Using the TCP/IP Communications Protocol
  • Two-Phase Commit
  • Multi-Row Stored Procedures
  • DCE Security
  • DCE Cell Directory Support and Host Systems
  • Enhanced Security Failure Notification
  • Enhanced System/390 SYSPLEX Exploitation
  • Optimized Catalog Access for ODBC and JDBC Applications
  • New BIND Options
  • Microsoft Transaction Server Support
  • Simplified Password Management
  • Client Information Enhancements
  • Bidirectional Language Support
  • Monitoring DB2 Connect Applications
  • Two-Phase Commit Enhancements for Version 5.2
  • Simplified DB2 Syncpoint Manager Configuration
  • Additional Data Objects and Types Supported
  • DB2 Connect for Personal Communications
  • Additional Operating System Support
  • SCO UnixWare 7
  • Windows 98
  • Windows NT
  • Solaris
  • Client Application Enabler
  • Migration
  • Migrating to Version 5
  • Migrating to Version 5.2
  • Security
  • Authentication
  • Communications
  • Named Pipe Support in Windows
  • Named Pipe Support in Windows 98

    • Chapter 3. Extensibility

  • SQL Enhancements
  • Outer Join Support
  • Additional Authorization Support
  • REAL Data Type Support
  • New CREATE SCHEMA and DROP SCHEMA Statements
  • User-Defined Table Functions Supported
  • Unique Constraints Supported
  • CUBE and ROLLUP Aggregations
  • New RENAME TABLE Statement
  • Friendly Arithmetic and Conversion
  • Built-in Functions
  • 500 Table Columns
  • DATALINK Data Type
  • BIGINT Data Type
  • Increasing VARCHAR Column Length
  • Free Space on Pages
  • Replication of Long Fields
  • Multiple Page Size Support
  • CURRENT SCHEMA
  • Typed Tables and Views
  • Command and API Enhancements
  • LOAD and IMPORT
  • Table Space Recovery to a Point in Time
  • Restore Subset of Table Spaces from Backup
  • Query Table Spaces
  • FORCE
  • Audit Function
  • Client Information
  • History File Information
  • IMPORT and EXPORT
  • LOAD and RESTORE
  • RECONCILE
  • RUNSTATS
  • Log Sequence Number
  • Application Development Enhancements
  • Open Database Connectivity 3.0 Support
  • Additional Support in the DB2 Precompiler and APIs
  • User-Defined Functions
  • Precompile and Bind Enhancements
  • Support for Java Programming
  • Microsoft Transaction Server
  • Extended Support for Java Applets
  • Support for JDBC and SQLJ
  • Perl Interface
  • Configuration Parameters
  • Number of Commits to Group (mincommit)
  • Default Database System Monitor Switches (dft_monswitches)
  • National Language Support
  • Bidirectional CCSID Support
  • Euro Support
  • DB2 Extenders
  • Partitioned Databases
  • Commands
  • Migration
  • Net.Data
  • Legato

    • Chapter 4. Performance

  • Query
  • Index ANDing
  • Star Joins
  • Table-Level Locks
  • Limit Fetch Size
  • Retrieval Using Index-Only Access
  • Correlated Predicates
  • Summary Tables
  • Replicated Tables
  • Hash Joins
  • Cache
  • Global SQL Cache
  • Package Lock Avoidance
  • Recovery
  • Faster Restart
  • Buffer Pools
  • Multiple Buffer Pools
  • Extended Storage
  • Page Size
  • Fast Communications Manager Buffers
  • Commands
  • LOAD
  • Applications
  • DB2 Governor
  • Client/Server
  • Deferred Prepare
  • Log File Storage
  • Indexes
  • Clustering Indexes
  • Index-Only Access
  • Tables
  • APPEND Parameter for ALTER TABLE
  • Communications
  • Virtual Interface Architecture Support
  • Multiple Logical Nodes

    • Chapter 5. Scalability

  • Partitioned Databases
  • Single Partition on a Single Processor
  • Single Partition with Multiple Processors
  • Multiple Partitions Each with Its Own Processor
  • Multiple Partitions with Multiple Processors
  • Windows NT and Solaris
  • Migrating from DB2 Parallel Edition
  • Symmetric Multi-Processor (SMP) Enhancements
  • Intra-Partition Parallelism
  • LOAD Utility
  • BACKUP and RESTORE Utilities
  • Index Generation
  • Degree of Parallelism
  • Autoloader Utility

    • Chapter 6. Usability

  • Graphical User Interface (GUI)
  • Control Center
  • SmartGuides
  • Visual Explain
  • Command Center
  • Web Control Center
  • NetQuestion Search Service and the Web Control Center
  • Connectivity and Protocol Configuration and Auto-Discovery
  • Server Communications Configuration
  • Client Configuration Assistant
  • Client Configuration Assistant Enhancements for Version 5.2
  • Instance Profile Manager
  • Licensing

    • Chapter 7. Serviceability

  • Version 5
  • DB2 Database Repair Tool
  • Messages
  • Version 5.2
  • Service Level Tool

    • Appendix A. System Monitor Guide and Reference Updates

  • System Monitoring for DB2 Connect
  • Changed Commands
  • Existing Data Elements
  • New Data Elements
  • Transaction Processor Monitoring
  • New System Monitor Data Elements
  • Hash Join
  • Page Reorganization
  • Lock Escalations
  • Application Identification
  • System Monitor Switches
  • Changes to Number of Log Pages Written
  • Changes to Query Number of Rows Estimate
  • Changes to Query Cost Estimate

    • Appendix B. Call Level Interface Guide and Reference Updates

  • Data Types
  • BIGINT
  • DATALINK
  • Defined Types
  • Configuration Keywords
  • CLISCHEMA
  • CURRENTREFRESHAGE
  • CURRENTSCHEMA
  • IGNOREWARNLIST
  • OPTIMIZESQLCOLUMNS
  • PATCH1 and PATCH2 Values
  • Functions
  • SQLBuildDataLink - Build DATALINK Value
  • SQLGetDataLinkAttr - Get Datalink Attribute Value
  • SQLDriverConnect() and NEWPWD Support
  • SQLBrowseConnect() and NEWPWD Support
  • SQLGetInfo()
  • SQLGetLength()
  • SQLSetConnectAttr() - Additional Connection Attributes
  • SQLSetStmtAttr()
  • Messages
  • SQLSTATE 22003 - Numeric value out of range
  • Microsoft Transaction Server

    • Appendix C. Embedded SQL Programming Guide Updates

  • Running CLI/ODBC/JDBC/SQLJ Programs in a DBCS Environment
  • Host Structure Support in C/C++
  • Indicator Tables
  • SQL Enhancements
  • BIGINT Data Type
  • Fetch-first-clause
  • Altering Tables
  • Recognizing Equivalence of Repeated Host Variables
  • Programming in JDBC
  • Getting Started
  • How Does It Work?
  • Creating and Running JDBC Applets and Applications
  • Creating Java UDFs and Stored Procedures
  • Embedded SQL for Java (SQLJ) Programming
  • SQLJ and DB2 SQLJ Support
  • Basic SQLJ Concepts
  • Advanced Features
  • Comparison with ANSI/ISO Embedded
  • SQLJ Translator Reference
  • Sample Programs and Extra Examples

    • Appendix D. Building Applications for Windows and OS/2 Environments Updates

  • Changes to the Preface: About This Book
  • Changes to Chapter 1. About the DB2 Software Developer's Kit
  • Sample Programs
  • Changes to Chapter 2. Setup
  • Changes to Chapter 3. Introduction to Embedded SQL Applications
  • Changes to Chapter 7. Building DB2 Call Level Interface (CLI) Applications
  • Changes to Chapter 8. Building Java Applications and Applets
  • Setting the Environment
  • Java Sample Programs
  • The Java Makefile
  • JDBC Programs
  • SQLJ Programs
  • General Points for DB2 Java Applets
  • Changes to Appendix. Migrating Your Applications

    • Appendix E. Web Control Center and NetQuestion

  • Web Control Center Installation and Configuration
  • Components to Install
  • Machine Configuration
  • Web Control Center Installation
  • Functional Considerations
  • Installation Tips for Web Control Center Help on UNIX Operating Systems
  • Differences From DB2 V5.0.0 Control Center
  • Troubleshooting
  • Enabling the Web Control Center Remote Documentation Searches

    • Appendix F. How the DB2 Library Is Structured

  • SmartGuides
  • Online Help
  • DB2 Books
  • Viewing Online Books
  • Searching Online Books
  • Printing the PostScript Books
  • Ordering the Printed DB2 Books
  • Information Center

    • Appendix G. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]