DB2 Information Center home
DB2 documentation and help
Feature of this information center
Navigating and searching
Displaying topics in your preferred language
Accessibility
Invoking contextual help from a DB2 tool
DB2 PDF and printed documentation
Product overviews
Database systems
What's new
Version 8.2 FixPak 4
Version 8.2 FixPak 3
Version 8.2.2
Version 8.2
Highlights of DB2 UDB Version 8.2
Disaster recovery technology enables around-the-clock availability
Autonomic computing technology makes the DBA's job easier
Enhanced integration with Microsoft .NET, J2EE/WebSphere Studio and Web services improves developer productivity
Protecting your valuable information resources
Extend your solutions to include mobile data with DB2 mobility on demand
Find the DB2 documentation you need using the DB2 Information Center
Manageability enhancements
Activity Monitor
Index extensions in partitioned environments
System security enhancements for Windows improve usability
SQL statement size limit increased to 2 MB
Log file inclusion in backup images
Self-tuning backup and restore operations
Health Center enhancements
DB2 UDB is compliant with the FIPS 140-2 (Use of certified Cryptographic Module) government standard
New command for simplified database recovery
Simplified memory configuration and reduced memory errors
Advanced alter table functionality from the GUI
Support for Windows Local System account
Column default values can be altered
Kerberos authentication support for the UNIX platforms
Pattern matching when using the db2look command
DB2 embedded application server enhancements
View historical storage information for all objects in the storage management view
Automatic maintenance available when creating a database
Automating database maintenance
Performance enhancements
Design advisor enhancements for recommending indexes, MQTs, MDC tables, and partitions
Specifying a lock wait mode strategy
Improved query execution plans through better cardinality estimation
Reduction of the time and space required to optimize complex queries
Automating database maintenance
Automatic statistics profiling
Improved RUNSTATS performance through sampling
Throttling of RUNSTATS utility
Large page support in buffer pools on DB2 UDB for Linux
Multipage file allocation on SMS table spaces enabled by default
Automatic setting of prefetch size
XA timeout sample code
Availability enhancements
High availability disaster recovery (HADR)
XML Extender support for HP-UX 32-bit and 64-bit PA-RISC
Automatic client reroute
Utility for demigrating database directories from version 8.2 to version 8.1
Usability enhancements
Command Editor
Control Center enhancements
Utility progress monitoring
Changing generated column properties without having to recreate the table
SQL enhancements
Column default values can be altered (ALTER TABLE)
Changing generated column properties without having to recreate the table (ALTER TABLE)
SQL statement size limit increased to 2 MB
SQL procedures no longer require a C or C++ compiler
Bind option REOPT enables reoptimization of SQL statements
New SQL/XML publishing function: XMLSERIALIZE
Function XMLNAMESPACES new for Version 8.2
Unicode tables in a non-Unicode database (CREATE TABLE)
Specifying a lock wait mode strategy
Improved query execution plans through better cardinality estimation
Procedure invocation in a trigger body in DB2 UDB Enterprise Edition
Serviceability enhancements
New utility to retrieve statistics from a running DB2 instance or database (similar to 'onstat' for Informix)
db2diag.log format message enhancements
Diagnostic log analysis tool for filtering and formatting db2diag.log
Trace facility improved
Application development enhancements
JDK 1.4 supported by DB2 UDB
DB2 Universal JDBC Driver improvements
OLE DB and ODBC .NET data providers
DB2 .NET Data Provider enhancements
.NET common language runtime procedures and UDFs
IBM DB2 Development Add-In for Microsoft Visual Studio .NET enhancements
New SQL/XML publishing function: XMLSERIALIZE
Procedure invocation in a trigger body in DB2 UDB Enterprise Edition
Unicode tables in a non-Unicode database
Nested savepoints allow for greater control of rollbacks
Bind option REOPT enables reoptimization of SQL statements
Simplified association of packages with an application using CURRENT PACKAGE PATH special register
SQL procedures no longer require a C or C++ compiler
Development Center stored procedure and debugging enhancements
Development Center no longer requires C compiler for building SQL stored procedures
Development Center supports SQL stored procedure debugging for UNIX 64-bit platforms
Development Center supports Java stored procedures on iSeries
DB2 WebSphere MQ UDF 64-bit support
Advanced alter table functionality from the GUI
XA timeout sample code
DB2 Run-Time Client Lite
DB2 family enhancements
DB2 Run-Time Client Lite
Find the DB2 documentation you need using the DB2 Information Center
Asynchronous I/O support on Linux (2.6 kernel exploitation)
DB2 Query Patroller 64-bit support for UNIX, Linux, and Windows
Licensing updates
Function XMLNAMESPACES new for Version 8.2
DB2 for Linux 64-bit support on the zSeries platform
DB2 for LinuxPPC 64-bit support
DB2 for Linux 64-bit support on iSeries and pSeries platforms
DB2 Connect Linux zSeries 64-bit support
DB2 Express support on Linux PowerPC 32-bit
DB2 extender enhancements
DB2 Geodetic Extender
Spatial Extender enhancements
XML Extender support for HP-UX 32-bit and 64-bit PA-RISC
National language enhancements
Thai and Unicode collation algorithm differences
New collators for Unicode databases
Security enhancements
Common Criteria certification of DB2 UDG products
System security enhancements for Windows improve usability
Support for Windows Local System account
Prevention of access to DB2 system files on Windows-based platforms
Access token on Windows provides users' group information
Custom security plugins for authentication and group management
Kerberos authentication support for the UNIX platforms
Encryption of user data using two new authentication types
Version 8.1.4
Manageability enhancements
Resource management
Referential integrity
Row migration
Online import
db2Import
Compressed backup
Buffer pool memory allocation
New registry variables
Performance enhancements
Range-clustered tables
Asymmetric index splitting
Temporary tables in SMS
Page cleaning enhancements
Monitoring network time
db2dlm_upd_hostname command
Lock deferral
Direct I/O (AIX)
Application development enhancements
CLI/ODBC KEEPDYNAMIC support
CLI dynamic scrollable cursors
CLI LOAD fullselect support
OLEDBRETURNCHARASWCHAR keyword
SQL data-change operations
Searched statements against fullselects
SQL table functions that modify SQL data
EXECUTE privilege
DB2 family enhancements
Data Links Manager help and messages
XML Extender variable
Version 8.1 FixPak 3
Performance enhancements
Buffer pool monitoring
Usability enhancements
Documentation feedback
Application development enhancements
Microsoft Visual Studio
SQLJ and JDBC
Compiler support
Windows support
SQL procedures
Linux application support
DB2 family enhancements
Support for Linux on AMD 64-bit
Data Links Manager
Version 8.1.2
Product changes
Performance enhancements
Throttle utilities
MERGE statement
Query sampling
Usability enhancements
Customized folders
Multiple views of the documentation
Application development enhancements
IBM Development Add-In
Remote debugging on z/OS servers
DB2 family enhancements
Query Patroller
Version 8.1
Product changes
Component replacements and name changes
Terminology changes
National languages
Supported languages
National language support
Discontinued and deprecated functions
Manageability enhancements
Load enhancements
Storage management
Flush the package cache
Logging enhancements
Backup and recovery enhancements
New administration notification log
Multiple service level installation for UNIX
Version ID for packages
Database maintenance mode: QUIESCE
ON SCHEMA capability added to REORGCHK
RUNSTATS command enhancements
Tools for monitoring the health of your systems
Event monitors can now write to SQL tables
Improved deadlock event monitoring
Snapshot and event monitoring: controlling time stamp collection
Snapshot retrieval through SQL
Tivoli
Type-2 indexes
Automatic configuration, null compression, and index renaming
Performance enhancements
Multidimensional clustering
Prefetching enhancements
Page cleaner I/O improvements
Catalog and authorization caching on databases with multiple partitions
Threading of Java UDFs and stored procedures
Connection concentrator
Materialized query tables
Availability enhancements
Online table load
Online table reorganization
Online index reorganization
Online buffer pool creation, deletion, and resizing
Configurable online configuration parameters
Incremental maintenance of materialized query tables during load append
Incremental maintenance of immediate AST when using load append
DMS container operations
Scalability enhancements
Compression of nulls and defaults
INSERT through UNION ALL views
Logging enhancements for improved scalability
Changes to satellite administration
Usability enhancements
DB2 Administration Server (DAS) enhancements
DB2 Setup wizard enhancements
New wizards and GUI tools
New Configuration Assistant
Control Center 390 enhancements
Structural changes to DB2 HTML documentation
Separately installed documentation
Regularly updated DB2 documentation
Improved documentation search
Support for multilanguage installations on Windows platforms
Serviceability enhancements
INSPECT command for checking database architectural integrity
DB2 trace facility enhancements
Application development enhancements
Development Center
SQL in user-defined functions
SQL Assist enhancements
INSTEAD OF triggers, informational constraints, and new built-in functions
Dynamic dispatch of methods
Windows management instrumentation
New Call Level Interface (CLI) LOAD functionality
Declared global temporary table enhancements
IBM OLE DB Provider for DB2
Web services applications
JDBC driver enhancements
WebSphere Studio and WebSphere Application Server
DB2 XML support enhancements
DB2 family enhancements
Multiplatform tools
DB2 Data Links Manager enhancements
DB2 Spatial Extender enhancements
DB2 XML Extender enhancements
DB2 Net Search Extender
DB2 Universal Database overview
Tutorials
Video Central for e-business tutorial
Visual Explain tutorial
Clients
DB2 Run-Time Client Lite
DB2 Run-Time Client
DB2 Administration Client
DB2 Application Development Client
Supported and non-supported client configurations
SNA support limitations in DB2 UDB Version 8
Servers
DB2 Enterprise Server Edition
DB2 Express
DB2 Personal Edition
DB2 Workgroup Server Edition
DB2 UDB extenders overviews
DB2 Spatial and Geodetic extenders
When to use DB2 Geodetic Extender and when to use DB2 Spatial Extender
Differences in working with flat-Earth and round-Earth representations
DB2 Spatial Extender overview
Scenario: Using Spatial Extender
Spatial and geodetic data
How features, spatial information, spatial data, and geometries fit together
DB2 Geodetic Extender overview
Net Search Extender
XML Extender overview
XML documents
How XML data is handled in DB2 UDB
Features of XML Extender
XML Extender tutorials
Storing an XML document in an XML column
Composing an XML document
Compatibility issues
Version 8.2 FixPak 4
Version 8.2 FixPak 3
Version 8.2.2
Installation information
Version 8.2 FixPak 4
Version 8.2 FixPak 3
Version 8.2.2
Limitations, problems and workarounds
Version 8.2 FixPak 4
Version 8.2 FixPak 3
Version 8.2.2
Version 8.2
Version 8.1.4
Version 8.1.2
Version 8.1 FixPak 1
Version 8.1
Incompatibilities between releases
Client and server compatibility
Planned incompatibilities
Version 8 incompatibilities with previous releases
Version 7 incompatibilities with previous releases
DB2 Query Patroller overview
Scenarios
Managing query submitter needs by configuring submitter profiles
Handling very large queries
Running large emergency queries
Managing queries of different sizes using query classes
Using historical analysis to improve performance
Components
Limitations and restrictions
64-bit support for Linux, UNIX, and Windows
DB2 Data Links Manager overview
What's new in DB2 Data Links Manager Version 8
DB2 Data Links environment
Data Links server components
DB2 clients in the Data Links Manager environment
DB2 servers in the Data Links Manager environment
File system paradigm
DB2 Data Links Manager and your applications
DATALINK data type
Information integration
What's new
Version 8 Fix Pack 10
Replication and event publishing enhancements
Version 8 Fix Pack 9
Replication and event publishing enhancements
Version 8 Fix Pack 8
Replication and event publishing enhancements
Version 8.2 (Version 8 Fix Pack 7)
Highlights of DB2 Information Integrator Version 8.2
Federated systems enhancements
Web services enhancements
Event publishing enhancements
Replication enhancements
Metadata management enhancements
Version 8 Fix Pack 4
Replication enhancements
Object name length
Password file
Data on Oracle sources
Version 8 Fix Pack 2
Replication enhancements
Usability improvements
Performance improvements
New function
Control tables
Version 8.1
Federated systems enhancements
Replication enhancements
Replication Center
New replication control table structures
Capture program enhancements
Multiple Capture programs
Apply program and other enhancements
Replication monitoring
DB2 Data Links Manager replication enhancements
DB2 Information Integrator overview
Information integration overview
Introduction to information integration
Why information integration is important to your enterprise
DB2 Information Integrator
The DB2 product family - a foundation for information integration
Problems that DB2 Information Integrator helps solve
DB2 Information Integrator editions
Components and complementary products
DB2 Universal Database
Relational federated technologies
Nonrelational federated technologies
Event publishing technologies
Replication technologies
DB2 Information Integration Technology Demo
DB2 Information Integrator editions
Federated systems overview
Scenario
Cottonwood Distributors, Inc. - a warehouse example
Business solutions: extending the DB2 Warehouse Manager
Discovering the data - Cottonwood Distributors, Inc.
Designing applications - Cottonwood Distributors, Inc. warehouse scenario
Deploying the application - Cottonwood Distributors, Inc. solution
Tutorials
Simplified portal applications with DB2 Information Integrator
Integrating asynchronous information: Using DB2 Information Integrator and WebSphere MQ
Configuring DB2 Information Integrator to access diverse data
Federated server
Federated database
Supported data sources
Wrappers and wrapper modules
Methods of interacting with a federated system
Web services overview
Tutorials
Invoking Web services from SQL: Integrating relational data with Web services
Invoking IMS applications using information integration technology: Using Web service UDFs
IBM Video Central for e-business
DB2 Universal Database as a Web services provider
Replication and event publishing overview
Introduction to replication and event publishing
Introduction to SQL replication
Introduction to Q replication
Introduction to event publishing
Administrative interface for replication and publishing
Utilities for replication and publishing
SQL replication overview
Infrastructure
Registration of sources
Subscription sets
Capture of data from DB2 UDB sources
Application of data to DB2 UDB targets
Capture of data from non-DB2 UDB sources
Application of data to non-DB2 UDB targets
Q replication overview
Infrastructure
Sources and targets
Capture of data
DB2 UDB targets
Non-DB2 targets
Types of replication
Comparison of SQL replication and Q replication
Comparison of infrastructure
Comparison of sources and targets
Comparison of data capturing and applying
Which replication solutions should you use in common scenarios?
Event publishing overview
Infrastructure
Sources
Capture of data
Comparison of SQL replication, Q replication, and event publishing
Comparison of the replication solutions to high availability disaster recovery (HADR)
Comparison of Q replication to high availability disaster recovery (HADR)
Enterprise search overview
Welcome to DB2 Information Integrator OmniFind Edition
What is enterprise search?
Data source types supported by enterprise search
Enterprise search component overview
Enterprise search crawlers
Enterprise search parsers
Enterprise search indexes
Search servers for enterprise search
Enterprise search administration console
Monitoring an enterprise search system
Enterprise search log files
Customizing enterprise search
Sample search application for enterprise search
The enterprise search data flow
Glossary
Enterprise search documentation
Notices
Trademarks
Metadata management overview
XML Metadata Registry overview
Administrators
Error logging
Group actions
Classification systems
Organizations
Relationships
Users
XML Metadata Registry user interface
Home page
Database
System folder
Registry objects and business objects
Metadata items
Aggregate items
Folders and views
Classification system notebook
Advanced Search notebook
XML Metadata Registry document load tool
Documentation
DB2 Information Integrator documentation
Documentation for complementary products
Problems, workarounds, and documentation updates
Version 8 Fix Pack 10
Version 8 Fix Pack 9
Version 8 Fix Pack 8
Version 8.2 (Version 8 Fix Pack 7)
Version 8 Fix Pack 6
Version 8 Fix Pack 5
Version 8 Fix Pack 4
Version 8 Fix Pack 3
Version 8.1
Business intelligence
DB2 Data Warehouse Edition, Version 9.1
Data warehousing in DB2 UDB, Version 8.2
Tutorials for DB2 UDB, Version 8.2
Information Catalog Center tutorial
Video Central for e-business tutorial
Visual Explain tutorial
What's new
Version 8.2
Business intelligence enhancements
Data Warehouse Center and Warehouse Manager ETL enhancements
Warehouse Manager ETL supports Unicode warehouse control databases
Online import (new in Version 8.1.4)
Improved RUNSTATS performance through sampling
Design advisor enhancements for recommending indexes, MQTs, MDC tables, and partitions
DB2 Data Warehouse Edition enhancements including integrated installation
Version 8.1.2
Red Brick utility programs
Version 8.1
Warehouse server (AIX)
Warehouse agent (Linux)
Clean transformer enhancements
Common warehouse metamodel (CWM) XML support enhancements
Data Warehouse Center column mapping enhancements
Data Warehouse Center cascading processes
Multiple wait support
SQL Select and Update step
Information Catalog Manager enhancements
DB2 OLAP Server and DB2 OLAP Integration Server changes
Data warehousing solutions overview
Data warehousing Balanced Configuration Unit
Introduction to the Balanced Configuration Unit (BCU)
Benefits of the BCU
When to apply the BCU
What does it mean to balance a warehouse configuration?
BCU usage of DB2 UDB configurations
BCU layer definitions
High-availability BCU
Types of BCUs
Balanced partition unit (BPU)
BPU architecture
DB2 Data Warehouse Center tutorials
Introduction to the Data Warehouse Center--a Business Intelligence tutorial
Extended lessons in data warehousing--a Business Intelligence tutorial
DB2 Data Warehouse Manager overview
DB2 Warehouse Manager installation CD
Information Catalog Manager
Warehouse agents
Warehouse transformers
DB2 Information Catalog Center overview
How Data Warehouse Center metadata is displayed in the information catalog
DB2 Data Warehouse Enterprise and Standard Editions overview
Business intelligence data flow scenarios for Data Warehouse Editions
Data flow scenario for DB2 Data Warehouse Enterprise Edition
Products in the DB2 Data Warehouse Edition
DB2 Universal Database
DB2 Cube Views
DB2 Intelligent Miner
DB2 Query Patroller
DB2 Warehouse Manager (ETL component)
DB2 Alphablox
DB2 Office Connect
DB2 Cube Views
DB2 Cube Views, Version 8.1, FixPak 10 (Version 8.2, FixPak 3) enhancements
DB2 Cube Views, Version 8.2 enhancements
Mainframe and midrange server connections
What's new
Version 8.2
Control Center for z/OS and OS/390 enhancements
Version 8.1.4
Control Center for z/OS and OS/390 enhancements
Version 8.1.2
Remote debugging on z/OS servers
Version 8.1
Host and iSeries applications can use two-phase commit with TCP/IP
Scenarios
Direct access to mainframe and midrange servers
Direct access to mainframe and midrange servers with DB2 Connect Personal Edition
DB2 Connect Enterprise Edition as a connectivity server
DB2 Connect and Web applications
DB2 Connect and IBM WebSphere
DB2 Connect and Net.Data
DB2 Connect as a Java application server
DB2 Connect on the Web server
DB2 Connect and application servers
DB2 Connect and transaction processing monitors
DB2 Connect overview
IBM DB2 Information Integrator and DB2 Connect
Functions delivered in Version 8.2 and previous releases
DB2 Connect administration utilities
Tools for administration and application development
Administering
Command Editor
Control Center
Control Center: administering OS/390 and z/OS subsystems
Data Warehouse Center
Federated systems
Information Catalog Center
License Center
Net Search Extender
OLAP Center for DB2 Cube Views
Query Patroller Center
Replication Center
Satellite Administration Center
Spatial Extender
Task Center
Web Command Center
Configuration Assistant
Developing
Development Center
IBM DB2 Development Add-In for Microsoft Visual Studio .NET
SQL Assist
Monitoring
Activity Monitor
Health Center
Journal
Memory Visualizer
Transaction Manager
Web Health Center
Tuning
Visual Explain
Invoking contextual help from DB2 tools
How to use the DB2 Universal Database help
Documentation
DB2 Information Center
Access to the DB2 Information Center
Documentation updates
Command line help
Invoking message help from the command line
Invoking command help from the command line
Invoking SQL state help from the command line
DB2 PDF and printed documentation
Printing DB2 books from PDF files
Ordering printed DB2 books
Notices
Accessibility
Keyboard shortcuts and accelerators
Typing characters using the Alt+Gr key
Dotted decimal syntax diagrams
Migrating
Database systems
DB2 Universal Database Version 8.2
Migrating from previous versions of DB2 Universal Database
DB2 Personal Edition
Linux
Preparing to migrate
Installing DB2 Personal Edition Version 8.2
Migrating databases
Windows
Preparing to migrate
Installing DB2 Personal Edition Version 8.2
Migrating databases
Servers
Migration overview
Migration restrictions
Reverse migration restrictions
Migration recommendations
Space recommendations for DB2 migration
Migration test considerations
Migrating explain tables
Migrating DB2 servers (Linux and UNIX)
Premigration tasks
Backing up databases before DB2 migration
Recording system configuration settings before DB2 migration
Changing the diagnostic error level before DB2 migration
Verifying that databases are ready for migration
Taking DB2 UDB Version 6 or Version 7 servers offline
Migrating instances
Migrating the DB2 Administration Server (DAS)
Migrating databases
Migrating databases to new systems
Migrating DB2 servers in partitioned database environments
Migrating DB2 servers (Windows)
Premigration tasks
Backing up databases before DB2 migration
Recording system configuration settings before DB2 migration
Changing the diagnostic error level before DB2 migration
Verifying that databases are ready for migration
Taking DB2 UDB Version 6 or Version 7 servers offline
Migrating databases
Migrating databases to new systems
Migrating DB2 servers in partitioned database environments
Applications
Migrating Java applications, routines, and applets
Migrating applications from 32-bit to 64-bit environments
Ensuring application portability
Administrative APIs and application migration
Changed APIs and data structures
Extenders
Spatial Extender
Migrating spatially enabled databases
The db2se migrate_v82 command
Geodetic Extender
Migrating from Informix Geodetic DataBlade
XML Extender
Migrating XML Extender from previous versions
Migrating to XML Extender fix packs from prior releases
Migrating from other database management systems
Migrating to 64-bit databases
Linux and UNIX
Migrating to DB2 Version 8 64-bit
Migrating a DB2 Version 7 64-bit instance (AIX Version 4) to DB2 Version 8
Windows
Migrating applications from 32-bit to 64-bit environments
DB2 Data Links Manager
Migrating a DLFF-enabled file system to another hard disk
Migrating a DLFS to another hard disk
AIX
Solaris Operating Environment
Windows
DB2 Query Patroller
Migrating Query Patroller server automatically using the DB2 Setup wizard
Migrating Query Patroller server manually
Information integration
Migrating federated systems
Planning to migrate to version 8
Migration overview
Supported features and functions
Migration recommendations
Space considerations for DB2 Universal Database migration
Migration restrictions
DB2 Version 7 federated system migration restrictions
DataJoiner migration restrictions
Reverse migration restrictions
Before you migrate
Preparing to migrate to DB2 Information Integrator
Backing up databases
Recording system configuration settings
Recording your database information
Recording your instance information
Changing the diagnostic error level
Preparing your DB2 replication environment
Verifying that your databases are ready for migration
Taking a DB2 Universal Database server off line
Replacing KEGG user-defined functions
Migrating Windows servers
Installation sequence for migrating instances and databases
Migrating DB2 Universal Database (Windows)
Migrating databases
Migrating UNIX servers
Installation sequence for migrating instances and databases
Migrating DB2 Universal Database (UNIX)
Migrating instances (UNIX)
Migrating databases
Migrating the DB2 Administration Server
Migrating to DB2 Universal Database Version 8 on UNIX 64-bit systems
Migrating from DataJoiner on UNIX 32-bit to DB2 Universal Database Version 8 on UNIX 64-bit systems
Migrating explain tables
Migrating applications
Accessing data sources after migration
After you migrate to DB2 Information Integrator
Updating federated databases to support importing data into nicknames
Enabling write operations on large object data types
Accessing DB2 family data sources
Accessing Documentum data sources
Accessing Informix data sources
Accessing Microsoft SQL Server data sources
Accessing ODBC data sources
Accessing Oracle data sources
Accessing Sybase data sources
Accessing Teradata data sources
Migration reference
DataJoiner Version 2.1.1 migration
DataJoiner protocol support
DataJoiner terms and their DB2 Information Integrator equivalents
DataJoiner catalog conversion
Default data type mapping changes
DB2 Universal Database data sources
DB2 Universal Database for iSeries data sources - changes to default data type mappings
DB2 Universal Database for Linux, UNIX, and Windows data sources - changes to default data type mappings
DB2 Universal Database for VM and VSE data sources - changes to default data type mappings
DB2 Universal Database for z/OS and OS/390 data sources - changes to default data type mappings
Oracle data sources
Oracle NET8 - changes to default data type mappings
Oracle SQLNET - changes to default data type mappings
Informix data sources - DataJoiner protocol support and changes to default data type mappings
Sybase data sources - DataJoiner protocol support and changes to default data type mappings
Microsoft SQL Server data sources
DataJoiner protocol support in Microsoft SQL Server data sources
Changes to default data type mappings for Microsoft SQL Server data sources
ODBC data sources
DataJoiner protocol support in ODBC data sources
Changes to default data type mappings for ODBC data sources
Teradata data sources - DataJoiner protocol support and changes to default data type mappings
DB2 Universal Database Version 7 migration
DB2 Information Integrator Version 8 migration
Changes to fixed columns for BLAST nicknames
Changes to KEGG user-defined functions
Changes to KEGG function arguments
Changes to the Pathway function names and accepted arguments
Changes to the SSDB function names and accepted arguments
Changes to the columns that are returned from SSDB database queries (table functions)
IMPORT and EXPORT commands for nicknames
Migrating a replication environment
Migrating WebSphere Portal collections to enterprise search
Migration from WebSphere Portal to enterprise search
Migrating a model-based taxonomy from WebSphere Portal
Migrating a collection from WebSphere Portal
Migrated collection settings
Migration wizard log file
Business intelligence
Data warehousing
Migrating metadata from existing information catalogs
Migrating DB2 UDB V7 control databases to V8 when on different systems
Running the Manage Information Catalog wizard
Migrating DB2 Cube Views
Migrating DB2 Cube Views to Version 8.1, FixPak 10
Upgrading your DB2 UDB and DB2 Cube Views software
Migrating your DB2 Cube Views catalog tables and metadata
Migrating DB2 Cube Views from Version 8.1 to Version 8.2
Upgrading your DB2 UDB and DB2 Cube Views software
Migrating your DB2 Cube Views catalog tables and metadata
Mainframe and midrange server connections
DB2 Connect Version 8.2
Installing
Version 8.2 FixPak 4 Installation information
Version 8.2 FixPak 3 Installation information
Version 8.2.2 Installation information
Database systems
DB2 Universal Database for Linux, UNIX, and Windows
DB2 clients
Supported interface languages
Running the DB2 Setup wizard in another language
Displaying the db2setup command in another language
Client-to-server communication scenarios
Disk and memory requirements
Configuring communication protocols for a local DB2 instance
Configuring communication protocols for a remote DB2 instance
UNIX
AIX installation requirements
HP-UX
Installation requirements
Modifying kernel parameters
Recommended kernel configuration parameters
Linux
Installation requirements
Modifying kernel parameters
Solaris
Installation requirements
Modifying kernel parameters
Windows
Installation requirements
Host connection requirements
Thin clients (Windows)
Thin client environments
Thin client considerations
Setting up a thin-client environment
Installing a DB2 Administration Client or DB2 Connect Personal Edition on the code server
Setting up cross-platform support on the code server
Making the code directory available to all thin workstations
Creating a thin client response file
Mapping a network drive from the thin client to the code server
Running the thnsetup command to enable thin clients
DB2 Run-Time Client Lite installation options
DB2 UDB client merge modules
DB2 servers
Supported interface languages
Running the DB2 Setup wizard in another language
Displaying the db2setup command in another language
DB2 UDB Enterprise Server Edition (non-partitioned)
Requirements
Disk and memory requirements
Java SDK levels
Kerberos authentication
AIX
Installation requirements
Mounting the CD-ROM
Starting the DB2 Setup wizard
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation using the CLP
Verifying the installation using First Steps
HP-UX
Installation requirements
Modifying kernel parameters
Mounting the CD-ROM
Starting the DB2 Setup wizard
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation using the CLP
Verifying the installation using First Steps
Linux
Installation requirements
Modifying kernel parameters
Mounting the CD-ROM
Starting the DB2 Setup wizard
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation using the CLP
Verifying the installation using First Steps
Solaris
Installation requirements
Modifying kernel parameters
Mounting the CD-ROM
Starting the DB2 Setup wizard
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation using the CLP
Verifying the installation using Fir