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]

rah command

Rational brand 2nd RDBMS (relational database management system)Read problems    lost updates [See concurrency, isolation levels, lock, locking, locks]    nonrepeateable reads [See concurrency, isolation levels, lock, locking, locks]

    phantom reads [See concurrency, isolation levels, lock, locking, locks]

    transactions [See concurrency, isolation levels, lock, locking, locks]    uncommitted reads [See concurrency, isolation levels, lock, locking, locks] Read stability (RS) 2nd 3rd

Readahead prefetching Readonly Readonly views 2nd

REAL/FLOAT data type

Rebind

REBIND utility

Record identifier (RID) Record length

Records

RECOVER DATABASE command Recoverable logs Recoverable versus nonrecoverable databasesRecovery

    archival logging [See Recovery;backup, transaction logs]

    automatic after crash [See Recovery;backup, transaction logs]

    backup [See Recovery;backup, transaction logs]

    case study [See Recovery;backup, transaction logs]

    circular logging [See Recovery;backup, transaction logs]

    crash [See Recovery;backup, transaction logs]

    databases [See Recovery;backup, transaction logs]

    definition [See Recovery;backup, transaction logs]

    dropped tables [See Recovery;backup, transaction logs]

    HADR (High Availability Disaster Recovery)

        ASYNC (Asynchronous) mode [See Recovery;backup, transaction logs]

        NEARSYNC (Near Synchronous) mode [See Recovery;backup, transaction logs]

        overview [See Recovery;backup, transaction logs]

        setup [See Recovery;backup, transaction logs]

        SYNC (Synchronous) mode [See Recovery;backup, transaction logs]

        synchronization modes [See Recovery;backup, transaction logs]    HADR Wizard [See Recovery;backup, transaction logs]    log files [See Recovery;backup, transaction logs]

    logging methods versus recovery methods [See Recovery;backup, transaction logs]

    RECOVER DATABASE command [See Recovery;backup, transaction logs]    recoverable versus nonrecoverable databases [See Recovery;backup, transaction logs]

    redirected restore [See Recovery;backup, transaction logs]

    Restore Data Wizard [See Recovery;backup, transaction logs]    roll forward

        databases [See Recovery;backup, transaction logs]        definition [See Recovery;backup, transaction logs]

        table spaces [See Recovery;backup, transaction logs]        with Control Center [See Recovery;backup, transaction logs]    scenarios [See Recovery;backup, transaction logs]    SQL1015N message [See Recovery;backup, transaction logs]    strategies [See Recovery;backup, transaction logs]

    table spaces [See Recovery;backup, transaction logs]

    terminology [See Recovery;backup, transaction logs]    to a minimum PIT (point in time) [See Recovery;backup, transaction logs]    transactions [See Recovery;backup, transaction logs]

    types of [See Recovery;backup, transaction logs] Recovery history file 2ndRecovery log [See database logs]

Recovery pending

Recursive common table expressions

Recursive queries

Recursive SQL 2nd Redirected restore 2nd 3rd

REFERENCE UDTs 2nd

REFERENCES clause Referential constraints 2nd 3rd 4th 5th 6th 7th 8thReferential integrity     definition

     establishing 2nd 3rd

     SQL implications 2nd 3rd 4th

REFRESH DEFERRED clause 2nd

REFRESH IMMEDIATE clause 2nd

Register Visual Studio AddIns

Register Visual Studio AddIns menu

Registry [See profile registry]

Registry variables

     case study 2nd 3rd

     configuration parameters 2nd

     listing

     setting

     viewing

Regular table spaces 2nd

Relational database management system (RDBMS)

Relational databases 2nd Relocating a database 2nd [See also backups, Databases;cloning] rem command 2nd 3rd

Remote clients

Remote databases Remote unit of work (RUOW)

Removing [See deleting, dropping]

Renaming a database 2nd reorg command 2nd 3rd 4th 5th

REORG utility 2nd 3rd 4th 5th Reorganizing table data, performance 2nd 3rd 4th

reorgchk command 2nd 3rd 4th 5th REORGCHK utility 2nd 3rd 4th 5th 6th 7th 8th 9th Repeatable read (RR) Repeatable reads (RR) 2nd 3rd REPLACE import mode 2nd

REPLACE_CREATE import mode 2nd

Replication 2nd 3rd Replication Center 2nd 3rd 4th 5th 6thReporting problems [See troubleshooting]

Request For Comments (RFC) Requester I/O block size, configuring instances Requesters

Reserved words

reset admin cfg command

reset db cfg command

reset dbm cfg command reset statement 2nd

Resetting

     DAS configuration file     database configuration file     Database Manager (DBM) Configuration file RESIZE option

Resource limit facility (RLF)

Resources

     books and publications

     computer-based training

     conferences

     course offerings

     e-mail services

     IBM business partners

     IBM certification program 2nd

     news groups

     periodicals

     technical resources

     tutorials 2nd

     user groups

     Web sites in this book 2nd

Response file generatorsResponse files     creating 2nd 3rd

     definition

     generating a 2nd 3rd     installing DB2

     Silent install 2nd 3rd 4th 5th

Restore [See also backups, recovery] Restore Data Wizard 2nd 3rd

RESTORE DATABASE command 2nd Restore sets

RESTRICT keyword RESTRICT rule Result sets Result sets, row counts Result tables

Results page 2nd 3rd

RevokeREVOKE statement     database authorities 2nd

     index privileges 2nd     package privileges 2nd     routine privileges 2nd

     schema privileges

     sequence privileges 2nd

     table and view privileges 2nd

     table spaces privileges RFC (Request For Comments)

RID (record identifier)

Right outer joins RIGHTOUTERJOIN keyword 2nd 3rd RLF (resource limit facility) Roll back

Roll forward recovery

    databases [See forward recovery]

    definition [See forward recovery]

    table spaces [See forward recovery]

    with Control Center [See forward recovery]

ROLLBACK statement

ROLLFORWARD DATABASE command 2nd 3rd

Routines 2nd 3rd

Row locks

ROWNUMBER function 2nd 3rd [See also FETCH FIRST n ROWS ONLY clause, OVER function, WHERE clause]

Rows

     counting in result sets

     definition

     eliminating duplicates 2nd 3rd

     grouping 2nd

     parent     phantom    retrieving

         adding to result sets 2nd 3rd

         between specified values         by distinct values

         by specified values 2nd

         first n         higher than n 2nd 3rd

         in specified order         maximum of n 2nd

     selfreferencing RQRIOBLK parameter 2nd RR (repeatable read) 2nd 3rd 4th RS (read stability) 2nd 3rd runcmd command

runstats command 2nd

RUNSTATS utility 2nd 3rd 4th 5th 6th Runtime clients RUOW (remote unit of work)