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 First Steps
Windows
Installation requirements
User account requirements
Adding user IDs to the DB2ADMNS and DB2USERS user groups
LDAP: Extending directory schema
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
DB2 UDB Enterprise Server Edition (partitioned)
Requirements
Disk and memory requirements
Java SDK levels
Kerberos authentication
DB2 node configuration file (db2nodes.cfg)
DB2 users and groups (UNIX)
Fast communications manager (UNIX)
AIX
Installation requirements
Verifying port range availability on participating servers
Updating AIX environment settings
Verifying that NFS is running
Creating a DB2 home file system
Creating required users
Copying the contents of the DB2 product CD-ROM to your computer
Installing a database partition server on the primary computer using the DB2 Setup wizard
Installing database partition servers on participating computers using a response file
Updating the node configuration file
Enabling communication between database partition servers
Enabling the execution of remote commands
Enabling Control Center administration
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation
Changing the DB2 interface language
Setting up a working collective to distribute commands to workstations
HP-UX
Installation requirements
Verifying port range availability on participating servers
Modifying kernel parameters
Verifying that NFS is running
Creating a DB2 home file system
Creating required users
Copying the contents of the DB2 product CD-ROM to your computer
Installing a database partition server on the primary computer using the DB2 Setup wizard
Installing database partition servers on participating computers using a response file
Updating the node configuration file
Enabling communication between database partition servers
Enabling the execution of remote commands
Enabling Control Center administration
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation
Changing the DB2 interface language
Linux
Installation requirements
Verifying port range availability on participating servers
Modifying kernel parameters
Verifying that NFS is running
Creating a DB2 home file system
Creating required users
Preparing to install DB2 for Linux on S/390
Copying the contents of the DB2 product CD-ROM to your computer
Installing a database partition server on the primary computer using the DB2 Setup wizard
Installing database partition servers on participating computers using a response file
Updating the node configuration file
Enabling communication between database partition servers
Enabling the execution of remote commands
Enabling Control Center administration
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation
Changing the DB2 interface language
Solaris
Installation requirements
Verifying port range availability on participating servers
Verifying that NFS is running
Creating a DB2 home file system
Creating required users
Copying the contents of the DB2 product CD-ROM to your computer
Installing a database partition server on the primary computer using the DB2 Setup wizard
Installing database partition servers on participating computers using a response file
Updating the node configuration file
Enabling communication between database partition servers
Enabling the execution of remote commands
Enabling Control Center administration
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation
Changing the DB2 interface language
Windows
Installation requirements
Verifying port range availability on participating servers
User account requirements
Adding user IDs to the DB2ADMNS and DB2USERS user groups
Preparing the environment
Extending the directory schema
Installing the instance owning database partition server
Verifying port range availability on participating computers
Fast communications manager
Installing database partition servers on participating computers
Setting up notification and contact lists
Applying the latest FixPak
Verifying access to the registry on the instance owning machine
Verifying the installation
Changing the DB2 interface language
DB2 UDB Personal Edition
Linux
Installation requirements
Mounting CD-ROMs
Starting the DB2 Setup wizard
Setting up notification and contact lists
Applying the latest FixPak
Verifying the installation
Creating required groups and users
Modifying desktop icons
Windows
Installation requirements
Starting the DB2 Setup wizard
DB2 UDB Workgroup Server Edition
Disk and memory requirements
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 First Steps
Windows
Installation requirements
User account requirements
Granting user rights
DB2 UDB system administrator group
LDAP: Extending directory schema
Virtual Interface Architecture
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
DB2 extenders
Setting up and installing DB2 Spatial Extender
System requirements for installing DB2 Spatial Extender
Installing DB2 Spatial Extender (Windows)
Installing DB2 Spatial Extender (AIX)
Installing DB2 Spatial Extender (HP-UX)
Installing DB2 Spatial Extender (Solaris)
Installing DB2 Spatial Extender (Linux)
Creating the DB2 Spatial Extender instance environment
Verifying the DB2 Spatial Extender installation
Post-installation considerations and troubleshooting
Downloading ArcExplorer for DB2
Accessing geocoder reference data
CDs for DB2 Spatial Extender data and maps
DB2 Web tools
Deploying on the application server for DB2
Installing the application server for DB2
Deploying on WebSphere application servers
Deploying on WebLogic application servers
Deploying on other application servers
DB2 Query Patroller
Installation environment overview
Installing Query Patroller (Linux and UNIX)
Server requirements
Installation requirements
Memory requirements
Disk requirements
Client tools requirements
Installation requirements
Memory requirements
Disk requirements
Installing with the DB2 Setup wizard
Query Patroller server
Verifying the installation of Query Patroller server
Query Patroller client tools
Installing Query Patroller manually
Installing a DB2 product manually
Installing a DB2 product using the db2_install script
Installing a DB2 product on AIX using SMIT
Installing a DB2 product on Solaris Operating Environments using pkgadd
Installing a DB2 product on Linux using rpm
Installing a DB2 product on HP-UX using swinstall
Installing Query Patroller (Windows)
Server requirements
Installation requirements
Memory requirements
Disk requirements
Client tools requirements
Installation requirements
Memory requirements
Disk requirements
Installing Query Patroller with the DB2 Setup wizard
Installing Query Patroller server
Installing the Query Patroller client tools
Configuring the client and server connection
Configuring a client to Query Patroller server connection using the CLP
Cataloging the TCP/IP node on the DB2 client
Cataloging a database using the CLP
Testing the client to server connection using the CLP
DB2 Data Links Manager
Minimum hardware and software requirements
AIX
Before you install DB2 Data Links Manager
Converting an existing DLFM database to the DB2 Version 8.1 format
Installation considerations in JFS environments
Tivoli Space Manager Hierarchical Storage Manager
Installing DB2 Data Links Manager manually using the db2_install command
Installing DB2 Data Links Manager using the DB2 Setup wizard
Actions performed by the DB2 Setup wizard
Verifying that the DLFM_DB was successfully created and catalogued
Manual post-installation tasks
Workarounds in NFS environments
Creating a keytab file
Verifying the installation
Installation verification tasks
Creating a test environment on the DB2 server
Creating a test environment
Preparing your file system
Registering the file system with the Data Links Filesystem Filter
Registering the DB2 database with the Data Links File Manager
Authorizing a DB2 user ID to link a file
Creating a sample file for DB2 Data Links Manager
Registering the Data Links Server with the DB2 database
Verifying the sample file is controlled by Data Links Filesystem Filter
Verifying the sample file is accessible
Viewing the sample file
Applying a FixPak for Data Links Manager
Solaris Operating Environment
Before you install
Installing with the DB2 Setup wizard
Installing manually with the db2_install command
Actions performed by the DB2 Setup wizard
Verifying the DLFM_DB was successfully created and catalogued
Verifying the installation
Installation verification tasks
Creating a test environment on the DB2 server
Creating a test environment
Preparing your file system
Registering the file system with the Data Links Filesystem Filter
Registering the DB2 database
Authorizing a DB2 user ID to link a file
Creating the sample file
Registering the Data Links server
Verifying the sample file is controlled by Data Links Filesystem Filter
Verifying the sample file is accessible
Viewing the sample file
Applying a FixPak for Data Links Manager
Windows
Before you install
Installing DB2 Data Links Manager
Actions performed by the DB2 Setup wizard
Verifying the DLFM_DB was successfully created and catalogued
Verifying the DB2 Data Links Manager installation
Installation verification tasks
Creating a test environment on the DB2 server
Creating a test environment on the DB2 Data Links server
Registering the drive with the Data Links Filesystem Filter
Registering the DB2 database with the Data Links File Manager
Authorizing a DB2 user account to link a file
Creating a sample file
Registering the Data Links server with the DB2 database
Verifying the sample file is controlled by Data Links Filesystem Filter
Verifying the sample file is accessible
Viewing the sample file
Applying a FixPak for DB2 Data Links Manager
Creating a response file installation
Response file considerations
Creating a response file using the DB2 Setup wizard
UNIX
Creating a response file using the sample response file
Installing DB2 using a response file
Response file installation error codes
Windows
Making the DB2 files available for a response file installation
Setting up shared access to a directory
Creating and editing a response file
Installing a DB2 product using a response file
Microsoft Systems Management Server (SMS)
Importing the DB2 install file
Creating the SMS package on the SMS server
Distributing the DB2 installation package across your network
Distributing DB2 Version 8 using SMS
Configuring remote access to a server database
Configuring db2cli.ini for a response file installation
Response file generator
db2rspgn - Response file generator command
DB2 Control Server response file keywords
Response file installation error codes
Installing with batch files
Available sample response files
Response file keywords
Exporting and importing a profile
Stopping DB2 processes during an interactive installation (Windows)
Stopping DB2 processes during a response file installation
Managing licenses
Managing licenses with the License Center
Viewing licensing information
Viewing processor status information
Viewing concurrent users policy information
Viewing user statistics
Viewing user details
Changing licenses and policies
Changing the enforcement policy
Changing the license type policy
Changing the number of concurrent users
Changing the number of licensed processors
Adding licenses
Adding a database partitioning feature (DPF) license
Adding a DB2 Geodetic Extender license
Adding a registered user
Removing licenses
Removing a registered user
Manually installing DB2 products
AIX
HP-UX
Linux
Solaris
Installing with the db2_install script (Linux and UNIX)
Setting up DB2 servers after manual installation
Creating group and user IDs for a DB2 UDB installation (UNIX)
Creating a DB2 Administration Server
Creating an instance using db2icrt
Creating links for DB2 files
Uninstalling
DB2 Universal Database (Linux and UNIX)
Removing DB2 FixPaks
Removing DB2 UDB instances
Removing DB2 UDB products using the db2_deinstall command
Removing the DB2 administration server
DB2 Universal Database (Windows)
DB2 Data Links Manager
Application server for DB2
Information integration
Planning to install DB2 Information Integrator Version 8 on Windows and UNIX
Installation scenarios
Migration
Clean installation
DB2 Universal Database, Version 8.1.2 through 8.1.6
DB2 Universal Database, Version 8.2 is installed
DB2 Universal Database Version 8.2 Fix Pack 8 or later is installed
An unsupported edition or version of DB2 Universal Database is installed
Installation overview
Installation documentation
Hardware and software requirements for DB2 Information Integrator
Supported operating systems for DB2 Information Integrator (32-bit)
Supported operating systems for DB2 Information Integrator (64-bit)
Supported data sources
Supported Web browsers for the XML Metadata Registry
Prerequisites for installing DB2 Information Integrator Relational Wrappers
Environment variables for DB2 Information Integrator
Installation worksheet
Installing DB2 Information Integrator on Windows and UNIX
Installation worksheet
DB2 Information Integrator wrappers
Relational wrappers
Nonrelational wrappers
Installing the wrapper development kit
DB2 Information Integrator user-defined functions
Life sciences user-defined functions
KEGG user-defined functions
Editing the Oracle genclntsh script before setting up the server to access Oracle data sources
Installing DB2 Information Integrator on UNIX and Windows
Installing DB2 Information Integrator (Windows)
Installing DB2 Information Integrator (UNIX)
Adding wrappers and user-defined functions after you install DB2 Information Integrator
Confirming and registering the Microsoft SQL Server Client Version 2000 driver (Windows)
Installing the DataDirect Technologies Connect ODBC 3.7 driver (UNIX)
Editing the Oracle genclntsh script and creating the libclntsh.so file after you install DB2 Information Integrator (UNIX)
Editing the Oracle 10g genclntsh script and creating the libclntsh file after you install DB2 Information Integrator (HP-UX and Linux)
Installing the wrapper development kit for C++ and Java
On Windows with DB2 Universal Database
On UNIX with DB2 Universal Database
Installing the DB2 XML Metadata Registry - overview
Installing the application server for DB2
Installing the XML Metadata Registry
deployXMR command syntax
Installing Web services components
Installing the Web services provider
Web services provider software requirements
For UNIX and Windows
For OS/390 and z/OS
Installing Web services on WebSphere Application Server for UNIX, Windows, z/OS, and OS/390
Installing the Web services software requirements
DTD definitions for the XML Extender
Installing and deploying the WORF examples
On WebSphere Application Server Version 5.1 for z/OS or OS/390
On WebSphere Application Server Version 4.0.4 for z/OS or OS/390
Installing on Apache Jakarta Tomcat on UNIX and Windows
Installing the Web services software requirements
Installing WORF
Installing and deploying the WORF examples
Installing the Web services software requirements
Installing the Web services consumer
Web services consumer functions
Web services consumer user-defined functions
Installing the Web services consumer user-defined functions
Installing DB2 Information Integrator Fix Packs
Changing to a different edition of DB2 Information Integrator
Installing the DB2 Information Center
On UNIX
On Windows
Removing DB2 Information Integrator from your system
Removing the product license keys for DB2 Information Integrator and DB2 Universal Database
Removing wrappers and user-defined functions
On Windows
On UNIX
Removing the wrapper development kit
On Windows
On UNIX
Removing the XML Metadata Registry - overview
Removing the XML Metadata Registry from your computer
undeployXMR command syntax
Enterprise search
Required software and supported data sources
Hardware and disk space requirements for DB2 II OmniFind Edition
DB2 II OmniFind Edition fix pack installation
Installation and data directories
Enterprise search administrator user ID and password
Installing DB2 II OmniFind Edition, Version 8.2.2 on AIX 5.3
Installing DB2 II OmniFind Edition, Version 8.2.2 on SuSE Linux 9
Starting First Steps
Starting DB2 II OmniFind Edition on Linux and AIX
Starting DB2 II OmniFind Edition on Windows
Starting the information center
Enterprise search documentation
Uninstalling DB2 II OmniFind Edition on Linux and AIX
Uninstalling DB2 II OmniFind Edition on Windows
Installation information form
Business intelligence
DB2 Warehouse Manager installation CD
Information Catalog Manager tools
Preparing to install the Information Catalog Manager components
Installing the Information Catalog Manager components
Installing the Information Catalog Center
Installing the Information Catalog Center for the Web (AIX)
Installing the Information Catalog Center for the Web (Windows)
Initializing a warehouse database
Changing the active warehouse control database
Initializing a warehouse control database during installation
Migrating DB2 UDB V7 control databases to V8 when on different systems
Warehouse agents
Preparing to install warehouse agents
Database clients on warehouse agent sites and warehouse servers
Installing a Windows warehouse agent
Installing and configuring the z/OS warehouse agent
Overview of the z/OS warehouse agent
Installing the z/OS warehouse agent
Starting the z/OS warehouse agent daemon
DB2 Warehouse Manager user-defined programs
Removing a z/OS warehouse agent
Installing and configuring the iSeries warehouse agent
Removing iSeries warehouse agents
Non-U.S. English installations of the iSeries warehouse agent
Post-installation considerations for iSeries warehouse agents
iSeries warehouse agent security
Troubleshooting for iSeries warehouse agents
Testing for bidirectional communication between the iSeries warehouse agent and the warehouse server
Determining the source of connectivity errors for the iSeries warehouse agent
Reading iSeries warehouse agent trace files
iSeries agent trace files
Working with flat files on the iSeries system
Using the warehouse FTP utility with the iSeries warehouse agent
Installing and configuring the AIX, Linux, and Solaris Operating Environment warehouse agents
Configuring the AIX, Linux, and Solaris Operating Environment warehouse agent environments
Sample IWH.environment file for AIX, Linux, and the Solaris Operating Environment
Cataloging the DB2 nodes and databases after installing the AIX, Linux, or Solaris Operating Environment warehouse agent
Database connections for the AIX, Linux, and Solaris Operating Environment warehouse agents
Using the Data Warehouse Center external trigger
Removing an AIX warehouse agent
Removing a Solaris Operating Environment warehouse agent
Warehouse transformers
Preparing your environment for warehouse transformers
Install the Java Development Kit for warehouse transformers
Updating environment variables for warehouse transformers
AIX
Linux
Solaris Operating Environment
Windows
Updating the database manager configuration before installing warehouse transformers
Updating the database configuration for the target database
Installing and enabling warehouse transformers
Installing warehouse transformers
Enabling warehouse transformers
z/OS transformers
Setting up Java stored procedures on your DB2 subsystem for the warehouse transformers
Setting up warehouse transformers on DB2 for z/OS
Reducing the number of characters in the environment variable data set for the z/OS warehouse transformers
National language support for warehouse transformers
DB2 Data Warehouse Enterprise and Standard Editions
Quick start
DWE hardware and software requirements
Supported languages
Before you install DWE
Shortcuts in DWE installation
Installing DB2 Data Warehouse Editions
Starting the installation
Starting the installation on Windows
Starting the installation on UNIX and Linux
Upgrading DB2 Data Warehouse Editions
Uninstalling DB2 Data Warehouse Editions
Installing DB2 Alphablox or DB2 Office Connect
Installing DB2 Cube Views
Installation requirements
Installing DB2 Cube Views on Windows
Installing DB2 Cube Views on AIX, Linux, or Solaris Operating System
Setting up a database for DB2 Cube Views
Setting up the CVSAMPLE sample database
Mainframe and midrange server connections
DB2 Connect Enterprise Edition
AIX
Installation requirements
Mounting CD-ROMs
HP-UX
Installation requirements
Mounting CD-ROMs
Linux
Installation requirements
Mounting CD-ROMs
Solaris
Installation requirements
Mounting CD-ROMs
Windows
Installing without Administrator authority
Installation requirements
LDAP: Extending the directory schema
DB2 Connect Personal Edition
Linux
Installation requirements
Mounting CD-ROMs
Windows
Installing without Administrator authority
Installation requirements
LDAP: Extending the directory schema
DB2 Connect license keys
Using the License Center
Installing DB2 Connect license keys
Setting the license type
Using the db2licm command
Installing DB2 Connect license keys
Setting the license type
DB2 Information Center
Linux and UNIX
Windows
Updating the DB2 Information Center
Configuring
Database systems
Database connections
Adding database connections with the Configuration Assistant
Discovery method
Manually
Profile method
Client profiles
Creating and exporting client profiles
Importing and configuring client profiles
LDAP directory support considerations
Testing database connections
Adding database connections with the CLP
Setting communication protocols for a DB2 instance
Named pipe connections
Named Pipes parameter values worksheet
Cataloging the node
Cataloging the database
NetBIOS connections
NetBIOS parameter values worksheet
Determining the logical adapter number
Updating the database manager configuration file
Cataloging the node
Cataloging the database
TCP/IP connections
TCP/IP parameter values worksheet
Resolving a server host address
Updating the services file on the client
Cataloging the node
Cataloging the database
Testing database connections
Configuring Lightweight Directory Access Protocol (LDAP) directory services
Overview
Security considerations in an LDAP environment
LDAP object classes and attributes used by DB2
Extending the LDAP directory schema with DB2 object classes and attributes
Supported LDAP client and server configurations
LDAP support and DB2 Connect
Registering host databases in LDAP
IBM SecureWay Directory Server
Netscape LDAP directory support and attribute definitions
Sun One Directory Server
Windows Active Directory
Support for Active Directory
Configuring DB2 to use Active Directory
Security considerations
DB2 objects
Enabling LDAP support after installation is complete
Configuring DB2 in the IBM LDAP environment
Registering LDAP entries
Registering DB2 servers
Cataloging a node alias for ATTACH
Registering databases
Deregistering LDAP entries
Deregistering the DB2 server
Deregistering the database from the LDAP directory
Configuring LDAP users
Creating an LDAP user
Configuring the LDAP user for DB2 applications
Setting DB2 registry variables at the user level in the LDAP environment
Disabling LDAP support
Update the protocol information for the DB2 server
Rerouting LDAP clients to another server
Attaching to a remote server in the LDAP environment
Refreshing LDAP entries in local database and node directories
Searching the LDAP directory partitions or domains
Configuring XA transaction managers
Resource manager setup
IBM WebSphere Application Server
IBM TXSeries CICS
IBM TXSeries Encina
BEA Tuxedo
Accessing DB2 UDB Version 7 servers using DB2 UDB Version 8 clients
Configuration Assistant
Systems
Adding a system
Changing a system
Removing a system
Instance nodes
Adding an instance node
Changing an instance node
Removing an instance node
Instance configurations
Setting database manager configuration parameters
Setting DB2 registry variables
Configuring another instance
Resetting configuration
Databases
Adding a database using a wizard
Adding a database
Adding a database when LDAP is enabled
Changing a database using a wizard
Changing a database
Removing a database
Binding files and utilities to a database
Testing database connections
Changing a password
Data sources
Adding a data source
Changing a data source
Removing a data source
Configuring CLI settings
Profiles
Exporting a configuration profile
Importing a configuration profile
Editing a profile offline
Configuration parameters
Configuration parameter tuning
Configuring parameters dynamically
Application development environment
DB2 Application Development Client
Database manager instances
DB2 supported servers
DB2 supported development software
AIX supported development software
HP-UX supported development software
Linux supported development software
Solaris supported development software
Windows supported development software
Setting up the application development environment
Rebuilding DB2 routine shared libraries
Updating the database manager configuration file
Setting up the CLI environment
Setting up the Java environment
Setting up DB2 WebSphere MQ functions
Setting up the UNIX application development environment
UNIX environment variable settings
CLI
Setting up the UNIX ODBC environment
Setting up the unixODBC Driver Manager
Sample configurations
Setting up the UNIX Java environment
Setting up the AIX Java environment
Setting up the HP-UX Java environment
Setting up the Linux Java environment
Setting up the Solaris Java environment
Setting up the Windows application development environment
Setting up the Windows CLI environment
Setting up the Windows Java environment
Setting up the sample database
Creating the sample database
Creating the sample database on mainframe or midrange servers
Cataloging the sample database
Binding the sample database utilities
Migrating applications to DB2 Version 8
Migrating Java applets
Migrating applications from 32-bit to 64-bit environments
Ensuring application portability
Running applications on two versions of DB2
Application behavior
Isolation levels
Specifying isolation levels
Configuring CLI/JDBC/ODBC/SQLJ behaviour with db2cli.ini
Setting CLI environment, connection, and statement attributes
Automatic maintenance of your database
Configuring automatic maintenance of your databases
Configuring backup maintenance options
Specifying the tables on which to perform table maintenance activities
Changing when maintenance activities are performed
Automatic statistics collection
Enabling automatic statistics collection
Query Patroller
Setting your own query submission preferences
Setting up Query Patroller server manually
Administration tasks overview
Starting Query Patroller
Enabling Query Patroller to intercept queries
Stopping Query Patroller
Query processing by Query Patroller
Managing users
Administering operators
Query Patroller operators
Query Patroller operator profiles
Creating operator profiles for users and groups
Suspending or restoring operator privileges for users and groups
Administering submitters
Query Patroller submitters
Query Patroller submitter profiles
Configuring submitter profiles
Creating submitter profiles for users and groups
Setting submitter resource limits
Suspending or restoring submitter privileges for users and groups
Administering query submission preferences
Setting preferences for another submitter
Setting your own preferences
Managing queries with Query Patroller
Managed query status
Changing the status of queries using Query Patroller
Viewing managed query details using Query Patroller
Viewing the SQL of managed queries using Query Patroller
Viewing result tables using Query Patroller
Running held queries at a scheduled time
Scheduling the start time for running held queries
Using historical analysis
Query Patroller historical analysis interface
Enabling collection of historical data
Uses for historical analysis reports
Collecting historical data
Generating historical data
Determining when historical data was last generated
Viewing historical query details
Viewing index details
Managing space
Setting Query Patroller maintenance schedules for queries and result tables
Managing historical queries
Scheduling purges of managed queries and result tables
Scheduling purges of historical queries
Dropping result tables manually using Query Patroller
Removing managed queries manually
Removing historical queries manually
Query Patroller system configuration
Setting query thresholds for the Query Patroller system
Updating the list of databases in Query Patroller
Enabling e-mail notification of Query Patroller submitters
Enabling collection of historical data
Query class configuration
Configuring query classes
Creating query classes for Query Patroller
Removing query classes for Query Patroller
Databases for Spatial Extenders
Configuring a database to accommodate spatial data
Tuning the database configuration parameters
Inventory of resources supplied for your database
Enabling a database for spatial operations
Setting up and enabling DB2 Geodetic Extender
Federated systems and data sources
Configuring a federated system
Federated systems - overview
Federated server
Federated database
Federated database system catalog
SQL compiler
Query optimizer
Query compensation
Pass-through sessions
Wrappers and wrapper modules
Default wrapper names
Server definitions and server options
Column options
Methods of interacting with a federated system
Checking the setup of the federated server
Confirming the link-edit to the data source client libraries (UNIX)
Checking the wrapper library files (UNIX)
Wrapper library files
Checking the link-edit error message files (UNIX)
Manually linking DB2 Universal Database to the data source client libraries
Manually linking the wrapper libraries to the data source client software
Creating a federated database
National language considerations for federated databases
Collating sequences and data source configuration
Setting the federated database collating sequence
Creating the federated database
Mapping data types
Data type mappings in a federated system
Data type mappings and the federated database global catalog
When to create alternative data type mappings
Data type mappings for nonrelational data sources
Forward and reverse data type mappings
Creating data type mappings
Mapping a specific data source type
Mapping a specific version and data type
Mapping all data source objects on a specific server
Mapping functions and user-defined functions
How function mappings work in a federated system
Requirements for mapping user-defined functions
Function templates
Creating function templates
Providing function mapping overhead information to the query optimizer
Specifying function names in a function mapping
Creating function mappings
Mapping a specific data source type
Mapping a specific version and data source type
Mapping all data source objects on a specific server
Developing applications that use user-defined functions
Disabling a default function mapping
Dropping a user-defined function mapping
Creating index specifications
Index specifications in a federated system
For data source objects
On tables that acquire new indexes
On views
On Informix synonyms
Creating and modifying remote tables by using transparent DDL
Transparent DDL
Restrictions on transparent DDL
Remote LOB columns and transparent DDL
Creating remote tables using transparent DDL
Altering remote tables using transparent DDL
Dropping remote tables using transparent DDL
Caching
Creating a cache table
Enabling a cache
Adding a materialized query table to a cache table
Dropping a materialized query table from a cache table
Dropping a cache table
Configuring data sources
Data source configuration - overview
Data sources - overview
Supported data sources
Wrappers and wrapper modules
Server definitions and server options
User mappings
Nicknames and data source objects
Valid data source objects
Data type mappings
Function mappings
Index specifications
Planning to configure federated data sources
Collating sequences
Methods of accessing Excel data
Federated object naming rules
Case-sensitive values in a federated system
Update data source statistics
Plan the data type mappings
Plan the function mappings
Plan the user mappings
Choose the correct wrapper
Checklist for planning your federated system configuration
Configuring your data sources - overview
Configuring multiple federated servers to access data sources
Setting the data source environment variables
db2dj.ini file - restrictions
Applying environment variables in a multi-partition instance configuration
Adding data sources to a federated server by using the DB2 Control Center
Registering wrappers for a data source
Registering server definitions for a data source
Registering user mappings for a data source
Registering nicknames for a data source
Specifying nickname columns for a nonrelational data source
Creating a nickname on a nickname
Nickname column customization
Configuring BioRS data sources
BioRS as a data source
Adding BioRS to a federated system
Registering the custom functions for the BioRS wrapper
Custom functions for the BioRS wrapper
Registering the BioRS wrapper
BioRS wrapper library files
Registering the server for a BioRS data source
CREATE SERVER statement options - BioRS wrapper
Registering user mappings for BioRS data sources
CREATE USER MAPPING statement options - BioRS wrapper
Registering nicknames for BioRS data sources
CREATE NICKNAME statement - examples for BioRS wrapper
CREATE NICKNAME statement syntax - BioRS wrapper
BioRS statistical information
Determining BioRS databank cardinality statistics
Updating BioRS column cardinality statistics
Updating BioRS nickname cardinality statistics
Updating cardinality statistics for BioRS _ID_ column
Queries and custom functions for BioRS data sources
Custom functions and BioRS queries
Equijoin predicates for the BioRS wrapper
BioRS AllText element
BioRS wrapper - example queries
Optimizing BioRS wrapper performance
Optimization tips for the BioRS wrapper
Messages for the BioRS wrapper
Configuring BLAST data sources
BLAST as a data source
Adding BLAST to a federated system
Verifying that the correct version of the blastall executable and matrix files are installed
Configuring the BLAST daemon
BLAST daemon configuration file - examples
Starting the BLAST daemon
db2blast_daemon command - syntax and examples
Registering the BLAST wrapper
BLAST wrapper libraries
Registering the server for a BLAST data source
Registering nicknames for BLAST data sources
Defining line parsing
Fixed columns for BLAST nicknames
CREATE NICKNAME statement - examples for BLAST wrapper
Setting up TurboBlast to work with the BLAST wrapper
Writing BLAST SQL queries
BLAST data source - Example queries
Optimization tips for the BLAST wrapper
Messages for the BLAST wrapper
Configuring business application data sources
WebSphere Business Integration wrapper
Configuring the WebSphere Business Integration adapters
Business object definitions
Configuration properties for business object definitions
Required WebSphere MQ message queues
Adding business applications to a federated system
Registering the WebSphere Business Integration wrapper (DB2 command line)
WebSphere Business Integration wrapper library files
Registering the server definition for business object application data sources (DB2 command line)
Registering nicknames for business application data sources
Using the DB2 Control Center
Identifying the required input columns in the business object
Using the DB2 command line
CREATE NICKNAME statement - examples for the WebSphere Business Integration wrapper
Nicknames and XPATH expressions
Nicknames and column option templates
Result sets for business applications
Nickname options for business application data sources
Query restrictions for wrappers for business applications and Web services
Creating federated views for business application nicknames
Business application data sources - example queries
Configuring DB2 family data sources
Adding DB2 family data sources to a federated system
Cataloging a node entry in the federated node directory
Cataloging the remote database in the federated system database directory
Registering the DB2 wrapper
DB2 wrapper library files
Registering the server definitions for a DB2 family data source
CREATE SERVER statement - examples for the DB2 wrapper
Creating the user mapping for a DB2 family data source
CREATE USER MAPPING statement - examples for the DB2 wrapper
Testing the connection to the DB2 data source server
Registering nicknames for DB2 Universal Database tables and views
CREATE NICKNAME statement - examples for the DB2 wrapper
Configuring Documentum data sources
Documentum as a data source
Adding Documentum to a federated system
Setting the Documentum environment variables
Making the Documentum client library available to DB2 Universal Database
Registering the Documentum wrapper
Documentum wrapper library files
Registering the server for Documentum data sources
Registering user mappings for Documentum
Registering nicknames for Documentum data sources
CREATE NICKNAME statement - examples for Documentum wrapper
Registering custom functions for Documentum data sources
Documentum data source - example queries
Dual defining repeating attributes for the Documentum wrapper
Access control for the Documentum wrapper
Messages for the Documentum wrapper
Configuring Entrez data sources
Entrez as a data source
Adding Entrez to a federated system
Registering custom functions for the Entrez wrapper
Custom functions for the Entrez wrapper
Registering the Entrez wrapper
Entrez wrapper library files
Registering the server for an Entrez data source
Registering nicknames for Entrez data sources
Queries and custom functions for Entrez data sources
Custom functions and Entrez queries
Relational predicates for the Entrez wrapper
Invalid WHERE clauses for the Entrez wrapper
Schema data element simplification
Entrez data source - example queries
PubMed schema tables
Nucleotide schema tables
Messages for the Entrez wrapper
Configuring Microsoft Excel data sources
Excel as a data source
Adding Excel to a federated system
Registering the Excel wrapper
Excel wrapper library files
Registering the server for an Excel data source
Registering nicknames for Excel data sources
Accessing Excel data using the ODBC wrapper
Excel data source - example queries
Excel data source - example scenario
File access control for the Excel wrapper
Messages for the Excel wrapper
Configuring Extended Search data sources
Extended Search as a data source
Extended Search nicknames
Extended Search vertical tables
Adding Extended Search data sources to a federated system
Registering the Extended Search wrapper
Extended Search wrapper library files
Registering the server for Extended Search data sources
Registering user mappings for Extended Search data sources
Registering nicknames for Extended Search data sources
Registering the Extended Search custom function
Query guidelines for the Extended Search wrapper
Example queries for the Extended Search wrapper
Generalized query language - Extended Search wrapper
Messages for the Extended Search wrapper
Configuring HMMER data sources
HMMER as a data source
Adding HMMER to a federated system
Verifying the version of the HMMER program executable
Configuring the HMMER daemon
HMMER daemon configuration file - examples
Starting the HMMER daemon
db2hmmer_daemon command - syntax and examples
Registering the HMMER wrapper
HMMER wrapper library files
Registering the server for a HMMER data source
CREATE SERVER statement - examples
Registering nicknames for HMMER data sources
Fixed columns for HMMER nicknames
CREATE NICKNAME statement - example
Example for adding HMMER to a federated system
Example queries for HMMER data sources
Messages for the HMMER wrapper
Configuring Informix data sources
Adding Informix data sources to federated servers
Setting up and testing the Informix client configuration file
Setting Informix environment variables
Registering the Informix wrapper
Informix wrapper library files
Registering the server definitions for an Informix data source
CREATE SERVER statement - examples for the Informix wrapper
Creating the user mapping for an Informix data source
CREATE USER MAPPING statement - examples for the Informix wrapper
Testing the connection to the Informix server
Registering nicknames for Informix tables, views, and synonyms
CREATE NICKNAME statement - examples for the Informix wrapper
Tuning and troubleshooting the configuration to Informix data sources
Configuring KEGG data sources using KEGG user-defined functions
KEGG user-defined functions - overview
KEGG user-defined functions by functional category
Function arguments for the KEGG user-defined functions
Registering the KEGG user-defined functions
Disabling the KEGG user-defined functions
Configuring life sciences data sources using life science user-defined functions
Life sciences user-defined functions - overview
Life sciences user-defined function library files
Life sciences user-defined functions by functional category
Registering life sciences user-defined functions
Disabling life sciences user-defined functions
Configuring Microsoft SQL Server data sources
Adding SQL Server data sources to a federated system
Preparing the federated server and database to access SQL Server data sources
Setting the SQL Server environment variables
Registering the SQL Server wrapper
Microsoft SQL Server wrapper library files
Registering the server definitions for a SQL Server data source
CREATE SERVER statement - examples for the SQL Server wrapper
Creating a user mapping for a SQL Server data source
CREATE USER MAPPING statement - examples for the SQL Server wrapper
Testing the connection to the SQL Server remote server
Registering nicknames for SQL Server tables and views
CREATE NICKNAME statement - examples for the SQL Server wrapper
Tuning SQL Server data source configuration
Configuring ODBC data sources
Adding ODBC data sources to federated servers
Preparing the federated server and database through ODBC
Registering the ODBC wrapper
CREATE WRAPPER statement - examples for the ODBC wrapper
ODBC wrapper library files
Registering the server definitions for an ODBC data source
CREATE SERVER statement - examples for the ODBC wrapper
Creating a user mapping for an ODBC data source
CREATE USER MAPPING statement - examples for the ODBC wrapper
Testing the connection to the ODBC data source server
Registering nicknames for ODBC data source tables and views
CREATE NICKNAME statement - examples for the ODBC wrapper
Accessing Excel data using the ODBC wrapper
Tuning ODBC data source configuration
Configuring OLE DB data sources
Adding OLE DB data sources to federated servers
Registering the OLE DB wrapper
OLE DB wrapper library files
Registering the server definitions for an OLE DB data source
CREATE SERVER statement - examples for the OLE DB wrapper
Creating a user mapping for an OLE DB data source
CREATE USER MAPPING statement - examples for the OLE DB wrapper
Configuring Oracle data sources
Adding Oracle data sources to a federated system
Setting Oracle environment variables
Setting up and testing the Oracle client configuration file
Registering the Oracle wrapper
Oracle wrapper library file names
Registering server definitions for an Oracle data source
CREATE SERVER statement - examples for the Oracle wrapper
Creating user mappings for an Oracle data source
CREATE USER MAPPING statement - examples for the Oracle wrapper
Testing the connection to the Oracle server
Registering nicknames for Oracle tables and views
CREATE NICKNAME statement - examples for the Oracle wrapper
Tuning Oracle data source configuration
Configuring Sybase data sources
Adding Sybase data sources to a federated system
Setting Sybase environment variables
Setting up and testing the Sybase client configuration file
Registering the Sybase wrapper
Sybase wrapper library files
Registering server definitions for a Sybase data source
CREATE SERVER statement - examples for the Sybase wrapper
Creating a user mapping for a Sybase data source
CREATE USER MAPPING statement - examples for the Sybase wrapper
Testing the connection to the Sybase server
Registering nicknames for Sybase tables and views
CREATE NICKNAME statement - examples for the Sybase wrapper
Tuning Sybase data source configuration
Configuring table-structured file data sources
Table-structured files as a data source
Types of table-structured files
How DB2 Information Integrator works with table-structured files
Adding table-structured files to a federated system
Registering the table-structured file wrapper
Table-structured files wrapper library files
Registering the server for table-structured files
Registering nicknames for table-structured files
CREATE NICKNAME statement - examples for the table-structured file wrapper
File access control for the table-structured file wrapper
Optimization tips for the table-structured file wrapper
Messages for the table-structured file wrapper
Configuring Teradata data sources
Adding Teradata data sources to a federated system
Testing the connection to the Teradata server
Verifying that the Teradata library is enabled for run-time linking (AIX)
Setting Teradata environment variables
Registering the Teradata wrapper
Teradata wrapper library files
Registering the server definitions for a Teradata data source
CREATE SERVER statement - examples for the Teradata wrapper
Creating a user mapping for a Teradata data source
CREATE USER MAPPING statement - examples for the Teradata wrapper
Testing the connection from the federated server to the Teradata server
Teradata nicknames on federated servers
Registering nicknames for Teradata tables and views
CREATE NICKNAME statement - examples for the Teradata wrapper
Tuning and troubleshooting the configuration to Teradata data sources
Configuring Web services data sources
Web services wrapper and the Web services description language document
Adding Web services to a federated system
Registering the Web services wrapper
Web services wrapper library files
Registering the server definition for Web services data sources
CREATE SERVER statement options - Web services wrapper
Registering nicknames for Web services data sources
Creating federated views for Web services nicknames
Nicknames and column option templates
Nicknames and XPATH expressions
CREATE NICKNAME statement - examples for the Web services wrapper
Query restrictions for the wrappers for business applications and Web services
Example queries for Web services data sources
Security for the Web services wrapper
Messages for the Web services wrapper
Configuring XML data sources
XML as a data source
Adding XML to a federated system
Registering the XML wrapper
XML wrapper library files
Registering the server for an XML data source
Data associations between nicknames and XML documents
Cost model facility for the XML wrapper
Optimization tips for the XML cost model facility
Registering nicknames for XML data sources
CREATE NICKNAME statement - examples for the XML wrapper
Creating federated views for nonroot nicknames (XML wrapper)
Example queries for XML data sources
Messages for the XML wrapper
Replication and event publishing
Configuring for SQL replication
Planning
Configuring servers
UNICODE and ASCII encoding schemes (z/OS)
Configuring for Q replication and event publishing
Planning memory and storage requirements
Planning memory requirements
Memory used by the Q Capture program
Memory used by the Q Apply program
Memory used by the Replication Alert Monitor
Memory for LOB data types
Planning storage requirements
Storage for DB2 UDB logs
Storage for diagnostic files
Storage for when the Q Capture program exceeds its memory limit
Storage for traces
Data conversion
Data conversion for Q replication
Data conversion for event publishing
Setting up user IDs and passwords
Authorization requirements for Q replication and event publishing
Q Capture program
Q Apply program
Replication Alert Monitor
To administer Q replication and event publishing
Storing user IDs and passwords for remote servers
Setting up WebSphere MQ
WebSphere MQ objects required for Q replication and event publishing
Required WebSphere MQ objects at a glance
Unidirectional replication on the same system
Unidirectional replication (remote)
Event publishing
Bidirectional or peer-to-peer replication (two remote servers)
Peer-to-peer replication (three or more remote servers)
Required settings for WebSphere MQ objects
WebSphere MQ message size
Storage requirements for WebSphere MQ
Storage requirements for spill queues for the Q Apply program
Connectivity and authorization requirements for WebSphere MQ objects
Queue depth considerations for LOB values
Queue manager clustering
Configuring servers
Connectivity requirements
Configuring databases (Linux, UNIX, Windows)
Setting environment variables
Configuring the source database to work with the Q Capture program
Configuring the target database to work with the Q Apply program
Binding the program packages
Q Capture program packages
Q Apply program packages
Replication Alert Monitor packages
Configuring databases (z/OS)
Software prerequisites for the Replication Center
Creating control tables for the Q Capture and Q Apply programs
Business intelligence
Information Catalog Center
Configuring the Information Catalog Center for the Web with WebSphere Application Server 4
Configuring the Information Catalog Center for the Web with WebSphere Application Server 5
Configuring the Information Catalog Center for the Web with the DB2 Embedded Application Server
Environment structure for Information Catalog Manager components
Warehouse agent environment structures
Identifying ports for Data Warehouse Center components if your system configuration uses a firewall
Communications between Data Warehouse Center clients and servers
Communications between Data Warehouse Center servers and warehouse agents
Data Warehouse Center
Data Warehouse Center configuration
Data Warehouse Center environment variables
Data Warehouse Center registry updates
Data Warehouse Center configuration files
Warehouse agents
Preparing to install warehouse agents
Non-DB2 source database access using ODBC
Validating the connectivity of an ODBC data source for warehouse agents
Warehouse agent connectivity with warehouse sources and targets
Connectivity products for warehouse sources and targets
Database clients on warehouse agent sites and warehouse servers
Verifying TCP/IP connectivity between the warehouse server and the warehouse agent
Setting up your warehouse
Starting and stopping the DWC server and logger
Starting the Data Warehouse Center
Starting the Data Warehouse Center administrative interface
Starting and stopping the warehouse server and logger (Windows NT, Windows 2000, Windows XP)
Starting and stopping the warehouse server and logger (AIX)
Verifying that the warehouse server and logger daemons are running (AIX)
Starting the warehouse agent daemon
Warehouse agent daemons
Connectivity requirements for the warehouse server and the warehouse agent
Starting the warehouse agent daemon (Windows)
Starting the iSeries warehouse agent daemon
Verifying that the iSeries warehouse agent started
Verifying that the iSeries warehouse agent daemon is still running
Configuring TCP/IP on z/OS
Starting the zSeries agent daemon in the foreground
Starting the zSeries warehouse agent daemon in the background
Verifying that the zSeries warehouse agent is running
Verifying communication between the warehouse server and the warehouse agent
Stopping the warehouse agent daemon
Stopping the warehouse agent daemon (Windows NT, Windows 2000, Windows XP)
Stopping the warehouse agent daemon (AIX, Linux, Solaris Operating Environment)
Stopping the iSeries warehouse agent daemon
Stopping the warehouse agent daemon (zSeries)
Agent site configurations
Defining an agent site
Updating your environment variables on z/OS
Data Warehouse Center security
Defining warehouse security
Setting up supported DB2 data sources
DB2 warehouse sources
Defining DB2 warehouse sources
Warehouse agent support for DB2 sources
Setting up connectivity for DB2 and DRDA sources
Setting up connectivity for a DB2 Universal Database source (AIX)
Setting up connectivity for a DB2 DRDA database source (AIX)
Setting up connectivity for a DB2 Universal Database source (Linux, Solaris Operating Environment)
Setting up connectivity for a DRDA data source (Linux, Solaris Operating Environment)
Setting up connectivity for DB2 sources (OS/2)
Setting up connectivity for a DRDA data source (OS/2)
Setting up connectivity for DB2 Universal Database databases (Windows)
Setting up connectivity for DB2 DRDA databases (Windows)
Accessing source databases
Defining privileges to DB2 data sources
Establishing connectivity to DB2 data sources
Setting up access to DB2 DRDA data sources
Defining privileges to DB2 DRDA data sources
Setting up a DB2 Connect gateway site (Windows)
Connecting to DB2 DRDA data sources
Connectivity requirements for remote databases
Connectivity requirements for remote databases from the iSeries warehouse agent
Setting up access to local and remote databases from the iSeries warehouse agent
Example of how to catalog local and remote database names for the iSeries warehouse agent
Viewing and editing remote relational database directory entries
Requirements for accessing remote data sources with the zSeries warehouse agent
Requirements for accessing relational data sources with the zSeries warehouse agent
Setting up connectivity for non-DB2 sources
Supported non-DB2 data sources
Warehouse agent support for non-DB2 sources
Column size truncation for non-DB2 warehouse sources
Setting up connectivity for non-DB2 sources (Windows)
Setting up connectivity for a Sybase Adaptive Server source - without client (Windows)
Setting up connectivity for an Oracle source (Windows)
Setting up connectivity for an Informix 9.2 source - with client (Windows)
Setting up connectivity for an Informix 9.2 source - without client (Windows)
Setting up connectivity for a Microsoft SQL Server data source (Windows)
Setting up connectivity for a Microsoft Access source or a Microsoft Excel data source (Windows)
Managing the warehouse agent for non-DB2 sources
Verifying the warehouse agent (AIX, Linux, Solaris Operating Environment)
Switching between versions of the warehouse agent
Setting up connectivity for non-DB2 sources (AIX, Linux, Solaris Operating Environment)
Setting up connectivity for a Sybase Adaptive Server source - without client (AIX)
Setting up connectivity for an Oracle source - without client (AIX)
Setting up connectivity for an Informix 9.2 source - without client (AIX)
Setting up connectivity for a Microsoft SQL Server source - without client (AIX)
Setting up connectivity for a Microsoft SQL Server source (Linux, Solaris Operating Environment)
Configuring non-DB2 warehouse sources (Windows)
Configuring the ODBC driver for non-DB2 warehouse sources- without client (Windows)
Handling errors for Informix 9.2 - without client
Creating a target warehouse database (Windows)
Defining a warehouse that uses the Microsoft Access and warehouse target databases (Windows)
Importing table definitions from a Microsoft Access database (Windows)
Cataloging a Microsoft Access source database in ODBC (Windows)
Cataloging a target warehouse database for use with a Microsoft Access source database (Windows)
Using a Microsoft Excel spreadsheet as a warehouse source (Windows)
Cataloging a Microsoft Excel data source in ODBC (Windows)
Creating named tables for Microsoft Excel data sources (Windows)
Creating a target warehouse database for use with a Microsoft Excel data source (Windows)
Cataloging a target warehouse database for use with a Microsoft Excel data source (Windows)
Defining sources and targets to the Data Warehouse Center that use a Microsoft Excel data source (Windows)
Configuring the Red Brick client to access a Red Brick Warehouse database (Windows)
Configuring non-DB2 warehouse sources (AIX, Linux, Solaris Operating Environment)
Configuring the Red Brick client to access a Red Brick Warehouse database (AIX, Linux, Solaris Operating Environment)
Sample .odbc.ini file for the Red Brick ODBC driver
Defining a non-DB2 warehouse source in the Data Warehouse Center
Specifying database information for a non-DB2 warehouse source in the Data Warehouse Center
Defining warehouse sources for use with a DB2 federated system
Server definitions and nickname tables for warehouse sources accessed through a DB2 federated server
Defining source tables for federated system warehouse sources
Setting up warehouse file sources
Warehouse agent support for file sources
Defining a file source to the Data Warehouse Center
Accessing remote data files
Accessing data files with the Copy file using FTP warehouse program
Setting up connectivity for file sources (Windows NT, Windows 2000, Windows XP)
Setting up connectivity for a z/OS or VM file source (Windows NT, Windows 2000, Windows XP)
Setting up connectivity for a local file source (Windows NT, Windows 2000, Windows XP)
Requirements for accessing a remote file from a file server (Windows)
Setting up connectivity for a remote file source (Windows NT, Windows 2000, Windows XP)
Setting up connectivity for file sources (AIX)
Setting up connectivity to a z/OS or VM file source (AIX)
Setting up connectivity for a local file source (AIX)
Setting up connectivity for a remote file source (AIX)
Setting up connectivity for file sources (Linux, Solaris Operating Environment)
Setting up connectivity for a z/OS or VM file source (Linux, Solaris Operating Environment)
Setting up connectivity for a local file source (Linux, Solaris Operating Environment)
Setting up connectivity for a remote file source (Linux, Solaris Operating Environment)
Example .odbc.ini file entry for a warehouse file source (AIX, Linux, Solaris Operating Environment)
Network File System protocol
Mainframe and midrange server connections
DB2 Universal Database for iSeries
DB2 Universal Database for OS/390 and z/OS
Host databases
Configuring TCP/IP
Configuring DB2 Universal Database for OS/390 and z/OS
Configuring VTAM
Setting utility execution options
DB2 for VSE & VM
DB2 Connect Sysplex support
DB2 Sysplex exploitation
Configuration requirements
IMS options
Cataloging mainframe and midrange servers
Cataloging databases with Configuration Assistant
Managing connections
Changing a mainframe and midrange server
Removing a mainframe and midrange server
Cataloging databases using discovery
Cataloging databases using a profile
Setting the license type using the db2licm command
Setting the license type using the License Center
Tools for administration and application development
Creating a database for the DB2 tools catalog
Setting documentation properties
Setting the location of the DB2 Information Center
Setting startup and default options
Changing the fonts for menus and text
Filtering objects in the display
Enabling Health Monitor notification
Setting the default scheduling scheme
Setting Command Editor options
Setting IMS options
Documentation
Invoking the DB2 Information Center
Setting the location for accessing the DB2 Information Center
Displaying topics in your preferred language
Designing
Database systems
Database system overview
Relational databases
Structured Query Language (SQL)
DB2 administration server (DAS)
Instances
Database objects
Databases
Schemas
Tables
Views
Database aliases
Table or view aliases
Catalog views
System catalog views
Database partitioning feature
Database partitioning across multiple partitions
Database partition groups
Table objects
Tables
Indexes
Constraints
Keys
Foreign key clause
Triggers
Interaction of triggers and constraints
Units of work
Recovery objects
Backups
Recovery log files
Recovery history files
Accessing the history file using the LIST_HISTORY table function
Storage objects
Database directories and files
Table spaces
Buffer pools
Buffer pool management
Page cleaners
Prefetchers
Database systems
Distributed relational databases
Parallel database systems
Parallelism
Partition and processor environments
Data warehouse systems
Data warehouse objects
Warehouse tasks
Federated database systems
Agents
Users and groups
Authentication
Authorization
Authorities and privileges
Roles in a Query Patroller environment
Operators
Submitters
Logical database design
What to record in a database
Database relationships
Column definitions
Primary keys
Identity columns
Normalization
Constraints
Triggers
Interaction of triggers and constraints
Finding object dependencies in a database system
Data integrity
Physical database design
Database directories and files
Space requirements for database objects
System catalog tables
User table data
Long field data
Large object data
Indexes
Log files
Temporary tables
Database partition groups
Database partition group design
Partitioning maps
Partitioning keys
Table collocation
Partition compatibility
Replicated materialized query tables
Table space design
System managed space
Database managed space
Adding and extending containers
Dropping and reducing containers
Table space maps
Comparison of SMS and DMS table spaces
Table space disk I/O
Workload considerations
Extent size
Table spaces and buffer pools
Table spaces and database partition groups
Temporary table space design
Temporary tables in SMS table spaces
Catalog table space design
Optimizing table space performance on RAID devices
Considerations when choosing table spaces for tables
Storage management view
Stored procedures for the storage management tool
Storage management view tables
Table design
Range-clustered tables
Range-clustered tables and out-of-range record key values
Range-clustered table locks
Examples
How the SQL compiler works with range-clustered tables
Guidelines for using range-clustered tables
Multidimensional clustering (MDC)
Choosing MDC table dimensions
Creating MDC tables
National language versions
Supported territory codes and code pages
Date and time formats by territory code
Enabling and disabling euro symbol support
Conversion table files for euro-enabled code pages
Conversion tables for code pages 923 and 924
Choosing a language for your database
Enabling bidirectional support
Bidirectional-specific CCSIDs
Bidirectional support with DB2 Connect
Collating sequences
Collating Thai characters
Unicode character encoding
Unicode implementation in DB2 Universal Database
Unicode handling of data types
Creating a Unicode database
Unicode literals
String comparisons in a Unicode database
Installing the previous tables for converting between code page 1394 and Unicode
Alternative Unicode conversion tables for the coded character set identifier (CCSID) 943
Replacing the Unicode conversion tables for coded character set (CCSID) 943 with the Microsoft conversion tables
Designing distributed databases
Updating a single database in a transaction
Using multiple databases in a single transaction
Updating a single database in a multi-database transaction
Updating multiple databases in a transaction
DB2 transaction manager
DB2 transaction manager configuration
Updating a database from a mainframe or midrange server
Two-phase commit
Error recovery during two-phase commit
Designing for XA-compliant transaction managers
xa_open string formats
Updating data on mainframe or midrange database servers
Manually resolving indoubt transactions
Security considerations for XA transaction managers
XA function supported by DB2 UDB
XA interface problem determination
Configuring XA transaction managers
Resource manager setup
IBM WebSphere Application Server
IBM TXSeries CICS
IBM TXSeries Encina
BEA Tuxedo
Business Intelligence
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 Cube Views
Administering
Database systems
Starting and stopping DB2 Universal Database
Starting DB2 UDB on UNIX
Starting DB2 UDB on Windows
Stopping a DB2 instance on UNIX
Stopping a DB2 instance on Windows
Auto-starting DB2 instances
Administration tools
Control Center
Starting the server DB2 administration tools
Shutting down the server DB2 administration tools
Opening new Control Centers
Selecting and customizing Control Center views
Selecting your Control Center view
Customizing your Control Center view
Deleting custom folders or objects in custom folders
Displaying objects in the object tree
Expanding and collapsing the object tree
Refreshing objects in the objects tree and details view
Adding DB2 systems and IMSplexes, instances, and databases to the object tree
Adding DB2 federated system objects to the object tree
Adding DB2 for z/OS and OS/390 subsystems to the object tree
Adding DB2 servers for VSE & VM to the object tree
Displaying objects in the contents pane
Finding objects in the contents pane
Displaying table information in the contents pane
Getting help in the Control Center
Finding service level information about the DB2 administration tools environment
Task Center
Command Editor
Executing commands and SQL statements
Net Search Extender
Instance services administration
Database administration
Creating text indexes
Maintaining indexes
Setting up database systems
Adding database systems using the Add System window
Creating instances
Multiple instances
Linux or UNIX
Windows
Setting the DB2 environment (UNIX)
Automatically
Manually
Adding instances
Creating instances from the command line
Linux and UNIX
Windows
Adding an instance using the Add Instance window
Adding a record of an instance
Setting up communications
Configuring APPC
Configuring the APPC stack
Configuring named pipes
Configuring NetBIOS
Configuring TCP/IP
Configuring instances for multisite update
Testing multisite update
Viewing the results of a multisite update test
Setting up a DB2 administration server (DAS)
Tools catalog database and DAS scheduler setup and configuration
DAS Java virtual machine setup
Notification and contact list setup and configuration.
Setting up the DAS to use the Configuration Assistant and the Control Center
Discovery of administration servers, instances, and databases
Hiding server instances and databases from discovery
Configuring the DAS on DB2 UDB Enterprise Server Edition systems
Setting up the DAS
Creating databases
Database configuration file
System catalog tables
Adding databases using the Add Database window
Creating databases
Automatic storage databases
Creating databases with the Create Database Wizard
Cloning databases
Binding utilities to the database
Cataloging a database
Updating the directories with information about remote database server machines
Creating database objects
Creating table spaces
Initial table spaces
Automatic resizing of table spaces
Creating table spaces
Creating table spaces using the Create Table Space wizard
Creating system temporary table spaces
Creating user temporary table spaces
Specifying raw I/O
Setting up raw I/O (Linux)
Creating table spaces in database partition groups
Creating schemas
Creating a schema
Setting a schema
Creating tables
Space compression for tables
Space compression for new tables
Large object (LOB) column considerations
Business rules for data
Estimating space requirements for tables and indexes
Creating tables using the Create Table wizard
Creating tables in multiple table spaces
Creating staging tables
Creating materialized query tables
Creating user-maintained materialized query tables
Creating user-defined temporary tables
Creating hierarchy tables or typed tables
Defining dimensions on multidimensional clustering (MDC) tables
Adding dimensions
Changing dimensions
Creating columns
Adding columns
Adding predefined columns
Changing columns when creating a table
Defining a generated column on a new table
Defining an identity column on a new table
Changing column categories
Creating indexes, index extensions, or index specifications
Tips
Options on the CREATE INDEX statement
Creating indexes
Creating indexes using the Create Index window
Creating a user-defined extended index type
Index maintenance
Index searching
Index exploitation
Defining an index extension
Defining constraints
Implications for utility operations
Defining unique constraints
Adding unique keys
Changing unique keys
Defining the primary key
Changing the primary key
Creating sequences
Comparison of IDENTITY columns and sequences
Defining referential constraints
Foreign key clause
References clause
Adding foreign keys
Changing foreign keys
Defining table check constraints
Adding check constraints
Changing check constraints
Defining informational constraints
Creating triggers
Creating triggers using the Create Trigger notebook
Trigger dependencies
Updating view contents using triggers
Creating user-defined functions (UDF) or methods
Creating function mappings
Creating function templates
Creating user-defined types (UDT)
Creating user-defined distinct types from the command line
Creating distinct types using the Create Distinct Type window
Creating user-defined structured types
Creating type mappings
Creating views
Creating views using the Create View window
Creating typed views
Creating database aliases
Setting up partitioned database environments
Initial database partition groups
Creating a node configuration file
Adding database partition servers to an instance (Windows)
Setting up multiple logical nodes
Configuring multiple logical nodes
Enabling parallelism
Inter-partition query parallelism
Intra-partition parallelism for queries
Intra-partition parallelism for utilities
Enabling parallelism when creating indexes
Enabling parallelism for loading data
Enabling I/O parallelism when backing up a database or table space
Enabling I/O parallelism when restoring a database or table space
Adding database partitions to an instance
Using the Add Partitions wizard
Using the Add Partitions launchpad
Creating database partition groups (formerly nodegroups)
Creating database partition groups using the Create Database Partition Group window
Creating table spaces in database partition groups
Creating tables in partitioned databases
Defining the partitioning key
Changing the partitioning key
Enabling communication between database partitions using fast communications manager (FCM) communications
Setting up database storage objects
Database directories
Local database directory
System database directory
Node directory
Buffer pools
Creating buffer pools from the command line
Creating buffer pools using the Create Buffer Pool window
Creating a buffer pool for a partitioned database
Setting environment variables and the profile registry
Declaring registry and environment variables
Aggregate registry variables
Setting environment variables (Linux and UNIX)
Setting environment variables (Windows)
Granting authorities and privileges to users and groups
Users
Database authorities
Table space privileges
Schema privileges
Table privileges
Index privileges
CONTROL privilege
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Groups
Database authorities
Table space privileges
USE privilege
Schema privileges
Table privileges
Index privileges
CONTROL privilege
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Maintaining database systems
Stopping, starting, and quiescing instances
Stopping an instance
Starting an instance
Starting an instance in admin mode
Quiescing an instance
Unquiescing an instance
Stopping, starting, and quiescing databases
Restarting a database
Quiescing a database
Unquiescing a database
Managing database systems
Discovering database system objects
Changing database systems
Working with your local database systems, DRDA systems, and Version 2 systems
Managing instances
Listing instances
Setting the current instance
Running multiple instances concurrently
Changing instances
Updating instance configuration
Linux and UNIX
Windows
Updating instances after the installation or removal of executables or components (Linux and UNIX)
Managing the database manager
Attaching to another instance of the database manager
Viewing the database manager configuration
Setting database manager configuration parameters
Viewing a list of the applications for the local databases on an instance
Forcing the applications for the local databases on an instance
Removing instances
Managing the DB2 administration server (DAS)
Starting and stopping the DAS
Listing the DAS
Reconfiguring the DAS
Updating the DAS configuration for discovery
Setting discovery parameters
Updating the DAS after installing DB2 UDB updates (UNIX)
Removing the DAS
Managing databases
Database recovery log
Selecting a database
Viewing the local or system database directory files
Viewing the database configuration
Changing node and database configuration files
Setting database configuration parameters
Invoking the Configuration Advisor from the command line processor
Generating DDL statements for database objects
Adding a database
Adding a database from the All Databases folder
Altering a database
Statement dependencies when changing objects
Changing databases
Dropping databases
Altering table spaces
Altering table spaces using the Alter Table notebook
Renaming table spaces
Renaming table spaces using the Rename Table Space window
Switching the state of a table space
Adding and changing containers in an SMS table space
Adding SMS containers
Changing SMS containers
Adding and changing containers in a DMS table space
Adding DMS containers
Adding DMS containers using the Define Container window
Modifying DMS containers
Changing DMS containers using the Define Container window
Automatic prefetchsize adjustment after adding or dropping containers
Dropping user table spaces
Dropping system temporary table spaces
Dropping user temporary table spaces
Altering a schema
Dropping a schema
Modifying tables
Space compression for existing tables
Changing the quiesce mode of table
Viewing and editing the contents of a table
Copying a table
Renaming an existing table or index
Renaming a table using the Rename Table window
Changing table attributes
Changing table properties using the Alter Table notebook
Altering tables using stored procedures
Updating table and view contents using the MERGE statement
Declaring a table volatile
Recovering inoperative summary tables
Modifying materialized query tables
Populating user-maintained materialized query tables
Altering materialized query table properties
Refreshing the data in a materialized query table
Deleting the contents of staging tables
Dropping materialized query or staging tables
Populating a typed table
Reorganizing a table
Running statistics on tables
Running statistics on multiple tables
Running statistics on a single table
Specifying statistics to collect for individual columns or column groups
Creating or changing column groups
Dropping tables
Dropping tables using the Control Center
Dropping user-defined temporary tables
Modifying table objects
Modifying columns
Editing and testing SQL statements when changing columns
Validating related objects when changing columns
Adding columns to existing tables
Adding columns using the Alter Table notebook
Adding predefined columns
Changing new columns
Changing existing columns
Changing existing columns in a pre-version 8.2 database
Modifying column definitions
Changing column categories
Defining generated columns on existing tables
Altering identity columns
Modifying an identity column definition
Modifying the generated or identity property of a column
Removing rows from a table or view
Deleting and updating rows of a typed table
Managing indexes
Altering indexes
Renaming indexes
Reorganizing indexes
Dropping indexes, index extensions, or index specifications
Dropping indexes
Modifying constraints
Turning off constraint checking, immediate refreshing, or immediate propagation for tables
Making tables in no data movement mode fully accessible
Modifying unique constraints
Adding unique constraints
Adding unique keys
Changing unique keys
Adding primary keys
Defining the primary key
Changing the primary key
Dropping unique constraints
Dropping primary keys
Modifying foreign constraints
Adding foreign keys
Adding foreign keys using the Add Foreign Keys window
Changing foreign keys
Dropping foreign keys
Modifying check constraints
Adding table check constraints
Adding check constraints using the Add Check Constraint window
Changing check constraints
Dropping table check constraints
Altering sequences
Dropping sequences
Modifying triggers
Viewing trigger definitions
Adding, changing, or deleting a comment on a trigger
Specifying information for triggers
Specifying a triggered action
Copying the SQL for a triggered action
Dropping a trigger using the DROP statement
Dropping triggers
Dropping a user-defined function (UDF), function mapping, or method
Altering a user-defined structured type
Dropping a user-defined type (UDT) or type mapping
Altering or dropping views
Altering views using the Alter View window
Viewing a sample of the contents of a view
Recovering inoperative views
Dropping views
Modifying database aliases
Creating aliases
Altering aliases
Dropping aliases
Maintaining partitioned database environments
Listing database partition servers in an instance
Eliminating duplicate entries from a list of machines in a partitioned database environment
Specifying the list of machines in a partitioned environment
Changing the database configuration across multiple partitions
Adding a container to an SMS table space on a partition
Altering buffer pools
Maintaining database partitions
Starting database partitions
Stopping database partitions
Configuring database partitions
Restarting database partitions
Changing database partitions (Windows)
Dropping database partitions
Dropping partitions from the instance using the Drop Partitions launchpad
Dropping database partitions (Windows)
Confirming the partition to drop from an instance
Scheduling when to dropping partitions from the instance
Maintaining database partition groups
Altering database partition groups from the command line
Altering database partition groups using the Alter Database Partition Group wizard
Redistributing data in a database partition group
Confirming the database partitions to drop from database partition groups
Changing partitioning keys
Changing partitioning keys from the command line
Changing partitioning keys using the Alter Table notebook
Defining partitioning keys
Issuing commands in a partitioned database environment
rah and db2_all commands overview
rah and db2_all command descriptions
Specifying the rah and db2_all commands
Running commands in parallel (Linux and UNIX)
Monitoring rah processes (Linux and UNIX)
Extension of the rah command to use tree logic (AIX and Solaris)
rah command prefix sequences
Controlling the rah command
Specifying which . files run with rah (Linux and UNIX)
Setting the default environment profile for rah (Windows NT)
Determining problems with rah (Linux and UNIX)
Managing storage
Table columns in the storage management view
Storage exceptions
Setting up the storage management tool
Specifying table space settings for storage management
Specifying threshold settings for disk space usage
Specifying threshold settings for cluster ratio
Specifying threshold settings for data skew
Altering buffer pools
Altering buffer pools from the command line
Altering buffer pools using the Alter Buffer Pool window
Identifying alternate servers with automatic client reroute
Description and setup
Limitations
Identifying an alternate server for a database
Examples
Managing authorities and privileges for users and groups
Users
Defining a new database user to DB2 UDB
Adding users to the privileges user list
Granting USE privilege on table spaces when adding users
Granting USE privilege on table spaces when changing users
Changing user authorities and privileges
Database authorities
Schema privileges
Table privileges
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Revoking user authorities and privileges
Database authorities
Table space privileges
USE privilege
Schema privileges
Table privileges
Index privileges
CONTROL privilege
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Groups
Defining a new group of database users to DB2 UDB
Adding groups to the privileges group list
Granting the USE privilege on table spaces when adding groups
Granting USE privilege on table spaces when changing groups
Changing group authorities and privileges
Database authorities
Schema privileges
Table privileges
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Revoking group authorities and privileges
Database authorities
Table space privileges
USE privilege
Schema privileges
Table privileges
View privileges
Function privileges
Method privileges
Procedure privileges
Package privileges
Managing tasks with Task Center
Creating a task
Specifying run properties for a script
For DB2 UDB scripts
For MVS shell scripts
For operating system scripts
Specifying tasks for a grouping task
Creating task actions
Creating notifications of task status
Customizing the notification message
Creating schedules
Scheduling a task
Viewing task progress and statistics
Managing contacts
Viewing related contacts and contact groups
Adding or changing contacts
Adding or changing contact groups
Removing contacts or contact groups
Managing task categories
Viewing tasks in the same category
Adding new task categories
Removing task categories
Managing success code sets
Viewing tasks that use the same success code
Adding or changing success code sets
Removing success code sets
Managing saved schedules
Viewing related tasks that use the same saved schedule
Adding saved schedules
Changing saved schedules
Removing saved schedules
Viewing task, database, and message histories
Moving data
Overview
File formats
Export/import/load utility file formats
Delimited ASCII (DEL) file format
Example DEL file
DEL data type descriptions
Non-delimited ASCII (ASC) file format
Example ASC file
ASC data type descriptions
PC version of IXF file format
PC/IXF record types
PC/IXF data types
PC/IXF data type descriptions
General rules governing PC/IXF file import into databases
Data type-specific rules governing PC/IXF file import into databases
FORCEIN option
Differences between PC/IXF and Version 0 System/370 IXF
Worksheet File Format (WSF)
Delimiter restrictions for moving data
Differences between the import and load utility
Moving data between typed tables
Traverse order
Selection during data movement
Examples of moving data between typed tables
Bind files used by the export, import and load utilities
Export/import/load utility Unicode considerations
Exporting data - overview
Privileges, authorities and authorization
Exporting data with the DB2 Control Center
Specifying file options when exporting data to a file
Adding column names when exporting a file
Specifying options for exporting DEL data
Modifying columns when exporting a file
Exporting data
Using export with identity columns
Recreating an exported table
Exporting large objects (LOBS)
Exporting data in parallel
Export sessions - CLP examples
Importing data - overview
Privileges, authorities, and authorization
Importing data with the DB2 Control Center
Specifying file options
Specifying import options
Mapping columns for non delimited ASCII format (ASC)
Mapping columns for delimited ASCII format (DEL)
Specifying options for work sheet format (WSF) data
Mapping columns for integrated exchange format (IXF)
Specifying options for importing ASC data
Specifying options for importing DEL data
Specifying options for importing IXF data
Importing data
... in a client/server environment
... with buffered inserts
... with identity columns
... with generated columns
... to recreate an exported table
Importing large objects (LOBS)
Importing user-defined distinct types (UDTs)
Table locking during import
Character set and NLS considerations
Import sessions - CLP examples
Loading data - overview
Privileges, authorities, and authorizations
Loading data with the DB2 Control Center
Loading data into a table
Specifying options for loading positional text data into a table
Specifying options for loading DEL data into a table
Modifying the list of target table columns
Loading data
Enabling read access during load operations
Building indexes
Using load with identity columns
Using load with generated columns
Moving data using the cursor file type
Maintaining referential integrity
Pending states after a load operation
Table locking, table states and table space states
Checking for integrity violations
Load exception table
Restarting an interrupted load operation
Refreshing dependent immediate materialized query tables
Propagating dependent immediate staging tables
Multi-dimensional clustering considerations
Recovering data with the load copy location file
Load dump file
Load temporary files
Load utility log records
Optimizing load performance
Parallelism and loading
Character set and national language support
Load - CLP examples
Loading data in a partitioned database environment
Using load in a partitioned database environment
Monitoring a partitioned database load using the LOAD QUERY command
Restarting or terminating a load operation in a partitioned database environment
Partitioned database load configuration options
Example partitioned database load sessions
Migration and back-level compatibility
Loading data in a partitioned database environment - hints and tips
Moving DB2 Data Links Manager data
Exporting DB2 Data Links Manager data
Importing DB2 Data Links Manager data
Loading DB2 Data Links Manager data
Moving data between systems
Moving data with DB2 Connect
Using Replication to move data
IBM Replication tools by component
Using the Data Warehouse Center to move data
Data recovery
Developing a backup and recovery strategy
Deciding how often to back up
Storage considerations
Keeping related data together
Using different operating systems
Crash recovery
Recovering damaged table spaces
Recovering table spaces in recoverable databases
Recovering table spaces in non-recoverable databases
Reducing the impact of media failure
Reducing the impact of transaction failure
Recovering from transaction failures in a partitioned database environment
Recovering from the failure of a database partition server
Recovering indoubt transactions on mainframe or midrange servers
... with DB2 syncpoint manager
... without DB2 syncpoint manager
Disaster recovery
Version recovery
Rollforward recovery
Incremental backup and recovery
Restoring from incremental backup images
Limitations to automatic incremental restore
Monitoring the progress of backup, restore and recovery operations
Understanding recovery logs
Configuring logging options
Log mirroring
Reducing logging with the NOT LOGGED INITIALLY parameter
Configuration parameters for database logging
Managing log files
Managing log files through log archiving
Log file allocation and removal
Blocking transactions when the log directory file is full
On demand log archive
Using raw logs
Including log files with a backup image
How to prevent losing log files
Understanding the recovery history file
Garbage collection
Understanding table space states
Enhancing recovery performance
Backup
Privileges, authorities, and authorization required to use backup
Using backup
Backing up databases using Control Center
Backing up to tape
Backing up to named pipes
Backup sessions - CLP examples
Optimizing backup performance
Recover
Privileges, authorities, and authorization required to recover databases
Using recover
Cross-node recovery with db2adutl
Restore
Privileges, authorities, and authorization required to restore databases
Restoring databases
Restoring databases using Control Center
Taking database partitions out of the rollforward pending state
Taking a table space partition out of the rollforward pending state
Using incremental restore in a test and production environment
Redefining table space containers during a restore operation (redirected restore)
Restoring to an existing database
Restoring to a new database
Optimizing restore performance
Restore sessions - CLP examples
Rollforward
Privileges, authorities, and authorization
Using rollforward
Rolling forward changes in a table space
Recovering a dropped table
Using the load copy location file
Synchronizing clocks in a partitioned database system
Client/server timestamp conversion
Rollforward sessions - CLP examples
Configuring a Tivoli Storage Manager client
Data Links Manager
Database recovery using DB2 utilities with the Data Links File Manager
DB2 utilities and the Data Links File Manager
High availability
High availability through log shipping
High availability through online split mirror and suspended i/o support
Using a split mirror as a clone database
Using a split mirror as a standby database
Using a split mirror as a backup image
Fault monitor facility for UNIX based systems
High availability disaster recovery (HADR) overview
System requirements
Requirements for high availability disaster recovery
Restrictions
Standby database states
Synchronization modes
Managing HADR
Initializing HADR
Stopping HADR
Database configuration for HADR
Managing HADR using Control Center
Setting up HADR databases
Stopping HADR
Starting HADR
Switching database roles in HADR
Performing a failover operation
Automatic client reroute and HADR
Index logging and HADR
Replicated operations for HADR
Non-replicated operations for HADR
Cluster managers and HADR
Switching the database roles
Using HADR takeover during a failover
Reintegrating a database after a takeover operation
Performing a rolling upgrade in a HADR environment
High availability on AIX
High availability on the Windows operating system
High availability in the Solaris Operating Environment
High availability in the Solaris Operating Environment
High availability on Sun Cluster 3.0
High availability with VERITAS Cluster Server
Data Links server (AIX)
Administering Query Patroller
Starting Query Patroller
Enabling Query Patroller to intercept queries
Stopping Query Patroller
Query processing by Query Patroller
Managing users
Administering operators
Query Patroller operators
Query Patroller operator profiles
Creating operator profiles for users and groups
Suspending or restoring operator privileges for users and groups
Administering submitters
Query Patroller submitters
Query Patroller submitter profiles
Configuring submitter profiles
Creating submitter profiles for users and groups
Setting submitter resource limits
Suspending or restoring submitter privileges for users and groups
Administering query submission preferences
Setting preferences for another submitter
Setting your own preferences
Managing queries with Query Patroller
Managed query status
Changing the status of queries using Query Patroller
Viewing managed query details using Query Patroller
Viewing the SQL of managed queries using Query Patroller
Viewing result tables using Query Patroller
Running held queries at a scheduled time
Scheduling the start time for running held queries
Analyzing historical data
Query Patroller historical analysis interface
Enabling collection of historical data
Uses for historical analysis reports
Collecting historical data
Generating historical data
Determining when historical data was last generated
Viewing historical query details
Viewing index details
Managing space
Setting Query Patroller maintenance schedules for queries and result tables
Managing historical queries
Scheduling purges of managed queries and result tables
Scheduling purges of historical queries
Dropping result tables manually using Query Patroller
Removing managed queries manually
Removing historical queries manually
Administering Data Links and Data Links Manager
Data Links Manager concepts and operations
Data Links Manager file control
DATALINK column configuration
Data Links servers
File system prefixes
Linked and unlinked files
DB2 database and DB2 Data Links Manager file access controls
Backup and recovery of linked files
Examples of using UDFs to access linked files
Movement of Data Links Manager data
System management options
Data Links server file backups
Backup storage location
Size considerations
Using Tivoli Storage Manager as an archive server (AIX)
Using Tivoli Storage Manager as an archive server (Solaris Operating Environment)
Using Tivoli Storage Manager as an archive server (Windows)
Using a local directory for the archive area
Using an XBSA-compliant storage manager
Authorizing users to perform actions
Configuration tuning
Synchronizing system clocks
Server environment management
Setting the number of copy processes
Administering Data Links File Manager
DB2 Data Links Manager typical setups
Basic Data Links File Manager tasks
Restarting the DLFM after an abnormal termination
Basic operations: starting, stopping, and restarting the DLFM
Creating additional Data Links File Systems on a Data Links server
Modifying a Data Links File System
Adding DB2 databases to a DLFM on a Data Links server
Adding DLFMs to a specific DB2 database on the DB2 host
Dropping Data Links Manager from a specific DB2 database on the DB2 host
Enabling the Data Links Manager Replication daemon
Working with the Data Links File Manager
Restarting the DLFM after an abnormal termination
Enabling and registering file systems with DLFM (AIX, Solaris Operating Environment)
Registering a drive with DLFF (Windows operating systems)
Listing registered file systems (AIX, Solaris Operating Environment)
Listing registered drives (Windows operating systems)
Registering, querying and de-registering a DLFF (Windows operating system)
Increasing a DLFF-controlled file system size (AIX, Solaris Operating Environment)
Registering DB2 Universal Databases with the Data Links server
Listing databases registered with the Data Links server
Removing information about a DB2 database from Data Links Manager
Data Links Filesystem Filter (DLFF) Logging
Changing the diagnostic level for error message log files
Modifying logging for DLFF processing (Windows operating systems)
Logging messages after the DLFF driver has been loaded (AIX)
Modifying logging for Data Links Filesystem Filter (DLFF) processing (AIX)
Minimizing logging for Data Links Filesystem Filter (DLFF) processing (Solaris Operating Environment)
Retrieving archive server backup file information
Enabling and registering file systems with DLFM (AIX, Solaris Operating Environment)
Listing registered file systems (AIX, Solaris Operating Environment)
Monitoring the DLFM background processes
Monitoring the DLFM background processes (AIX, Solaris Operating Environment)
Monitoring the DLFM background processes (Windows)
Registering a drive with DLFF (Windows operating systems)
Listing registered drives (Windows operating systems)
Loading, querying and unloading a DLFF
Loading, querying, and unloading (AIX)
Loading, querying, and unloading (Solaris Operating Environment)
Modifying logging for DLFF
Modifying logging for Data Links Filesystem Filter (DLFF) processing (AIX)
Logging messages after the DLFF driver has been loaded (AIX)
Minimizing logging for Data Links Filesystem Filter (DLFF) processing (Solaris Operating Environment)
Changing the diagnostic level for error message log files
Removing information about a DB2 database from Data Links Manager
Retrieving archive server backup file information
Listing databases registered with the Data Links server
Registering DB2 Universal Databases with the Data Links server
Data Links File Manager server availability issues
DB2 utilities and the Data Links File Manager
Database recovery using DB2 utilities with the Data Links File Manager
Setting up high availability support with the Data Links server (AIX)
Replicating linked files with DB2 DataPropagator
An overview of how linked files get replicated
How the Data Links Manager replication daemon works
Setting up replication of linked files
Operating replication to replicate linked files
Data replication example with DB2 Data Links Manager
Administering Spatial Extender
Geometries
Properties of geometries
Enabling a database for spatial operations
Inventory of resources supplied for your database
Coordinate systems
Geographic coordinate system
Projected coordinate systems
Selecting or creating coordinate systems
Viewing the details of a coordinate system
Setting up spatial reference systems
Deciding whether to use a default spatial reference system or create a new system
Viewing the details of a spatial reference system
Spatial reference systems supplied with DB2 Spatial Extender
Conversion factors that transform coordinate data into integers
Creating a spatial reference system
Calculating scale factors
Determining minimum and maximum coordinates and measures
Calculating offset values
Setting up spatial columns
Creating spatial columns
Registering and populating spatial columns
Importing and exporting spatial data
Importing shape data to a new or existing table
Importing SDE transfer data to a new or existing table
Exporting data to a shapefile
Exporting data to an SDE transfer file
Geocoders and geocoding
Viewing the details of a geocoding
Reference data
Setting up access to reference data
Registering a geocoder
Setting up geocoding operations
Setting up a geocoder to run automatically
Running a geocoder in batch mode
Using indexes to access spatial data
Types of spatial indexes
Viewing the details of a spatial index
Spatial grid indexes
Considerations for number of index levels and grid sizes
Creating spatial grid indexes
CREATE INDEX statement for a spatial grid index
Tuning spatial grid indexes with the Index Advisor
Determining grid sizes for a spatial grid index
Analyzing spatial grid index statistics
The gseidx command
Using views to access spatial columns
Analyzing and generating spatial information
Environments for performing spatial analysis
Examples of how spatial functions operate
Functions that use indexes to optimize queries
Invoking commands for setting up DB2 Spatial Extender and developing projects
Administering DB2 Geodetic Extender
When to use DB2 Geodetic Extender and when to use DB2 Spatial Extender
Geodetic concepts
Geodetic datums
Geodetic latitude and longitude
Geodesic distances
Geodetic regions
Geodetic spheroids
Enabling Geodetic Extender
Inventory of resources supplied for your database
Setting up and enabling DB2 Geodetic Extender
Setting up spatial reference systems
Deciding whether to use a default spatial reference system or create a new system
Viewing the details of a spatial reference system
Spatial reference systems supplied with DB2 Spatial Extender
Conversion factors that transform coordinate data into integers
Creating a spatial reference system
Calculating scale factors
Determining minimum and maximum coordinates and measures