DB2 Information Center home
Documentation
DB2 troubleshooting information
DB2 PDF and printed documentation
Documentation updates
Updates available for download
Updating the DB2 Information Center
Mirroring the update site
From a CD
DB2 Information Center
DB2 Information Center installation options
Starting the DB2 Information Center
Navigating in the information center
Searching the information center
Setting bookmarks in the information center
Accessing different versions of the DB2 Information Center
Displaying topics in your preferred language
Getting more from the DB2 Information Center
Accessibility
Keyboard shortcuts and accelerators
Accessing help from a DB2 tool, window, wizard or advisor
Terms and Conditions
Product overviews
Database systems
What's new
Fix pack summary
New features and functionality
Highlights of Version 9.1
Information as a service (native XML data store)
More agile development
Autonomic computing
Improved large database management using table partitioning
Secure and resilient
Manage your business, not your database
Hardware and operating system support
Product, packaging, and terminology changes
New name for DB2 Universal Database for Linux, UNIX, and Windows
New names for DB2 Information Integrator
DB2 Version 9.1 component replacements and name changes
DB2 product-line changes
Distribution key terminology change
Native XML data store support
XML schema, DTD, and external entity management using the XML schema repository (XSR)
XQuery language support
XQuery builder
DB2 Net Search Extender support for the XML data type
Application development support - native XML data store
Application programming language support for XML
XML data type support in SQL and external procedures
XML support in Developer Workbench
XML support in SQL statements and SQL/XML functions
XML support in SQL Assist
Annotated XML schema decomposition
FP4: XQuery upper-case and lower-case functions support locales
Performance considerations - native XML data store
Indexes over XML data
FP2: Annotated XML schema decomposition performance is improved
Performance guidelines for XML indexing
RUNSTATS command support for the native XML data store
Optimizer support for the native XML data store
Administration tools support - native XML data store
Control Center support for the native XML data store
Explain and Visual Explain support for SQL/XML and XQuery statements
Command Line Processor (CLP) and command line tool support - native XML data store
DB2 command line processor support for the native XML data store
db2batch command changes
db2look command changes for the native XML data store
Import and export utility support for the native XML data store
Application development enhancements
BINARY, VARBINARY, and DECFLOAT data type support in .NET and CLI client applications
Client support for trusted connections to DB2 for z/OS databases
Command line processor (CLP) 64KB limit for SQL statements has been removed
DB2 .NET Data Provider enhancements and support for .NET Framework 2.0 and 3.0
Developer Workbench replaces the Development Center
External table function support across database partitions
FP1: Optimization profile table can be created through a stored procedure
FP3: COLLATION_KEY_BIT scalar function added
IBM Database Add-Ins for Microsoft Visual Studio 2005 enhancements
Java procedure class loader enhancements
JDBC and SQLJ enhancements
New and changed development software support
New samples
SAMPLE database enhancements
STRIP and TRIM scalar functions added
FP5: Micro Focus Server Express, Version 5.0, supported (Linux on Power)
Backup, logging, and recovery enhancements
Continue a recover operation that ended during the rollforward phase
Rebuild database function provides new restore options
Redirected restore operation using an automatically generated script
Tivoli Storage Manager support added (Windows x64)
Client and connectivity enhancements
A single client (DB2 Client) provided for application development and administration
Connection timeout support for database applications added
DB2 Runtime Client enhancements (Windows)
Internet Protocol Version 6 (IPv6) support added
ODBC and CLI applications can now run without a DB2 client
Federation enhancements
Asynchrony optimization support improves query performance
Create Cache Table wizard enhancements
Error tolerance supported in nested table expressions
Nickname statistics system procedure performance enhancements
Statement level isolation for nicknames
Two-phase commit for multivendor data sources is available
User mapping retrieval from an external repository is now supported
Write operations supported on DRDA LOB data
Installation, migration, and fix pack enhancements
Coexistence of multiple DB2 versions and fix packs enhancements (Linux and UNIX)
Coexistence of multiple DB2 versions and fix packs now supported (Windows)
FP2: Databases should be updated using the db2updv9 command
FP2: DRDA and Informix wrapper support added (HP-UX IA64)
FP2: Windows Server 2008 support added
FP2: Windows Vista support added (Windows)
FP3: Query Patroller support added (HP-UX IA64)
FP4: AIX 6.1 workload partition support added
FP4: Net Search Extender support added (HP-UX IA64)
FP6: Support added for Windows Server 2008 Failover Clusters in partitioned database environments
Installation of DB2 products without using an Administrator user ID now supported (Windows)
Live Partition Mobility support added
Manual installation enhancements (Linux and UNIX)
Migration resources for DB2 database systems added
New DB2 product uninstall features using the db2unins command (Windows)
Response file enhancements
Update capabilities added to the DB2 Information Center
What's new for V9.1 FP8: The client fix pack download location has changed
Manageability enhancements
Adaptive, self-tuning memory allocation
ALTER TABLE statement enhancements
Automated evaluation of object maintenance policies by the DB2 UDB for z/OS health monitor
Automatic storage enhancements
Automatic table and index reorganization enhancements
Buffer pool identifiers displayed in database memory output
Copy schema support added
Enhanced access to DB2 administration commands through SQL
EXEC SQL utility support added for loading data into DB2 UDB for z/OS tables
Fast communications manager (FCM) enhancements
First Steps interface enhancements
FP4: Lock timeout diagnosis has been enhanced
FP5: db2pd command output provides more information
FP6: db2pd and db2pdcfg can be run by more users
FP6: Adding client information to transaction event monitor
Identifier length limits increased to 128 bytes for additional objects and names
Limits for log file size and active log space have increased
Load support added for partitioned tables
New SQL Monitor Area (SQLMA) for monitoring information flow in partitioned database environments
MANUAL keyword added to UPDATE DATABASE CONFIGURATION command
National language enhancements
FP3: COLLATION_KEY_BIT scalar function added
FP4: UPPER (UCASE) and LOWER (LCASE) scalar functions support locales
Unicode support for character-based string functions
FP8: GB18030 code set support has been extended
Performance enhancements
Enhanced query performance using statistical views
Faster data loading using SOURCEUSEREXIT customizable user exit
FP2: New keyword can improve query performance in DPF environments
FP2: DB2_MEMALLOCATE_HIGH registry variable can reduce memory fragmentation (Windows)
FP4: New DB2_WORKLOAD values are available for 1C and Tivoli Provisioning Manager
Load from cursor with remote fetch
Materialized query table (MQT) enhancements
Online processing of the SET INTEGRITY statement
Optimizer registry variable and keywords added
Row compression support added
64 KB page size support added for POWER5+ processors (AIX)
FP5: TCP socket buffer size for HADR connections can be tuned
FP7: Veritas Fast Allocation is supported (AIX, Solaris, HPUX and Linux)
FP7: New db2advis command parameters
FP8: Additional system monitoring information can be generated
Replication enhancements
Replication Alert Monitor can be suspended for defined time periods
Capture program can ignore transactions in the DB2 log
Scalability enhancements
Increased maximum number of index columns and maximum size of index keys
Larger system and user temporary tables
Table size limits increased to 1.1 trillion rows and 16 terabytes
Security enhancements
Data access security improved through label-based access control (LBAC)
Disable the client change password capability
FP2: domain group support added for the db2extsec command (Windows)
FP2: Secure Sockets Layer (SSL) protocol is supported by the database server
FP3: Change password support added (Linux)
FP5: Secure Sockets Layer (SSL) protocol is supported by the database client
FP6: SERVER_ENCRYPT_AES authentication type added
FP6: LDAP security plug-ins are installed with DB2 database products
LDAP-based authentication supported
RESTRICTIVE option added to CREATE DATABASE command
Security administrator (SECADM) authority added to centralize security privileges
SETSESSIONUSER privilege added
TRANSFER OWNERSHIP statement added
Troubleshooting and problem determination enhancements
Data collection improved for database system failures
High water mark option added to the db2pd -fcm command
Trace mask support added to the db2trc command
FP6: Database monitoring enhanced with the db2top utility (AIX, Linux, and Solaris)
What's changed
Changes in existing functionality
Installation, migration, and fix pack changes
Application and routine migration changes
DB2 install images package format changes (Linux and UNIX)
db2_deinstall command parameter changes (Linux and UNIX)
Documentation updates are available between product releases
FP4: Minimum C++ runtime levels have changed
FP8: IBM Tivoli SA MP 3.1 is required for high availability support (SUSE Linux 11)
Installation CD changes for national language versions of DB2 products (Linux and UNIX)
Licensing support changes
Locally installed Information Center installation restrictions
Migration support changes during installation (Windows)
Migration support changes for DB2 database systems
Multiple CD Installation required for some products (Linux and UNIX)
Database setup changes
Authority required to start the database manager has changed (Windows)
Automatic configuration of prefetchers and page cleaners enabled by default
Automatic self-tuning memory enabled by default during database creation
Automatic statistics collection enabled by default during database creation
Automatic storage enabled by default during database creation
Configuration Advisor enabled by default during database creation
Configuration parameters default value changes
Databases require additional space
database_memory configuration parameter changes
Increased log, table space, and memory requirements due to larger record identifiers (RIDs)
Increased memory required for database connections
Lock lists require additional space
Registry and environment variables default value changes
The -w option of the db2icrt, db2ilist, and db2iupdt commands is deprecated
32-bit DB2 database instance support changes
Administration changes
Application ID format changed
Backup image naming convention has changed (Windows)
Catalog table changes in support of table partitioning
Collating sequence IDENTITY replaces BINARY in command output
db2mtrk command changes (Windows)
Data movement utilities changes
DMS table space type default value changed to LARGE
FP2: domain group support added for the db2extsec command (Windows)
FP3: LDAP Security plug-ins updated
Handling of new database connections has changed
Headers in CLP output are no longer displayed in Japanese
Load from cursor incompatibilities with previous releases
Location of diagnostic messages for automatic maintenance
New DB2 agents might affect MAX_CONNECTIONS configuration and application monitor output
REORGCHK command output changes
ROLLFORWARD DATABASE output has changed
SET SESSION AUTHORIZATION requires SETSESSIONUSER privilege
sheapthres_shr configuration parameter change
Table space-level point-in-time rollforward operation restrictions
TSM management class no longer used as a basis for filtering when restoring or retrieving logs
Write-to-table event monitor changes
Application development changes
Application and routine feature support changes
Changed parameters and output for the db2batch command
CURRENT TIMESTAMP special register might return duplicate values
Cursor blocking is disabled in SQL procedures
DB2 Embedded Application Server updated
FP1: Availability of LOB or XML values in JDBC applications with progressive streaming
FP1: Modification level of product identifier can contain alphanumeric characters
Support for new versions of the IBM Software Development Kit (SDK) for Java is added
Removal of mutating table conflicts when calling procedures from triggers
Reverse scans enabled by default for indexes, primary keys and unique keys
Sample build scripts updated
Deprecated functionality
Check pending table state is replaced and iCheckPending parameter is deprecated
CLISchema CLI keyword is deprecated
COLNAMES column from SYSCAT.INDEXES is deprecated
Database logging using raw devices is deprecated
DB2 JDBC Type 2 driver is deprecated
db2ilist command options are deprecated (Linux and UNIX)
DB2LINUXAIO registry variable is deprecated
db2secv82 command is deprecated
Distribution key terminology change
External routines require an explicit entry point specification
FP1: Address Windowing Extensions (AWE) support is deprecated (Windows)
FP2: Network Information Services (NIS and NIS+) support is deprecated (Linux and UNIX)
FP3: DB2 Web Tools support is deprecated
Some SQL administrative routines have been replaced
The ADD PARTITIONING KEY clause of the ALTER TABLE statement is deprecated
The DROP PARTITIONING KEY clause of the ALTER TABLE statement is deprecated
The -w option of the db2icrt, db2ilist, and db2iupdt commands is deprecated
Type 1 indexes are deprecated
Discontinued functionality
Alternate FixPak images are discontinued (UNIX)
Autoloader utility (db2atld) is discontinued
Audio, Image, and Video (AIV) Extenders are no longer supported
Data Links Manager is no longer supported
Data Warehouse Center and the Information Catalog Manager are no longer included
DB2 Administration Tools are no longer supported on some platforms
db2reg2large utility for converting DMS table space size is discontinued
db2profc and db2profp utilities are discontinued
DB2_SCATTERED_IO registry variable is discontinued
Desktop icon and folder making utility are no longer supported (Linux)
Extended Storage option for buffer pools is discontinued
Fast communications manager (FCM) no longer uses Virtual Interface (VI) architecture
FP2: The -schema option of the db2sampl command is discontinued
NetBios and SNA communication protocols are no longer supported
Text Extender is no longer supported
Type 3 JDBC support is discontinued
Vendor load API (sqluvtld) is discontinued
VSE and VM objects are no longer supported in the DB2 Control Center
Documentation enhancements
DB2 Database for Linux, UNIX, and Windows overview
Tutorials
Native XML data store
Visual Explain tutorial
Clients
DB2 Runtime Client
DB2 Client
Servers
DB2 Express-C
DB2 extenders overview
About DB2 Spatial Extender
The purpose of DB2 Spatial Extender
How data represents geographic features
The nature of spatial data
The nature of geodetic data
Where spatial data comes from
Using business data as source data
Using functions to generate spatial data
Importing spatial data
How features, spatial information, spatial data, and geometries fit together
Setting up a database
Configuring a database to accommodate spatial data
Tuning transaction log characteristics
Tuning the application heap size
Tuning the application control heap size
Setting up spatial resources for a database
How to set up resources in your database
Inventory of resources supplied for your database
Enabling a database for spatial operations
How to work with reference data
Reference data
Setting up access to reference data
Registering a geocoder
Setting up spatial resources for a project
How to use coordinate systems
Coordinate systems
Geographic coordinate system
Projected coordinate systems
Selecting or creating coordinate systems
How to set up spatial reference systems
Spatial reference systems
Deciding whether to use a default spatial reference system or create a new system
Spatial reference systems supplied with DB2 Spatial Extender
Conversion factors that transform coordinate data into integers
Offset values
Scale factors
Units for offset values and scale factors
Creating a spatial reference system
Calculating scale factors
Conversion factors that transform coordinate data into integers
Determining minimum and maximum coordinates and measures
Calculating offset values
Creating a spatial reference system
Setting up spatial columns
Spatial columns
Spatial columns with viewable content
Spatial data types
Data types for single-unit features
Data types for multi-unit features
A data type for all features
Creating spatial columns
Registering spatial columns
Setting up DB2 Geodetic Data Management Feature
Setting up and enabling DB2 Geodetic Data Management Feature
Populating spatial columns with geodetic data
Net Search Extender key concepts
SQL scalar search function overview
Stored procedure search overview
SQL table-valued function overview
Additional concepts
Column transformation function
Instance services
Externally stored data
Administration tables and views
Partitioned database support
Indexes on nicknames in a federated database
Native XML support
Key features of DB2 Net Search Extender
Introducing the db2text commands
Incompatibilities between releases
Supported combinations of client and server versions
Deprecated and discontinued features
Version 9 incompatibilities with previous releases and changed behaviors
Standards compliance
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
Information integration
What's new
Information integration overview
Welcome to WebSphere Information Integration
Accessibility features
Introduction to information integration
The foundation of information integration
Problems that WebSphere Information Integration products help solve
Why information integration is important to your enterprise
Products and technologies
Products and components for WebSphere Information Integration
DB2 database system and WebSphere Information Integration
Federation technologies
Relational technologies
Relational wrappers
Nonrelational technologies
Nonrelational wrappers
Life sciences user-defined functions overview
Replication technologies
Event publishing technologies
Tutorials
Basic SQL replication tutorial: DB2 for Windows
Before you begin
Planning the SQL Replication tutorial
Replication options
Replication source
Replication target
Setting up the replication environment for this tutorial
Step 1: Create control tables for the Capture program
Step 2: Enable the source database for replication
Step 3: Register a replication source
Step 4: Create control tables for the Apply program
Step 5: Create a subscription set and a subscription-set member
Step 6: Create an Apply password file
Step 7: Replicate the data for the tutorial scenario
Operating in a replication environment
Step 1: Update the source table
Step 2: View status for the Capture program
Step 3: View status for the Apply program
Step 4: Stop the Capture and Apply programs
Monitoring replication
Step 1: Create control tables for the Monitor program
Step 2: Create a contact for replication alerts
Step 3: Select an alert condition for the Capture program
Step 4: Select an alert condition for the Apply program
Step 5: Start the Replication Alert Monitor for a monitor qualifier
Q replication tutorial
Introduction to the Q replication tutorial
Module 1: Setting up WebSphere MQ
Lesson 1.1: Creating the source and target queue managers
Lesson 1.2: Creating the source queues
Lesson 1.3: Creating the target queues
Lesson 1.4: Creating WebSphere MQ channels
Lesson 1.5: Starting WebSphere MQ channels and listeners
Module 2: Setting up Q replication
Lesson 2.1: Creating the source and target control tables
Lesson 2.2: Enabling the source database for replication
Lesson 2.3: Creating a replication queue map
Lesson 2.4: Creating a Q subscription
Module 3: Starting Q replication
Lesson 3.1: Starting replication between the source and target
Lesson 3.2: Viewing the results of replication
Summary and resources
Federated systems overview
Federated systems
The federated server
What is a data source?
The federated database
Wrappers and wrapper modules
How you interact with a federated system
DB2 command line processor (CLP)
DB2 Command Center
DB2 Control Center
Application programs
DB2 family tools
Rational Data Architect
Web services providers
Supported data sources
Replication and event publishing overview
Introduction to DB2 replication and publishing–Overview
Introduction to SQL replication
Introduction to Q replication
Introduction to event publishing
Administrative interface for DB2 replication and publishing
Utilities for DB2 replication and publishing
SQL replication—Overview
Infrastructure for an SQL replication environment
Registration of sources in SQL replication
Subscription sets in SQL replication
Capture of data from DB2 sources in SQL replication
Application of data to DB2 targets in SQL replication
Capture of data from non-DB2 sources in SQL replication
Application of data to non-DB2 targets in SQL replication
Q replication—Overview
Infrastructure for a Q replication environment
Sources and targets in Q replication
Capture of data in Q replication
Application of data to targets in Q replication
Types of replication in Q replication
Comparison of SQL replication and Q replication—Overview
Comparison of the infrastructure of SQL replication and Q replication
Comparison of sources and targets in SQL replication and Q replication
Comparison of data capturing and applying in SQL replication and Q replication
Replication solutions for common scenarios
Event publishing—Overview
Infrastructure for an event publishing environment
Sources in event publishing
Capture of data in event publishing
Comparison of SQL replication, Q replication, and event publishing
Comparison of Q replication to high availability disaster recovery (HADR)
Comparison of event publishing to DB2 MQ user-defined functions
Documentation
Problems, workarounds, and documentation updates
Version 9.1 and fix packs
Mainframe and midrange server access
What's new
Fix pack summary
DB2 Connect enhancements
DB2 Connect Personal Edition easier to upgrade
32-bit DB2 Connect instance support changes
FP3: DB2 Connect products added (Solaris x86-64)
Documentation enhancements
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 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
WebSphere Federation Server and DB2 Connect
DB2 Connect administration utilities
Documentation
First Steps
DB2 Information Center
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
Ordering printed DB2 books
Release Notes
Notices
Accessibility
Accessibility
Dotted decimal syntax diagrams
Migrating
Database systems
Migrating to DB2 Version 9
Planning migration for your environment
Planning migration for your DB2 servers
Planning migration for DB2 clients
Planning migration for database applications
Migrating DB2 servers
Migration essentials for DB2 servers
What gets migrated
Migration recommendations
Disk space requirements for DB2 database system migration
Migration restrictions
Support changes for 32-bit and 64-bit kernels in DB2 database systems
Functionality not supported in DB2 database system that impacts migration
DB2 client support for migration
Common licensing questions
Pre-migration tasks
Verifying that your databases are ready for migration
Backing up databases before migration
Saving configuration information
Increasing table space and log file sizes before migration
Changing raw devices to block devices (Linux)
Migrating in a test environment
Capturing error and diagnostic information during migration
Taking a DB2 database offline for migration
Migrating a DB2 server (Windows)
Migrating instances
Migrating the DB2 Administration Server (DAS)
Migrating databases
Migrating a DB2 server (Linux and UNIX)
Migrating instances
Migrating the DB2 Administration Server (DAS)
Migrating databases
Migrating environments with specific characteristics
Migrating DB2 32-bit servers to 64-bit systems (Windows)
Migrating DB2 32-bit servers to 64-bit systems (Linux and UNIX)
Migrating databases to another database server
Migrating partitioned database environments
Migrating from a system with multiple DB2 copies (Linux and UNIX)
Migrating from DB2 UDB Version 7 servers (Windows)
Migrating from DB2 UDB Version 7 servers (Linux and UNIX)
Migrating DB2 servers in Microsoft Cluster Server environments
Migrating from DB2 Data Links Manager
Migrating XML Extender
Migrating from XML Extender to native XML data store
Migrating from non-DB2 relational database management systems
Post-migration tasks
Adjusting the log space size in migrated databases
Database activated after migration
Changes in DB2 registry variables, configuration parameters, and database physical design characteristics
Conversion of type-1 indexes in migrated databases
Changes to EXECUTE privilege on PUBLIC for migrated routines
Rebinding packages in migrated databases
Migrating explain tables
Ensuring system temporary table spaces page sizes meet requirements
Verifying migration of DB2 servers
Initialization of HADR replication in migrated databases
Enabling DB2 Version 9 new features in migrated databases
Reversing DB2 databases system migration
Migrating DB2 clients
Migration essentials for DB2 clients
Pre-migration tasks
Saving DB2 clients configuration information
Migrating a DB2 Client (Windows)
Migrating a DB2 Runtime Client (Windows)
Migrating DB2 clients (Linux and UNIX)
Migrating from DB2 clients Version 7 (Windows)
Migrating from DB2 clients Version 7 (Linux and UNIX)
Post-migration tasks
Recataloging nodes and databases using TCP/IP protocol
Verifying migration of DB2 clients
Migrating database applications and routines
Migration essentials for database applications
DB2 command changes
Changed APIs and data structures
Migration essentials for routines
Pre-migration tasks
Migrating database applications
Migrating Embedded SQL applications
Migrating Java applications that use IBM DB2 Driver for JDBC and SQLJ
Migrating Java applications that use DB2 JDBC Type 2 or 3 driver
Migrating ADO.NET applications
Migrating scripts
Migrating 32-bit database applications to 64-bit instances
Migrating routines
Migrating C, C++, and COBOL routines
Migrating Java routines
Migrating .NET CLR routines
Migrating SQL procedures
Migrating 32-bit external routines to 64-bit instances
Post-migration tasks
Migrating Query Patroller
Enabling Query Patroller after migration
Migrating Extenders
Migrating the Spatial Extender environment to a DB2 Version 9 database system
Migrating a spatially-enabled database
Migrating from Informix Geodetic DataBlade to DB2 Geodetic Data Management Feature
The db2se migrate command
Migrating from Informix Geodetic DataBlade to DB2 Geodetic Data Management Feature
Net Search Extender Migration
Migrating WebSphere Information Integration products
Migrating federated systems
Planning to migrate to WebSphere Federation Server
Overview for migrating to WebSphere Federation Server
Supported data sources
Migrated objects
Migration restrictions for federated systems
DataJoiner migration restrictions
WebSphere Information Integrator, version 8 migration restrictions
Migration restrictions
Support changes for 32-bit and 64-bit kernels in DB2 database systems
Functionality not supported in DB2 database system that impacts migration
Migration recommendations
Disk space requirements for DB2 database system migration
Migrating in a test environment
Migrating DB2 applications and server side routines
Reversing DB2 databases system migration
Preparing to migrate to federated systems
Copying configuration settings
Backing up databases before migration
Recording database information before migration
Recording instance information before migration
Capturing error and diagnostic information during migration
Verifying that your databases are ready for migration
Taking a DB2 database offline for migration
Migrating Windows servers
Migrating to WebSphere Federation Server on Windows
Migrating a DB2 server (Windows)
Migrating instances
Migrating the DB2 Administration Server (DAS)
Migrating databases
Migrating explain tables
Migrating databases to another database server
Migrating 32-bit federated systems to 64-bit federated systems on Windows
Migrating Linux and UNIX servers
Migrating to WebSphere Federation Server on Linux and UNIX
Migrating a DB2 server (Linux and UNIX)
Migrating instances
Migrating the DB2 Administration Server (DAS)
Migrating databases
Migrating explain tables
Migrating 32-bit federated systems to 64-bit federated systems on UNIX
Accessing data sources after migration
Configuring federated systems after migration
Restoring configuration settings for federated systems
Converting type-1 indexes to type-2 indexes
Rebinding packages
Changing the wrapper for a data source
Specifying wrapper information in the federated.sql file
Altering the data source version in a server definition (DB2 Control Center)
Altering the data source version in a server definition (DB2 command line)
Setting isolation-level behavior for applications after migration
Configuring XML data sources after migration
Restoring connections to DB2 family data sources
Allowing write operations on LOBs after migrating federated systems
Write operations on large object data types
Accessing DB2 family data sources after migrating to WebSphere Federation Server
Accessing Informix data sources after migrating to WebSphere Federation Server
Accessing Microsoft SQL Server data sources after migrating to WebSphere Federation Server
Accessing ODBC data sources after migrating to WebSphere Federation Server
Accessing Oracle data sources after migrating to WebSphere Federation Server
Accessing Sybase data sources after migrating to WebSphere Federation Server
Accessing Teradata data sources after migrating to WebSphere Federation Server
Modifying existing Teradata configurations
Recreating Teradata configurations
Migration reference
DataJoiner migration
DataJoiner terms and their federation server equivalents
DataJoiner catalog conversion
DB2 data sources
DataJoiner protocols for DB2 family data sources
Changes to default data type mappings for DB2 Universal Database for z/OS and OS/390 data sources
Changes to default data type mappings for DB2 Universal Database for iSeries (AS/400) data sources
Changes to default data type mappings for DB2 Database for Linux, UNIX, and Windows data sources
Changes to default data type mappings for DB2 Server for VSE and VM data sources
Oracle data sources
DataJoiner protocols for Oracle data sources
Changes to default data type mappings for Oracle NET8
Informix data sources
DataJoiner protocols for Informix data sources
Changes to default data type mappings for Informix data sources
Microsoft SQL data sources
DataJoiner protocols for Microsoft SQL Server data sources
Changes to default data type mappings for Microsoft SQL Server data sources
ODBC data sources
DataJoiner protocols for ODBC data sources
Changes to default data type mappings for ODBC data sources
Sybase data sources
DataJoiner protocols for Sybase data sources
Changes to default data type mappings for Sybase data sources
Teradata data sources
DataJoiner protocols for Teradata data sources
Changes to default data type mappings for Teradata data sources
Nonrelational data sources for life sciences
Changes to fixed columns for BLAST nicknames
Changes to KEGG function arguments
Changes to the SSDB function names and accepted arguments
Changes to SSDB database queries
IMPORT and EXPORT commands for nicknames
Migrating to replication and event publishing Version 9
Coexistence support in Version 9 Q replication and event publishing
Migrating different Q replication and event publishing environments to Version 9
Migrating a unidirectional Q replication environment to Version 9
Migrating a bidirectional or peer-to-peer Q replication environment to Version 9
Migrating an event publishing environment to Version 9
Migrating the Q replication and event publishing programs to Version 9 (z/OS)
Migrating the Q Capture program to Version 9 (z/OS)
Migrating the Q Apply program to Version 9 (z/OS)
Migrating the Replication Alert Monitor to Version 9 (z/OS)
Migrating Q replication and event publishing programs to Version 9 (Linux, UNIX, and Windows)
Migrating the Q Capture program to Version 9 (Linux, UNIX, Windows)
Migrating the Q Apply program to Version 9 (Linux, UNIX, Windows)
Migrating the Replication Alert Monitor to Version 9 (Linux, UNIX, Windows)
Migrating the SQL Capture program to Version 9 (z/OS)
Mainframe and midrange server access
Migrating to DB2 Connect Version 9
Migration essentials for DB2 Connect
Pre-migration tasks
Migrating DB2 Connect servers
Post-migration tasks
Installing
Release Notes
Database systems
Mounting the product CD (Linux and UNIX)
AIX
HP-UX
Linux
Solaris
DB2 Database for Linux, UNIX, and Windows
DB2 Setup Wizard national language support
Displaying the db2setup command in your national language
Language identifiers for running the DB2 Setup wizard in another language
Changing the DB2 interface language (Linux and UNIX)
Changing the DB2 interface language (Windows)
Reducing the size of your DB2 product installation image (Windows)
DB2 servers
DB2 installation methods
Installation requirements for DB2 database products
Disk and memory requirements
Java software support for DB2 products
Windows - installation requirements
Additional Windows requirements
DB2 services running on your system (Windows)
Required user accounts for installation of DB2 server products (Windows)
Setting up elevated privileges
Preparing the environment for a partitioned DB2 server (Windows)
Granting user rights (Windows)
DB2 system administrator group (Windows)
Fast communications manager (Windows)
AIX - installation requirements
HP-UX - installation requirements
Linux - installation requirements for DB2 servers (Linux)
Solaris Operating Environment - Installation requirements
Additional Linux and UNIX requirements
Multiple DB2 copies on one system (Linux and UNIX)
Listing DB2 products installed on your system (Linux and UNIX)
Fast communications manager (UNIX)
DB2 users and groups (Linux and UNIX)
Centralized user-management considerations (Linux and UNIX)
Preparing to install DB2 for Linux on zSeries
Creating group and user IDs for a DB2 database installation
Multiple CD installation (Linux and UNIX)
DB2 product installation on an NFS-mounted directory
Verifying port range availability on participating computers (Windows)
Kernel parameters (Linux and UNIX)
Modifying kernel parameters (HP-UX)
Recommended kernel configuration parameters (HP-UX)
Modifying kernel parameters (Linux)
Modifying kernel parameters (Solaris Operating Environment)
Additional partitioned database environment pre-installation tasks (Linux and UNIX)
Updating environment settings for a partitioned DB2 installation (AIX)
Setting up a working collective to distribute commands to ESE workstations (AIX)
Copying the contents of the DB2 product CD to your computer (Linux and UNIX)
Verifying port range availability on participating computers (UNIX)
Creating a DB2 home file system for a partitioned database environment
AIX
HP-UX
Linux
Solaris
Verifying that NFS is running (UNIX)
Java software support for DB2 products
Installing DB2 servers (Windows)
Installing DB2 servers (Linux and UNIX)
Setting up a partitioned database environment
Verifying your installation
Using First Steps to verify the installation of DB2 servers (Linux and Windows)
Using the command line processor (CLP) to verify the installation
Verifying a partitioned database server installation (UNIX)
Verifying a partitioned database environment installation (Windows)
Directory structure for your DB2 database product (Windows)
Directory structure for your DB2 database product (Linux)
Post-installation tasks
Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)
Upgrading your 32-bit DB2 instances to 64-bit instances (Windows)
Updating the node configuration file (UNIX)
DB2 node configuration file - db2nodes.cfg
Applying fix packs
Enabling communications between database partition servers (UNIX)
Enabling the execution of remote commands (Linux and UNIX)
Enabling Control Center administration (Linux)
Setting up notification and contact lists
DB2 Version 9 co-existence and migration with DB2 UDB Version 8 (Windows)
Using the Default DB2 Selection wizard
Applying DB2 licenses
Working with existing DB2 copies
DB2 clients
Methods for installing DB2 clients
Options for connecting to DB2 databases
DB2 Setup Wizard national language support
Language identifiers for running the DB2 Setup wizard in another language
Displaying the db2setup command in your national language
Disk and memory requirements
UNIX
AIX - installation requirements
HP-UX - installation requirements
Recommended kernel configuration parameters (HP-UX)
Modifying kernel parameters (HP-UX)
Linux - installation requirements for DB2 servers (Linux)
Modifying kernel parameters (Linux)
Solaris Operating Environment - Installation requirements
Modifying kernel parameters (Solaris Operating Environment)
Windows
Windows - installation requirements
Alternative installation methods
Thin client topology
Thin client setup overview
Installing a DB2 Client or DB2 Connect Personal Edition on the code server
Making the code directory available to all thin workstations
Creating a thin client response file
Mapping a network drive from each thin client to the code server
Running the thnsetup command to enable thin clients
DB2 Runtime Client installation command line options
DB2 Runtime Client merge modules
Host connection requirements
Changing DB2 product editions
Moving between DB2 database products (Linux and UNIX)
Moving between DB2 database products (Windows)
DB2 extenders
Getting started with DB2 Spatial Extender
Setting up and installing Spatial Extender
System requirements for installing Spatial Extender
Installing DB2 Spatial Extender for Windows
Installing DB2 Spatial Extender for AIX
Installing DB2 Spatial Extender for HP-UX
Installing DB2 Spatial Extender for Solaris Operating Environment
Installing DB2 Spatial Extender for Linux
Creating the DB2 Spatial Extender instance environment
Verifying the Spatial Extender installation
Post-Installation considerations
Downloading ArcExplorer for DB2
Accessing geocoder reference data
Net Search Extender
Installing Net Search Extender in the DB2 client/server environment
Installation system requirements
Installation overview for a partitioned DB2 server (AIX only)
Installation on UNIX
Installation on Windows
Directory names and file names
Installing the Outside In libraries
Installation verification
Installation verification on UNIX
Installation verification on Windows
Uninstalling Net Search Extender
Uninstalling Net Search Extender on UNIX
Uninstalling Net Search Extender on Windows
DB2 Query Patroller
Installation environment overview
Installing Query Patroller (Linux and UNIX)
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 Query Patroller (Windows)
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
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
Installing database partition servers using a response file (UNIX)
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
Uninstalling 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 9 using SMS
Configuring remote access to a server database
Configuring db2cli.ini for a response file installation
Response file generator
db2rspgn - Response File Generator
Response file installation error codes
Installing with batch files
Available sample response files
Response file keywords
Embedding the DB2 installation image (Linux and UNIX)
Exporting and importing a profile
Stopping DB2 processes during an interactive installation (Windows)
Stopping DB2 processes during a response file installation
Managing licenses
DB2 license files
Applying DB2 licenses
Registering a license key using the License Center
Registering a license key using the db2licm command
Upgrading your DB2 license
Checking license compliance
License Center overview
Changing licenses and policies
Viewing licensing information
Viewing concurrent users policy information
Viewing authorized user infraction information
Viewing and resetting compliance details
Removing licenses
Manually installing DB2 products
Installing with the db2_install script (Linux and UNIX)
Multiple DB2 copies on one system (Linux and UNIX)
Manually installing payload files (Linux and UNIX)
Creating required users for a DB2 server installation in a partitioned database environment
AIX
HP-UX
Linux
Solaris
Verifying access to the registry on the instance-owning computer (Windows)
Setting up DB2 servers after manual installation
Creating group and user IDs for a DB2 database installation
Creating a DB2 Administration Server
Creating an instance using db2icrt
Creating links for DB2 files
Updating the services file on the server for TCP/IP communications
Configuring TCP/IP communications for a DB2 instance
DB2 Web applications
DB2 Web Tools
DB2 Web Command Center
DB2 Heath Command Center
Deploying on DB2 Embedded Application Server
Deploying on WebSphere application servers
Troubleshooting deployment
Uninstalling from the DB2 Embedded Application Server
Uninstalling from the WebSphere application server
DB2WebServices application
Deploying
Undeploying
DB2 Embedded Application Server
Installing
Starting or stopping the server
Uninstalling the DB2 Embedded Application Server
Uninstalling
DB2 (Linux and UNIX)
Stopping the DB2 administration server
Stopping DB2 instances
Uninstalling fix packs
Removing DB2 instances
Removing DB2 products using the db2_deinstall command
Removing the DB2 administration server
DB2 (Windows)
Uninstalling the DB2 Embedded Application Server
Information integration
Planning to install WebSphere Information Integration products
Planning overview
Hardware and software requirements
Data source requirements
Supported data sources
Prerequisites for installing relational wrappers
Installing ODBC drivers
Installing the ODBC driver for 32-bit systems
Installing the ODBC driver for 64-bit systems
Upgrading the ODBC driver
Installing the DataDirect Technologies Connect ODBC driver (UNIX and Linux)
Installation scenarios
Installation planning worksheet
Enabling federated access to DB2 and Informix data sources
Enabling federated access to the DB2 family of data sources
Enabling federated access to Informix data sources
Installing WebSphere Information Integration
Installation process
Editing the Oracle 9i genclntsh script and creating the libclntsh file before installation (HP-UX, Linux, and Solaris)
Installing WebSphere Information Integration products (Windows)
Installing WebSphere Information Integration products (UNIX and Linux)
Silent installation
Confirming and registering the Microsoft SQL Server Client Version 2000 driver (Windows)
Editing the Oracle 9i genclntsh script and creating the libclntsh file after installation (HP-UX, Linux, and Solaris)
Editing the Oracle 10g genclntsh script and creating the libclntsh file after you install WebSphere Information Integration products (HP-UX and Linux)
Updating WebSphere Information Integration documentation
Adding relational wrappers, nonrelational wrappers, and user-defined functions
Installing fix packs
Installing the wrapper development kit
Adding the wrapper development kit to a system where DB2 is installed (Windows)
Adding the wrapper development kit to a system with DB2 installed (UNIX)
Troubleshooting
Registering the product license keys
Enabling error logging for the installation wizard
Troubleshooting errors when selecting TEXT data from an Informix nickname
Removing WebSphere Information Integration from your environment
Removing WebSphere Information Integration products
Removing the product licensing
Removing wrappers and life sciences user-defined functions (Windows)
Removing wrappers and user-defined functions (UNIX and Linux)
Mainframe and midrange server access
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
Installation requirements
Required user accounts for installation of DB2 server products (Windows)
LDAP: Extending the directory schema
Non-Administrator installation of DB2 Connect
DB2 Connect Personal Edition
Typical steps for installing DB2 Connect Personal Edition
Linux
Installation requirements
Mounting CD-ROMs
Installing DB2 Connect Personal Edition
Solaris
Installation requirements
Mounting CD-ROMs
Installing DB2 Connect Personal Edition (Solaris)
Windows
Installation requirements
Required user accounts for installation of DB2 Connect Personal Edition
LDAP: Extending the directory schema
Installing DB2 Connect Personal Edition
Installing without Administrator authority
DB2 Connect license keys
Using the License Center
Registering DB2 Connect license keys
Setting the license type
Using the db2licm command
Registering DB2 Connect license keys
Setting the license type
Server requirements for client connections
DB2 Information Center
Deleting a Firefox or Netscape browser profile
Installing the DB2 Information Center using the DB2 Setup wizard (Linux)
Installing the DB2 Information Center using the DB2 Setup wizard (Windows)
DB2 Information Center installation options
Updating the DB2 Information Center
Configuring
Database systems
Client-to-server communications
Communication protocols supported
Configuring Secure Sockets Layer (SSL) support in the DB2 client
Configuring client-to-server connections using the Configuration Assistant (CA)
Manually
Cataloging databases using discovery
Client profile method
Creating a client profile
Using a client profile
Testing database connections
LDAP considerations
Adding database connections with the CLP
Named pipe connections
Named Pipes worksheet
Cataloging the node
TCP/IP connections
TCP/IP worksheet
Updating hosts and services files for TCP/IP connections
Cataloging the node
Cataloging the database
Worksheet for cataloging a database
Testing the client-to-server connection using the CLP
Configuring communication protocols for a DB2 instance
Configuring Named Pipes communications for a DB2 instance
Configuring Secure Sockets Layer (SSL) support in a DB2 instance
Configuring TCP/IP communications for a DB2 instance
Updating the services file on the server for TCP/IP communications
Updating the database manager configuration file on the server for TCP/IP communications
Setting communication protocols for a DB2 instance
DB2 server communications configuration using the Control Center
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
BEA Tuxedo
Configuration Assistant overview
Systems
Removing a system
Instance nodes
Removing an instance node
Instance configurations
Configuring communication protocols for a local DB2 instance
Configuring communication protocols for a remote DB2 instance
Databases
Removing a database
Changing a password
Removing CLI keywords
Data sources
Removing a data source
Bind options
Removing bind options
Profiles
Exporting a configuration profile using the Configuration Assistant
Importing a configuration profile
Registry variables
Removing DB2 registry variables
Configuration parameters
Configuring parameters dynamically
Application development environment
DB2 Client
Database manager instances
DB2 supported servers
Setting up the application development environment
Statically and dynamically linking libraries
Rebuilding DB2 routine shared libraries
Updating the database manager configuration file
Setting up the CLI environment
Setting up the UNIX application development environment
UNIX environment variable settings
CLI
Setting up the UNIX ODBC environment
Sample configurations
Setting up the UNIX Java environment
Setting up the Windows application development environment
Setting up the Windows CLI environment
Selecting a DB2 copy for Windows CLI applications
Sample files
Creating the sample database
Creating the sample database on Host or AS/400 and iSeries servers
Cataloging the sample database
Binding the sample database utilities
Application behavior
Isolation levels
Specifying isolation levels
Configuring CLI/JDBC/ODBC/SQLJ behavior with db2cli.ini
Setting CLI environment, connection, and statement attributes
Automatic maintenance of your database
Automatic features enabled by default
Configuring automatic maintenance of your databases
Automatic statistics collection
Enabling automatic statistics collection
Enabling automatic table and index reorganization
Enabling automatic backup
Self tuning memory roadmap
Self-tuning memory
Enabling self-tuning memory
Disabling self-tuning memory
Determining which memory consumers are enabled for self tuning
Operational details and limitations
Self-tuning memory in partitioned database environments
Using self tuning memory in partitioned database environments
Query Patroller
Setting up Query Patroller server manually
Administering Query Patroller
Starting Query Patroller
Enabling Query Patroller to intercept queries
Stopping Query Patroller
Query processing by Query Patroller
Managing users
Administering operators
Operators
Query Patroller operator profiles
Creating operator profiles for users and groups
Suspending or restoring operator privileges for users and groups
Administering submitters
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 individual query submission preferences
Managing queries
Managed query status
Changing the status of queries using Query Patroller
Query Patroller variables
Viewing managed query details
Viewing the SQL of managed queries using Query Patroller
Result tables and result sets in Query Patroller
Viewing result tables using Query Patroller
Running held queries at a scheduled time
Scheduling the start time for running held queries
Cost estimation in Query Patroller
Definition of your query management policy
Query Patroller 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
Scheduling purges of managed queries and result tables
Scheduling purges of historical queries
Dropping result tables manually using Query Patroller
Removing orphaned result table aliases
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
Query Patroller query classes
Query Patroller thresholds
Using Query Patroller with other DB2 components
Methods for searching text
Searching for text using the SQL scalar search functions
Issuing a query
Searching and returning the number of matches found
Searching and returning the score of a found text document
Specifying SQL search arguments
Searching for terms in any sequence
Searching with the Boolean operators AND and OR
Searching with the Boolean operator NOT
Fuzzy search
Searching for parts of a term (character masking)
Searching for terms that already contain a masking character
Searching for terms in a fixed order
Searching for terms in the same sentence or paragraph
Searching for terms in sections of structured documents
Thesaurus search
Numeric attribute search
Free-text search
Additional search syntax examples
Searching for text using a stored procedure search
Searching for text using an SQL Table-Valued Function
Using the highlight function
Searching on more than one column
Using text search in outer joins
Performance considerations during search
User scenarios
Simple example with the SQL scalar search function
Simple example with cache usage and stored procedure search
Simple example with the SQL table-valued function
Using a thesaurus to expand search terms
The structure of a thesaurus
Predefined thesaurus relations
Defining your own relations
Creating and compiling a thesaurus
Creating a thesaurus definition file
Compiling a definition file into a thesaurus dictionary
Thesaurus support
Thesaurus supported CCSIDs
Messages returned by the thesaurus tool
Text Search Engine
Tokenization
Stop words
Languages supporting stop words
Configuration
Working with structured documents
Searching natively stored XML documents
Using the default document model
Using a customized document model
XQuery support
Structured document support
How a document model describes structured documents
An example of a document model
Document models
Text fields
Document attributes
Number attributes
Default document models
Defining a document model for structured plain-text documents
What happens when a GPP document is indexed
Defining a document model for HTML documents
Defining a document model for XML documents
Defining a document model for Outside In filtered documents
What happens when an Outside In document is indexed
Document model reference
DTD for document models
Semantics of locator (XPath) expressions
Limitations for text fields and document attributes
Outside In tag attribute values
Federated systems and data sources
Configuring a federated system
Federated systems - overview
The federated database system catalog
The SQL compiler
The query optimizer
Compensation
Pass-through sessions
Default wrapper names
Server definitions and server options
User mappings
Nicknames and data source objects
Valid data source objects
Nickname column options
Data type mappings
Function mappings
Index specifications
Federated stored procedures
Collating sequences
How collating sequences determine sort orders
Setting the local collating sequence to optimize queries
Security
Wrapper support for HTTP and SOCKS proxies and SSL
Encryption
Proxy servers
Checking the setup of the federated server
Confirming the link-edit of the wrapper library files (UNIX)
Checking the wrapper library files (UNIX)
Wrapper library files
Checking the link-edit message files (UNIX)
Manually linking the wrapper libraries to the data source client software
Checking the FEDERATED parameter
Creating a federated database
Federated database code sets and collating sequences
Federated database national language considerations
Collating sequences in a federated system
Configuring data sources
Data sources - overview
Plan the federated data source configuration
Federated object naming rules
Preserving case-sensitive values in a federated system
Update data source statistics
Choose the correct wrapper
Methods of accessing Excel data
Plan the user mappings
Plan the data type mappings
Plan the function mappings
Checklist for planning your federated system configuration
Overview of configuring access to data sources
Fast track to configuring your data sources
Adding data sources to a federated server using the DB2 Control Center
Configuring multiple federated servers to access data sources
Setting the data source environment variables
Restrictions for the db2dj.ini file
Applying environment variables in a multi-partition instance configuration
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
Optional configuration steps
Configuring access to BioRS data sources
BioRS wrapper
Adding BioRS data sources to a federated server
Registering the custom functions for the BioRS wrapper
Custom functions for the BioRS wrapper
Registering the BioRS wrapper
BioRS wrapper library files
CREATE WRAPPER statement - Examples for the BioRS wrapper
Registering the server definition for a BioRS data source
CREATE SERVER statement - Examples for the BioRS wrapper
Creating the user mappings for a BioRS data source
CREATE USER MAPPING statement - Examples for the BioRS wrapper
Registering nicknames for BioRS data sources
CREATE NICKNAME statement - examples for the BioRS wrapper
Custom functions and BioRS queries
Equality operations in BioRS queries
Equijoin predicates for the BioRS wrapper
The BioRS AllText element
BioRS data source - Example queries
Optimizing BioRS wrapper performance
Guidelines for optimizing BioRS wrapper performance
BioRS statistical information
Determining BioRS databank cardinality statistics
Updating BioRS nickname cardinality statistics
Updating BioRS column cardinality statistics
Updating BioRS _ID_ column cardinality
Configuring access to BLAST data sources
BLAST wrapper
Adding BLAST data sources to a federated server
Verifying the versions of the BLAST server files
Configuring the BLAST daemon
BLAST daemon configuration file - Examples
Starting the BLAST daemon
db2blast_daemon command - options and examples
Registering the BLAST wrapper
BLAST wrapper library files
CREATE WRAPPER statement - Examples for the BLAST wrapper
Creating the user mappings for a BLAST data source (optional)
CREATE USER MAPPING statement - examples for the BLAST wrapper
Registering the server definition for a BLAST data source
CREATE SERVER statement - Examples for the BLAST wrapper
Registering nicknames for BLAST data sources
Definition line parsing
Fixed input columns for BLAST nicknames
BLAST search types and switches for fixed input columns
Fixed output columns for BLAST nicknames
CREATE NICKNAME statement - example for the BLAST wrapper
Querying BLAST data sources
Setting up TurboBlast to work with the BLAST wrapper
Construct BLAST SQL queries
BLAST data source – example queries
Guidelines for optimizing BLAST query performance
Configuring access to business application data sources
WebSphere Business Integration wrapper
Configuring the WebSphere Business Integration Adapters
Business object definitions
Configuration properties for business object definitions
WebSphere MQ message queues for the WebSphere Business Integration wrapper and the adapter
Adding business application data sources 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 application data sources (DB2 command line)
Registering nicknames for business application data sources
Registering nicknames for business application data sources (DB2 Control Center)
Identifying the required input columns in the business object before generating nickname definitions in the DB2 control center
Registering nicknames for business application data sources (DB2 command line)
CREATE NICKNAME statement – examples for the WebSphere Business Integration wrapper
Nicknames and XPATH expressions
The TEMPLATE option at the nickname and column levels
TEMPLATE option for the WebSphere Business Integration wrapper
Nickname requirements for result sets
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 access to DB2 family data sources
Cataloging a node entry in the federated node directory
Cataloging the remote database in the federated server system database directory
Registering the DB2 wrapper
DB2 wrapper library files
Registering the server definitions for a DB2 data source
CREATE SERVER statement - Examples for the DB2 wrapper
Creating the user mappings for a DB2 data source
CREATE USER MAPPING statement - Examples for the DB2 wrapper
Testing the connection to the DB2 data source server
Troubleshooting data source connection errors
Registering nicknames for DB2 tables and views
CREATE NICKNAME statement - Examples for the DB2 wrapper
Configuring access to Entrez data sources
Entrez Wrapper
Adding Entrez data sources to a federated server
Registering the custom functions for the Entrez wrapper
Custom functions for the Entrez wrapper
Registering the Entrez wrapper
Entrez wrapper library files
CREATE WRAPPER statement - examples for the Entrez wrapper
Registering the server definition for Entrez data sources
CREATE SERVER statement - Examples for the Entrez wrapper
Creating the user mappings for a Entrez data source (optional)
CREATE USER MAPPING statement - Examples for the Entrez wrapper
Access Entrez using a proxy server
Nicknames for the Entrez data sources
Nicknames for the Nucleotide database
Nicknames for the OMIM database
Nicknames for the PubMed database
Registering nicknames for Entrez data sources
CREATE NICKNAME statement - examples for the Entrez wrapper
Alternative names for the Entrez nicknames
Queries and custom functions for Entrez data sources
Query the Entrez databases using the custom functions
Relational predicates for the Entrez wrapper
Records returned from Entrez queries
Entrez data sources - Example queries
Fixed columns for the Nucleotide nicknames
Fixed columns for the OMIM nicknames
Fixed columns for PubMed nicknames
Configuring access to Excel data sources
Excel wrapper
Adding Excel data sources to a federated server
Registering the Excel wrapper
Excel wrapper library files
Registering the server definition for an Excel data source
CREATE SERVER statement - Examples for the Excel wrapper
Registering nicknames for Excel data sources
CREATE NICKNAME statement - examples for the Excel wrapper
Excel data sources - example queries
Excel data source – sample scenario
File access control model for the Excel wrapper
Configuring access to HMMER data sources
HMMER wrapper
Adding HMMER data sources to a federated server
Verifying the version of the HMMER program executable
Configuring the HMMER daemon
HMMER daemon configuration file - examples
Starting the HMMER daemon
db2hmmer_daemon command - options and examples
Registering the HMMER wrapper
HMMER wrapper library files
CREATE WRAPPER statement - Examples for the HMMER wrapper
Registering the server definitions for a HMMER data source
CREATE SERVER statement - Examples for HMMER wrapper
Creating the user mappings for a HMMER data source (optional)
CREATE USER MAPPING statement - Examples for the HMMER wrapper
Registering nicknames for HMMER data sources
CREATE NICKNAME statement - examples for HMMER wrapper
Fixed columns for HMMER nicknames
Fixed input columns for HMMER nicknames
Fixed output columns for HMMER nicknames
HMMER data source - complete example
Construct new HMMER queries with samples
Configuring access to Informix data sources
Setting up and testing the Informix client configuration file
Setting the Informix environment variables
Informix environment variables
Informix code page conversion
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 mappings for an Informix data source
CREATE USER MAPPING statement - Examples for the Informix wrapper
Testing the connection to the Informix server
Troubleshooting data source connection errors
Performance tuning for the Informix wrapper
Registering nicknames for Informix tables, views, and synonyms
CREATE NICKNAME statement - Examples for the Informix wrapper
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
Pathway database functions
CompoundsByPathwyS user-defined function
CompoundsByPathwyT user-defined function
EnzymesByPathwyS user-defined function
EnzymesByPathwyT user-defined function
GenesByPathwyS user-defined function
GenesByPathwyT user-defined function
PathwysByCompndsS user-defined function
PathwysByCompndsT user-defined function
PathwysByEnzymesS user-defined function
PathwysByEnzymesT user-defined function
PathwysByGenesS user-defined function
PathwysByGenesT user-defined function
Sequence Similarity Database functions
Columns that are returned from SSDB database queries (table functions)
BestNbrsByGeneS user-defined function
BestNbrsByGeneT user-defined function
BstBstNbrsByGeneS user-defined function
BstBstNbrsByGeneT user-defined function
BtitS user-defined function
GenesByMotifsT user-defined function
MotifsByGenesS user-defined function
MotifsByGenesT user-defined function
ParalogsByGeneS user-defined function
ParalogsByGeneT user-defined function
RevBestNbrsByGeneS user-defined function
RevBestNbrsByGeneT user-defined function
Disabling the KEGG user-defined functions
Life sciences user-defined functions
Life sciences user-defined function library files
Life sciences user-defined functions by functional category
Registering life sciences user-defined functions
Disabling the life sciences user-defined functions
Back translation user-defined functions - overview
LSPep2AmbNuc user-defined function
LSPep2AmbNuc user-defined function - example
LSPep2ProbNuc user-defined function
LSPep2ProbNuc user-defined function - example
Defline parsing user-defined functions - overview
LSDeflineParse user-defined functions
LSDeflineParse user-defined function - examples
Generalized pattern matching user-defined functions - overview
LSPatternMatch user-defined function
LSPatternMatch user-defined function – example
LSPrositePattern user-defined function
LSPrositePattern user-defined function - example
GeneWise user-defined function - overview
Linking to GeneWise
LSGeneWise user-defined function
LSGeneWise user-defined function – example
Motif user-defined functions - overview
LSBarCode user-defined function
LSBarCode user-defined function - example
LSMultiMatch user-defined function
LSMultiMatch user-defined function - example
LSMultiMatch3 user-defined function
LSMultiMatch3 user-defined function – example
Reverse user-defined functions - overview
LSRevComp user-defined function
LSRevComp user-defined function - example
LSRevNuc user-defined function
LSRevNuc user-defined function - example
LSRevPep user-defined function
LSRevPep user-defined function - example
Translate user-defined functions - overview
LSNuc2Pep user-defined function
LSNuc2Pep user-defined function – example
LSTransAllFrames user-defined function
LSTransAllFrames user-defined function - example
Codon frequency table format
Codon frequency table - example
Translation table format
Translation table - example
Configuring access to Microsoft SQL Server data sources
Preparing the federated server to access Microsoft SQL Server data sources (Windows)
Preparing the federated server to access Microsoft SQL Server data sources (Linux, UNIX)
Setting the Microsoft SQL Server environment variables
Microsoft SQL Server environment variables
Registering the Microsoft SQL Server wrapper
Microsoft SQL Server wrapper library files
Registering the server definitions for a Microsoft SQL Server data source
CREATE SERVER statement - Examples for the Microsoft SQL Server wrapper
Creating the user mappings for a Microsoft SQL Server data source
CREATE USER MAPPING statement - Examples for the Microsoft SQL Server wrapper
Testing the connection to the Microsoft SQL Server remote server
Registering nicknames for Microsoft SQL Server tables and views
CREATE NICKNAME statement - Examples for the Microsoft SQL Server wrapper
Using ODBC tracing information to troubleshoot connections to Microsoft SQL Server data sources
Configuring access to ODBC data sources
Preparing the federated server to access data sources through ODBC (Windows)
Preparing the federated server to access data sources through ODBC (Linux, UNIX)
Registering the ODBC wrapper
ODBC wrapper library files
CREATE WRAPPER statement - Examples for the ODBC wrapper
Registering the server definitions for an ODBC data source
CREATE SERVER statement - Examples of 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
Optimizing ODBC wrapper performance with the ODBC tuning utility (db2fedsvrcfg)
db2fedsvrcfg command syntax - ODBC tuning utility
Test table definitions for the ODBC tuning utility (db2fedsvrcfg)
Accessing Excel data using the ODBC wrapper
Configuring ODBC access to WebSphere Classic Federation Server for z/OS data sources
Registering the ODBC wrapper
ODBC wrapper library files
CREATE WRAPPER statement - Examples for the ODBC wrapper
Registering the server definitions for an ODBC data source
CREATE SERVER statement - Examples of 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
Optimizing ODBC wrapper performance with the ODBC tuning utility (db2fedsvrcfg)
db2fedsvrcfg command syntax - ODBC tuning utility
Test table definitions for the ODBC tuning utility (db2fedsvrcfg)
Configuring access to OLE DB data sources
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 the user mappings for an OLE DB data source
CREATE USER MAPPING statement - Examples for the OLE DB wrapper
Configuring access to Oracle data sources
Setting the Oracle environment variables
Oracle environment variables
Oracle code page conversion
Setting up and testing the Oracle client configuration file
Registering the Oracle wrapper
Oracle wrapper library files
Registering the server definitions for an Oracle data source
CREATE SERVER statement - Examples for the Oracle wrapper
Creating the user mappings for an Oracle data source
CREATE USER MAPPING statement - Examples for the Oracle wrapper
Testing the connection to the Oracle server
Troubleshooting connectivity problems with Oracle data sources
Registering nicknames for Oracle tables and views
CREATE NICKNAME statement - Examples for the Oracle wrapper
Configuring access to scripts as data sources
Script wrapper overview
Adding scripts as data sources to a federated system
Registering the custom function for the script
Data types for the custom function for the script wrapper
Configuring the script daemon
Starting the script daemon
db2script_daemon command - options and examples
Registering the script wrapper
Script wrapper library file
Registering the server definition for a script as a data source (DB2 command line)
CREATE SERVER statement - examples for the script wrapper
Registering nicknames for scripts (DB2 command line)
CREATE NICKNAME statement - examples for the script wrapper
Script wrapper nickname options
SQL queries with the script wrapper
Optimizing script wrapper performance
Configuring access to Sybase data sources
Sybase wrapper support for Adaptive Server Enterprise (ASE)
Setting the Sybase environment variables
Sybase environment variables
Setting up and testing the Sybase client configuration file (Windows)
Setting up and testing the Sybase client configuration file (UNIX)
Registering the Sybase wrapper
Sybase wrapper library files
Registering the server definitions for a Sybase data source
CREATE SERVER statement - Examples for the Sybase wrapper
Creating the user mappings 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
Troubleshooting the Sybase wrapper configuration
Problems loading the Sybase wrapper library
Missing SYBASE environment variable
Missing Sybase node name
Configuring access to table-structured file data sources
Table-structured files - overview
Attributes of table-structured files
Table-structured files wrapper
Adding table-structured file data sources to a federated server
Registering the table-structured file wrapper
Table-structured files wrapper library files
Registering the server definition for table-structured files
CREATE SERVER statement - example for the table-structured file wrapper
Registering nicknames for table-structured files
CREATE NICKNAME statement - examples for table-structured file wrapper
File access control model for the table-structured file wrapper
Guidelines for optimizing query performance for the table-structured file wrapper
Configuring access to Teradata data sources
Testing the connection to the Teradata server
Verifying that the Teradata library is enabled for run-time linking (AIX)
Setting the Teradata environment variables
Teradata environment variables
Verifying the character set on the Teradata server
Troubleshooting character sets for Teradata data sources
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 the 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
Troubleshooting data source connection errors
Registering nicknames for Teradata tables and views
Teradata nicknames on federated servers
CREATE NICKNAME statement - Examples for the Teradata wrapper
Troubleshooting the Teradata data source configuration
Enabling run-time linking for libcliv2.so (AIX)
Troubleshooting character sets for Teradata data sources
Troubleshooting UPDATE or DELETE operation errors on nicknames
Working with Teradata access logging
Configuring access to Web services data sources
Web services and the Web services wrapper
Registering the Web services wrapper
Web services wrapper library files
Registering the server definition for Web services data sources
CREATE SERVER statement - Examples for Web services wrapper
Enabling security through the Web services wrapper
Registering nicknames for Web services data sources
Registering nicknames for Web services data sources (DB2 command line)
Registering nicknames for Web services data sources (DB2 Control Center)
CREATE NICKNAME statement – examples for the Web services wrapper
Nicknames and XPATH expressions
The TEMPLATE option at the nickname and column levels
The TEMPLATE option for the Web services wrapper
Creating federated views for Web services nicknames
Query restrictions for wrappers for business applications and Web services
Web services data sources – example queries
Configuring access to XML data sources
XML wrapper
Adding XML to a federated system
Registering the XML wrapper
XML wrapper library files
CREATE WRAPPER statement - Examples for the XML wrapper
Registering the server definition for an XML data source
CREATE SERVER statement - Examples for the XML wrapper
Access XML files using a proxy server
Nicknames for XML data sources
Data associations between nicknames and XML documents
The cost model facility for the XML wrapper
Namespaces for XML data sources
Registering nicknames for XML data sources
CREATE NICKNAME statement - examples for XML wrapper
Queries for XML data sources
Creating federated views for the XML wrapper nicknames
CREATE VIEW statement - examples for the XML wrapper
Query optimization tips for the XML cost model facility
XML data source - example queries
Mapping functions and user-defined functions
Function mappings in a federated system
When to create your own function mappings
Why function mappings are important
How function mappings work in a federated system
Requirements for mapping user-defined functions (UDFs)
Function templates
Creating function templates
Providing function mapping overhead information to the query optimizer
Function mapping options that specify function overhead - examples
Updating overhead information
Specifying function names in a function mapping
Mapping functions with the same name
Mapping functions with different names
How to create function mappings
Creating a function mapping for a specific data source type
Creating a function mapping for a specific data source type and version
Creating a function mapping for all data source objects on a specific server
User-defined functions in applications
Disabling a default function mapping
Dropping a user-defined function mapping
Configuring for query optimization
Creating index specifications
Index specifications in a federated system
Creating index specifications for data source objects
Creating index specifications on tables that acquire new indexes
Creating index specifications on views
Creating index specifications on Informix synonyms
Cache tables
Creating cache tables
Modifying the settings for materialized query tables
Adding materialized query tables to a cache table
Routing queries to cache tables
Enabling and disabling the replication cache settings
Dropping materialized query tables from a cache table
Dropping cache tables
Replication and event publishing
Configuring SQL replication
Planning for SQL replication
Migration planning
Memory planning
Memory used by the Capture program
Memory used by the Apply program
Storage planning
Log impact for DB2 source servers
Log impact for target servers
Storage requirements of target tables and control tables
Space requirements for spill files for the Capture program
Space requirements for spill files for the Apply program
Space requirements for diagnostic log files (Linux, UNIX, Windows, z/OS)
Conflict detection planning
Non-DB2 relational source planning
Transaction throughput rates for Capture triggers
Log impact for non-DB2 relational source servers
Coexistence of preexisting triggers with Capture triggers
Locks for Oracle source servers
Code page translation planning
Replication for data between databases with compatible code pages
Configure national language support (NLS) for replication
Replication planning for DB2 UDB for z/OS
Performance tuning
Configuring servers for SQL replication
Connectivity requirements for SQL replication
Connecting to iSeries servers from Windows
Connecting to non-DB2 relational servers
Creating control tables for SQL replication
Creating control tables for SQL replication
Creating control tables (iSeries)
Creating control tables for non-DB2 relational sources
Creating multiple sets of Capture control tables
Capture control tables on multiple database partitions
Setting up the replication programs
Setting up the replication programs (Linux, UNIX, Windows)
Setting environment variables for the replication programs (Linux, UNIX, Windows)
Preparing the DB2 database to run the Capture program (Linux, UNIX, Windows)
Optional: Binding the Capture program packages (Linux, UNIX, Windows)
Optional: Binding the Apply program packages (Linux, UNIX, Windows)
Binding the Apply program packages for Sybase sources
Creating SQL packages to use with remote systems (iSeries)
Creating SQL packages for the Apply program (iSeries)
Creating SQL packages for the Replication Analyzer (iSeries)
Granting privileges to the SQL packages (iSeries)
Setting up the replication programs (z/OS)
Capture for multiple database partitions
Setting up journals (iSeries)
Setting up journals for source tables (iSeries)
Managing journals and journal receivers (iSeries)
Specifying system management of journal receivers (iSeries)
Changing definitions of work management objects (iSeries)
Specifying user management of journal receivers (iSeries)
Delete journal receiver exit routine (iSeries)
Configuring Q replication and event publishing
Planning memory and storage requirements for Q replication and event publishing
Planning memory requirements for Q replication and event publishing
Memory used by the Q Capture program
Memory used by the Q Apply program
Memory for LOB data types for Q replication and event publishing
Planning storage requirements for Q replication and event publishing
Storage requirements for database logs for Q replication and event publishing
Storage for diagnostic files for Q replication and event publishing
Storage requirements for when the Q Capture program exceeds its memory limit
Storage requirements for traces for Q replication and event publishing
Data conversion for Q replication and event publishing
Data conversion for Q replication
Data conversion for event publishing
Setting up WebSphere MQ for Q replication and event publishing—Overview
WebSphere MQ objects required for Q replication and event publishing—Overview
WebSphere MQ objects required for unidirectional replication (remote)
WebSphere MQ objects required for unidirectional replication on the same system
WebSphere MQ objects required for event publishing
WebSphere MQ objects required for bidirectional or peer-to-peer replication (two remote servers)
WebSphere MQ objects required for peer-to-peer replication (three or more remote servers)
Required settings for WebSphere MQ objects
Sample commands for creating WebSphere MQ objects for Q replication and event publishing
Specifying a default model queue
Running the replication programs on a WebSphere MQ client
Validating WebSphere MQ objects for Q replication and event publishing
Sending test messages between queues in a replication queue map
Connectivity and authorization requirements for WebSphere MQ objects
Storage requirements for WebSphere MQ for Q replication and event publishing
WebSphere MQ message size
Queue depth considerations for large object (LOB) values
Queue manager clustering in Q replication and event publishing
Configuring servers for Q replication and event publishing
Connectivity requirements for Q replication and event publishing
Configuring databases for Q replication and event publishing (Linux, UNIX, Windows)
Setting environment variables (Linux, UNIX, Windows)
Configuring the source database to work with the Q Capture program (Linux, UNIX, Windows)
Configuring the target database to work with the Q Apply program (Linux, UNIX, Windows)
Optional: Binding the program packages (Linux, UNIX, Windows)
Optional: Binding the Q Capture program packages (Linux, UNIX, Windows)
Optional: Binding the Q Apply program packages (Linux, UNIX, Windows)
Optional: Binding the Replication Alert Monitor packages (Linux, UNIX, Windows)
Configuring databases for Q replication and event publishing (z/OS)
Software prerequisites for the Replication Center
Creating control tables for the Q Capture and Q Apply programs
Mainframe and midrange server access
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
DB2 for VSE & VM
DB2 Connect Sysplex support
Considerations for Sysplex exploitation
DB2 Sysplex exploitation
Configuration requirements
Configuring connections to mainframe and midrange servers
With the Configuration Assistant (CA)
With the command line processor (CLP)
Cataloging mainframe and midrange servers
Cataloging databases using discovery
Managing connections
Removing a mainframe and midrange server
Registering a license key using the db2licm command
Registering a license key using the License Center
Tools for administration and application development
Creating a database for the DB2 tools catalog
Setting up access to DB2 contextual help and documentation
Setting the location for accessing the DB2 Information Center
Setting startup and default options
Changing the fonts for menus and text
Filtering or pre-filtering objects in the display
Enabling health alert notification
Setting the default scheduling scheme
Setting Command Editor options
Setting IMS options
Documentation
Setting the location for accessing the DB2 Information Center
Setting up access to DB2 contextual help and documentation
Displaying topics in your preferred language
Using the DB2 database help
Setting up access to DB2 contextual help and documentation
Environment-specific information
Designing
Database systems
Relational databases
Distributed relational databases
Database agents
Structured Query Language (SQL)
DB2 administration server (DAS)
First failure data capture (FFDC)
Creating instances
Connections
Database agents
Database objects
Databases
Schemas
Database partitions
Data partitions
Tables
Views
Table or view aliases
Catalog views
Catalog views
Parallel database systems
Parallelism
Database partition and processor environments
Automatic maintenance
Online maintenance
Offline maintenance
Maintenance windows
Automatic features enabled by default
Automatic database backup
Automatic statistics collection
Automatic statistics profiling
Storage used by automatic statistics collection and profiling
Automatic reorganization
Monitoring and notification for automatic features
Table objects
Tables
Indexes
Constraints
Keys
Foreign key clause
Triggers
Interaction of triggers and constraints
Units of work
Isolation levels
Backup
Recovery log files
Recovery history files
Accessing the history file using the LIST_HISTORY table function
Rollforward pending states
Automatic client reroute
Storage objects
Database directories and files
Directory structure for your DB2 database product (Windows)
Directory structure for your DB2 database product (Linux)
Table space design
Buffer pool management
Thresholds
Data security
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
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
Data organization schemes
Database partitioning feature
Table partitioning
Multidimensional clustering tables
Data organization schemes in DB2 and Informix databases
Database partition groups
Database partition group design
Database partitions across multiple database partitions
Distribution maps
Distribution 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
DMS device considerations
Table space maps
DMS device considerations
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
SYSTOOLSPACE and SYSTOOLSTMPSPACE table spaces
Storage management view
Tables
Table design
Range-clustered tables
Out-of-range record key values
Locks
Examples
How the SQL compiler works with range-clustered tables
Guidelines for use
Multidimensional clustering (MDC)
Multidimensional clustering tables
Comparison of regular and MDC tables
Choosing MDC table dimensions
Creating MDC tables
Table partitioning and multidimensional clustered tables
Partitioned tables
Data organization schemes in DB2 and Informix databases
Data partitions
Table partitioning keys
Table partitioning and multidimensional clustered tables
Locking behavior on partitioned tables
Migrating existing tables and views to partitioned tables
Optimization strategies for partitioned tables
Large object behavior in partitioned tables
Large object behavior in partitioned 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
Heuristic APIs
Security considerations for XA transaction managers
XA function supported by DB2
XA interface problem determination
Resolving xa_end transactions
Configuring XA transaction managers
Resource manager setup
IBM WebSphere Application Server
IBM TXSeries CICS
BEA Tuxedo
National language versions
Supported territory codes and code pages
Locale names for SQL and XQuery
Date and time formats by territory code
Enabling and disabling euro symbol support
Character-conversion guidelines
Conversion table files for euro-enabled code pages
Conversion tables for code pages 923 and 924
Choosing a language for your database
Displaying Indic characters in the DB2 GUI tools
Installing additional Asian fonts (Linux)
Enabling bidirectional support
Bidirectional-specific CCSIDs
Bidirectional support with DB2 Connect
Collating sequences
Collating Thai characters
Unicode character encoding
Unicode implementation
Unicode handling of data types
Creating a Unicode database
Converting non-Unicode databases to Unicode
Unicode literals
String comparisons in a Unicode database
Code page 1394 and Unicode conversion
CCSID 943 alternative Unicode conversion tables
CCSID 943 Microsoft replacement conversion tables
CCSID 954 alternative Unicode conversion tables
CCSID 954 Microsoft replacement conversion tables
CCSID 5026 alternative Unicode conversion tables
Replacing the Unicode conversion table for coded character set identifier (CCSID) 5026 with the Microsoft conversion table
CCSID 5035 alternative Unicode conversion tables
Replacing the Unicode conversion table for coded character set identifier (CCSID) 5035 with the Microsoft conversion table
CCSID 5039 alternative Unicode conversion tables
CCSID 5039 Microsoft replacement conversion tables
Unicode Collation Algorithm based collation names
Business intelligence
Administering
Database systems
Getting started
Database basics
Authorities
DB2 tools
Basic navigation concepts
Control Center
Command Editor
Configuration Assistant
Health Center
Journal
Replication Center
Task Center
Web Command Center
Web Health Center
Creating your own database using the Automatic Maintenance wizard
Reviewing your new database
Starting and stopping DB2 Database for Linux, UNIX, and Windows
Starting a DB2 instance (Linux, UNIX)
Starting a DB2 instance (Windows)
Stopping an instance on UNIX
Stopping an instance on Windows
Auto-starting DB2 instances
Administration tools
Control Center
Control Center Legend
DB2 toolbar
DB2 Help menu
DB2 Tools menu
DB2 secondary toolbar
Performing administrative tasks on ControlCenter objects
Shutting down the DB2 administration tools
Opening new Control Centers
Selecting and customizing Control Center views
Selecting your Control Center view
Custom folder
Deleting custom folders or objects in custom folders
Database unavailable status in the database details pane
Displaying objects in the object tree
Expanding and collapsing the object tree
Refreshing objects in the objects tree and details view
Obtaining Control Center diagnostic information
Performing administrative tasks on ControlCenter objects
Filtering or pre-filtering objects in the display
Finding objects in the contents pane
Finding service level information about the DB2 administration tools environment
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
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
Using advisors, wizards, and launchpads to perform tasks quickly and easily
Introducing the plug-in architecture for the Control Center
Task Center
Command Editor
Executing commands and SQL statements
Tools for administration and application development
Setting Command Editor options
Setting a command statement termination character
Setting startup and default options
Setting the server administration tools startup property
Changing the fonts for menus and text
Setting the default scheduling scheme
Enabling or disabling notification using the Health Center Status Beacon
Setting DB2 UDB OS/390 and z/OS utility execution options
Setting IMS options
Setting up database systems
Cataloging database systems
Changing system names displayed in the Control Center
Multiple DB2 copies roadmap
Multiple instances on a Linux or UNIX operating system
Multiple DB2 copies on the same computer (Windows)
Setting the default instance when using multiple DB2 copies (Windows)
Changing the Default DB2 copy after installation (Windows)
Client connectivity using multiple DB2 copies (Windows)
Setting the DAS when running multiple DB2 copies
Managing DB2 copies (Windows)
Uninstalling DB2 copies (Linux, UNIX, and Windows)
Creating instances
Location of the instance directory
Multiple instances
Multiple instances on a Linux or UNIX operating system
Windows
Setting the DB2 environment (UNIX)
Automatically
Manually
Adding instances
Creating instances from the command line
Linux and UNIX
Windows
Adding instances
Adding a database partition to an instance using the Add Partitions wizard
Setting up a DB2 administration server (DAS)
Setting up the DAS to use the Configuration Assistant and the Control Center
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
Discovering and hiding server instances and databases
Configuring the DAS on DB2 Enterprise Server Edition systems
Setting up the DAS
Creating databases
Creating a database for the DB2 tools catalog
Database configuration file
Generating recommendations for database configuration
System catalog tables
Naming rules
Naming conventions
DB2 object naming rules
Delimited identifiers and object names
User, user ID and group naming rules
User name and group name restrictions (Windows)
Password rules and maintenance
Federated database object naming rules
Schema name restrictions and recommendations
Maintaining password information
Naming rules in NLS environments
Naming rules in Unicode environments
Creating databases
Automatic storage databases
Restore database implications
Monitoring storage paths
Restrictions when using automatic storage
Adding an automatic storage path
Using a split mirror as a clone database
Binding utilities to the database
Binding applications and utilities (DB2 Connect)
Cataloging a database
Updating the directories with information about remote database server machines
Management of database server capacity
Creating database objects
Creating table spaces
Initial table spaces
Automatic resizing of table spaces
Creating table spaces without file system caching
Automatic storage table spaces
Temporary automatic storage table spaces
Regular and large automatic storage table spaces
Monitoring storage paths
Restrictions when using automatic storage
Creating system temporary table spaces
Creating user temporary table spaces
Attaching a direct disk access device
Setting up raw I/O (Linux)
Creating table spaces in database partition groups
Creating schemas
Grouping objects by schema
Setting a schema
Copying a schema
Restarting a failed copy schema operation
Creating tables
Creating a table using the Create Table wizard
Table creation
Using the ALTER TABLE statement to alter columns of a table
Space compression for tables
Space value compression
Data row compression
Large object (LOB) behavior in partitioned tables
Large object (LOB) column considerations
Business rules for data
Estimating space requirements for tables and indexes
Creating tables in multiple table spaces
Creating partitioned tables
Creating a new source table using db2look
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 a table
Altering a table
Making a table in no data movement mode fully accessible
Defining data partitions on partitioned tables
Defining ranges
Adding data partitions
Attaching a data partition
Detaching a data partition
Attributes of detached data partitions
Resolving a mismatch during an attach
Dropping a data partition
Creating columns
Adding columns to existing tables
Changing columns
Dropping columns
Defining a generated column on a new table
Defining an identity column on a new table
Ordering columns to minimize update logging
Creating indexes, index extensions, or index specifications
Guidelines
Tips
Options on the CREATE INDEX statement
Creating indexes
Creating a user-defined extended index type
Index maintenance
Index searching
Index exploitation
Defining an index extension
Constraints
Implications for utility operations
Defining unique constraints
Adding unique keys
Changing unique keys
Adding primary keys
Changing primary keys
Checking for constraint violations using SET INTEGRITY
Creating sequences
Sequences
Comparison of IDENTITY columns and sequences
Defining referential constraints
Foreign key clause
References clause
Adding foreign keys
Changing foreign keys
Dropping foreign keys
Defining table check constraints
Adding check constraints
Changing check constraints
Defining informational constraints
Creating triggers
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
Source data types
Length limits for source data types
Creating user-defined structured types
Creating type mappings
Creating views
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 using the Add Partitions launchpad
Adding a database partition to a running database system
Adding a database partition to a stopped database system on UNIX
Adding a database partition to a stopped database system on Windows
Adding database partitions in a partitioned database environment
Adding database partitions using the Add Partitions launchpad
Error recovery when adding database partitions
Creating database partition groups (formerly nodegroups)
Creating table spaces in database partition groups
Creating tables in partitioned database environments
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
Changing database directory information
Buffer pools
Creating buffer pools
Creating buffer pools for partitioned databases
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
Privileges
Groups
Database authorities
Privileges
Maintaining database systems
Stopping, starting, and quiescing instances
Starting a DB2 instance (Linux, UNIX)
Starting a DB2 instance (Windows)
Stopping an instance on UNIX
Stopping an instance on Windows
Quiescing and unquiescing instances
Stopping, starting, and quiescing databases
Quiescing and unquiescing databases
Managing database systems
Automatic features enabled by default
Discovering and hiding server instances and databases
Cataloging database systems
Managing instances
Listing instances
Setting the current instance
Running multiple instances concurrently
Updating instances after the installation or removal of executables or components (Linux and UNIX)
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
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 updates (Linux and UNIX)
Removing the DAS
Managing databases
Database recovery log
Viewing the local or system database directory files
Changing node and database configuration files
Invoking the Configuration Advisor from the command line processor
Configuration Advisor sample output
Generating DDL statements for database objects
Altering a database
Statement dependencies when changing objects
Dropping databases
Space value compression
Data row compression
Altering table spaces
Renaming table spaces
Switching the state of a table space
Adding and changing containers in a DMS table space
Adding DMS containers
Modifying DMS containers
Automatic prefetch size adjustment after adding or dropping containers
Dropping user table spaces
Dropping system temporary table spaces
Dropping user temporary table spaces
Dropping a schema
Modifying tables
Space compression for existing tables
Quiescing tables
Copying tables
Renaming an existing table or index
Changing table attributes
Changing table properties
Altering tables using stored procedures
Updating table and view contents using the MERGE statement
Declaring a table volatile
Recovering inoperative summary tables
Modifying partitioned tables
Altering partitioned tables
Guidelines and restrictions on altering partitioned tables
Rotating data in a partitioned table
Examples of rolling in and rolling out partitioned table data
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
Dropping tables
Dropping user-defined temporary tables
Modifying table objects
Modifying columns
Validating related objects
Showing related objects
Adding columns to existing tables
Modifying column definitions
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
Dropping indexes, index extensions, or index specifications
Modifying constraints
Modifying unique constraints
Adding unique constraints
Adding unique keys
Changing unique keys
Adding primary keys
Changing primary keys
Dropping unique constraints
Dropping primary keys
Modifying foreign constraints
Adding foreign keys
Changing foreign keys
Dropping foreign keys
Modifying check constraints
Adding table check constraints
Changing check constraints
Dropping table check constraints
Altering sequences
Dropping sequences
Modifying triggers
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
Recovering inoperative views
Table or view aliases
Dropping aliases
Scenario: Changing the system clock
Maintaining the organization of your tables and indexes
Determining when to reorganize tables and indexes
Choosing a reorganization method
Offline table reorganization
Inplace Table Reorganization
Automatic reorganization
Reorganizing tables offline
Recovery of a classic reorganization
Improving the performance of classic table reorganization
Reorganizing tables online
Pausing and restarting an inplace table reorganization
Recovery of a failed inplace table reorganization
Locking and concurrency considerations for inplace table reorganization
Reorganizing indexes
Online index defragmentation
Monitoring a table reorganization
Monitoring the reorganization of a partitioned table
Costs of reorganization
Reducing the need to reorganize tables and indexes
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 computers in a partitioned database environment
Changing the database configuration across multiple database partitions
Adding a container to an SMS table space on a database partition
Maintaining database partitions
Managing database partitions
Changing database partitions (Windows)
Dropping database partitions
Dropping a database partition
Dropping database partitions from the instance using the Drop Partitions launchpad
Dropping database partitions (Windows)
Managing database partitions from the Control Center
Maintaining database partition groups
Altering database partition groups
Redistributing data in a database partition group
Defining and changing distribution keys
Defining distribution keys
Changing distribution 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)
Determining problems with rah (Linux and UNIX)
Managing storage
Setting up the storage management tool
Altering buffer pools
Identifying alternate servers with automatic client reroute
Description and setup
Description and setup (DB2 Connect)
Limitations
Identifying an alternate server for a database
Automatic client reroute configuration (DB2_MAX_CLIENT_CONNRETRIES and DB2_CONNRETRIES_INTERVAL)
Automatic client reroute connection failures
Automatic client reroute roadmap
Interaction between client connection timeout and client reroute
Examples
Task Center
Creating or editing a task
Scheduler
Success code sets
Selecting users and groups for new tasks
Changing the default notification message
Enabling scheduling settings in the task Center
Running tasks immediately
Scheduling a task
Managing contacts
Managing task categories
Managing saved schedules
Managing success code sets
Managing saved schedules
Viewing task, database, and message histories
Moving data
Overview
Data movement options
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
Changes to previous export behavior introduced in DB2 Version 9.1
Privileges, authorities and authorization
Exporting data
LBAC-protected data export considerations
Using export with identity columns
Recreating an exported table
Exporting large objects (LOBS)
Export sessions - CLP examples
Importing data - overview
Changes to previous import behavior introduced in DB2 Version 9.1
Privileges, authorities, and authorization
Importing data
In a client/server environment
With buffered inserts
With identity columns
With generated columns
LBAC-protected data import considerations
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
Changes to Previous Load Behavior Introduced in DB2 V9.1
Changes to previous load behavior introduced in DB2 UDB Version 8
Privileges, authorities, and authorizations
Loading data
Loading data into a table using the Load wizard
Enabling read access during load operations
Restarting or Terminating an Allow Read Access Load Operation
Building indexes
Using load with identity columns
Using load with generated columns
Using load with partitioned tables
Moving data using the cursor file type
Moving data using a customized application (user exit)
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
Using 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 data between systems
Moving data with DB2 Connect
IBM Replication tools by component
Data recovery
Developing a backup and recovery strategy
Deciding how often to back up
Storage considerations
Keeping related data together
Using different operating systems and hardware platforms
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
Recovery log files
Configuration parameters for database logging
Configuring database logging options
Configuring database logging without file system caching
Log mirroring
Reducing logging with the NOT LOGGED INITIALLY parameter
Managing log files
Administration notification log files
Managing log files through log archiving
Log archiving using db2tapemgr
Archiving log files to tape
User exits for database recovery
User exit program calling format
Sample user exit programs
User exit error handling
Log file allocation and removal
Blocking transactions when the log directory file is full
On demand log archive
Including log files with a backup image
How to prevent losing log files
Recovery history files
Garbage collection
Understanding table space states
Optimizing recovery performance
Backup
Privileges, authorities, and authorization required to use backup
Using backup
Backing up data using the Backup wizard
Backing up to tape
Backing up to named pipes
Backing up partitioned tables using Tivoli Space Manager Hierarchical Storage Management
Backup sessions - CLP examples
Enabling automatic backup
Optimizing backup performance
Compatibility of online backup and other utilities
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 data using the Restore wizard
Using incremental restore in a test and production environment
Performing a redirected restore operation
Redefine table space containers by restoring a database using an automatically generated script
Performing a redirected restore using an automatically generated script
Restoring to an existing database
Restoring to a new database
Optimizing restore performance
Redirected Restore sessions - CLP examples
Database rebuild
Choosing a target image for database rebuild
Restrictions for database rebuild
Rebuilding a database using selected table space images
Rebuilding selected table spaces
Rebuild and incremental backup images
Rebuild and table space containers
Rebuild and temporary table spaces
Rebuilding a partitioned database
Rebuild 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
Data recovery with Tivoli Storage Manager (TSM)
Configuring a Tivoli Storage Manager client
Considerations for using Tivoli Storage 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 Linux and UNIX
High availability disaster recovery (HADR) overview
System requirements
Installation and storage requirements
Restrictions
Replicated operations for HADR
Non-replicated operations for HADR
Commands for HADR
Standby database states
Synchronization modes
High availability disaster recovery (HADR) management
Initializing HADR
Stopping HADR
Database configuration for HADR
Setting hadr_timeout and hadr_peer_window
Automatic client reroute and HADR
Index logging and HADR
Log archiving configuration for HADR
Cluster managers and HADR
Switching the database roles
HADR takeover during failover
Performing an HADR failover operation
Reintegrating a database after a takeover operation
Performing rolling updates and upgrades in a HADR environment
HADR database activation and deactivation
HADR performance
High Availability on Linux and AIX
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
Administering Query Patroller
Starting Query Patroller
Enabling Query Patroller to intercept queries
Stopping Query Patroller
Query processing by Query Patroller
Managing users
Administering operators
Operators
Query Patroller operator profiles
Creating operator profiles for users and groups
Suspending or restoring operator privileges for users and groups
Administering submitters
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
Managing queries with Query Patroller
Managed query status
Changing the status of queries using Query Patroller
Viewing managed query details
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
Query Patroller 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
Filtering tables for historical analysis using Query Patroller
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
Administering Net Search Extender
Net Search Extender instance services
Starting and stopping Net Search Extender instance services
Net Search Extender locking services
Using the locking services
Viewing a lock snapshot
Update services
Using the DB2 control center
Starting and stopping Net Search Extender Instance Services from the DB2 Control Center
Enabling and disabling a database
Text index administration using the DB2 control center
Creating a text index using the DB2 control center
Name panel
Target panel
Text Properties panel
Update characteristics panel
Cache table panel
Determining cache utilization and cache size
Summary panel
Maintaining a text index using the DB2 control center
Altering a text index using the DB2 control center
Dropping a text index using the DB2 control center
Updating a text index using the DB2 control center
Showing index events using the DB2 control center
Activating a text index cache using the DB2 control center
Deactivating a text index cache using the DB2 control center
Showing index status using the DB2 control center
How to use DB2 Spatial Extender
How to use DB2 Spatial Extender
Interfaces to DB2 Spatial Extender and associated functionality
Tasks that you perform to set up DB2 Spatial Extender and create projects
DB2 Spatial Extender commands
Invoking commands for setting up DB2 Spatial Extender and developing projects
DB2 Geodetic Data Management Feature
DB2 Geodetic Data Management Feature
When to use DB2 Geodetic Data Management Feature and when to use DB2 Spatial Extender
Geodetic datums
Geodetic latitude and longitude
Geodesic distances
Geodetic regions
About geometries
Geometries
Properties of geometries
Type
Geometry coordinates
X and Y coordinates
Z coordinates
M coordinates
Interior, boundary, and exterior
Simple or non-simple
Closed
Empty or not empty
Minimum bounding rectangle (MBR)
Dimension
Spatial reference system identifier
Populating spatial columns
About importing and exporting spatial data
Importing spatial data
Importing shape data to a new or existing table
Importing SDE transfer data to a new or existing table
Exporting spatial data
Exporting data to a shapefile
Exporting data to an SDE transfer file
How to use a geocoder
Geocoders and geocoding
Setting up geocoding operations
Setting up a geocoder to run automatically
Running a geocoder in batch mode
Using indexes and views to access spatial data
Types of spatial indexes
Spatial grid indexes
Generation of spatial grid indexes
Use of spatial functions in a query
How a query uses a spatial grid index
Considerations for number of index levels and grid sizes
Number of grid levels
Grid cell sizes
Creating spatial grid indexes
CREATE INDEX statement for a spatial grid index
Tuning spatial grid indexes with the Index Advisor
Tuning spatial grid indexes with the Index Advisor—Overview
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
Geodetic Indexes
Geodetic Voronoi indexes
Voronoi cell structures
Considerations for selecting an alternate Voronoi cell structure
Creating geodetic Voronoi indexes
CREATE INDEX statement for a geodetic Voronoi index
Voronoi cell structures supplied with DB2 Geodetic Data Management Feature
World, based on population density (Voronoi ID: 1)
United States (Voronoi ID: 2)
Canada (Voronoi ID: 3)
India (Voronoi ID: 4)
Japan (Voronoi ID: 5)
Africa (Voronoi ID: 6)
Australia (Voronoi ID: 7)
Europe (Voronoi ID: 8)
North America (Voronoi ID: 9)
South America (Voronoi ID: 10)
Mediterranean (Voronoi ID: 11)
World, uniform data distribution, medium resolution – dodeca04 (Voronoi ID: 12)
World, industrial nations – G7 nations (Voronoi ID: 13)
World, uniform data distribution, low resolution – isotype (Voronoi ID: 14)
Differences in using geodetic and spatial data
Minimum and maximum x and y attributes
Differences in working with flat-Earth and round-Earth representations
Line segments that cross the 180th meridian
Polygons that straddle the 180th meridian
Polygons that enclose a pole
Polygons that represent hemispheres, equatorial belts, and the whole Earth
Spatial functions supported by DB2 Geodetic Data Management Feature
DB2 Geodetic Data Management Feature stored procedures and catalog views
Datums supported by DB2 Geodetic Data Management Feature
Geodetic spheroids
Spatial tasks from the DB2 Control Center
Altering a coordinate system
Creating a coordinate system
Creating a spatial column
Creating a spatial index
Running geocoding
Setting up geocoding
Altering a spatial reference system
Importing spatial data
Identifying DB2 Spatial Extender problems
How to interpret DB2 Spatial Extender messages
DB2 Spatial Extender stored procedure output parameters
DB2 Spatial Extender function messages
DB2 Spatial Extender CLP messages
DB2 Control Center messages
Tracing DB2 Spatial Extender problems with the db2trc command
The administration notification file
Administering XML Extender
XML Extender administration overview
Preparing to administer XML Extender
Administration tools for XML Extender
Setting up the administration wizard
dxxadm - XML Extender Administration command
Access and storage methods
When to use the XML column method
When to use the XML collection method
Managing data in XML columns
Planning for XML columns
XML columns as a storage and access method
Defining and enabling an XML column
Using indexes for XML column data
Storing XML data
Method for retrieving an XML document