Understanding DB2: Learning Visually with Examples (2nd Edition)
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 warehousesDatabase 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 3rdDatabases 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 2nddb2 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 2ndDB2NODE 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 viewsDeleting 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 parameterDiagnosing 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 3rdDouble-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 2ndDropping 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 |