Understanding DB2: Learning Visually with Examples (2nd Edition)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

Backout

Backslash (\), CLP line continuation 2nd 3rd 4th BACKUP DATABASE command 2nd Backup files 2nd 3rd 4th Backup images Backup pending

Backups

    BACKUP DATABASE command [See Databases;cloning, recovery, Databases;relocating, transaction logs]    case study [See Databases;cloning, recovery, Databases;relocating, transaction logs]    cumulative [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    databases [See Databases;cloning, recovery, Databases;relocating, transaction logs]    definition [See Databases;cloning, recovery, Databases;relocating, transaction logs]    delta [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    high availability

        cloning a database [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        creating a backup image [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        creating a standby database [See Databases;cloning, recovery, Databases;relocating, transaction logs]        db2inidb mirror command [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        db2inidb snapshot command [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        db2inidb standby command [See Databases;cloning, recovery, Databases;relocating, transaction logs]        mirror option [See Databases;cloning, recovery, Databases;relocating, transaction logs]        partitioned environments [See Databases;cloning, recovery, Databases;relocating, transaction logs]        snapshot option [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        split mirroring [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        standby option [See Databases;cloning, recovery, Databases;relocating, transaction logs]

        suspended I/O support [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    incremental [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    online access versus offline [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    table space [See Databases;cloning, recovery, Databases;relocating, transaction logs]

    with Control Center [See Databases;cloning, recovery, Databases;relocating, transaction logs]

Base tables

Basic view

Before trigger

BEFORE triggers 2nd

BEGIN NEW STRIPE SET clause 2nd

BETWEEN predicate

BID (block identifier)

Big integer (BIGINT) data type 2nd

BIGINT (big integer) data type 2ndBinary large object (BLOB) [See BLOB (binary large object] Bind

bind command, modifying isolation levels 2nd

Bind file BINDADD authority 2nd

Bit data

BLOB (binary large object)     definition

     description     exporting 2nd

Block fetch Block identifier (BID) Block indexes 2nd 3rd Block locks Block maps 2nd

Block size

Block-based I/O Blocking Blocks

Books and publications    periodicals [See resources]    referenced in this book [See resources]

bp_resizeable keyword

Buffer manipulators

Buffer pools

     creating 2nd 3rd 4th 5th     definition 2nd 3rd

     DPF environment

     dropping     examples 2nd 3rd     extracting information from 2nd 3rd 4th     maximizing size (Windows)

     modifying 2nd

     page cleaning

     prefetching

     prefetching and cleaning

     table spaces 2nd 3rd 4th 5th

Built-in data types 2nd 3rd 4th 5th

Built-in functions

Business intelligence