R

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 databases
Recovery
    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 2nd
Recovery 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 8th
Referential 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 6th
Reporting 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 generators
Response 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
Revoke
REVOKE 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)