DB2 UDB V8.2 on the Windows Environment

© 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