Learning Visually with Examples [Electronic resources]

Index

[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]

Daemons

DAS (Database Administration Server)

command summary 2nd

creating

definition 2nd

displaying the configuration file

dropping

history of 2nd

resetting the configuration file

setting user information

starting/stopping

updating the configuration file

DAS users 2nd

dascrt command

dasdrop command

Dash (-), turning on CLP options

DATA BUFFER modifier

Data Control Language (DCL) 2nd

Data Definition Language (DDL) [See DDL (Data Definition Language]

Data dictionaries

DATA INITIALLY DEFERRED clause 2nd

Data Links Manager

Data Manipulation Language (DML) 2nd

Data marts

Data mining

Data movement utilities

case study 2nd

cursor format 2nd

DB2 maintenance

FLUSH PACKAGE CACHE command

high cluster ratio

maintaining statistics 2nd

package creation

process overview

REBIND

REORG 2nd 3rd 4th 5th

reorg command 2nd 3rd 4th 5th

reorganizing table data 2nd 3rd 4th 5th

REORGCHK 2nd 3rd 4th 5th

reorgchk command 2nd 3rd 4th 5th

RUNSTATS 2nd

runstats command 2nd

db2look command 2nd 3rd

db2move command 2nd

db2relocatedb command 2nd

dbset command 2nd

delimited ASCII (DEL) format

export

authority required

character delimiter, changing

code page, changing

column delimiter, changing

column names, specifying 2nd

date format, changing

export command 2nd 3rd

exporting large objects 2nd

file type modifiers 2nd

with the Control Center

file formats 2nd 3rd 4th

fixed length ASCII file format

generating DDL 2nd 3rd

import

authority required 2nd

concurrent write access 2nd 3rd 4th

file type modifiers

generated columns

identity columns

import command 2nd

import modes 2nd

overview 2nd

regular commits

restarting after failure

selecting columns

with the Control Center

IXF format

load

allow no access option 2nd

allow read access option

ANYORDER modifier

authority required

collecting statistics 2nd

copy yes/no options

CPU_PARALLELISM modifier

DATA BUFFER modifier

data validation

DISK_PARALLELISM modifier

exception option

exception tables

FASTPARSE modifier

file type modifiers 2nd

indexing mode option

leaving free space 2nd

list utilities command 2nd

load command 2nd 3rd 4th 5th 6th 7th 8th 9th

load querying

loading from a client 2nd 3rd

loading from a cursor

loading large objects 2nd 3rd

lock with force option 2nd

locking considerations 2nd

messages option

modified by modifier 2nd 3rd 4th

monitoring load operations 2nd 3rd 4th 5th 6th 7th

nonrecoverable option

overview 2nd

page overflow 2nd

performance considerations 2nd

pointers 2nd

process description 2nd

rebuilding indexes

roll forward recovery

savecount option

saving rejected records 2nd 3rd 4th

set integrity command

SORT BUFFER modifier

statistic profiles 2nd

statistics no option 2nd

statistics use profile option 2nd

table space states

table states 2nd 3rd

warningcount option

with the Control Center

Lotus worksheet format 2nd

multiple table operations 2nd

nondelimited ASCII (ASC) format

overview 2nd

PC version of IXF (PC/IXF) format

relocating a database 2nd

renaming a database 2nd

Symphony worksheet format 2nd

WSF format 2nd

Data sources

Data types

BIGINT (big integer) 2nd

BLOB (binary large object)

built-in 2nd 3rd 4th 5th

casting functions 2nd

changing in tables 2nd

CHAR (character) 2nd

choosing 2nd

CLOB (character long object) 2nd

datalink

datetime 2nd

DBCLOB (double-byte character large object) 2nd

DECIMAL/NUMERIC 2nd

definition

DISTINCT UDTs 2nd

DOUBLE/FLOAT 2nd

GRAPHIC 2nd

INT (integer) 2nd

INTEGER (integer) 2nd

LONG VARCHAR (long variable character) 2nd

LONG VARGRAPHIC 2nd

numeric 2nd

REAL/FLOAT

REFERENCE UDTs 2nd

SMALLINT (small integer) 2nd

string 2nd 3rd

STRUCTURE UDTs 2nd

table of 2nd

UDTs (userdefined types) 2nd

VARCHAR (variable character) 2nd

VARGRAPHIC 2nd

Data validation

Data Warehouse Center

Data warehouses

Database Administration Server (DAS) [See DAS (Database Administration Server]

Database administrator (DBA)

Database agents

Database clients

Database configuration file

case study 2nd 3rd

default

definition 2nd

displaying

getting current settings

resetting

sample contents 2nd 3rd 4th

updating 2nd

Database connection services (DCS) directory [See DCS (database connection services) directory]

Database directory

Database engines

Database functions

Database logs

Database management system (DBMS)

Database Manager (DBM) Configuration file [See DBM (Database Manager) Configuration file]

Database Manager Configuration parameters

Database manager instances

Database managers

Database object privileges

federated database support [See security]

implicit [See security]

indexes [See security]

nicknames [See security]

packages [See security]

routines [See security]

schemas [See security]

sequences [See security]

table spaces [See security]

tables [See security]

views [See security]

Database objects

case study 2nd 3rd 4th

definition

types of 2nd 3rd

DATABASE PARTITION GROUP clause

Database Partitioning Feature (DPF) [See DPF (Database Partitioning Feature]

Database request module (DBRM)

Database Servers

Database-level EDUs 2nd 3rd

Database-level operations memory 2nd

Database-managed space (DMS) 2nd

Database-managed space (DMS) table space

DATABASE_MEMORY parameter 2nd 3rd

Databases

accessing multiple [See data movement utilities, environment, tables, federation]

active partition, determining [See data movement utilities, environment, tables, DB2NODE]

attachments versus connections [See data movement utilities, environment, tables]

backup [See data movement utilities, environment, tables]

cloning [See data movement utilities, environment, tables]

configuration parameters [See data movement utilities, environment, tables]

configuring [See data movement utilities, environment, tables, configuring, databases]

connecting to [See data movement utilities, environment, tables, connectivity]

copying [See data movement utilities, environment, tables, backups, Databases;cloning, Databases;relocating]

creating

case study [See data movement utilities, environment, tables]

CREATE DATABASE statement [See data movement utilities, environment, tables]

examples [See data movement utilities, environment, tables]

multipartition environment [See data movement utilities, environment, tables]

sample [See data movement utilities, environment, tables]

setup tools [See data movement utilities, environment, tables]

singlepartition environment [See data movement utilities, environment, tables]

creating a backup image [See data movement utilities, environment, tables]

default structure [See data movement utilities, environment, tables]

definition [See data movement utilities, environment, tables]

design considerations [See data movement utilities, environment, tables]

dropping [See data movement utilities, environment, tables]

dropping partitions [See data movement utilities, environment, tables]

indirect entries [See data movement utilities, environment, tables]

inspecting, tools for [See data movement utilities, environment, tables]

listing [See data movement utilities, environment, tables]

loading data [See data movement utilities, environment, tables, ]

names [See data movement utilities, environment, tables]

node configuration file (db2notes.cfg)

description [See data movement utilities, environment, tables]

DPF environment [See data movement utilities, environment, tables]

nodes [See data movement utilities, environment, tables, database partition]

partition groups

classifications [See data movement utilities, environment, tables]

creating [See data movement utilities, environment, tables]

default [See data movement utilities, environment, tables]

definition [See data movement utilities, environment, tables]

description [See data movement utilities, environment, tables]

DPF environment [See data movement utilities, environment, tables]

dropping [See data movement utilities, environment, tables]

listing [See data movement utilities, environment, tables]

modifying [See data movement utilities, environment, tables]

multipartition [See data movement utilities, environment, tables]

singlepartition [See data movement utilities, environment, tables]

partition servers [See data movement utilities, environment, tables]

partitioning [See data movement utilities, environment, tables, partitions]

propagating data to servers [See data movement utilities, environment, tables]

recoverable versus nonrecoverable [See data movement utilities, environment, tables]

recovery [See data movement utilities, environment, tables]

relocating [See data movement utilities, environment, tables]

removing connections [See data movement utilities, environment, tables]

roll forward recovery [See data movement utilities, environment, tables]

servers

accessing multiple [See data movement utilities, environment, tables, federation]

definition [See data movement utilities, environment, tables]

IBM [See data movement utilities, environment, tables]

information management products [See data movement utilities, environment, tables]

propagating data to [See data movement utilities, environment, tables]

standby, creating [See data movement utilities, environment, tables]

system monitors [See data movement utilities, environment, tables]

DATALINK

datalink data type

Date and time, querying data

Date format, changing

datetime data type 2nd

datetime values

db2

application-level EDUs

database-level EDUs 2nd

executables

DB2

history of 2nd 3rd

information management products 2nd

db2

instance-level EDUs 2nd 3rd

listeners 2nd 3rd

perrequest EDUs 2nd 3rd 4th

Windows services/processes

DB2 AD Client (DB2 Application Development Client)

DB2 Application Development Client (DB2 AD Client)

DB2 brand 2nd

DB2 commands [See also commands]

DB2 Personal Developer's Edition (PDE) 2nd

DB2 Universal Developer's Edition (UDE)

db2_all command 2nd 3rd

DB2_EVALUNCOMMITTED variable

db2_install script 2nd 3rd

db2admin create command

db2admin drop command

db2admin start command

db2admin stop command

db2dart tool 2nd

DB2DC [See Development Center]

db2diag.log 2nd

db2evmon command 2nd 3rd 4th

db2exfmt tool 2nd

db2expln tool 2nd

db2icrt command 2nd 3rd

db2idrop command 2nd

db2ilist command

db2inidb mirror command 2nd

db2inidb snapshot command 2nd

db2inidb standby command 2nd

DB2INSTANCE environment variable

attaching to instances 2nd

changing value

commands at the instance level

configurable online parameters

configuring instances 2nd 3rd 4th 5th

Control Center instances 2nd

creating 2nd 3rd 4th

modifying 2nd 3rd 4th

overview 2nd 3rd 4th

resetting to defaults

starting 2nd 3rd 4th

use for 2nd

viewing contents of

db2level command 2nd

db2licm command 2nd

db2look command 2nd 3rd

db2move command 2nd

DB2NODE environment variable

changing value

creating 2nd 3rd 4th

modifying 2nd 3rd 4th

overview 2nd

use for 2nd

viewing contents of

db2notes.cfg (node configuration file)

description 2nd 3rd 4th 5th 6th

DPF environment 2nd

db2pd tool 2nd

db2relocatedb utility 2nd

db2rspgn utility

db2secv82.exe command

db2set command, options

db2setup command 2nd

db2setup utility

db2start command 2nd 3rd 4th 5th 6th 7th

db2stop command 2nd 3rd 4th

db2stop force command

db2support command 2nd

DB2SUPPORT tool 2nd

db2trc command

DBA (database administrator)

DBA utility

DBADM authority

DBCLOB (double-byte character large object)

definition

description

exporting 2nd

DBCS (double-byte character set)

DBM (Database Manager) Configuration file

displaying

overview 2nd

resetting

updating 2nd

viewing contents

DBMS (database management system)

DBRM (database request module)

dbset command 2nd

DCL (Data Control Language) 2nd

DCS (database connection services) directory

cataloging [See directories]

definition [See directories]

description [See directories]

entering information in [See directories]

listing [See directories]

sample [See directories]

DDF (distributed data facility)

DDL (Data Definition Language)

creating databases

definition

deleting databases

examples

generating 2nd 3rd

modifying databases

DEACTIVATE DATABASE command

Deadlock detectors

Deadlocks 2nd 3rd 4th 5th 6th 7th 8th 9th

DECIMAL/NUMERIC data type 2nd

Decision Support System (DSS)

DECLARE statement 2nd

Declared temporary tables

DEFAULT clause 2nd

DEFINITION ONLY clause 2nd

Degree of parallelism

DEL (delimited ASCII) format 2nd

Delete rule

DELETE statement 2nd 3rd

Deleteable views

Deleting

columns [See dropping]

data [See dropping]

directory contents [See dropping]

Delimited ASCII (DEL) format 2nd

Delimited identifiers

Delta backups 2nd 3rd 4th

Denormalization

Dependent

Dependent foreign key tables

Dependent immediate materialized query tables

Dependent materialized query tables

Dependent rows

Dependent table spaces

Derived columns

Development Center 2nd 3rd 4th 5th

Development tools

Development Center 2nd 3rd 4th

Project Deployment Tool 2nd

uses for 2nd

DIAGLEVEL parameter

Diagnosing problems [See troubleshooting]

DIAGPATH parameter 2nd

Differential backup images

Dimension block indexes 2nd 3rd

Dimension tables

Dimensions

Directories

book analogy [See connectivity, DCS (Database Connection Services]

deleting contents [See connectivity, DCS (Database Connection Services]

dropping [See connectivity, DCS (Database Connection Services]

inserting contents [See connectivity, DCS (Database Connection Services]

local connections [See connectivity, DCS (Database Connection Services]

local database [See connectivity, DCS (Database Connection Services]

node [See connectivity, DCS (Database Connection Services]

remote connection to DB2 server [See connectivity, DCS (Database Connection Services]

remote connection to host DB2 server [See connectivity, DCS (Database Connection Services]

system database [See connectivity, DCS (Database Connection Services]

uncataloging [See connectivity, DCS (Database Connection Services]

viewing [See connectivity, DCS (Database Connection Services]

Dirty read [See UR (uncommitted read]

DISABLE QUERY OPTIMIZATION clause

Disaster recovery

disconnect statement 2nd

DISCOVER parameter 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

DISCOVER_DB parameter 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

DISCOVER_INST parameter 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

Discovery method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

Disk requirements, performance

DISK_PARALLELISM modifier

Displaying

access plans [See listing, Visual Explain]

command syntax [See listing]

database configuration file [See listing]

Database Manager (DBM) Configuration file [See listing]

DISTINCT keyword

Distinct type

DISTINCT UDTs 2nd

Distributed data facility (DDF)

Distributed platform support

Distributed Relational Database Architecture (DRDA)

Distributed unit of work (DUOW)

DML (Data Manipulation Language) 2nd

DMS (database-managed space) 2nd 3rd

DNS (Domain Name Server)

Documentation [See help, Information Center, resources]

Domain names

Domains

Double quotes ("), command delimiters 2nd 3rd

Double-byte character large object (DBCLOB) [See DBCLOB (double-byte character large object]

Double-byte character set (DBCS)

Double-precision floating point numbers

DOUBLE/FLOAT data type 2nd

DPF (Database Partitioning Feature)

buffer pools

case study 2nd 3rd 4th 5th 6th

catalog partition

commands, issuing 2nd 3rd

configuration files

coordinator partition

database configuration files

database partitions 2nd 3rd 4th 5th

DB2NODE environment variable 2nd

definition

environment variables

generating values from partition numbers 2nd

installing DB2 2nd 3rd

instance-owning servers

instances 2nd 3rd

local database directory

logical partitions 2nd 3rd 4th 5th

logs 2nd

multipartition database 2nd 3rd 4th 5th

node configuration file 2nd

overview

partition groups 2nd

partitioned databases 2nd 3rd 4th 5th

partitioning a database 2nd 3rd 4th

partitioning keys 2nd

partitioning maps 2nd

partitions 2nd 3rd 4th 5th

SQL statements, issuing 2nd 3rd

table spaces

uses for

DRDA (Distributed Relational Database Architecture)

DRDA Application Requester 2nd [See also host connectivity]

DRDA Application Server 2nd [See also host connectivity]

DRDA clients 2nd 3rd 4th 5th

DROP BUFFERPOOL statement

drop database command 2nd

DROP DATABASE PARTITION GROUP statement 2nd

DROP DISTINCT TYPE statement

DROP PROCEDURE statement

DROP SCHEMA statement

DROP SEQUENCE statement, uses for

DROP statement, objects used on

DROP TABLE statement 2nd

DROP TABLESPACE statement

DROP VIEW statement

DROPIN schema privilege 2nd 3rd

DROPPED TABLE RECOVERY option 2nd

Dropped tables, recovery 2nd

Dropping

buffer pools [See deleting]

connections [See deleting]

DAS (Database Administration Server) [See deleting]

database partitions [See deleting]

databases [See deleting]

directories [See deleting]

indexes [See deleting]

instances [See deleting]

partition groups [See deleting]

schemas [See deleting]

stored procedures [See deleting]

table spaces [See deleting]

tables [See deleting]

UDTs (userdefined types) [See deleting]

views [See deleting]

DSS (Decision Support System)

Dual log paths

Dumb terminal clients

Dump files

DUOW (distributed unit of work)

Dynamic SQL