DB2 Developers Guide (5th Edition)
| < Day Day Up > |
| [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)
|
| < Day Day Up > |