index_R

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

RACF authorization
        CICS
RADIANS function
RAISE_ERROR function 2nd
RAMAC I/O
        tuning
RAND function
Rank UDF
        text
RCT
        RDO, compared 2nd
RCT (Resource Control Table)
RCT parameters
        AUTH values
        COMD macro 2nd 3rd
                AUTH
                ROLBE
                THRDA
                THRDM
                THRDS
                TWAIT
        ENTRY macro 2nd 3rd 4th
                AUTH
                DPMODE
                PLAN
                PLNEXIT
                PLNGME
                ROLBE
                TASKREQ
                THRDM
                THRDS
                TOKENE
                TWAIT
                TXID
        example 2nd
        INIT macro 2nd 3rd 4th
                DPMODI
                ERRDEST
                PCTEROP
                PLANI
                PLNPGMI
                PLNXTR1
                PLNXTR2
                PURGEC
                ROLBI
                SHDDEST
                SIGNID
                SNAP
                STANDBY
                STRTWT
                SUBID
                SUFFIX
                THRDMAX
                TOKENI
                TRACEID
                TWAITI
                TXIDSO
        POOL macro 2nd
                AUTH
                DPMODE
                PLAN
                PLNEXIT
                PLNPGME
                ROLBE
                TASKREQ
                THRDM
                THRDS
                TWAIT
RCTs
        migrating to RDO
RDA (Remote Database Access)
RDBMS
       development
                cardinal rule
RDBMSs (relational database management systems)
RDO 2nd
        parameter wildcarding
        parameters
        RCT, compared 2nd
RDO (Resource Definition Online)
RDO parameters
        DB2CONN
                command thread attributes 2nd
                connection attributes 2nd
                pool thread attributes 2nd 3rd
        DB2ENTRY
                thread operation attributes 2nd
                thread selection attributes
        DB2TRAN 2nd
RDS
RDS (Relational Data Services) 2nd
RDS sorting
reactive governing
        RLF
READ command
        CICS file processing
read stability
        BIND statements
read-only access
        cursors
read-only cursors
read-only data
        data warehouses
read-only systems
        RI
read-only transactions
        IMS SYSGEN
reading
        data 2nd
       logs
                reducing
READNEXT command
        CICS file processing
READPREV command
        CICS file processing
reads
       dirty
                isolation levels 2nd 3rd 4th 5th 6th
        repeatable
        stability
        uncommitted
REAL data type
        promotability
REAL function
real storage
Real Time Statistics.
real-time statistics
REASON column
        DSN STATEMENT TABLE
rebalancing
       partitions
                table spaces 2nd
REBIND command
REBIND jobs
Rebind Package panel
rebinding
        DB2I
        packages
                DB2I
       plans
                DB2I
REBUILD INDEX utility 2nd
        concurrency
        index versions
        JCL listing
        large indexes
        locking
        phases
        rerunning
        system indexes
        SYSUT1 data sets
        Version 6
        VSAM data sets
        work data sets
REBUILD parameter
        REPAIR DBD utility
REBUILD utility
        indexes
rebuilding
        indexes
                DB2 Catalog
REBUILDLASTTIME column
        INDEXSPACESTATS table
record identifiers.
record IDs. 2nd
record OBIDs
        translating
record trace report sets 2nd 3rd
Record Trace Summary report
record-level processing
records
       accounting
                CICS
        system of
recover & diagnostic utilities
RECOVER INDEX utility
        Version 6 2nd
RECOVER INDOUBT command
recover pending flags
        correcting
        repairing
RECOVER TABLESPACE utility 2nd 3rd
RECOVER utility
        active logs
        archive logs
        concurrency
        concurrent copies
        consistent image copies
        DFSMS copies
        disaster recovery
        GDG image copies
        image copy data sets 2nd
        indexes
        locking
        logs, reading
        multiple table spaces
        parallel restorations
        performance
        phases
        previous image copies
        RECOVER INDEX utility
        RECOVER TABLESPACE utility 2nd 3rd
        restarting
        SHRLEVEL CHANGE image copies
        system table spaces
        table spaces
        units of work
        VSAM data sets
        work data sets
Recoverable Resource Manager Services Attach Facility.
recovering
        concurrent copies
        DFSMS copies
        system table spaces
        table spaces
        units of work
recovery
        CF
        COPY utility
        data sharing
        disaster
                active log sizes
                application classes 2nd
                archiving
                backups
                compression
                copying
                documentation
                DSN1COPY 2nd 3rd
                environments 2nd
                instant copies/restore 2nd
                normal business return
                offsite copies
                offsite recovery validation
                planning 2nd
                QMF form with DBID/PSID/OBID queries
                RECOVER utility
                recovery basics
                requirements 2nd
                risks
                scalpel 2nd 3rd 4th 5th
                SET LOG SUSPEND command 2nd
                shipping image copies offsite
                sledgehammer 2nd
                table spaces
                testing
       full
                JCL listing
        indexes
        LPL pages
        old information
       partial
                JCL listing
        REORG utility
Recovery Log Extractor utility.
recovery points
        COPY utility
        QUIESCE utility
recovery utilities
        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
                partition levels
                phases
                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
        RECOVER
                active logs
                archive logs
                concurrency
                concurrent copies
                consistent image copies
                DFSMS copies
                GDG image copies
                image copy data sets 2nd
                indexes
                locking
                logs, reading
                multiple table spaces
                parallel restorations
                performance
                phases
                previous image copies
                RECOVER INDEX utility
                RECOVER TABLESPACE utility 2nd 3rd
                restarting
                SHRLEVEL CHANGE image copies
                system table spaces
                table spaces
                units of work
                VSAM data sets
                work data sets
        REPAIR
        REPORT RECOVERY 2nd
                JCL listing
                locking
recursion
        CTEs 2nd
        data knowledge
        duplicate output rows
        necessity for
        stopping 2nd
        Version 8
redo transaction recovery
redundant data
        denormalization
redundant predicates
        avoiding
reentrant stored procedures
reference material
reference materials
        Book Manager Library Reader
        industry periodicals 2nd 3rd 4th
reference tables
        multi-table table spaces
references
       LOBs
                checking 2nd 3rd 4th
REFERENCES privileges
referential constraint
referential constraints
        AQR 2nd
        defining 2nd 3rd
       dependent tables
                navigational queries
       informational
                checking
        names
       parent tables
                navigational queries
referential constrats
       forcing
                LOAD utility
referential integrity
        application-enforced
        checking
        data warehouses
        DB2-enforced
        declarative
                triggers
        locks
        multi-table table spaces
        triggers 2nd 3rd
        tuning 2nd 3rd 4th
referential integrity.
referential sets 2nd 3rd
Refine UDF
        text
reformatting
        data cleansing
REFRESH DEFERRED parameter
REFRESH TABLE statement
        MQTs
refreshes
        AQR
refreshing
        MQTs
regions
        IMS/TM
registered users
registering
       stored procedures
                Version 6 2nd
registers
       special
                security 2nd
Relational Architects Inc.
relational closure
Relational Data Services. 2nd
relational database management systems.
relational division 2nd
Relational OLAP.
relational purity
RELATIVE keyword
        scrollable cursors
relative positioning.
REMARKS column
        PLAN TABLE
        Plan TABLE
Remote Database Access.
remote processing
        deleting
remote request (DRDA)
remote request DRDA level
Remote Unit of Work .
remote unit of work.
renaming
        columns 2nd
REOPT parameter
reoptimization
        enabling
        isolating
reoptimizing
        SQL
reoptimzation
        dynamic
REORG INDEX utility
        locking
        SHRLEVEL CHANGE parameter
        SHRLEVEL NONE parameter
        SHRLEVEL REFERENCE parameter
REORG parameter
        DSN1COMP utility
REORG TABLESPACE utility
        locking
        phases
        SHRLEVEL CHANGE parameter
        SHRLEVEL NONE parameter
        SHRLEVEL REFERENCE parameter
REORG utility 2nd 3rd
        archives 2nd
        automatically reorganizing 2nd
        clustering
        concurrency
        frequency
        frequency (reorganizations) 2nd
        index phases 2nd
        indexes 2nd
        inline statistics 2nd
        job stream 2nd
        LOB table space phases
        nonrestartable
        online reorganizations 2nd
                disadvantages
                mapping tables 2nd
                parameters 2nd 3rd 4th 5th 6th
        partitions, rebalancing 2nd
        performance
        philosophies 2nd
        recovery
       REORG INDEX utility
                locking
                SHRLEVEL CHANGE parameter
                SHRLEVEL NONE parameter
                SHRLEVEL REFERENCE parameter
       REORG TABLESPACE utility
                locking
                phases
                SHRLEVEL CHANGE parameter
                SHRLEVEL NONE parameter
                SHRLEVEL REFERENCE parameter
        reorganization rules
        reorganization types
        rerunning/restarting 2nd 3rd
                BUILD phase
                BUILD2 phase
                RELOAD phase
                SORT phase
                SWITCH phase
                UNLOAD phase
                UTILINIT phase
                UTILTERM phase
        restartable
        REUSE option
        SCOPE PENDING option
        SHRLEVEL parameter
        SORTKEYS parameter
        standards (recommended)
        STOGROUP-defined data sets
        table space phases 2nd
        unloaded data sets
        VARCHAR columns
        VSAM data sests
        work data sets 2nd 3rd
        work data sets, buffering
reorganization indicators
reorganizing
        .
        DB2 Catalog 2nd 3rd
                synchronizing 2nd
                table spaces 2nd
       DB2 Directory
                table spaces 2nd
       table spaces
                regular 2nd
                restrictions 2nd 3rd
                six special 2nd
        utilities 2nd
REORGAPPENDINSERT column
        INDEXSPACESTATS table
REORGDELETES column
        INDEXSPACESTATS table
        TABLESPACESTATS table
REORGDISORGLOB column
        TABLESPACESTATS table
REORGFARINDREF column
        TABLESPACESTATS table
REORGINSERTS column
        INDEXSPACESTATS table
        TABLESPACESTATS table
REORGLASTTIME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
REORGLEAFFAR column
        INDEXSPACESTATS table
REORGLEAFNEAR column
        INDEXSPACESTATS table
REORGMASSDELETE column
        INDEXSPACESTATS table
        TABLESPACESTATS table
REORGNEWARINDREF column
        TABLESPACESTATS table
REORGNUMLEVELS column
        INDEXSPACESTATS table
REORGPSEUDODELETES column
        INDEXSPACESTATS table
REORGUNCLUSTINS column
        TABLESPACESTATS table
REORGUPDATES column
        TABLESPACESTATS table
REP tools 2nd
REPAIR DBD utility 2nd
        DROP/REBUILD parameter
        error resolution
        LOG YES parameter
REPAIR LOCATE utility 2nd 3rd
        broken page bits
        DB2 Catalog/Directory
        dumps
        locks
        LOG YES parameter
        recovery
        VERIFY parameter
REPAIR SET utility 2nd
        check pending flag
        copy pending flag
        down-level data sets
        recover pending flag
REPAIR utility 2nd 3rd 4th
        VERSIONS parameter
REPEAT function
repeatabe reads
        BIND statements 2nd 3rd
                page locking
repeatable reads
repeating groups
        denormalization 2nd
REPLACE function
Replace UDF
        audio
        image
        video
ReplaceA UDF
        audio
        image
        video
replacing
       data
                LOAD utility
replication 2nd
        data warehouses
REPORT RECOVERY utility 2nd
        JCL listing
        locking
report sets 2nd
        accounting 2nd 3rd 4th 5th 6th
                long
                long.
                short 2nd 3rd 4th
                traces
        audit 2nd 3rd
        explain
        I/O activity 2nd 3rd
        locking 2nd
        record trace 2nd 3rd
        SQL trace 2nd 3rd
        statistics 2nd 3rd
                EDM pools
                locking
                log management
                short 2nd 3rd 4th
        summary 2nd
        system parameters 2nd 3rd
        transit time 2nd 3rd 4th
report tables
        denormalization
REPORT TABLESPACESET utility 2nd 3rd 4th
REPORT utility
report writers 2nd
        capabilities
reporting
        exceptions
REPORTONLY keyword
        REORG utility
reports
       formatted
                creating 2nd
       statistics
                RUNSTATS utility
repositioning
        batch programs
repository tools 2nd
requests
        combining
       data
                serializing
       direct
                Net.Data
requests (SQL)
        consolidating
requirements
        data sharing 2nd 3rd
        disaster recovery 2nd
        memory
        precompiling
reserved words (SQL) 2nd
        IBM 2nd
reserving
        buffer pools
RESETBR command
        CICS file processing
resident programs
resident stored procedures
resolution
        functions
                DSN FUNCTION TABLE 2nd 3rd 4th
                information 2nd 3rd
                UDFs, selecting
resource authority query
Resource Control Table.
Resource Definition Online.
Resource Limit Facility.
Resource Limit Specification Tables.
resource privileges
Resource Translation Tables.
resource unavailable errors
resource unavailable messages
resources
       availability
                operating environments 2nd 3rd
        DB2
                mailing lists 2nd
                Usenet newsgroups 2nd 3rd
                Web 2nd 3rd 4th 5th 6th
        DB2.
       governing
                RLF.
        Java
       non-DB2
                accessing
       serializing
                claim/drain compatibility 2nd 3rd
                claims 2nd
                drains 2nd 3rd
        status, viewing
        TSO
        XML
response times
        distribution performance
responsibilities
        administrative 2nd 3rd
Responsive Systems Co.
Restart Light
restart light
        data sharing
restarting
        batch programs 2nd 3rd 4th 5th
       BUILD utility
                RELOAD phase
        COPY utility
        IMS
        LOAD jobs 2nd
        LOAD utility 2nd 3rd 4th
                DISCARD phase
                INDEXVAL phase
                RELOAD phase
                REPORT phase
                UTILINIT phase
                UTILTERM phase
        MODIFY STATISTICS utility
        RECOVER utility
        REORG utility 2nd 3rd 4th
                BUILD phase
                BUILD2 phase
                RELOAD phase
                SORT phase
                SWITCH phase
                UNLOAD phase
                UTILINIT phase
                UTILTERM phase
       SORT utility
                RELOAD phase
        UNLOAD utility
RESTORE SYSTEM utility
        concurrency
        phases
        running
restore/instant copies disaster recovery 2nd
restoring
       system
                RESTORE SYSTEM utility 2nd 3rd 4th
RESTRICT option
        referential constraints
RESTRICT parameter
        DISPLAY DATABASE command
restricted objects
        viewing
restricted userids
restrictive predicates
result set iterators (Java) 2nd
result sets
       duplicate rows
                deleting 2nd
        limiting 2nd
       returning
                stored procedures 2nd 3rd
        scrollable cursor navigation
       SQL
                distribution performance
        Top Ten retrieval 2nd
RESULT_SETS parameter
resynchronization
RETAIN CURSORS SAVEPOINT clause
RETAIN LOCKS clause
RETAIN parameter
        BIND statements
RETPD option
        TEMPLATE statement
retrieving
        generated values
       pages
                limiting
       rows
                multiple
return codes
        DSNTIAUL/DSNTIAD/DSNTEP2 utilities
        ODBC
        online utilities
RETURNS UDF characteristic
reusability
        UDFs
REUSE option
        REORG utility
reuseability
        stored procedures 2nd
reviewing
        designs 2nd 3rd 4th
                phase five
                phase four
                phase one
                phase seven
                phase six
                phase three
                phase two
REVOKE statements
        privileges
revoking
        privileges
        SYSADM authority
REWRITE command
        CICS file processing
rewriting
        queries
REXX 2nd
        comments
        data types
        host variables
        null
        SQL statements
REXX EXEC
        program preparation
RI
        defined
        entity integrity
        implementation restrictions
        programmatic
        read-only systems
        referential constraint
       referential constraints
                defining 2nd 3rd
                names
        referential sets 2nd 3rd
        self-referencing constraints 2nd
        stable data
RI (referential integrity)
RI parameter
        LISTDEF statements
RI problem errors
RI- related objects, copying
RID list processing
        long accounting reports information
RID pools
        tuning 2nd
RIDs 2nd
        pseudo-deletes
RIDs (record identifiers)
RIDs (record IDs) 2nd
RIGHT function
RIGHT OUTER JOIN outer join
risks
RLF
       governing
                predictive 2nd
                reactive
        RLSTs 2nd
                columns 2nd
                defining
                dynamic SQL access
                multiple
                starting
RLF (Resource Limit Facility)
RLF_CATEGORY_B column
        RLSTs
RLFASUERR column
        RLSTs
RLFASUWARN column
        RLSTs
RLFBIND column
        RLSTs
RLFCOLLN column
        RLSTs
RLFFUNC column
        RLSTs
RLFPKG column
        RLSTs
RLSTs 2nd
        columns 2nd
        defining
        dynamic SQL access
        multiple
        starting
RLSTs (Resource Limit Specification Tables)
ROLAP (Relational
ROLBE COMD macro parameter
ROLBE ENTRY macro parameter
ROLBE POOL macro parameter
ROLBI RCT INIT macro parameter
roles
        administrative 2nd 3rd
ROLLBACK statements
        stored procedures
rollbacks
        automatic
root pages 2nd
        indexes
rotating
       partitions
                table spaces 2nd
ROUND function
ROUND_TIMESTAMP function
rounding
        timestamps
routine authority query
ROUTINE ID column
        PLAN TABLE
routines
        DSN8HUFF
        exit 2nd
                EDITPROC
                FIELDPROC
                VALIDPROC
       I/O
                application development
       validation
                data integrity
row expressions 2nd
        Version 7 enhancements
row level security
row locking
        table spaces
row-level locking
        data sharing
row-level MLS 2nd 3rd 4th
        access controls
        restrictions 2nd
        SECLABELs comparisons
        utility processing
        write down security
row-level triggers
ROWID column
        direct row access
ROWID columns
        LOBs 2nd
ROWID data type
        promotability
ROWID data types
ROWID function
ROWID values
        loading
ROWLIMIT parameter
        DSN1COMP utility
rows
        abbreviation standards
        adding to empty tables
        counting 2nd 3rd
        data types 2nd
        data types, selecting 2nd 3rd
        date/time data
        date/time stamp 2nd
        defaults 2nd
       deleting
                cursors
                non-SELECT dynamic SQL
        direct row access 2nd
        duplicate
                deleting 2nd
       duplicate output
                CTEs
       fetching
                Version 7 enhancements 2nd
       joins
                reducing
        keeping
        locks 2nd 3rd 4th 5th 6th
                compatibility
                page locks, compared 2nd
       maximum
                table spaces 2nd
        multi-row fetches
       multiple
                adding 2nd 3rd
                retrieving
        navigational queries
        nulls 2nd 3rd 4th
        ordering
       PLAN TABLE
                deleting
        primary keys
        qualifying
        returning
        selecting 2nd
        sequence objects 2nd 3rd
                creating
                identity columns, compared 2nd
                parameters
                performance
        sequencing 2nd 3rd
        surrogate keys
        tables 2nd
                ROWID data types
                sequence objects
        Top Ten retrieval 2nd
        updating
        wasted space
rowset positioning cursors 2nd
        data customizations
        multiple rows, adding
rowsets
        defined
RRSAF
RRSAF (Recoverable Resource Manager Services Attach Facility)
RTRIM function
RTS
        accuracy
        activity, checking
        DSNACCOR stored procedure 2nd
        externalizing 2nd
        indexes
                reorganizing
                RUNSTATS, running
        program impact
        tables 2nd 3rd 4th
                INDEXSPACESTATS columns 2nd 3rd
                TABLESPACESTATS columns 2nd 3rd
        tablespace information
       tablespaces
                image copies
                reorganizing
                RUNSTATS, running
RTS (Real Time Statistics)
RTT parameter
        SSMs
RTTs
RTTs (Resource Translation Tables)
RUN command
Run option
        DB2I
RUN OPTIONS UDF characteristic
Run panel (DB2I)
run time reoptimization
running
        applications 2nd
        CHECK DATA utility
RUNSTATS
        DB2 Catalog statistics
        EXPLAIN tables
        indexes
        tablespaces
RUNSTATS jobs
RUNSTATS utility 2nd 3rd 4th 5th
        access paths 2nd
        Catalog statistics, customizing
        clustering
        column/column group statistics 2nd
        DB2 Catalog tables, updating 2nd
        DBAs 2nd 3rd
        executing 2nd 3rd
        historical statistics 2nd
        indexes
        inline statistics 2nd
        list of objects statistics
        locking 2nd
        non- avoidance
        partition-level statistics
        phases
        reports
        running 2nd
        sampling
        scheduling
        SHRLEVEL REFERENCE parameter
        statements, invalidating
        table spaces
        value statistics
runtime modules
        application development
RUW
RUW (remote unit of work)
RUW (Remote Unit of Work)