index_D

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

DAD (Data Access Definition) files
DASD
       tablespaces
                monitoring
DASD and space management tools
DASD volumes
        partitioned table spaces
data
       administration
                standards/procedures 2nd
       appending
                LOAD utility
       archiving
                REORG utility 2nd
        buffering (global) 2nd
                buffer pools
                group buffer pool duplexing 2nd
                updating/reading data 2nd
       cleansing
                data warehouses 2nd
        compressing
        customizations
                data integrity
                INSERT statements
                LOAD utility vs INSERT statements
                multiple rows, adding
                primary keys
                UPDATE/DELETE statements
        customizing
                changed columns , updating
                column updates
                columns, listing
                cursors 2nd 3rd
                DELETE statements
                FOR UPDATE OF clause
                generated values, retrieving
                indexed columns, updating
                large insertions
                long columns
                mass DELETE
                multiple rows, adding
                row updates
                rowset positioning cursors
                self-referencing DELETE statements
                self-referencing sub-SELECT statements
                UPDATE statements
       derivable
                denormalization
       distributed
                .
       dynamic
                accessing
       filtering
                WHERE clause
       floating point
                loading
                unloading
        frequently used, storing
        grouping 2nd
       index synchronization
                COPY utility
       integrity
                FOR UPDATE OF clause
                stored procedures
        limiting
       metadata
                storing
       modification
                indexes
       non-relational
                joining
       non-uniform
                dynamic SQL
       overactive
                online 2nd
        physical storage
       purging
                data warehouses
       quality
                data warehouses
       read-only
                data warehouses
        reading 2nd
       redundant
                denormalization
       replacing
                LOAD utility
        sharing
        sorting 2nd
                online
       stable
                RI, avoiding
       time/date
                tables
        uncertain
        updating 2nd
Data Access Definition.
Data Administration Newsletter, The (ital)
data analysts
DATA CAPTURE parameter
        tables
data cleansing
        data warehouses, populating 2nd 3rd
                reformatting
                value validation 2nd
data consistency utilities
        CHECK
        CHECK DATA
                bypassing
                check constraints 2nd
                check pending status
                DELETE YES parameter
                exception tables
                indexes
                informational referential constraints
                LOB references 2nd 3rd 4th
                locks
                partition levels 2nd
                phases 2nd
                referential integrity
                rerunning
                running
                SCOPE PENDING option
                work data sets 2nd
        CHECK INDEX 2nd
                dangerous operations
                DB2 Catalog
                locks
                partition levels
                phases
                rerunning
                running
                work data sets 2nd
        CHECK LOB 2nd
                EXCEPTIONS parameter
                locks
                phases
        DIAGNOSE
        REPAIR 2nd 3rd
                VERSIONS parameter
        REPAIR DBD 2nd
                DROP/REBUILD parameter
                error resolution
                LOG YES parameter
        REPAIR LOCATE 2nd 3rd
                broken page bits
                DB2 Catalog/Directory
                dumps
                locks
                LOG YES parameter
                recovery
                VERIFY parameter
        REPAIR SET 2nd
                check pending flag
                copy pending flag
                down-level data sets
                recover pending flag
        REPORT
        REPORT TABLESPACESET option 2nd 3rd 4th
Data Control Language.
data conversions
        LOAD utility
data currency
        block fetches 2nd 3rd
Data Definition Language.
data derivation
        views
data dictionaries
data distribution
        accessing
                application-directed 2nd 3rd 4th
                methods , comparing
                system-directed 2nd 3rd 4th
        ASCII support
        binding options 2nd
        block fetches
                continuous 2nd 3rd
                cursors 2nd 3rd 4th 5th
                data currency 2nd 3rd
                limited 2nd 3rd
        CDB 2nd
        client/server applications
        DDF
        DDF suspend/resume
        DDF.
        dynamic cursor pre-opens
        locations
       one-phase commit
                two-phase, compared
        optimization 2nd 3rd
        partitioned table spaces
        performance
                buffer pools
                DDF dispatching priority 2nd
                OPTIMIZE FOR n ROWS clause
                response times
                SQL result sets
                throughput chains
                throughput, analyzing 2nd 3rd
                VTAM parameters 2nd
        placement 2nd
       private protocol
                converting to DRDA
        problem resolution logs
        remote processing, deleting
        requests
        requests, combining
        security
                authid translations 2nd
                come-from checking
                PUBLIC AT ALL LOCATIONS parameter
        TCP/IP support
       threads
                connection pools 2nd
                inactive DBATs 2nd
        two-phase commit
                actual commit 2nd
                multi-site updates
                one-phase, compared
                preparation phase
                syncpoint trees
        type-2 connections
        Unicode support
        units of work
        Version 8
                database aliases
                location aliases
                TCP/IP network member routing
        versions (DB2)
        workstation DB2
data extraction
        4GL applications
DATA INITIALLY DEFERRED parameter
data integrity
        violations
Data Junction
data management
        Version 7 enhancements 2nd 3rd
                data sharing
                declared temporary tables 2nd
                deferred data set creation
                identity columns 2nd
                LOG SUSPEND command
                Unicode 2nd
                utilities 2nd 3rd
Data Management Review (ital)
Data Manager.
Data Manipulation Language.
data marts
        data warehouses, compared
data mining
        intelligent miner scoring
data modeling
        CASE tools support
data modifications.
data movement tools 2nd
data organization utilities
        LOAD
                appending/replacing data
                blocked input
                concurrency 2nd
                contingency options
                data conversion
                DECIMAL columns
                delimited input data sets 2nd
                editing data before loading
                floating point data
                index keys, sorting
                indexes, creating
                inline copies
                inline statistics 2nd
                input data sets, sequencing 2nd
                INSERTs, compared
                locking 2nd
                LOG NO option
                mass deletes
                multi-table simple table space
                nonrestartable jobs 2nd
                nullable columns
                online loading
                parameters, coding
                partitions
                performance
                phases 2nd
                philosophies 2nd 3rd 4th
                referential constraints, forcing
                reorganizing
                rerunning/restarting 2nd 3rd 4th
                restarting jobs 2nd
                ROWID values
                security
                serializing jobs
                sort utility
                statistics, gathering
                table triggers
                work data sets 2nd 3rd
                work data sets, buffering
                work data sets, separating
        REORG 2nd
                archives 2nd
                automatically reorganizing 2nd
                clustering
                concurrency
                frequency
                frequency (reorganizations) 2nd
                index phases 2nd
                indexes 2nd
                inline statistics 2nd
                job stream 2nd
                LOB table space phases
                nonrestartable
                online reorganizations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
                partitions, rebalancing
                performance
                philosophies 2nd
                recovery
                REORG INDEX 2nd 3rd 4th
                REORG TABLESPACE 2nd 3rd 4th 5th
                reorganization rules
                reorganization types
                rerunning/restarting 2nd 3rd
                restartable
                REUSE option
                SCOPE PENDING option
                SHRLEVEL parameter
                SORTKEYS parameter
                standards (recommended)
                STOGROUP-defined data sets
                table space phases 2nd
                unloaded data sets
                VARCHAR columns
                VSAM data sets
                work data sets 2nd 3rd
                work data sets, buffering
        UNLOAD 2nd
                concurrency
                data, limiting
                encoding schemes
                floating point data
                JCL listing
                LOAD control statements
                locking
                phases
                restarting
                security
                terminating
data pages
        index
                Type 1
                Type 2 2nd 3rd
        LOB
        table spaces 2nd
data partitioned secondary indexes. 2nd
data requests
        serializing
Data Set Dump Creator utility.
data sets
        allocating
        allocating.
       DB2 Catalog
                multiple extents
                SQL access, monitoring
       deferred
                creating
        deleting
       delimited input
                loading 2nd
       down-level
                repairing
        DSN1DMP utility
        ESDS
       image copy
                allocating
                specifying
        indexes
                size 2nd 3rd
       input
                sequencing 2nd
        LDS
       log
                DSN1COPY utility
       non-DB2
                buffering
        open
                tuning 2nd 3rd
       output
                utilities
        pages 2nd 3rd 4th
        partition sizes 2nd
       STOGROUP-defined
                moving
       SYSCOPY
                allocating 2nd
                buffering
                MERGECOPY utility 2nd
       SYSDISC
                space requirements
        SYSMAP
       SYSREC
                synchronizing
       SYSUT1
                MERGECOPY utility 2nd 3rd
                REBUILD INDEX utility
       SYSUT2
                size
       unloaded
                REORG utility
        VSAM
                closing 2nd 3rd
                deleting
                LOB table spaces 2nd
                non-partitionted objets 2nd
                pages 2nd
                partitionted objets 2nd
                RECOVER utility
                REORG utility
                user -defined 2nd 3rd
       work
                buffering 2nd
                CHECK INDEX utility 2nd
                checking 2nd
                LOAD utility 2nd 3rd
                online utilities 2nd 3rd
                REBUILD INDEX utility
                RECOVER utility
                REORG utility 2nd 3rd
                separating
data sharing
        administration
                backup/recovery
                buffer pools
                CF failures
                CF recovery
                database statuses
                DSNDB07 work file database name
                EDM pools
                group buffer pool duplexing 2nd
                groups, creating
                groups, monitoring 2nd
                lock structures
                logs, archviing
                LPL page recovery
                member shutdowns
                multiple coupling facilities
                naming conventions
                restart light
                row-level locking
                subsystem availability
        advantages 2nd
        application support
        applications
        attachment interfaces
        binding
        CF
                cache structures
                defining
                failures
                global data buffering 2nd
                global locking management 2nd
                inter-system communications
                list structures
                lock structures
                multiple
                naming conventions
                recovery
        commits
        DCL
        DDL
        DSNJU003
        groups 2nd
                monitoring 2nd
        IMMEDWRITE parameter
        lock avoidance
        locks, minimizing
        naming conventions 2nd 3rd
                group-level
                member-level
        Parallel Sysplex
        pre-existing subsystems
        requirements 2nd 3rd
        Sysplex 2nd
        sysplex parallelism
        tuning
        Version 7 enhancements
data sharing environments
        auto rebind
data sharing group buffer pools
        tuning 2nd 3rd 4th 5th
                castout process
                duplexing
                GBPCACHE parameter
                partitioned tablespaces
                size
                thresholds
data sharing groups
        global locks 2nd
                structures
        hierarchical locks
        L-locks
        P-locks
data stable
Data Transaction Manager.
data transfer rates
       increasing
                DB2 Connect
data transformations
        data warehouse population
                aggregation transformations
                automating 2nd
                data cleansing 2nd 3rd
                integration 2nd
                simple transformations
                summarization transformations
data types
       base
                UDTs, compared
       columns
                customizing 2nd 3rd 4th
        columns/rows, selecting 2nd 3rd
        DATE 2nd
        equivalent 2nd
        lengths 2nd
        native DB2 2nd
        promotability 2nd
        REXX
        ROWID
       SMALLINT
                Java
        stored procedures
        tables 2nd
        TIME 2nd
        TIMESTAMP 2nd
        user-defined.
       valid
                listing of 2nd
Data Warehouse Center 2nd
data warehouses
        accessing
        backing up
        check constraints
        data cleansing 2nd
        data quality
        Data Warehouse Center 2nd
        data-compression
        DB2 designs
        denormalization
        dirty reads
        environment
        format conversions
        implmenting 2nd
        indexes
        managing 2nd
        MQTs
        operational needs
        parallelism
        purging data
        pyramid
        query tools
        read-only data
        referential integrity
        triggers 2nd
        troubleshooting
        Warehouse Manager
data warehousing
        data marts, compared
        designing 2nd
                metadata 2nd
                star schema 2nd 3rd
        ODS 2nd
        OLAP 2nd
        operational databases, compared
        overview 2nd
        populating
                data transformations 2nd 3rd 4th 5th 6th 7th 8th
                replication vs propagation
                snapshots
data-compression
        data warehouses
DATA_SHARING_GROUP_NAME session variable
database analysis tools 2nd
database authority query
database changes
        online schema changes
                column data types 2nd 3rd 4th
                exception states
                implementing
                indexes 2nd 3rd 4th 5th 6th 7th
                pre-V8
                table space partitioning 2nd 3rd 4th
                V8 new features 2nd
                versioning 2nd 3rd 4th
DATABASE class privileges
database code usage (long accounting reports )
DATABASE DB2 object
database descriptors.
database management systems
        object/relational 2nd
database modeling and design tools 2nd
database object lists
        adding/deleting objects from 2nd
        creating 2nd
        example 2nd
        expanding 2nd
        guidelines 2nd
        indexes
        LOBs 2nd
        preveiwing
        referential integrity
        testing 2nd
        wildcards 2nd
database server (DS) function
Database Services Address Space.
databasees
        administration guide
databases
        active
        aliases
       data sharing
                statuses
                subsystem availability
        DBDs 2nd 3rd
                size, reducing
        denormalization 2nd 3rd 4th
                avoiding
                combined tables
                derivable data
                hierarchies 2nd 3rd 4th
                large page sizes
                mirror tables
                pre-joined tables
                redundant data
                repeating groups 2nd
                report tables
                split tables 2nd
                types
                validity, testing
       design
                tuning 2nd 3rd
       designs
                tuning
        DSNDB04 paraemter
        DSNDB07 work file database
        Fast Path
       IMS
                accessing 2nd
       multiple
                viewing
        normalization 2nd 3rd
                first normal form
                second normal form
                third normal form
        objects, dropping
       operations
                data warehouses, compared
        parameters 2nd
        sample
        security
       specific information, reporting
                navigational queries
       structures
                DB2 Family differences
        table average per
DATACLAS option
        TEMPLATE statement
Datamation (ital)
dataset passwords
        Version 6
datbases
        EDM pools
date and time
        addition table
        built-in options
        data types 2nd
        dates/non-dates combinations
        durations 2nd
        non-standard dates 2nd
        total number of days
date and time arithmetic 2nd
DATE data type 2nd 3rd
        promotability
DATE durations
DATE format
        nonstandard
DATE function
date/time data
        tables
date/time stamps
        tables 2nd
DAY function
day timestamp unit
DAYOFMONTH function
DAYOFWEEK function
DAYOFWEEK_ISO function
DAYS function
DB2 Catalog
        active 2nd
        CHECK INDEX utility
        columns, customizing
       data sets
                multiple extents
        DDL
        first-time effect
        I/O
       indexes
                rebuilding
        integrated
        links 2nd 3rd
        nonsubvertible
        proliferation
        queries 2nd
        queries.
        reorganizing 2nd 3rd
                synchronizing 2nd
                table spaces 2nd
        REPAIR LOCATE utility
        semiactive
        shadow copies
        size
        SQL access, monitoring
        statistics 2nd 3rd 4th 5th 6th 7th 8th
                column cardinality
                filter factors
                first key cardinality
                HIGH2KEY/LOW2KEY 2nd
                inner/outer tables
                maintenance
                optimizing 2nd 3rd
                relationships
                RUNSTATS
                SYSADMs 2nd
                troublesome queries
                unclulstered indexes
                updateable 2nd 3rd 4th
                updating
                values
        statistics, customizing
        structure 2nd 3rd
        tables 2nd 3rd 4th 5th
                IPLIST
                IPNAMES
                LOCATIONS
                LULIST
                LUMODES
                LUNAMES
                MODESELECT
                SYSAUXRELS
                SYSCHECKDEP
                SYSCHECKS
                SYSCHECKS2
                SYSCOLAUTH 2nd
                SYSCOLDIST
                SYSCOLDIST_HIST
                SYSCOLDISTSTATS
                SYSCOLSTATS
                SYSCOLUMNS
                SYSCOLUMNS_HIST
                SYSCONSTDEP
                SYSCOPY
                SYSDATABASE
                SYSDATATYPES
                SYSDBAUTH
                SYSDBRM
                SYSDUMMY1
                SYSFIELDS
                SYSFOREIGNKEYS
                SYSINDEXES
                SYSINDEXES_HIST
                SYSINDEXPART
                SYSINDEXPART_HIST
                SYSINDEXSTATS
                SYSINDEXSTATS_HIST
                SYSJARCLASS_SOURCE
                SYSJARCONTENTS
                SYSJARDATA
                SYSJAROBJECTS
                SYSKEYCOLUSE
                SYSKEYS
                SYSLINKS
                SYSLOBSTATS
                SYSLOBSTATS_HIST
                SYSPACKAGE
                SYSPACKAUTH
                SYSPACKDEP
                SYSPACKLIST
                SYSPACKSTMT
                SYSPARMS
                SYSPKSYSTEM
                SYSPLAN
                SYSPLANDEP
                SYSPLSYSTEM
                SYSPROCEDURES
                SYSRELS
                SYSRESAUTH
                SYSROUTINEAUTH
                SYSROUTINES
                SYSROUTINES_OPTS
                SYSROUTINES_SRC
                SYSSEQUENCEAUTH
                SYSSEQUENCES
                SYSSEQUENCESDEP
                SYSSTMT
                SYSSTOGROUP
                SYSSTRINGS
                SYSSYNONYMS
                SYSTABAUTH
                SYSTABCONST
                SYSTABLEPART
                SYSTABLEPART_HIST
                SYSTABLES
                SYSTABLES_HIST
                SYSTABLESPACE
                SYSTABSTATS
                SYSTABSTATS_HIST
                SYSTRIGGERS
                SYSUSERAUTH
                SYSVIEWDEP
                SYSVIEWS
                SYSVLTREE
                SYSVOLUMES
                SYSVTREE
                USERNAMES
       tablespaces
                separating
        tuning 2nd 3rd 4th
                contention 2nd 3rd
                data set placement 2nd
                data sets
                indexes 2nd
                performance
                reorganizing
                RUNSTATS
                size
                SQL access, monitoring
                tablespaces, separating
                timeouts/deadlocks
        updates
       utilities
                CATENFM
                CATMAINT 2nd
                DSNJCNVB 2nd 3rd
                MODIFY.
                RUNSTATS 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
                RUNSTATS.
                STOSPACE 2nd 3rd
        Version 4 features
        Version 5 features
        Version 6 features
DB2 Commands option
        DB2I
DB2 Connect 2nd
        advantages
        applications, binding
        character data types
        data transfer rates
        DDF for z/OS
        distributed threads 2nd
        overview 2nd 3rd
        packaging 2nd
                ASE
                EE 2nd 3rd 4th
                PE 2nd
                UE
       packging
                EE
                PE
        SQLCODE/SQLSTATE differences
        supported platforms
        utilities, binding
DB2 Connect Application Server Edition (ASE)
DB2 Connect Enterprise Edition (EE) 2nd
        thread pooling 2nd
DB2 Connect Personal Edition (PE) 2nd
DB2 Connect Unlimited Edition (UE)
DB2 data
        accessing (Internet)
                Java
                Net.Data 2nd 3rd 4th
                network traffic
                software versions
        encrypting 2nd
DB2 Data Warehouse Center.
DB2 DataPropagator.
DB2 Development Center
DB2 Directory
       reorganizing
                regular table spaces 2nd
                restrictions 2nd 3rd
                six special table spaces 2nd
                table spaces 2nd
        REPAIR LOCATE utility
        tables
                DBD01
                SCT02
                SPT01
                SYSLGRNX
                SYSUTILX
       utilities
                CATENFM
                CATMAINT 2nd
                DSNJCNVB 2nd 3rd
                MODIFY.
                RUNSTATS 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
                RUNSTATS.
                STOSPACE 2nd 3rd
DB2 Estimator
        table space space requirements
DB2 Express
DB2 Family
        code bases
        differences 2nd 3rd
                database structures
                directories
                optimizer
        products
DB2 intelligent miner for data
DB2 intelligent miner for text
DB2 intelligent miner scoring
DB2 Interactive.
DB2 Log Preformat utility.
DB2 Magazine (ital)
DB2 Magazine Web site
DB2 objects
        ALIAS
        COLUMN
        DATABASE
        defining 2nd
        hierarchy
        identifiers
        INDEX
        native data types 2nd
        security 2nd
        STOGROUP
        SYNONYM
        TABLE
        TABLESPACE
        VIEW
DB2 OLAP server
DB2 Performance Monitor.
DB2 PM
        monitoring reference 2nd 3rd
        report sets 2nd
                accounting 2nd 3rd 4th 5th 6th
                accounting.
                audit 2nd 3rd
                explain
                I/O activity 2nd 3rd
                locking 2nd
                record trace 2nd 3rd
                SQL trace 2nd 3rd
                statistics 2nd 3rd 4th 5th 6th 7th 8th
                summary 2nd
                system parameters 2nd 3rd
                transit time 2nd 3rd 4th
        report traces, starting 2nd 3rd
DB2 PM (DB2 Performance Monitor)
DB2 resources
       Internet
                bookmarks
                cross-posting (newsgroups)
                emoticons
                FAQs
                flames
                information sources
                mailing list archives
                mailing lists, digesting
                mailing lists, finding
                newsgroups tips
                newsgroups vs mailing lists
                privacy
                search engines
                spams
        mailing lists 2nd
        Usenet newsgroups 2nd 3rd
        Web 2nd 3rd 4th 5th 6th
DB2 tables
       declaring
                application programs
DB2 Times Web site
DB2 Today (ital)
DB2 Update (ital)
DB2 USA Web site
DB2 Version 4
        client/server features
        DB2 Catalog features
        DBA features
        performance features
        programming features
DB2 Version 5
        DB2 Catalog features
        DBA features
        performance features
        programming features
        utility features
DB2 Version 6
        database administration features
        dataset passwords
        DB2 Catalog features
        host variables
        performance features
        programming features
        REBUILD INDEX utility
        RECOVER INDEX utility 2nd
        SROD 2nd
        stored procedure registration 2nd
        Type 1 indexes 2nd
        Type 2 indexes
        utility features
DB2 Version 7
        application development enhancements 2nd 3rd
                Precompiler Services
                row expressiosn
                rows fetched 2nd
                SAVEPOINTs 2nd
                scrollable cursors 2nd
                SPB 2nd
                SQL Assist
        business intelligence enhancements 2nd
        data management enhancements 2nd 3rd
                data sharing
                declared temporary tables 2nd
                deferred data sets creation
                identity columns 2nd
                LOG SUSPEND command
                Unicode 2nd
                utilities 2nd 3rd
        DBA tools
        e-business enhancements 2nd
        migration
        utility core functionality 2nd
        utility improvements
        utility packaging
DB2 Version 8
        architecture 2nd
        DBAs 2nd 3rd
                log volumes
                multi-level security
                padded variable length indexes
                partitions 2nd
                Schema Evolution
                sequences 2nd
        migration 2nd 3rd
        programming 2nd 3rd
                CTEs
                Java
                recursion
                SQL system limits
                XML
DB2 Warehouse Manager.
DB2-enforced referential integrity
DB2-L mailing list
DB2-PM
DB2Audio UDF
        audio
DB2AUDIO UDT
DB2AudioA UDF
        audio
DB2CONN parameter
        command thread attributes 2nd
        connection attributes 2nd
        pool thread attributes 2nd 3rd
        THREADERROR parameter
DB2ENTRY parameter
        thread operation attributes 2nd
        thread selection attributes
DB2I 2nd 3rd 4th 5th 6th
        bind option
        bind panels
        DB2 Commands option
        DCLGEN option
        DCLGEN panel
        Defaults option
        Defaults panel
        environment commands, issuing 2nd
        Free Plan option
        JCL generation panels 2nd 3rd
        main menu
        menu
       panels
                Commands
                Defaults
                Free Package
                Free Plan
                Rebind Package
                Rebind Plan
                Run panel
                SPUFI
                SPUFI Defaults
        precompile option
        Precompile panel
        Program Preparation option
        Program Preparation panel
        rebind option
        Run option
        Run panel
        SPUFI option 2nd 3rd 4th 5th
                defaults
                input data set 2nd
                SPUFI Defaults panel
                SPUFI panel
        Utilities option
DB2I (DB2 Interactive)
DB2ID parameter
        DB2CONN parameter
DB2Image UDF
        image
DB2IMAGE UDT
DB2ImageA UDF
        image
DB2TEXTFH UDT
DB2TEXTH UDT
DB2TRAN parameter 2nd
DB2Video UDF
        video
DB2VIDEO UDT
DB2VideoA UDF
        video
DBA
        Version 4 features
        Version 5 features
        Version 6
DBA tools 2nd
        Version 7 enhancements
DBaAdminGetInaccessibleFiles API
DBADM group-level authorization
DBAs
DBAS
        BM
        DM
DBAs
        procedural
       Procedural
                political issues 2nd
                procedural SQL 2nd
                role 2nd
                schemas
                tasks 2nd
                technical issues 2nd
                triggers
DBAS
        RDS
DBAs
        roles 2nd 3rd
        statistics 2nd 3rd
        Version 8 2nd 3rd
                log volumes
                multi-level security
                padded variable length indexes
                partitions 2nd
                Schema Evolution
                sequences 2nd
DBAS (Database Services Address Space)
DBATs
        inactive 2nd
Dbazine.com (ital)
DBAzine.com Web site
DBCLOB data type
        promotability
DBCLOB function
DBCLOBs (Double Byte Character Large Objects)
DBCTRL group-level authorization
DBD01 table
DBD01 table space
DBDs 2nd 3rd
        multi-table table spaces
        size, reducing
DBDs (database descriptors)
DBE Software, Inc.
DBID column
        INDEXSPACESTATS table
        TABLESPACESTATS table
DBID queries
        QMF forms
DBINFO UDF characteristic
DBMAINT group-level authorization
DBMS
       protection
                stored procedures
DBMS logic support
        Procedural DBA
DBNAME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
DBNAME parameter
        buffer pools
DBRM libraries
        programs, precompiling
DBRMs
        defined
        long accounting reports information 2nd
        names 2nd
        retaining 2nd
DCE (Distributed Computing Environment)
DCL
        data sharing
DCL (Data Control Language)
DCLGEN command
        program preparation 2nd 3rd
                column prefixing 2nd
                null indicators
DCLGEN declare members
        names
DCLGEN libraries
DCLGEN option (DB2I)
DCLGEN panel (DB2I)
DCLGEN statements
        break apart columns 2nd
        DCLGEN libraries
        DCLGEN members 2nd
        field name PREFIX
        host variables, prefixing
        unqualified table references
DCRM (Distributed Communication Resource Manager)
DDF 2nd
        DCRM
        DDIS
        dispatching priority 2nd
        DRDS
        DTM
DDF (Distributed Data Facility) 2nd
DDF for z/OS
DDF suspend/resume
DDFS (Distributed Data Facility Services)
DDIS (Distributed Data Interchange System)
DDL
        applications
        data sharing
        DB2 Catalog
        DSNTIAD
        execution, planning
        IMS
DDL (Data Definition Language)
DDLs
        CICS
DDM (Distributed Data Management)
DE (UDB Developer •s Edition)
deactivating
        versions (online schema changes)
DEADLINE parameter
        online reorganizations
deadlock errors
DEADLOCK parameter
        IRLM address space
deadlocks 2nd
        batch programs
        IMS 2nd
debugging
        CICS tools
       SQL
                Procedural DBA
DEC function
decimal columns
DECIMAL columns
        LOAD utility
DECIMAL data type
        promotability
DECIMAL function
decimal precision
        precompiling
decimals
        precision/scale
declarations (variables)
        LOBs 2nd
declarative referential integrity
        triggers
DECLARE CURSOR statement
        FOR UPDATE OF clause
        order
DECLARE GLOBAL TEMPORARY TABLE statement
DECLARE statement
        cursors
DECLARE TABLE statements
declared temporary tables 2nd 3rd
        advantages 2nd
        scrollable cursors
        storage 2nd
        Version 7 enhancements 2nd
declaring
        cursors
DECPT parameter
DECRYPT_BIT function
DECRYPT_CHAR function
DECRYPT_DB function
Defaults option
        DB2I
Defaults panel (DB2I)
DEFER parameter
        CREATE INDEX statement
deferred data sets
       creating
                Version 7 enhancements
deferred write threshold
        buffer pools
DEFINE NO parameter
        index data sets
DEFINE parameter
        index data sets
defining
        CF
        columns
        LOB columns
        referential constraints 2nd 3rd
        RLSTs
degrees (parallelism)
DEGREES function
DELAY parameter
        online reorganizations
DELETE authority
        restricting
DELETE command
        CICS file processing
DELETE parameter
        MODIFY STATISTICS utility 2nd
DELETE statements
        cursor controlled
        cursors
        mass
        self-referencing
DELETE statemetns
DELETE YES parameter
        CHECK DATA utility
deleting
       columns
                base table views
        data sets
        duplicate rows 2nd
        IN list duplicates
       mass deletes
                LOAD utility
        nonuniform distribution statistics 2nd
       objects
                database object lists 2nd
        PLAN TABLE rows
        remote processing
        RIDs
       rows
                cursors
                non-SELECT dynamic SQL
        trigger packages
        VSAM data sets
delimited input data sets
        loading 2nd
denormalization 2nd 3rd 4th 5th
        avoiding
        combined tables
        data warehouses
        derivable data
       distributed
                fragmentation 2nd 3rd 4th
                replication 2nd
                snapshot tables 2nd
        hierarchies 2nd 3rd 4th
                department
                queries
                speed tables 2nd
        large page sizes
        mirror tables
        pre-joined tables
        redundant data
        repeating groups 2nd
        report tables
        split tables 2nd
        types
        validity, testing
department hierarchies
department table 2nd
dependent tables
       referential constraints
                navigational queries
derivable data
        denormalization
DES tools 2nd
DESC keyword
        ORDER BY clause
DESCRIBE PROCEDURE statements
DESCRIPTION parameter
        DB2CONN parameter
DESCTAT parameter
design
        CICS
                application size 2nd
                Attach Facility availability 2nd
                COBOL file processing
                COBOL verbs
                conditional table access
                conversational applications
                DDLs
                debugging
                linking
                locking problems
                paragraphs, executing
                plans
                sequential number assignments
                SQL
                synchronization
                variables, initializing
       databases
                tuning 2nd 3rd
        online TSO applications 2nd 3rd 4th 5th
                efficient performance
                fast application development
designing
        data warehouses 2nd
                metadata 2nd
                star schema 2nd 3rd
designs
       databases
                tuning
        dynamic SQL
        reviewing 2nd 3rd 4th
                phase five
                phase four
                phase one
                phase seven
                phase six
                phase three
                phase two
destinations
       trace
                specifying
        traces 2nd
DETAIL parameter
        DISPLAY BUFFERPOOL command
DETERMINISTIC parameter
        UDFs
DETERMINISTIC UDF characteristic
developing
        application programs
       applications
                Version 7 enhancements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
        applications (SQL only)
                domains, simulating 2nd 3rd
                integrity
                native SQL
        SQL stored procedures
        stored procedures
                LE/370 language
                nested procedure calls 2nd
                parameters 2nd
                program preparations
                result sets, returning 2nd 3rd
development
        CASE tools support
       RDBMS
                cardinal rule
DFSMS
        backup copies
DFSMS copies
        recovering
DFSORT utility
        sort work spaces
DIAGNOSE utility
diagramming
        CASE tools support
dictionaries
        compression
        data
dictionary pages
digesting
        mailing lists
DIGITS function
Direct Computer Resources
direct index lookups
direct requests
        Net.Data
direct row access
        online applications 2nd
directories
        DB2 Family differences
Directory (DB2)
       reorganizing
                regular table spaces 2nd
                restrictions 2nd 3rd
                six special table spaces 2nd
                table spaces 2nd
        REPAIR LOCATE utility
        tables
                DBD01
                SCT02
                SPT01
                SYSLGRNX
                SYSUTILX
       utilities
                CATENFM
                CATMAINT 2nd
                DSNJCNVB 2nd 3rd
                MODIFY.
                RUNSTATS 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
                RUNSTATS.
                STOSPACE 2nd 3rd
dirty reads
        BIND statements 2nd 3rd 4th
                benefits
                problems
                UR isolation levels 2nd
        data warehouses
        isolation levels
                advantages 2nd
                implementing 2nd
                requirements
DISABLE PARALLEL parameter
DISABLE parameters
        BIND statements 2nd
DISABLE QUERY OPTIMIZATION parameter
disabling
        environments
        index access
        list prefetch 2nd
        parallel
disaster recovery
        active log sizes
        archiving
        backups
        compression
        copying
        documentation
        environments 2nd
        normal business return
        offsite copies
        offsite recovery validation
        planning
       QMF forms
                DBID/PSID/OBID queries
        shipping image copies offsite
        table spaces
        testing
disaster recovery plans 2nd
        application classes 2nd
        DSN1COPY 2nd 3rd
        instant copies/restore 2nd
        RECOVER utility
        recovery basics
        requirements 2nd
        risks
        scalpel 2nd 3rd 4th 5th
        SET LOG SUSPEND command 2nd
        sledgehammer 2nd
        synchronizing
disasters
        defined 2nd
DISCONNECT parameter
DISCONNECT parameters
        application-directed distribution
disk devices
        retrieval costs
disk options
        TEMPLATE statement 2nd
disk volumes
        storage groups
disks
        COPY utility image copies
DISP option
        TEMPLATE statement
dispatching priorities
        batch jobs
        hierarchy
dispatching priority (DDF) 2nd
DISPLAY (/ before) command
DISPLAY BUFFERPOOL command
        DETAIL parameter
DISPLAY command
        OVERVIEW parameter
        resource status, viewing
DISPLAY DATABASE command 2nd 3rd 4th 5th
        ACTIVE paraemter
        CLAIMERS/LOCKS clauses
        RESTRICT parameter
        USE parameter
        wildcards
DISPLAY FUNCTION SPECIFIC command 2nd
DISPLAY GROUP command
DISPLAY LOG command
DISPLAY PROCEDURE command 2nd
DISPLAY UTILITY command 2nd
        LOAD utility
        utilities, monitoring
DISTINCT keyword 2nd
        clauses
DISTINCT TYPE class privileges
distinct type names
Distributed Communication Resource Manager.
Distributed Computing Environment.
distributed cursors
        client/server applications
distributed data
        accessing
                application-directed 2nd 3rd 4th
                methods, comparing
                system-directed 2nd 3rd 4th
       DRDA
                architectures 2nd 3rd 4th
                benefits 2nd
                five levels 2nd 3rd 4th 5th 6th 7th
                functions 2nd 3rd 4th 5th
                overview
                RDA, compared
                remote processing location example 2nd
        placement 2nd
       private protocol
                converting to DRDA
Distributed Data Facility Services.
Distributed Data Facility. 2nd
Distributed Data Interchange System.
Distributed Data Management.
distributed denormalization
        fragmentation 2nd 3rd 4th
        replication 2nd
        snapshot tables 2nd
distributed processing
distributed query blocks
        controlling
Distributed Relational Data System.
Distributed Relational Database Architecture.
distributed requests (DRDA)
distributed threads
        DB2 Connect 2nd
Distributed Unit of Work .
distributed unit of work.
distributing data
        ASCII support
        binding options 2nd
        block fetches
                continuous 2nd 3rd
                cursors 2nd 3rd 4th 5th
                data currency 2nd 3rd
                limited 2nd 3rd
        CDB 2nd
        client/server applications
        DDF
        DDF suspend/resume
        DDF.
        dynamic cursor pre-opens
        locations
       one-phase commit
                two-phase, compared
        optimization 2nd 3rd
        partitioned table spaces
        performance
                buffer pools
                DDF dispatching priority 2nd
                OPTIMIZE FOR n ROWS clause
                response times
                SQL result sets
                throughput chains
                throughput, analyzing 2nd 3rd
                VTAM parameters 2nd
        problem resolution logs
        remote processing, deleting
        requests
        requests, combining
        security
                authid translations 2nd
                come-from checking
                PUBLIC AT ALL LOCATIONS parameter
        TCP/IP support
       threads
                connection pools 2nd
                inactive DBATs 2nd
        two-phase commit
                actual commit 2nd
                multi-site updates
                one-phase, compared
                preparation phase
                syncpoint trees
        type-2 connections
        Unicode support
        units of work
        Version 8
                database aliases
                location aliases
                TCP/IP network member routing
        versions (DB2)
        workstation DB2
divertable transactions
DL/I batch interface 2nd
DM
DM (Data Manager)
DML (Data Manipulation Language)
Document Type Definitions.
documenting
        disaster recovery strategies
domains
        simulating 2nd 3rd
        views support 2nd 3rd
Double Byte Character Large Objects.
DOUBLE data type
        promotability
DOUBLE function
down-level data sets
        repairing
DPMODE ENTRY macro parameter
DPMODE POOL macro parameter
DPMODI RCT INIT macro parameter
DPROP (DB2 DataPropagator)
DPSIs
        troubleshooting 2nd
DPSIs (data partitioned secondary indexes) 2nd
drains 2nd 3rd
        claims compatibility 2nd 3rd
        locks
DRAW command
        QMF
DRDA
       architectures
                APPC
                CDRA
                DDM
                FD( colon )OCA
        benefits 2nd
        five levels 2nd
                distributed requests
                distributed unit of work
                remote processing location example 2nd
                remote request
                remote unit of work
                user-assited distribution
        functions
                application requesters
                application server
                database server
                returns
        ODBC, compared
        overview
        private protocol distribution, converting
        RDA, compared
DRDA (Distributed Relational Database Architecture)
DRDA levels
        DUW
        remote request
        RUW
DRDS (Distributed Relational Data System)
drivers
        JDBC 2nd
DROLLBACK parameter
        CICS pool thread attributes
        CICS thread operation attributes
DROP parameter
        REPAIR DBD utility
        tables
DS (database server) function
DSD tools
DSN command
DSN command processor
        invoking
        TSO online applications 2nd
DSN commands 2nd 3rd
        group attach processing
        sessions, terminating
        tracing
DSN FUNCTION TABLE 2nd 3rd 4th
        columns
        RUNSTATS
DSN option
        TEMPLATE statement
DSN STATEMENT TABLE 2nd 3rd
        columns 2nd 3rd
                APPLNAME
                COLLID
                COST CATEGORY
                EXPLAIN TIME
                GROUP MEMBER
                PROCMS
                PROCSU
                PROGNAME
                QUERYNO
                REASON
                STMT ENCODE
                STMT TYPE
        RUNSTATS
        version 8
DSN_FUNCTION_TABLE table 2nd 3rd
        columns 2nd
DSN_FUNCTION_TABLE.
DSN_STATEMNT_TABLE.
DSN1CHKR (Catalog Integrity Verification) utility
DSN1CHKR utility 2nd
        integrity verification
        JCL
        read-only mode
        scheduling
        table spaces
DSN1COMP (Compression Analyzer) utility
DSN1COMP utility
        compression, planning
        DSSIZE parameter
        JCL
        PAGESIZE parameter
        parameters
        prefixes
DSN1COPY (Offline Copy) utility
DSN1COPY disaster recovery strategy 2nd 3rd
DSN1COPY utility 2nd
        BUFND parameter
        hex dumps
        identity columns
        JCL listing
        large table spaces
        LOB table spaces
        log data sets
        OBIDXLAT option
        OBIDXLAT option JCL
        PAGESIZE parameter
        prefixes
        record OBIDs, translating
        running
        SYSUT2 data set
        SYSXLAT file
DSN1LOGP (Recovery Log Extractor) utility
DSN1LOGP utility
        active logs
        JCL
        output reports
DSN1PRNT (Data Set Dump Creator) utility
DSN1PRNT utility 2nd 3rd
        errors
        JCL
        LOB table spaces
        page sizes
        PAGESIZE parameter
        running
DSN1SDMP
        utility
                JCL
DSN1SDMP (Dump and Trace) utility.
DSN1SDMP utility
        data sets
        user authority
DSN8810.ACT table
        DDL
DSN8810.DEPT table 2nd
DSN8810.EMP table 2nd
DSN8810.EMP_PHOTO_RESUME table 2nd
DSN8810.EMPPROJACT table
DSN8810.PROJ table 2nd
DSN8810.PROJACT table 2nd
DSN8DLPL application
DSN8DLRV application
DSN8ED3 sample program
DSN8ES1 sample program
DSN8HUFF routine
DSNACCOR stored procedure 2nd
DSNC command
DSNC DISCONNECT command
DSNC DISPLAY command
DSNC DISPLAY STATISTICS command 2nd
DSNC MODIFY command
DSNC STOP command
DSNC STRT command
DSNCLI language interface
DSNDB04 parameter
DSNDB07 work file database
DSNDB07 work files
DSNH command
DSNHSQL sample program
DSNJ002I message
DSNJ1391 message
DSNJCNVB utility 2nd
        BSDS, expanding
DSNJLOGF utility 2nd
        (DB2 Log Preformat)
        JCL listing
        timestamps
DSNJU003 (Change Log Inventory) utility
DSNJU003 utility
        CCSID information
        data sharing
        JCL listing
        RESTORE SYSTEM utility combination
        running
DSNJU004 (Print Log Map) utility
DSNJU004 utility 2nd
DSNT375I messages
DSNT376I messages
DSNT501I messages
DSNTEJ63 sample program
DSNTEJ64 sample program
DSNTEP2 (dynamic SQL processor) application 2nd 3rd
        batch environment
        comments
        error handling
        input data sets
        rerunning
DSNTEP2 (sample unload) application
        return codes
DSNTEP2 application
DSNTIAD (dynamic SQL update) application 2nd 3rd
        comments
        DDL
        error handling
        executing authority
        JCL
        preparations
        rerunning
DSNTIAD (sample unload) application
        return codes
DSNTIAUL (sample unload) application 2nd 3rd
        data movement
        JCL
        LOCK TABLE statement
        maximum unloads
        preparations
        return codes
        SQL statements
        SYSREC data sets
        unloaded flat files
        views, unloading
        WHERE/ORDER BY clauses
DSNTPSMP
        SQL stored procedures, creating
DSNTPSMP (SQL procedure processor)
DSNU command
DSNUTILB parameter
DSNZ002I message
DSNZPARM parameter
        lock escalation
        table spaces 2nd
DSNZPARMs
        tuning
                active users
                EDM pools
                locks
                logs 2nd
                timeouts 2nd
                traces
DSSIZE parameter
        DSN1COMP utility
        DSN1COPY parameter
        partitioned table spaces
        table spaces
DTD repository tables 2nd
DTDs (Document Type Definitions)
DTM (Data Transaction Manager)
dual image copies
        COPY utility
dummy tables
Dump and Trace utility.
dumps
        REPAIR LOCATE utility
duplexing
        data sharing group buffer pools
        group buffer pools 2nd 3rd 4th
duplicate rows
        deleting 2nd
Duration UDF
        audio
        video
durations
        date and time 2nd
DUW
DUW (distributed unit of work)
DUW (Distributed Unit of Work)
DWQT parameter
        buffer pools
dynamic authorities
dynamic cursor pre-opens
dynamic data
       accessing
                dynamic SQL
DYNAMIC parameter
        scrollable cursors 2nd
dynamic plan
        selecting 2nd
dynamic reoptimization
dynamic scrollable cursors 2nd 3rd
dynamic sequential prefetches
dynamic SQL 2nd 3rd
        access, customizing 2nd
        advantages/disadvantages
        avoiding
        bind-time authorization checking
        classes
        designs
        dynamic data, accessing
       EXECUT IMMEDIATE statement
                host variables
                one-time processing
                syntax
        EXECUTE IMMEDIATE statement 2nd
        fixed-list SELECT 2nd 3rd
                flexibility
                listing
                parameter markers 2nd
                prepared statements
                SQLDA
        flexibility
        governing
        JDBC
        maintenance design
        non-SELECT 2nd 3rd
                EXECUTE IMMEDIATE statements, compared
                parameter markers 2nd
                prepared statements
                rows, deleting
                syntax
        non-uniform data
        overview
        parallelism
        parameter markers
        performance 2nd
        prepared statements, caching 2nd 3rd
        prepares, reducing
        QMFCI
        reoptimization
        RLSTs
        static SQL, compared
        tuning
        varying-list SELECT 2nd 3rd 4th 5th
                listing
                minimal SQLDA
                SQLDA 2nd
                SQLTYPE values 2nd
        varying-list SELECT statements
dynamic SQL processor (DSNTEP2) application 2nd 3rd
dynamic SQL statements
        stored procedures
dynamic SQL update (DSNTIAD) application 2nd 3rd
dynamic system parameters
DYNAMICRULES parameter
        BIND statements 2nd 3rd
dynamism
        SQL statements