Learning Visually with Examples [Electronic resources]

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)