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]
e-business enhancemens DB2 Version 7 2nd edit procedures data integrity editing ROWID columns EDITPROC clause compression routines EDITPROC exit routine EDM Pool EDM Pool (Environmental Descriptor Management Pool) EDM pools data sharing monitoring statistics reports prepared statements, caching size 2nd 3rd tuning 2nd 3rd 4th 5th authorization cache average package size query average plan size query column average per table query concurrent package query concurrent plans query DSNZPARMs EDM pool size 2nd 3rd package authorization caching query plan authorization caching query storage areas storage, moving table average per database query EDT tools 2nd education support 2nd industry periodicals 2nd 3rd 4th mailing lists education (DB2) advanced topics external training in-house training introductory courses on-site library reference material effectiveness variable character columns 2nd efficient performance online TSO applications efficieny TSO EJBs (Enterprise Java Beans) Embarcadero Technologies embedded SQL 4GL applications application programs 2nd 3rd comments DB2 tables, declaring delimiting statements error codes error trapping statement 2nd error-handling paragraph 2nd 3rd flat files, compared 2nd GETDIAGNOSTICS statement 2nd 3rd 4th 5th names 2nd 3rd SQLCA 2nd 3rd SQLCODE statement 2nd types existence checking 2nd ODBC applications overhead, reducing pretesting SELECT statements host variables 2nd EMENDATE column emoticons Internet employee assignment table employee photo & resume table 2nd employee table 2nd empty tables rows, adding EMSTDATE column ENABLE parameters BIND statements 2nd ENABLE QUERY OPTIMIZATION parameter enabling environments encoding schemes table spaces 2nd tables unloaded data ENCRYPT_TDES function encrypting passwords encryption DB2 data 2nd userids/passwords END command ENDBR command CICS file processing Enterprise Edition (DB2 Connect) 2nd multi-users thread pooling 2nd Enterprise Java Beans. entity integrity entries COMD CICS indexes 2nd ENTRY macro parameters RCT 2nd 3rd 4th AUTH DPMODE PLAN PLNEXIT PLNPGME ROLBE TASKREQ THRDM THRDS TOKENE TWAIT TXID entry threads CICS entry- sequenced data sets. environment commands administrative commands 2nd 3rd 4th active traces ALTER BUFFERPOOL ALTER UTILITY ARCHIVE LOG 2nd RECOVER INDOUBT START DATABASE 2nd START PROCEDURE START RLIMIT START TRACE 2nd START/STOP STOP STOP DATABASE system parameters TERM UTILITY 2nd information-gathering 2nd active objects, viewing buffer pools, monitoring buffer pools, tuning centralized areas database information, viewing database usage grouping buffer pools information, limiting LIMIT parameter LIST/LSTATS parameters locking information, viewing logging, monitoring LPLs, viewing objects, monitoring 2nd 3rd 4th OVERVIEW parameter restricted objects stored procedures, monitoring UDF statistics, monitoring utilities, monitoring 2nd wildcards issuing with DB2I 2nd structure environment control commands 2nd security Environmental Descriptor Management Pool. environmental support (DB2) environments client/server Net.Data support disaster recovery 2nd enabling/disabling operating. processing technical CASE tools support teleprocessing tuning 2nd 3rd three- tier Net.Data support TSO 2nd batch applications 2nd 3rd online applications 2nd 3rd 4th 5th 6th 7th 8th two-tier Net.Data support z/OS. equality expressions testing equivalent data types 2nd equivalent functionality features (SQL) ERASE parameter table spaces Eric Loriaux MVS Web site ERR parameter SSMs ERRDEST RCT INIT macro parameter error handling DSNTEP2 utility DSNTIAD error resolution REPAIR DBD utility error-handling error codes error trapping statement 2nd error-handling paragraph application programs 2nd 3rd errors BIND statements DSN1PRNT utility escalating locks 2nd 3rd DSNZPARM parameter LOCKMAX parameter ESDS (entry-sequenced data sets) ESE (UDB Enterprise Server Edition) ESMT parameter SSMs ‰SQL ‰ UDF characteristic Estimator (DB2) table space space requirements ETL tools 2nd events trigger selecting exception states online schema changes exception tables defining exceptions reporting EXCEPTIONS parameter CHECK LOB utility EXCLUDE clause LISTDEF statement 2nd EXCLUDING COLUMN DEFAULTS parameter EXEC SQL control statement 2nd 3rd 4th cursor-driven SELECT statements issuing 2nd non-SELECT dynamic statements EXECUTE IMMEDIATE statement 2nd host variables one-time processing syntax EXECUTE IMMEDIATE statements non-SELECT dynamic SQL, compared executing external actions (UDFs) packages RUNSTATS utility 2nd 3rd SQL stored procedures stored procedures 2nd 3rd 4th calls 2nd WLM 2nd UDFs 2nd 3rd 4th execution DDL planning execution types SQL statements existence SQL statements testing 2nd existence, checking 2nd existential SQL exit routines 2nd EDITPROC FIELDPROC VALIDPROC EXP function expanding database object lists 2nd indexes LIST keyword 2nd LOBs 2nd referential integrity EXPDL option TEMPLATE statement EXPLAIN command auto rebinds simple statements 2nd EXPLAIN feature cost estimations customizations, identifying DSN FUNCTION TABLE 2nd columns creating RUNSTATS version 8 DSN STATEMENT TABLE 2nd columns 2nd 3rd creating RUNSTATS version 8 historical information, recording optimizer, influencing overview 2nd PLAN TABLE access path efficiency access path examples columns 2nd 3rd 4th 5th 6th compressing indexes missing pieces 2nd QBLOCK TYPE column querying 2nd REMARKS column rows, deleting RUNSTATS version 7 version 8 PLAN TABLE access paths, populating 2nd 3rd PLAN TABLE, populating production packages production plans, binding SQL statement performance analysis 2nd 3rd statistics tools training explain report sets EXPLAIN TIME column DSN STATEMENT TABLE EXPLAIN_TIME column DSN_FUNCTION_TABLE table explicit consistency tokens BIND statements explicit inner joins explicit outer explicit versions names EXPORT commands QMF Express (DB2) expression arithmetic 2nd 3rd column renaming columns 2nd decimal precision/scale MULTIPLY_ALT two numbers expressions averages CASE 2nd 3rd rows, counting equality, testing largest values, returning LOBs row 2nd smallest values, returning sum table multiple table data retrieval table. expressions (rows) Version 7 enhancements extended storage extenders Net Search 2nd security 2nd UDFs audio extender created 2nd image extender created 2nd text extender created video extender created 2nd UDTs 2nd WLM requirements XML 2nd UDFs 2nd Extensible Markup Language. EXTENTS column INDEXSPACESTATS table TABLESPACESTATS table external actions executing (UDFs) external functions EXTERNAL NAME UDF characteristic external savepoints batch programs 2nd external security 2nd external stored procedures SQL stored procedures, compared external training (DB2) external UDFs program restrictions 2nd externalizing RTS 2nd extract/transformation/load tools 2nd extractChar UDFs extractCLOB UDFs extractDate UDFs extractDouble UDFs extracting data 4GL applications extractInteger UDFs extractReal UDFs extractSmallint UDFs extractTime UDFs extractTimestamp UDFs extractVarchar UDFs extranets
|
| < Day Day Up > |