Release Notes

Index

A B C D E F G H I J K L M N O P Q R S T U V W X

accessibility
- keyboard shortcuts (956)
accessibility features (1148)
accessing help (1064)
Adobe Acrobat Reader
- accessing with non-english locales (781)
ADT transforms (1014)
AIX
- DB2 installation on (787)
- installation errors (805)
AIX 4.3.3
- AutoLoader hanging after a fork (917)
ARCHIVE LOG
- usage notes (892)
AS/400
- capture and apply for (929)
assigning strings to columns, rules for (1091)
assignments
- datetime to string value (1107)
- datetime values, rules for (1105)
- strings, basic rules for (1089)
authentication
- by domain using DB2DOMAINLIST (1157)
AutoLoader
- hanging during fork (916)

backup
- when LOGRETAIN=CAPTURE (909)
backup method
- for Data Links Manager (914)
bidirectional language support
- with Control Center on Windows NT (953)
binding database utilities using Run-Time Client (1011)
buffer pool blocking (845)
- examples (852)
buffer pool IDs (851)
buffer pools
- block-based (847)
- contiguous pages (850)
- page-based (846)

CAPTURE (LOGRETAIN setting)
- backup and restore behavior (911)
capture and apply
- error messages (933)
- on AS/400 (930)
- starting from within an application (934)
character conversion
- rules for operations combining strings (1092)
- rules when comparing strings (1094)
character string
- assignment, overview (1088)
character strings
- double-byte character string (1130)
- VARGRAPHIC scalar function (1129)
CLI
- advantages of (1015)
- configuration keywords
  - CURRENTFUNCTIONPATH (1041)
  - SKIPTRACE (1042)
- stored procedures
  - multiple result sets (1016)
- writing a Unicode application (1017)
CLI functions
- SQLBindFileToParam (1044)
- SQLColAttribute (1045)
- SQLGetInfo (1049)
- SQLGetLength (1051)
- SQLNextResult (1054)
- SQLSetStmtAttr (1056)
CLI stored procedures
- autobinding (1040)
- limitations (1039)
CLI0637E (1010)
clients
- downloading (783)
- three-tier environment (1022)
CLOB data
- MQSeries functions (1085)
clone databases
- creating (905)
column
- string assignment, basic rules for (1090)
commands
- CREATE DATABASE (898)
compound SQL, using (1037)
concatenation
- operator (1098)
connections
- increasing data transfer rates (1147)
Control Center
- bidirectional support
  - on Windows NT (952)
- errors with Internet Explorer (768)
- fix required for OS/390 (964)
- infopops display problem on OS/2 (967)
- not working (770)
- on OS/390 platform (963)
- restrictions on concurrent applets (971)
- script center problems on Windows 95 (972)
- Tool Setting notebook (970)
- troubleshooting (965)
- troubleshooting on UNIX platforms (966)
- using to administer VM and VSE databases (951)
- using with Japanese (765)
- using with Simplified Chinese (764)
- Version 6, using to administer satellite environment (889)
conversion rules
- for operations combining strings (1093)
- for string comparisons (1095)
conversions
- character string to timestamp (1125)
- datetime to string variable (1106)
- DBCS from mixed SBCS and DBCS (1131)
- double-byte character string (1132)
copy daemon (808)
crash recovery
- using db2inidb tool (903)
CREATE DATABASE (899)
Create Database wizard
- setting extent size in (977)
CREATE PROCEDURE statement
- GET DIAGNOSTICS statement (1134)
cursors
- attributes, default (1026)
- concurrency (1030)
- keyset-driven
  - updating (1033)
- scrollable (1031)
  - keyset-driven (1021)
  - OS/390 (1018)
  - server-side (1019)
  - static (1020)
  - troubleshooting applications (1036)
- sensitivity (1028)
- type (1027)
- updatable (1029)
- values concurrency (1034)

Data Link Manager
- backup methods (915)
Data Links Manager
- problems retoring files (812)
Data Movement
- limits of Unicode clients (918)
data transfer rates
- increasing (1146)
data types
- promotion in a Unicode database (1087)
data warehouse center
- key definitions (987)
- tag language files (988)
- using stored procedures (1163)
Data Warehouse Center
Database Movement Tool (895)
DataJoiner
- restrictions (1159)
DATALINK
- problems when restoring (809)
- replication (924)
DATE function
- detailed description (1109)
- value to date format conversion (1110)
date strings
- definition (842)
datetime data types
- string representation of (1104)
datetime values
- string representations (841)
DAYOFWEEK_ISO scalar function (1062)
DB2_BINSORT (856)
DB2_BLOCK_BASED_BP (858)
DB2 control server
- minimum requirements (877)
- response file installation (878)
- Version 6, upgrading (888)
DB2 Enterprise Edition
- setting up as satellite (869)
  - prerequisites (876)
- Version 6, using as DB2 control server (887)
DB2_INLIST_TO_NLJN (860)
DB2_NEWLOGPATH (863)
DB2_NEWLOGPATH2 (865)
- formerly NEWLOGPATH2 (913)
DB2_PARALLEL_IO (840)
DB2 Personal Edition
- setting up as satellite (868)
  - prerequisites (875)
DB2_REDUCED_OPTIMIZATION (867)
DB2 Relational Connect
- installation on Unix (818)
- installation on Windows NT (817)
DB2_ROLLFORWARD_NORETRIEVE
DB2 Server for VM and VSE
- administering databases from Control Center (950)
db2ArchiveLog (1009)
db2inidb tool (900)
db2iupdt command, running after upgrading DB2 (799)
db2move (896)
db2start
- on Windows 95, 98 and ME (935)
deadlocks (937)
DFS Client Enabler
- uninstalling (1155)
dlfm client_conf
- reasons for failure (811)
double-byte character string (DBCS)
- returning string (1133)
DWC7906, message updated (984)

enable_MQFunctions (943), (945)
environment variables
- LD_ASSUME_KERNAL (947)
error messages
- bind files not found (1149)
- during migration (806)
- file access denied (961)
- invalid shortcut (955)
- SQL10012N (969)
- when adding nodes to partitioned databases (854)
errors, installation
- AIX (803)
exception table
- message column structure (1140)
expression
- concatenation operator (1096)
- string (1097)
extent size
- setting in the Create Database wizard (976)

federated systems
- nicknames (815)
- restrictions (816)
- wrappers (814)
Federated Systems, restrictions (1158)
file access denied error (960)
functions
- in a Unicode database (1102)
- scalar
  - DATE (1108)
  - GRAPHIC (1113)
  - MQPUBLISH (1067)
  - MQREADCLOB (1070)
  - MQRECEIVECLOB (1073)
  - MQSEND (1076)
  - TIME (1116)
  - TIMESTAMP (1122)
  - VARGRAPHIC (1128)
- table
  - MQREADALLCLOB (1079)
  - MQRECEIVEALLCLOB (1082)

gateways
- three-tier environment (1023)
GET DIAGNOSTICS statement (1135)
GET ROUTINE (897)
GET_ROUTINE_SAR (1139)
GRAPHIC function
- detailed description (1111)
- values and arguments (1112)
gui tools
- binding errors (1150)

Help (1065)
high availability (902)
hotkeys
- problems with (957)
HP-UX
- no support for Query Enabler (1007)
HP-UX 11
- memory windows (1153)

Information Catalog Manager
- in Hebrew (1160)
- utility program (997)
installation
- DB2 Enterprise-Extended Edition on AIX (786)
- hanging when using removable drive (792)
- service account required on Windows (1162)
- stopping DB2 processes during (797)
Installation
installation errors
- AIX (804)
installation prerequisites
- for UDB EE and CEE on Linux for OS/390 (802)
Internet Explorer
- errors with Control Center (769)
invalid shortcut error (954)
IPX/SPX protocol support, on Windows 2000 (796)
iSeries agent, post-installation considerations (1001)
iSeries agent, using transformers with (1002)

Japanese
- DB2 on PTX (767)
- locale setting on Linux (762)
JDBC
- scrollable cursors, accessing (1025)
JDBC/ODBC/CLI static profiling, limitations (1012)
JDK 1.1
- installation path (968)

key definitions
- metadata import/export (985)
keyboard shortcuts
- problems with (958)

Language Support
- SAP Connector (996)
Linux
- locale settings for Japanese and Simplified Chinese (761)
- running DB2 UBD administration tools (948)
- setting environment for Control Center (801)
locale
- Japanese and Simplified Chinese on Linux (760)
locales
- Simplified Chinese on Red Flag Linux (758)
lock waits (938)
locking, optimistic (1035)
log sequence numbers (LSNs) (894)
LSNs (893)

memory windows
- on HP-UX 11 (1152)
messages
- for capture and apply (932)
Microsoft SQL Server data sources
- code pages (836)
- DSN name (834)
- environment variables (830)
- improving performance (832)
- link to DB2 (831)
- MERANT library (829)
- MERANT wrappers (833)
- ODBC driver (828)
- ODBC traces (835)
migration
- errors during (807)
- on Windows 2000 (789)
- problems with views (793)
- running db2iupdt to update instances (800)
MQ Functions (944), (946)
MQPUBLISH function
- detailed description (1068)
- values and arguments (1069)
MQREADALLCLOB function
- detailed description (1080)
- values and arguments (1081)
MQREADCLOB function
- detailed description (1071)
- values and arguments (1072)
MQRECEIVEALLCLOB function
- detailed description (1083)
- values and arguments (1084)
MQRECEIVECLOB function
- detailed description (1074)
- values and arguments (1075)
MQSEND function
- detailed description (1077)
- values and arguments (1078)
MQSeries Assist wizard (979)
MQSeries functions
- CLOB data support (1086)
multisite update test connect
- instance version incompatibility (962)

NetQuestion
- using TCP/IP on OS/2 (777)
Netscape
- error messages (780), (975)
- using to access online info (772)
NEWLOGPATH2
- now called DB2_NEWLOGPATH2 (912)
next key locking (939)
NLV support
- Unicode (1143)
NUMA-Q
- no support for Query Enabler or Tracker (1008)

ODBC
- fetch orientations (1032)
- scrollable cursors, accessing (1024)
ODBC Unicode applications (1058)
OLE DB Assist wizard (981)
online help (1066)
online information
- searching
  - on Solaris operating environment (776)
operand
- string (1100)
Oracle data sources
- environment variables (821)
- Linux wrapper (820)
- Solaris wrapper (819)
OS/2
- installing Control Center (959)
- NetQuestion (778)

partitioned databases
- errors when adding nodes (853)
patch levels
- on Solaris version 2.6 (785)
PDF files
- accessing with non-english locales (782)
performace
- on paid (839)
process
- schedules (992), (993)
processes, stopping before installation (798)
PTX
- using with Japanese (766)

Query Enabler
- unsupported on HP-UX and NUMA-Q (1006)
Query Patroller
- loss of user privileges after migration (1004)
Query Patroller Tracker
- unsupported on NUMA-Q (1005)
query results, viewing (973)
quick tour (983)

raid
- optimizing for (837)
Red Flag Linux
- Simplified Chinese locale (759)
registry variables
- DB2_BINSORT (855)
- DB2_BLOCK_BASED_BP (857)
- DB2_INLIST_TO_NLJN (859)
- DB2_NEWLOGPATH (861)
- DB2_NEWLOGPATH2 (864)
- DB2_REDUCED_OPTIMIZATION (866)
- DB2_ROLLFORWARD_NORETRIEVE (862)
- DB2DOMAINLIST (1156)
remote client access
- configuring Communication Server for NT (791)
replication
- DATALINK (923)
- planning (925)
- problem determination in (927)
- restrictions on table and column names (922)
- scenarios for (921)
- update-anywhere prerequisite (926)
- with non-IBM servers (920)
Replication Analyzer (928)
response file installation
- DB2 control server keywords (879)
- satellite-specific keywords (884)
restore
- when LOGRETAIN=CAPTURE (910)
restoring
- problems with DATALINK columns (810)
restoring files
- Data Links Manager (813)
Restrictions
- SAP Connector (995)
RESULT_STATUS
- GET DIAGNOSTICS statement (1136)
returning timestamp from values
- TIMESTAMP function (1123)
ROW_COUNT
- GET DIAGNOSTICS statement (1137)

sample contents, viewing (974)
SAP connector
- Installation (994)
Satellite Administration Center
- Version 6, using to administer satellite environment (890)
satellite environment
- administering with Version 6 Satellite Administration Center (891)
- DB2 Personal Edition satellite (872)
- DB2 Workgroup Edition satellite (873)
- installation considerations (880)
- interactive installation of satellite (886)
- prerequisites (874)
- response file installation of satellite (883)
satellites
- DB2 Personal Edition (870)
- DB2 Workgroup Edition (871)
- installation considerations (881)
- interactive installation (885)
- response file installation (882)
scalar functions
- DAYOFWEEK_ISO (1060)
- WEEK_ISO (1061)
scattered read (848)
schedules
- duplicate (990)
- step and process (989)
search discovery (1151)
searching online information
- on Solaris operating environment (774)
Simplified Chinese
- locale setting on Linux (763)
SNA Server
- accessing UDB from host or AS/400 applications (790)
SNA SPM
- verifying start after rebooting (1161)
Solaris
- lack of support for versions previous to UltraSparc (757)
- patch level required on V2.6 (784)
Solaris operating environment
- searching online information on (775)
Solaris operating system
- 64-bit
  - configuration (940)
  - restrictions (941)
split mirror
- as a backup image (907)
- as a standby database (906)
- as the primary database (908)
split mirror handling
- online (904)
SQL, compound (1038)
SQL procedure
- GET DIAGNOSTICS statement (1138)
SQLBindFileToParam CLI function, correction (1043)
SQLColAttribute function
- SQL_DESC_AUTO_UNIQUE_VALUE (1046)
- SQL_DESC_UPDATABLE (1047)
SQLGetData function (1048)
SQLGetInfo function (1050)
SQLGetLength function
- DBCLOB (1052)
SQLNextResult function (1053)
SQLSetEnvAttr function
- SQL_ATTR_KEEPCTX attribute (1055)
SQLSetStmtAttr function
- SQL_ATTR_QUERY_TIMEOUT attribute (1057)
starting DB2
- using db2start on Windows 95, 98 and ME (936)
static profiling, in JDBC/ODBC/CLI applications (1013)
step
- schedules (991)
stored procedures
- in Data Warehouse Center (1164)
string
- expression (1099)
- operand (1101)
suspended I/O function
- supporting continuous availability (901)
Sybase
- incompatibility with ICM on Windows (998)
Sybase data sources (822)
- code pages (827)
- environment variables (824)
- improving performance (826)
- link to DB2 (825)
Sybase Open Client (823)

table
- exception
  - message column structure (1141)
table space
- on raid (838)
table structures (931)
tag language files
- key definitions (986)
TCP/IP
- NetQuestion (779)
time
- returning timestamp from values (1124)
- returning values based on time (1119)
- using time in an expression (1118)
TIME function
- detailed description (1114)
- values and arguments (1115)
time strings
- definition (843)
TIMESTAMP function
- detailed description (1120)
- values and arguments (1121)
timestamp strings
- definition (844)
tools
- using on Linux (949)
transfer rates
- increasing (1145)

Unicode
- database and applications (1142)
- documentation updates (1144)
- functions in (1103)
- in ODBC applications (1059)
Unicode clients
- data movement limitations (919)
uninstalling
- DB2 DFS Client Enabler (1154)
updated books
- Administration Guide (749)
- Application Building Guide (748)
- Application Development Guide (750)
- Command Reference (751)
- Data Recovery and High Availability Guide and Reference (752)
- Data Warehouse Center Administration Guide (753)
- DB2 Warehouse Manager Installation Guide (755)
- Message Reference (754)
- SQL reference (756)
user profiles
- changing node status (1003)
using time in an expression
- TIME function (1117)

VARGRAPHIC function
- detailed description (1126)
- values and arguments (1127)
vectored I/O (849)
views
- unavailable after migration (794)

warehouse agents, installing (1000)
web browsers
- recommendations for Windows 2000 (771)
WEEK_ISO scalar function (1063)
Windows
- incompatibility between Sybase and ICM (999)
Windows 2000
- IPXX/SPX protocol support (795)
- migrating on (788)
- recommended web browsers on (773)
Wizards
- Create Database (978)
- MQSeries Assist (980)
- OLE DB Assist (982)

XML extender
- release notes (942)

[ Top of Page | Previous Page | Table of Contents | Index ]