D


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



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net