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]
UCASE function UDB Developer •s Edition (DE) UDB Enterprise Server Edition (ESE) UDB Personal Developer •s Edition (PDE) UDB Personal Edition (PE) UDF statistics monitoring UDFs abends cardinality, overriding characteristics 2nd 3rd consistency creating 2nd 3rd 4th audio extender 2nd image extender 2nd text extender video extender 2nd data type promotability 2nd executing 2nd 3rd 4th external program restrictions 2nd external actions, executing function resolution function resolution information 2nd 3rd identical input parameters naming 2nd 3rd null input parameters package collections parallel, disabling parameters casting defining not required portability programming language options 2nd qualified names reusability scalar schemas 2nd scratchpads security sourced sourced functions SQL options 2nd 3rd starting 2nd 3rd 4th 5th 6th stopping 2nd 3rd 4th 5th 6th table table functions 2nd tasks templates XML extenders 2nd UDFs ( user -defined functions) 2nd UDT data type promotability UDTs base data types, compared casting functions 2nd comparison operators constants 2nd extender support 2nd host variables 2nd listing navigational queries LOBs 2nd naming 2nd sourced functions 2nd strong typing 2nd 3rd UNION statements 2nd value assignments 2nd UDTs (user-defined data types) 2nd UDTs (user-defined distinct types) UIDs unambiguous cursors uncertain data unclustered indexes UNCNT option TEMPLATE statement uncommitted reads uncommitted reads. undo transaction recovery Unicode support Version 7 enhancements 2nd Uniform Resource Locators. UNION ALL operator UNION operator UNION statements UDTs 2nd UNION verb unions multiple table data retrieval SQL 2nd UNION operator UNIQUE WHERE NOT NULL clause UNIT option TEMPLATE statement units of work batch programs 2nd distributed. recovering remote. Unix System Services. Unlimited Edition (DB2 Connect) unload sample application (DSNTIAUL) 2nd 3rd UNLOAD utility 2nd concurrency data, limiting encoding schemes floating point data JCL listing LOAD control statements locking phases restarting security terminating unloaded flat files DSNTIAUL utility unqualified SQL unqualified table references DCLGEN statements UPDATE authority restricting UPDATE statements cursor controlled cursors Update UDFs UPDATE verb updateable DB2 Catalog statistics 2nd 3rd 4th Updater UDF audio image video updates DB2 Catalog multi-site serializing UPDATESTATSTIME column INDEXSPACESTATS table TABLESPACESTATS table UpdateTime UDF audio image video updating changed columns columns cursors data 2nd DB2 Catalog statistics DB2 Catalog tables 2nd indexed columns partitioning keys rows views UPPER function TRANSLATE function, compared UR isolation levels 2nd 3rd URLs (Uniform Resource Locators) USE class privileges USE parameter DISPLAY DATABASE command Usenet newsgroups 2nd cross-posting DB2 resources 2nd 3rd tips user authority query user-assisted distribution (DRDA) user-defined data types. 2nd user-defined distinct types (LOBs) user-defined distinct types. user-defined functions application programs names user-defined functions. 2nd 3rd user-defined VSAM data sets 2nd 3rd userids checking encrypting restricted USERNAMES table users active tuning coding complexity, masking concurrent DSN1SDMP authority multi-users DB2 Connect EE Net.Data application development registered USING parameter table spaces 2nd 3rd USING TYPE DEFAULTS parameter USS (Unix System Services) utilites OPTIONS control statement 2nd utilities backup COPY 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th 29th 30th 31st 32nd 33rd COPY. BACKUP SYSTEM 2nd 3rd concurrency phases backup. BUFNO parameter CHECK CHECK DATA bypassing check constraints 2nd check pending status DELETE YES parameter exception tables indexes informational referential constraints LOB references 2nd 3rd 4th locks partition levels phases 2nd referential integrity rerunning running SCOPE PENDING option work data sets 2nd CHECK INDEX 2nd 3rd dangerous operations DB2 Catalog locks partition levels phases rerunning running work data sets 2nd CHECK LOB 2nd EXCEPTIONS parameter locks phases contention 2nd 3rd control cards 2nd COPY backups indexes core functionality 2nd data consistency CHECK CHECK DATA 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd CHECK DATA. CHECK INDEX 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th CHECK LOB 2nd 3rd 4th 5th DIAGNOSE REPAIR 2nd 3rd REPAIR DBD 2nd 3rd 4th 5th REPAIR LOCATE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th REPAIR SET 2nd 3rd 4th 5th 6th REPORT REPORT TABLESPACESET 2nd 3rd 4th data organization. database object lists testing 2nd DB2 Catalog/Directory CATENFM CATMAINT 2nd DSNJCNVB 2nd 3rd MODIFY. RUNSTATS 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th RUNSTATS. STOSPACE 2nd 3rd DB2 Connect binding DFSORT sort work spaces DIAGNOSE EXEC SQL control statement 2nd 3rd 4th cursor-driven SELECT statements issuing 2nd non-SELECT dynamic statements IBM packaging 2nd 3rd indexes, creating LISTDEF control statement LISTDEF statement 2nd example 2nd INCLUDE/EXCLUDE clauses 2nd indexes list expansion 2nd LIST keyword 2nd lists, previewing LOBs 2nd referential integrity wildcards 2nd LOAD 2nd appending/replacing data blocked input concurrency 2nd contingency options data conversion DECIMAL columns delimited input data sets 2nd editing data before loading floating point data index keys, sorting indexes, creating inline copies inline statistics 2nd input data sets, sequencing 2nd INSERT statements, compared INSERTs, compared locking 2nd LOG NO option mass deletes multi-table simple table space nonrestartable jobs 2nd nullable columns online loading parameters, coding partitions performance phases 2nd philosophies 2nd 3rd 4th referential constraints, forcing reorganizing rerunning/restarting 2nd 3rd 4th restarting jobs 2nd ROWID values security serializing jobs sort utility statistics, gathering table triggers work data sets 2nd 3rd work data sets, buffering work data sets;separating loading 2nd MODIFY RECOVERY copies pending data sets, deleting image copies JCL locking nonstandard DATE format running MODIFY STATISTICS 2nd DELETE parameter 2nd historical information, storing restarting running terminating MODIFY. monitoring 2nd online generating 2nd 3rd 4th 5th monitoring 2nd partition levels return codes UIDs work data sets 2nd 3rd operational Operational Utilities suite output data sets packages Version 7 enhancements REBUILD indexes REBUILD INDEX Version 6 RECOVER disaster recovery recover & diagnositc Recover and Diagnostics suite RECOVER INDEX Version 6 2nd recovery. REORG 2nd 3rd archives 2nd automatic 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 3rd 4th 5th 6th 7th 8th 9th 10th 11th partitions, rebalancing 2nd performance philosophies 2nd recovery REORG INDEX 2nd 3rd REORG REFERENCE REORG TABLESPACE 2nd 3rd 4th 5th reorganization rules reorganization types rerunning/restarting 2nd 3rd 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 sets work data sets 2nd 3rd work data sets, buffering REORG INDEX locking SHRLEVEL CHANGE parameter SHRLEVEL NONE parameter SHRLEVEL REFERENCE parameter REORG TABLESPACE locking phases SHRLEVEL CHANGE parameter SHRLEVEL NONE parameter SHRLEVEL REFERENCE parameter reorganizing 2nd REPAIR 2nd 3rd VERSIONS parameter REPAIR DBD 2nd DROP/REBUILD parameter LOG YES parameter 2nd REPAIR LOCATE 2nd 3rd broken page bits DB2 Catalog/Directory dumps locks LOG YES parameter recovery VERIFY parameter REPAIR SET 2nd check pending flag copy pending flag down-level data sets recover pending flag REPORT REPORT TABLESPACESET 2nd 3rd 4th RESTORE SYSTEM concurrency phases running RUNSTATS 2nd 3rd 4th access paths 2nd Catalog statistics, customizing clustering column/column group statistics 2nd concurrency DB2 Catalog tables, updating 2nd DBAs 2nd 3rd executing 2nd 3rd historical statistics 2nd indexes inline statistics 2nd list of objects statistics locking non- avoidance partition-level statistics phases reports running 2nd sampling scheduling SHRLEVEL REFERENCE parameter statements, invalidating table spaces value statistics stand-alone 2nd DSN1CHKR 2nd 3rd 4th 5th 6th DSN1CHKR;scheduling DSN1COMP 2nd 3rd 4th 5th 6th 7th DSN1COPY 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th DSN1LOGP 2nd 3rd 4th DSN1PRNT 2nd 3rd 4th 5th 6th 7th 8th 9th DSN1SDMP 2nd 3rd 4th 5th DSNJLOGF 2nd 3rd DSNJLOGF;JCL listing DSNJU003 2nd 3rd 4th 5th 6th DSNJU004 2nd STOSPACE 2nd 3rd concurrency DASD usage DB2 Catalog updates JCL generation JCL listing locking phases running SYSADM Catalog statistics, customizing TEMPLATE control statement TEMPLATE statement symbolics 2nd templates 2nd disk options 2nd examples 2nd names options 2nd tape options testing 2nd terminating 2nd third-party UNLOAD 2nd concurrency data, limiting encoding schemes floating point data JCL listing LOAD control statements locking phases restarting security terminating Version 5 features Version 6 features Version 7 enhancements 2nd 3rd Version 7 improvements Utilities option DB2I utilities suite utility enhancement tools utility IDs names utility managers utility processing row-level MLS UTIMOUT parameter UTL tools
|
| < Day Day Up > |