© Copyright IBM Corp. 2004. All rights reserved. 337
Index
Symbols
.NET 2, 23, 25, 237, 254, 268
.NET Data Provider 25
.NET Framework 256
Numerics
32-bit 28
64 KB limit on statement size 12
64-bit 50
A
AcceptChanges 244
Active Directory 24, 121
ActiveX Data Object 238
activity analyzer 71
activity monitor 175
AD 121
add-ins 24–25, 278–279
ADO.NET 25, 238–240, 268
alter table 13
Apache 301
Apache Axis 297
applets 221
ARCHRETRYDELAY 69
AS/400 254
AST 15
attribute 239
authentication 14, 23, 138, 141
authentication plugins 144
authorization 141
authorization ID 141
AUTO_MAINT 75
AUTO_RUNSTATS 75
AUTO_TBL_MAINT 75
automated summary table (AST) 6
automatic client reroute 21, 215–218
automatic database backup 54
automatic reorganization policy 80–86
automatic RUNSTATS 72
automatic statistics collection 70–72
automatic statistics profiling 70, 76, 78–80
autonomic computing 2, 7
AVG 163
B
background process 70
backup 16
Backup and Restore function 41
backup images 67
backup mode 62
BeginTransaction 240
Bernoulli sampling 163
BI 5–6
binary large object 265
BLOB 265
block-level sampling 163
business intelligence 5–6
business intelligence enhancements 15
C
C 12
C# 26, 237, 246
C++ 12
CALL statement support 12
CallableStatement 228
change monitor 71
character large object 265
classes 239
classloader 224
CLASSPATH 223
Clear (DataSet method) 244
client
Administration Client 11, 36
Application Development Client 11, 36
Run-Time Client 10, 36
Run-Time Client Lite 11, 36
client installation 36
CLOB 265
CLP 22
CLR 24, 237, 261, 278
CM 71
command
activate database 174
ALTER TABLE 218
BACKUP DATABASE 64
338 DB2 UDB V8.2 on the Windows Environment
CATALOG DATABASE 140
db2advis 170
db2diaglevel 321
db2expln 165
db2set 119
db2start 143
db2stop 28, 49
db2trc 143
force 47
LIST DATABASE CONFIGURATION 85
LOAD 71
PRUNE HISTORY 69
quiesce 47
RECOVER 69
RESTORE DATABASE 64
TAKEOVER 207
UPDATE ALTERNATE SERVER FOR DATA-
BASE 216
CommandText 241
CommandType 241
Common Language Runtime 24, 237, 261, 278
compact installation 37
compatibility 14
compiler 12
complex expression 233
compression 66
configFileName 44
Configure Automatic Maintenance wizard 72
ConnectionString 240
Control Center 7, 20, 54
counters
database-related 174
CPU 16
CreateCommand 240
CreateParameter 241
custom installation 37
D
DADX 296–299
Documentation operations 299
dynamic approach 298
SQL operations 297
static approach 298
XML collection operations 297
DADX Web services 297
Data Connections folder 281
data consumer 245
data encryption 138
data manipulation language 71
Data Provider 254
DATA_ENCRYPT_CMP 140
database administration 7
database configuration parameter
AUTO_DB_BACKUP 63
AUTO_MAINT 64
AUTO_PROF_UPD 78
AUTO_REORG 85
AUTO_STATS_PROF 78
DFT_PREFETCH_SZ 167
DIAGLEVEL 321
locktimeout 13
LOGINDEXBUILD 218
UTIL_HEAP_SZ 171
database disconnection method
close 235
database manager configuration parameter
BACKBUFSZ 64
CLNT_PW_PLUGIN 157–158
GROUP_PLUGIN 158
RESTBUFSZ 64
SRVCON_ATUH 159
SRVCON_AUTH 157
SRVCONS_PW_PLUGIN 157
database migration 48
Database Partitioning Feature 9
database-related counters 174
data-centric 71
data-manipulation-driven feedback loop 70
DataReader 242
DataSetName 244
DataSource 225–226
DB2
Backup and Restore function 41
data encryption 138
database administration tools 7
Database Partitioning Feature 9
Database Project type 280
database software family 3–4
federated system 8
technology strategy priorities 2–3
DB2 .NET Provider 265
DB2 administration add-in 25
DB2 Development Add-In 278–279
DB2 development add-in 24
DB2 Everyplace 4
DB2 Information Integrator Web services 297
DB2 registry variable
Index 339
DB2_GRP_LOOKUP 119
DB2 Server 3
DB2 Setup wizard 28, 35
DB2 SQL Editor 282
DB2 SQL optimizer 6
DB2 stored procedures 282–284
DB2 Toolbar 279
DB2 UDB 3–4
capabilities and benefits 4–9
for Windows 9
multimedia extensibility 4
partner solutions 5
scalability 4
Web enablement 5
DB2 Universal JDBC Driver 222
DB2 Web services 297
db2advis 15, 87
db2ckmig 48
command syntax 49
DB2Command 257
DB2Connection 240, 257
DB2DataAdapter 257
DB2DataReader 257
DB2DIAG.EXE 324
DB2DIAG.LOG 320
db2licd 49
db2logmgr 68
db2relocatedb 44–46
execution example 46
steps 45
db2rspgn 31
db2support.zip 320
DB2Transaction 257, 263
db2wi.log 35
DBCLOB 265
DBMS optimizer 71
DDL backup 62
DeleteCommand 243
Design Advisor 15, 86
development center 11
diagnostic level 48
diagnostic log 320
disaster recovery 17, 189
disconnection from database 235–236
disks assignments 42, 44
distributed data 8
DML 71
Document Access Definition Extension 297
domain handling 23
double-byte character large object 265
DPF 9
DRDA 8
DriverManager 224–225
dxxworf.jar 304
E
encryption 14, 138
enterprise content management 2
enterprise resource planning 5
Enterprise Server Edition 9
ERP 5
error handling 160
ESE 9
ExecuteNonQuery 242
ExecuteReader 242
ExecuteScaler 242
explicit connection to database 234
Explicit rebind 165
Express Edition 10
F
FAILARCHPATH 68
failover 21, 200, 207–213
feedback loops 70
feedback warehouse table 78
FieldCount 242
file system 62
force application 47
G
generated column 13
generated column property
changing 13
getConnection method 234
GetXML 244
group lookup 23
group name 129
group plug-in 150
GSS-API 145
plugins 145
GSSPLUGIN_SERVER_ENCRYPT 153
H
HADR 21, 190
automatic client reroute 215–218
backup and restore restrictions 215
340 DB2 UDB V8.2 on the Windows Environment
failover 207–213
index logging 218–220
managing 205–207
monitoring 206–207
performance restrictions 214
primary active system 190
restrictions 213–214
setup 190–205
standby active system 190
HADR action windows 22
HADR wizard 22
HasRows 242
Health Center 54
health indicator 19
Health Monitor 19, 71, 81
high availability 189–220
High Availability Disaster Recovery 21, 190
I
IBM.Data.DB2 257
identity attribute 13
implicit connection to database 234–235
INCLUDE LOGS 17, 67
index advisor 86
index logging 218–220
InsertComman 243
installation type 28
compact 37
custom 37
typical 37
interoperability 295
iSeries 3, 24
iterator Java class 231
J
JAR 301
JAR file 303
Java 2
Java identifier 233
Java package 223
JDBC 222
JDBC DataSource interface 234
JDBC driver type 222
JDBC drivers 222
JDBC method 223
JNDI 226
K
Kerberos 145
L
LANMAN 120
large object 265
large object data streaming 138
LDAP 143
Lempel-Ziv (LZ) compression 66
Linux 4
LOB
BLOB 265
CLOB 265
DBCLOB 265
LOB data streaming 138
local system account 24, 132
LocalSystem 132
lock wait mode 13
locking 12
log mirroring 215
LOGRETAIN 68
LSA 24, 132
M
materialized query table 6, 15
Materialized Query Table advisor 86
MDC 15, 166
memory configuration 18
method 239
BeginTransaction 263–264
Class.forName 224
Commit 263
ExecuteNonQuery 263
executeQuery 227
ExecuteReader 267
executeUpdate 227
GetBytes 267
getCnn 266
getConnection 224
GetXml 260
MemoryStream 267
open 240
PreparedStatement.executeQuery 228
RollBack 263
Microsoft .NET 25
migrate command 49
syntax 49
migration 40–51

Get DB2 UDB V8.2 on the Windows Environment now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.