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
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
FP9: Fenced routines history information is easier to collect
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 (Linux and UNIX)
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)
FP9: DB2 health information is easier to collect and assess
FP9: db2support command has new optimizer options
FP10: DB2 Health Advisor supports new send options
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 level for high availability support
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
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
FP9: Fenced routines history information is easier to collect
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 (Linux and UNIX)
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)
FP9: DB2 health information is easier to collect and assess
FP9: db2support command has new optimizer options
FP10: DB2 Health Advisor supports new send options
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 level for high availability support
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
32bit to 64bit migration tool for Net Search Extender full-text indexes
DB2 Net Search Extender index migration tool from 32-bit to 64-bit (Windows)
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
Coexistence support in Version 9 and Version 8 SQL replication
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
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
32bit to 64bit migration tool for Net Search Extender full-text indexes
DB2 Net Search Extender index migration tool from 32-bit to 64-bit (Windows)
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
Coexistence support in Version 9 and Version 8 SQL replication
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
Configuring Net Search Extender for high availability (HA)
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
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
Configuring Net Search Extender for high availability (HA)
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