DB2 UDB V8.2 on the Windows environment
IBM DB2 Universal Database Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This IBM Redbooks publication is an update of DB2 UDB Exploitation of the Windows Environment (...
| Autor Corporativo: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[S.l.] :
IBM, International Technical Support Organization
2004.
|
| Edición: | 1st ed |
| Colección: | IBM redbooks.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627145106719 |
Tabla de Contenidos:
- Front cover
- Contents
- Notices
- Trademarks
- Preface
- The team that wrote this redbook
- Acknowledgements
- Become a published author
- Comments welcome
- Chapter 1. Introduction
- 1.1 DB2 UDB overview
- 1.1.1 DB2 technology strategy priorities
- 1.1.2 DB2 family
- 1.1.3 DB2 UDB products for Windows
- 1.2 DB2 UDB V8.2 technology highlights
- 1.2.1 SQL enhancements
- 1.2.2 Security enhancements
- 1.2.3 Business intelligence enhancements
- 1.2.4 Autonomic computing enhancements
- 1.2.5 Usability enhancements
- 1.2.6 High availability enhancements
- 1.3 DB2 UDB V8.2 integration with Windows
- 1.3.1 System security
- 1.3.2 Application development
- Chapter 2. Installation and migration
- 2.1 DB2 UDB V8.2 installation
- 2.1.1 Installation overview for DB2 on Windows
- 2.1.2 DB2 UDB V8.2 server installation
- 2.1.3 DB2 UDB V8.2 client installation
- 2.2 Migration
- 2.2.1 Migrating DB2 between versions of Windows
- 2.2.2 Migrating between versions of DB2 UDB
- 2.2.3 Migrating from 32-bit to 64-bit
- 2.2.4 Migrating everything at once
- Chapter 3. Administration and management
- 3.1 Backup, recovery, and logging
- 3.1.1 Automatic backup
- 3.1.2 Self-tuning backup and restore
- 3.1.3 Backup compression
- 3.1.4 Logs in backup images
- 3.2 Automated log file management
- 3.3 RECOVER command
- 3.4 Automated table maintenance
- 3.4.1 Automatic statistics collection
- 3.4.2 Automatic statistics profiling
- 3.4.3 Automatic reorganization
- 3.5 Integrated Design Advisor
- Chapter 4. Security
- 4.1 Windows Domain handling and user IDs
- 4.1.1 Improved Windows Domain and Active Directory support
- 4.1.2 User ID and group name enhancements
- 4.2 Running DB2 under the local system account
- 4.3 Protecting DB2 UDB system files
- 4.4 Using DB2 with data encryption
- 4.5 The new DB2 security exit.
- 4.5.1 DB2 authentication before Version 8.2
- 4.5.2 The new DB2 authentication model in Version 8.2
- 4.5.3 DB2 security plug-ins
- 4.5.4 Developing security plug-ins
- 4.5.5 Deploying a userid/password plug-in
- 4.5.6 Deploying a group retrieval plug-in
- 4.5.7 Deploying a GSS-API plug-in
- 4.5.8 Error handling
- Chapter 5. Performance and monitoring
- 5.1 SQL query optimization enhancements
- 5.1.1 Native SQL procedures
- 5.1.2 SQL statement size limit increased to 2 MB
- 5.1.3 Data sampling in SQL queries
- 5.1.4 Dynamic SQL re-optimization
- 5.1.5 Specifying a lock wait mode strategy
- 5.1.6 Improved query execution plans
- 5.1.7 Multipage file allocation on SMS table spaces
- 5.1.8 Automatic setting of table space prefetch size
- 5.2 Multidimension clustering tables
- 5.2.1 MDC performance recommendations
- 5.3 Improvement of the RUNSTATS utility
- 5.3.1 Improved RUNSTATS performance through sampling
- 5.3.2 Throttling of the RUNSTATS utility
- 5.4 DB2 performance elements in Windows
- 5.5 DB2 Activity Monitor
- Chapter 6. High availability
- 6.1 High Available Disaster Recovery
- 6.2 Automatic client reroute
- 6.3 Index logging
- Head 0 - Chapter 7. Using DB2 with Java
- Head 1 - 7.1 Java Database Connectivity (JDBC)
- Head 3 - 7.1.1 Types of JDBC driver:
- Head 3 - 7.1.2 Writing a JDBC application
- Head 2 - 7.2 SQL Java (SQLJ)
- Head 3 - 7.2.1 Writing SQLJ applications
- Chapter 8. Using DB2 with .NET framework
- 8.1 An overview of ADO.NET
- 8.2 ADO.NET architecture
- 8.2.1 Connection
- 8.2.2 Command
- 8.2.3 DataReader
- 8.2.4 DataAdapter
- 8.2.5 DataSet
- 8.3 Connecting to the database
- 8.4 Data providers for DB2
- 8.4.1 OLE DB .NET Data Provider
- 8.4.2 ODBC .NET Data Provider
- 8.4.3 DB2 .NET Data Provider
- 8.4.4 Comparison between providers
- 8.5 Performing operations on a DB2 database.
- 8.5.1 Using DataAdapter and DataSet (Disconnected model)
- 8.5.2 Calling stored procedures
- 8.5.3 Controlling transaction
- 8.5.4 Using large objects (LOBs)
- 8.5.5 Binding Data Controls with ADO.NET
- 8.5.6 Accessing DB2 with Web Forms
- 8.6 Add-ins and stored procedures in CLR
- 8.6.1 IBM DB2 Development Add-In overview
- 8.6.2 DB2 Toolbar
- 8.6.3 DB2 Database Project type
- 8.6.4 Data Connections folder in the IBM Explorer
- 8.6.5 DB2 SQL Editor
- 8.7 Developing DB2 stored procedures in .NET
- 8.7.1 Save and build the solution
- Chapter 9. Consuming DB2 Web services in .NET
- 9.1 Web services and DB2
- 9.2 Web Services Object Runtime Framework (WORF)
- 9.2.1 Document access definition extension (DADX)
- 9.2.2 DB2 XML Extender
- 9.2.3 How WORF processes a Web service request
- 9.2.4 Setting up a WORF environment for Windows
- 9.2.5 Creating and deploying DB2 WORF service
- 9.3 Consuming the DADX Web service using .NET client
- Chapter 10. Problem resolution
- 10.1 RAS
- 10.2 PD/PSI
- 10.3 Information to collect
- 10.4 db2support utility
- 10.5 Understanding DB2DIAG.LOG
- 10.6 DB2DIAG tool
- 10.7 Prevention versus resolution
- Related publications
- IBM Redbooks
- Other publications
- Online resources
- How to get IBM Redbooks
- Help from IBM
- Index
- Back cover.
