index_B

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

b-trees (indexes)
backing up
       data
                COPY utility
        data sharing
        data warehouses
       system
                BACKUP SYSTEM utility 2nd 3rd 4th 5th
        table spaces
        XML administration support tables
BACKUP SYSTEM utility 2nd 3rd
        concurrency
        phases
backup utilities
        COPY 2nd 3rd
                CHANGELIMIT parameter 2nd 3rd
                concurrency 2nd
                data/index synchronization
                DFSMS
                disks
                dual image copies
                full image copies
                full image copy JCL
                image copies, compressing
                incremental image copy JCL
                incremental/full image copies, balancing
                index copy JCL
                indexes
                locking 2nd
                logs, suspending
                performance
                phases
                recovery points
                recovery time
                restarting
                RI- related objects, copying
                sequential prefetch
                SYSCOPY data set, allocating 2nd
                SYSCOPY data set, buffering
                SYSIBM.SYSCOPY table
                system page placement
        COPYTOCOPY 2nd
                concurrency
                inline copies
                JCL example
                locking
                phases
                running 2nd 3rd
        MERGECOPY 2nd
                concurrency
                full image copies
                incremental copies
                JCL
                phases
                SYSCOPY data set 2nd
                SYSUT1 data set 2nd 3rd
        QUIESCE 2nd
                concurrency
                JCL
                locking
                pahses
                partition levels
                recovery points
                running
                system databases
                table spaces 2nd 3rd
                TABLESPACESET parameter
                WRITE option
        REBUILD INDEX
                concurrency
                index versions
                JCL listing
                large indexes
                locking
                phases
                rerunning
                system indexes
                SYSUT1 data sets
                VSAM data sets
                work data sets
        REPAIR
        REPORT RECOVERY 2nd
                JCL listing
                locking
backups
        disaster recovery
base data types
        UDTs, compared
base tables
       views
                columns , adding 2nd 3rd
                columns, deleting
                combined tables
                creating 2nd 3rd 4th 5th
                split tables 2nd
Basic Cursor Table.
batch applications
        IMS
        TSO 2nd 3rd 4th
batch jobs
        dispatching priorities
batch message processor applications
        IMS
batch procedures
        program preparation 2nd
batch processing
        operating environments
batch programs
        clustered access
       COMMIT statements
                data customizations 2nd
                scheduling
        cursor repositioning
        deadlocks
        LOCK TABLE command
        lock timeouts
        locking
        parallel processing 2nd 3rd
        restarting 2nd 3rd 4th 5th
        units of work 2nd 3rd 4th
Batch Terminal Simulator.
BCT (Basic Cursor Table) plan messages
BEFORE keyword
        scrollable cursors
before triggers 2nd 3rd
bends
       AEY9
                avoiding
BETWEEN predicate
BEZ Systems
Binary Large Objects.
BIND command
        CACHESIZE parameter
        program preparation 2nd
        reactive governing
BIND PACKAGE command
        program preparation
BIND package parameters
        locks
bind panels (DB2I)
BIND parameters
       locks
                pages/rows 2nd 3rd 4th
                table spaces
BIND PLAN command
        program preparation
BIND plan parameters
        locks
BIND statements
        ACTION parameter
        CACHESIZE parameter
        collections
        DBRMs, retaining
        default parameters
        dirty reads 2nd 3rd 4th
                benefits
                problems
                UR isolation levels 2nd
        dynamic reoptimization
        DYNAMICRULES parameter 2nd 3rd
        ENABLE/DISABLE parameters 2nd
        errors
        explicit consistency tokens
        IMMEDWRITE parameter
        initial administration
        isolation levels
        like programs, grouping
        lock avoidance
        mirror tables
        multiple qualified tables
        OPTHINT parameter
        packages 2nd
        packages, creating
        parallelism 2nd
        PATH parameter
        plans
        prepared statements
        production BINDs
        QUALIFIER parameter
        read stability
        reoptimization
        reoptimization, isolating
        repeatable reads 2nd 3rd
                page locking
        RETAIN parameter
        statistics (current)
        tabe space locking 2nd
        validation
        wildcard package lists
BIND time
        monitoring
BIND TIME column
        PLAN TABLE
bind-time authorization checking
BIND_OPTS column
        SYSIBM.SYSPSMOPTS table
BINDAGENT authority
BINDAGENT group -level authorization
BINDCT plan messages
binding
       applications
                DB2 Connect
        data sharing
        DB2 Connect utilities
        DB2I
        distributed environment options 2nd
        online TSO applications
        packages
                DB2I
        plans 2nd
                DB2I
        production plans
        program precompiling
BitsPerSample UDF
        audio
        video
black boxes
        application programs 2nd
BLOB data type
        promotability
BLOB function
BLOBs (Binary Large Objects)
block fetches
        continuous 2nd 3rd
        cursors
                ambiguous
                FOR READ ONLY/FOR FETCH ONLY clauses
                non-updateable
                read-only
        data currency 2nd 3rd
        limited 2nd 3rd
block style coding
        SQL statements 2nd 3rd
BM
BM (Buffer Manager)
BMC Instant Copy and Recover 2nd
BMC Software
BMC Software Web site
bodies
        SQL stored procedures 2nd
Book Manager Library Reader
bookmarks
        Internet
boundaries
       partitions
                table spaces
BP0
        monitoring
        optimizing
BP32
BP32K
        allocating
Brio Technology
broken page bits
        repairing
browsing
        cursor-free
BSDS
        expanding
BTS (Batch Terminal Simulator)
Buffer Manager.
buffer pools
       active
                converting
        allocating
        allocations
       BP0
                optimizing
        BP0, monitoring
        BP32
        BP32K
        BP32K, allocating
        data sharing
       data sharing group buffer pools
                tuning 2nd 3rd 4th 5th
        deferred write threshold
        defining
        distributed
        FIFO algorithm
        group duplexing 2nd 3rd 4th
        grouping
        hit ratios
        indexes
        LOBs
        long accounting reports 2nd 3rd 4th
        LRU algorithm
        monitoring
        multiple 2nd
                assignments
                memory
                processing requirements
        one large buffer pool 2nd
        page stealing algorithm
       parameters
                tuning
        reserving
        size
                tuning 2nd 3rd
        sort
        storage groups
        subsystem size
        table spaces 2nd
                sizes
                specifying
        thresholds
        throughput
        tuning 2nd 3rd 4th 5th 6th 7th 8th
                access, isolating
                allocation 2nd
                available pages
                example scenario 2nd
                multiple buffer pools 2nd
                one large buffer pool 2nd
                performance
                processing 2nd
                reserving
                stealing
                tables, isolating
                unavailable pages
        tuning parameters
                DWQT
                PGSTEAL
                VDWQT
                VPSEQT 2nd 3rd 4th 5th 6th
                VPSIZE
                VTYPE
        workloads
buffering
        global data 2nd
                buffer pools
                group buffer pool duplexing 2nd
                updating/reading data 2nd
        non-DB2 data sets
        SYSCOPY data set
       work data sets
                LOAD utility
                REORG utility
BUFFERPOOL parameter
        table spaces 2nd
                sizes
                specifying
bufferpools
        sequential prefetch values
        sequential prefetch/detection values 2nd
buffers
        maximizing
        message
BUFND parameter
        DSN1COPY utility
BUFNO option
        TEMPLATE statement
BUFNO parameter
        MERGECOPY utility
        utilities
BUILDNAME column
        SYSIBM.SYSPSMOPTS table
BUILDOWNER column
        SYSIBM.SYSPSMOPTS table
BUILDSCHEMA column
        SYSIBM.SYSPSMOPTS table
built-in functions 2nd
        guidelines
                column function results, searching
                nulls
                synonyms, avoiding 2nd
                UPPER vs TRANSLATE functions
        MQSeries 2nd 3rd
        XML publishing 2nd
built-in security groupings
built-in stored procedures 2nd
Bunker Hill
business intelligence
        Version 7 enhancements 2nd
Business Objects, Inc.
BY DEFAULT parameter
        rows/columns
bytecodes (Java)
BytesPerSec UDF
        audio
        video