index_I

 <  Day Day Up  >    

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

I-marks
I/O
       application
                tuning 2nd 3rd
       internal
                tuning 2nd
       log
                tuning 2nd 3rd 4th
       paging
                tuning 2nd 3rd
        query I/O parallelism
       RAMAC
                tuning
        sort
                tuning 2nd
        tuning 2nd 3rd
                application 2nd 3rd
                costs, minimizing
                DB2 Catalog
                disk device retrieval costs
                internal 2nd
                log 2nd 3rd 4th
                page retrieval
                paging 2nd 3rd
                RAMAC
                sort 2nd
                write operations
I/O (input/output)
I/O activity report sets 2nd 3rd
I/O Activity Summary report 2nd
I/O costs
        optimizer
I/O parallelism
I/O routines
        application development
IBM
IBM DB2 for OS/390 and z/OS Web site
IBM Redbook Web site
IBM SERVICE DATA column
        PLAN TABLE
IBM SQL reserved words 2nd
IBM System Journal (ital)
IBM utility packages 2nd 3rd
ICTYPE column
        SYSIBM.SYSCOPY table
IDBACK parameter 2nd
identical input parameters
        stored procedures
        UDFs
identifiers
       collection
                packages
        DB2 objects
       location
                packages
identity columns 2nd 3rd
IDENTITY columns
identity columns
        copying
IDENTITY columns
        navigational queries
identity columns
        problems 2nd
        sequence objects, compared 2nd
        values
        Version 7 enhancements 2nd
identity protection (Internet)
IDENTITY_VAL_LOCAL function
IDFORE parameter 2nd
IDs
       subsystem
                CICS
       utility
                names
IDUG (International DB2 User Group )
IDUG Solutions Journal (ital)
IDUG Web site
IFCIDs
        traces
IFI (Instrumentation Facility Interface) 2nd
IFNULL function
image copies
       compressing
                COPY utility
        consistent, recovering
        DB2 Catalog reorganization
        falling back to previous
        full.
       GDG
                relative generation numbers
       incremental
                logs, reading
        incremental.
        indexes
        MODIFY RECOVERY utility
        shipping offsite
        SHRLEVEL CHANGE
        tablespaces
image copy data sets
        allocating
        specifying
IMMEDWRITE parameter
        binding
        data sharing
impedance mismatches
implementing
        data warehouses 2nd
        LOBs
        online schema changes
        optimization hints
        RI
       security
                views
        stored procedures 2nd 3rd
        triggers 2nd
Importer UDF
        audio
        image
        video
ImportTime UDF
        audio
        image
        video
IMS
        applications 2nd
        Attach Facility 2nd 3rd
        CICS, compared
        cursor closing points
        databases, accessing
        DDL
        deadlocks 2nd
        DL/I batch interface 2nd
        ESA quick reschedule
        Fast Path databases
        IRLMs, sharing
        online considerations 2nd
        PCBs, copying
        restarting
        RTTs
        SPAs
       SYSGEN
                PROCLIM paramter
                read-only transactions
                transaction modes
                WFI transactions
        testing pools
        threads 2nd
        TM regions
        two-phase commits 2nd 3rd
IMS (Information Management System)
IMS commands 2nd 3rd
IMS databases
       accessing
                stored procedures
IMS/TM online applications 2nd
IMSI
IN DATABASE clauses
        tables
IN lists
        duplicates
        ordering
IN parameter
        CREATE PROCEDURE statement
IN predicate
in-doubt threads
in-house training (DB2)
inactive DBATs 2nd
inactive threads
        connection pools 2nd
inbound authid translations
INCLUDE clause
        LISTDEF statement 2nd
INCLUDING COLUMN DEFAULTS parameter
INCRCOPY parameter
        DSN1COMP utility
incremental copies
        full image copies, balancing
        MERGECOPY utility
incremental image copies
        JCL listing
        logs, reading
index copy
        JCL listing
index data pages 2nd
        Type 1
        type 1 leaf 2nd 3rd
        type 1 non-leaf
        Type 2 2nd 3rd
INDEX DB2 object
index keys
        length 2nd
        sorting
index lookasides
index only access
index space
index-only access 2nd 3rd
indexability
        predicates 2nd
        simple statements
INDEXBP parameter
indexed columns
        joins
        updating
indexes 2nd
        access, disabling
        auxiliary tables
        avoiding
        b-trees
        buffer pools
        caching
        clustering 2nd
                customizing 2nd
                ignoring
        column cardinality 2nd
        column data type changes
        columns
                adding 2nd
                avoiding
                extra
                multiple
        considerations 2nd
       copying
                COPY utility
        creating 2nd 3rd 4th 5th
        customizing 2nd
        data monidification
       data sets
                size 2nd 3rd
        data sets, defining
       data synchronization
                COPY utility
        data warehouses
        database object lists
        databases
       DB2 Catalog
                rebuilding
        deferring creation
       disk storage
                monitoring
        DPSIs 2nd
                troubleshooting 2nd
        entries 2nd
        foreign keys
        free space 2nd
        image copies
        index data pages
        index key length 2nd
        index space
        index-only access 2nd
        indexed access 2nd 3rd 4th 5th 6th
                clustered index access
                direct index lookups
                index lookasides
                index scans
                index screening
                index-only access
                list prefetches 2nd
                matching index scans 2nd
                multi-indexes 2nd
                non-clustered index access
                non-matching index scans 2nd
                skip sequential prefetches
        large insertions
        large tables
        leaf pages
       levels
                reating
        LOAD utility
        loading tables
        lookasides
        MQTs
        multi-index access 2nd
        multiple
        multiple nulls
        names 2nd 3rd
        navigational queries
        non-partitioned
        non-partitioning 2nd
        nonleaf pages
        NPSI
        online schema changes
                clustering 2nd 3rd 4th
                columns, adding 2nd
        padded variable length
                Version 8
        padded/non-padded
        pages 2nd
       partition levels
                checking
        partitioned 2nd
                starting/stopping
        partitioned table spaces
        partitioning 2nd 3rd 4th 5th 6th
        physical characteristics
        PLAN TABLE
        primary keys
        primary/secondary space allocations
        rebuilding
        recover pending flags
        recovery
        REORG INDEX utility
                locking
        REORG phases 2nd
        reorganizing
                REORG utility 2nd
        RIDs
        root pages
        RTS
        RUNSTATS, running
        scan queries
        scans
                avoiding
                matching 2nd
                non-matching 2nd
        screening
        secondary
                partitioned
        small tables
        statistics
        statistics query
        storage 2nd
        storing
        structure 2nd
       system
                reorganizing
        tables
        three-level
                pages
        two-level
                pages
        Type 1
                pages
                Version 6 2nd
        type 1 leaf pages 2nd 3rd
        type 1 non-leaf pages
        Type 2
                organizing
                pages 2nd 3rd
                storage 2nd 3rd
                Version 6
        unclustered
        uniqueness
        validity
        VARCHAR columns
        variable columns 2nd
        variable index keys 2nd
       versions
                REBUILD INDEX utility
        workload analysis 2nd
INDEXONLY column
        PLAN TABLE
INDEXSPACESTATS table
        columns 2nd 3rd
indicator variables
        LOB locators
INDREFLIMIT parameter
        REORG utility
industry periodicals 2nd 3rd 4th
infinite loops
        preventing 2nd
influencing
        optimizer 2nd
                DB2 Catalog statistics.
                optimization hints 2nd 3rd 4th 5th
                OPTIMIZE FOR n ROWS clause 2nd 3rd
                SQL statements, tweaking 2nd 3rd
                standard methods 2nd 3rd 4th 5th
Informatica
Information Builders Inc.
Information Integrator
Information Integrator for Content
Information Management System.
information-gathering commands 2nd
        active objects, viewing
        buffer pools, monitoring
        buffer pools, tuning
        centralized areas
        database information, viewing
        database usage
        grouping buffer pools
        information, limiting
        LIMIT parameter
        LIST/LSTATS parameters
        locking information, viewing
        logging, monitoring
        LPLs, viewing
        objects, monitoring 2nd 3rd 4th
        OVERVIEW parameter
        restricted objects
        stored procedures, monitoring
        UDF statistics, monitoring
        utilities, monitoring 2nd
        wildcards
informational referential constraints
        checking
Infospace
Infotel Corporation
INIT macro parameters
        RCT 2nd 3rd 4th
                DPMODI
                ERRDEST
                PCTEROP
                PLANI
                PLNPGMI
                PLNXTR1
                PLNXTR2
                PURGEC
                ROLBI
                SHDDEST
                SIGNID
                SNAP
                STANDBY
                STRTWT
                SUBID
                SUFFIX
                THRDMAX
                TOKENI
                TRACEID
                TWAITI
                TXIDSO
Init_Text_Handle UDF
        text
initializing
        host variables
        variables
initiators
inline copies
        COPYTOCOPY utility
       creating
                LOAD utility
inline statistics
       gathering
                LOAD utility 2nd
                REORG utility 2nd
                RUNSTATS utility
inline views.
inner joins
        explicit
INNER keyword
        joins
inner tables
INOUT parameter
        CREATE PROCEDURE statement
input data set
        SPUFI 2nd
input data sets
        DSNTEP2 utility
        sequencing 2nd
input/output.
insensitive scrollable cursors
INSERT authority
        restricting
INSERT function
INSERT statements
        base table views
        columns, listing
        LOAD utility, compared
        multiple rows
        set-level processing
inside-out subquery access
INSTALL SYSADM group-level authorization
INSTALL SYSOPR group-level authorization
instances.
instant copies/restore disaster recovery 2nd
Instant Copy and Recover 2nd
Instrumentation Facility Interface. 2nd
INT function
INT tools 2nd
integer columns 2nd
INTEGER data type
        promotability
INTEGER function
integration
        data warehouses, populating 2nd
integrity
        check constraints 2nd 3rd
                advantages
                semantics
                table-level coding
                triggers, comapred
       data
                FOR UPDATE OF clause
                stored procedures
       declarative referential
                triggers
        edit procedures
        field procedures
       referential
                data warehouses
                triggers 2nd 3rd
        referential.
        SQL only applications
        triggers
        validation routines
integrity tools 2nd
Intelligent Enterprise (ital)
intelligent miner for data
intelligent miner for text
intelligent miner scoring
inter-system communications
        CF
interfaces
       attachment
                data sharing
        DL/I batch 2nd
internal DBA tools
        stored procedures
internal I/O
        tuning 2nd
International DB2 User Group.
Internet
        accessing
        bookmarks
        cross-posting (newsgroups)
        DB2 data access
                Java
                Net.Data 2nd 3rd 4th
                network traffic
                software versions
        DB2 functions
        DB2 resources
                mailing lists 2nd
                Usenet newsgroups 2nd 3rd
                Web 2nd 3rd 4th 5th 6th
        emoticons
        FAQs
        flames
        information sources 2nd
        mailing lists 2nd
                archives 2nd
                DB2 resources 2nd
                digesting
                finding 2nd
                newsgroups, compared
                privacy
        mailing lists, digesting
        newsgroup tips
       newsgroups
                cross-posting
                mailing lists, compared
                tips
        newsgroups vs mailing lists
        privacy 2nd
        search engines
        spams
        Usenet newsgroups 2nd
                DB2 resources 2nd 3rd
        WWW 2nd 3rd
                DB2 resources 2nd 3rd 4th 5th 6th
Internet enabling tools
Internet FAQ Consortium Web site
Internet Service Providers.
Intersystem Resource Lock Manager.
intranets
IPLIST table 2nd
IPNAMES table
IRLM
        tuning 2nd 3rd
IRLM (Intersystem Resource Lock Manager)
IRLM address space
        tuning 2nd
IRLM commands 2nd 3rd
IRLM parameters
        locks
IRLMRWT value (DSNZPARMs)
IRLMs
        sharing
IS NOT DISTINCT FROM comparison operator
        nulls
IS NULL predicate
ISO week timestamp unit
ISO year timestamp unit
ISOBID column
        INDEXSPACESTATS table
isolation levels
        BIND statements
        dirty reads
                advantages 2nd
                implementing 2nd
                requirements
        individual SQL statements
        Java
        SQL statements
        UR 2nd 3rd
ISOLATION parameter
        data sharing locks
        dirty reads 2nd 3rd
                advantages 2nd
                requirements
        page/row locks 2nd 3rd 4th
ISPF panels
        TSO
ISPF tables
        TSO 2nd
ISPs (Internet Service Providers)
ITRACE parameter
        IRLM address space

 <  Day Day Up  >    


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

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