[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]
CA (Configuration Assistant)
configuring connections
manually [See Add Database Wizard]
with access profiles [See Add Database Wizard]
definition [See Add Database Wizard]
illustration [See Add Database Wizard]
uses for [See Add Database Wizard]
Call-level interface (CLI) 2nd 3rd 4th
Case sensitivity
Case studies
agents [See examples]
backup [See examples]
careers in DB2 [See examples]
configuring database connections [See examples]
configuring databases [See examples]
connection concentrator [See examples]
connectivity [See examples]
creating databases [See examples]
data movement utilities [See examples]
database configuration file [See examples]
database objects [See examples]
DB2 environment [See examples]
DPF (database partitioning feature) [See examples]
indexes [See examples]
installing DB2 [See examples]
locking [See examples]
memory [See examples]
partitions [See examples]
performance [See examples]
process model [See examples]
querying data [See examples]
recovery [See examples]
security [See examples]
sequences [See examples]
table constraints [See examples]
tools and utilities [See examples]
troubleshooting [See examples]
Casting
Catalog (SYSCATSPACE) table space
CHAR (character) data type 2nd
Character (CHAR) data type 2nd
Character large object (CLOB) [See CLOB (character large object]
Check constraints
Check for DB2 Updates option 2nd 3rd 4th
CLI (call-level interface) 2nd 3rd 4th
Clients
CLOB (character large object)
Cloning a database 2nd [See also backups, Databases;relocating]
CLP (Command Line Processor)
! (exclamation mark), escape character
" (double quotes), command delimiters 2nd 3rd
# (pound sign), comment delimiter 2nd 3rd 4th
+ (plus sign), turning off CLP options
- (dash), turning on CLP options
; (semicolon), terminator character
? (question mark), help request 2nd 3rd
\ (backslash), CLP line continuation 2nd 3rd 4th
files as input 2nd 3rd 4th 5th 6th 7th
modes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
noninteractive mode 2nd 3rd 4th 5th 6th 7th
removing database connections 2nd
versus Command Window 2nd 3rd 4th 5th
Code updates (FixPaks) 2nd 3rd 4th
Columns
unique identifiers 2nd 3rd 4th
Command Editor 2nd 3rd 4th 5th 6th 7th
Command Line Processor (CLP) [See CLP (Command Line Processor]
Command options, CLP 2nd 3rd 4th
Command Window
modifying isolation levels 2nd
versus (Command Line Processor) 2nd 3rd 4th 5th
Commands
case sensitivity [See SQL statements]
CLP (Command Line Processor) commands [See SQL statements]
DB2 commands [See SQL statements]
definition [See SQL statements]
help for [See SQL statements]
issuing from DPF [See SQL statements]
listing [See SQL statements]
overview [See SQL statements]
syntax, displaying [See SQL statements]
system commands [See SQL statements]
types of [See SQL statements]
COMMIT statement
Common table expressions (CTE) 2nd 3rd
COMPRESS SYSTEM DEFAULT clause 2nd
Concurrency
scenarios
lost updates [See isolation levels, locking]
nonrepeateable reads [See isolation levels, locking]
phantom reads [See isolation levels, locking]
transactions [See isolation levels, locking]
uncommitted reads [See isolation levels, locking]
Concurrent write access 2nd 3rd 4th
Configurable configuration parameters
Configurable online configuration parameters
Configuration Advisor
Connections page [See performance]
definition [See performance]
Introduction page [See performance]
invoking
command line [See performance]
Control Center [See performance]
Isolation page [See performance]
Populated page [See performance]
Priority page [See performance]
Results page [See performance]
Schedule page [See performance]
Server page [See performance]
Transactions page [See performance]
Workload page [See performance]
Configuration Assistant (CA) [See CA (Configuration Assistant]
Configuration parameters
database level [See parameters]
definition [See parameters]
instance level [See parameters]
list of [See parameters]
updating [See parameters]
viewing [See parameters]
Configuring
database connections
case study [See performance]
manually, with CA Configuration Assistant [See performance]
manually, with DB2 commands [See performance, connectivity, Connectivity;scenarios]
with system tools [See performance, Add Database Wizard, CA (Configuration Assistant]
databases
average active applications [See performance]
buffer pool, prefetching and cleaning [See performance]
case study [See performance]
commands for [See performance]
configuration file [See performance]
Control Center [See performance]
instances [See performance]
locking [See performance]
logging [See performance]
number of commits to group [See performance]
parameters [See performance]
Setup tools [See performance]
sorting [See performance]
write-ahead logging [See performance]
instances
agent pool [See performance]
intra-partition parallelism [See performance]
parameters [See performance]
requester I/O block size [See performance]
sort heap threshold [See performance]
system/server for performance [See performance]
Connect 2nd 3rd [See also host connectivity]
Connection concentrator
Connections
Connectivity
case study [See configuring, Configuring;database connections, directories]
client-server TCP/IP problems [See configuring, Configuring;database connections, directories]
DB2 environment [See configuring, Configuring;database connections, directories]
iSeries client to
iSeries server [See configuring, Configuring;database connections, directories]
Linux server [See configuring, Configuring;database connections, directories]
UNIX server [See configuring, Configuring;database connections, directories]
Windows server [See configuring, Configuring;database connections, directories]
z/OS server [See configuring, Configuring;database connections, directories]
listener processes [See configuring, Configuring;database connections, directories]
scenarios
binding utilities [See configuring, Configuring;database connections, directories]
database directory, cataloging [See configuring, Configuring;database connections, directories]
database server, enabling [See configuring, Configuring;database connections, directories]
DCS directory, cataloging [See configuring, Configuring;database connections, directories]
local from DB2 client to DB2 server [See configuring, Configuring;database connections, directories]
node directory, cataloging [See configuring, Configuring;database connections, directories]
remote from DB2 client to DB2 host server [See configuring, Configuring;database connections, directories]
remote from DB2 client to DB2 server [See configuring, Configuring;database connections, directories]
to local database [See configuring, Configuring;database connections, directories]
to remote database [See configuring, Configuring;database connections, directories]
troubleshooting [See configuring, Configuring;database connections, directories]
z/OS client
communications database [See configuring, Configuring;database connections, directories]
to iSeries server [See configuring, Configuring;database connections, directories]
to Linux server [See configuring, Configuring;database connections, directories]
to UNIX server [See configuring, Configuring;database connections, directories]
to Windows server [See configuring, Configuring;database connections, directories]
to z/OS server [See configuring, Configuring;database connections, directories]
Constraints [See also tables, constraints]
Containers
DMS (database-managed space) 2nd
SMS (systemmanaged space) 2nd 3rd
Control Center 2nd 3rd 4th 5th 6th
Coordinated Universal Time (UTC)
Coordinator agents 2nd 3rd 4th 5th 6th
Copying databases [See backups, Databases;cloning, Databases;relocating]
Corrective code (FixPaks) 2nd 3rd 4th
CPU requirements, performance 2nd
Crash recovery 2nd [See also backups, recovery]
CREATE BUFFERPOOL statement 2nd 3rd 4th 5th 6th
create database command
partitioning a database 2nd 3rd 4th
CREATE DATABASE PARTITION GROUP statement 2nd 3rd
CREATE DISTINCT TYPE statement 2nd
CREATE EVENT MONITOR statement
CREATE statement, objects used on
CREATE TABLE statement
creating partitioning keys 2nd
CREATE TABLESPACE statement
IN DATABASE PARTITION GROUP statement
CREATE TOOLS CATALOG command 2nd
CREATE_EXTERNAL_ROUTINE authority 2nd
CREATEIN schema privilege 2nd 3rd
Creating
DAS (Database Administration Server) 2nd
databases
cloning [See backups, recovery]
CREATE DATABASE statement [See backups, recovery]
examples [See backups, recovery]
INSERT statement [See backups, recovery, import utility, load utility]
multipartition environment [See backups, recovery]
relocating [See backups, recovery]
sample [See backups, recovery]
singlepartition environment [See backups, recovery]
DB2INSTANCE environment variable 2nd 3rd 4th
DB2NODE environment variable 2nd 3rd 4th
environment variables 2nd 3rd 4th
in multipartitioned environment
rules for table data [See tables, constraints]
tables
based on another table 2nd 3rd 4th
from query results 2nd 3rd 4th
MQTs (materialized query tables) 2nd
CTE (common table expressions) 2nd 3rd
Cumulative backups 2nd 3rd 4th
CURRENT ISOLATION register 2nd 3rd
CURRENT LOCK TIMEOUT parameter 2nd
Cursors