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]
DAD (Data Access Definition) files DASD tablespaces monitoring DASD and space management tools DASD volumes partitioned table spaces data administration standards/procedures 2nd appending LOAD utility archiving REORG utility 2nd buffering (global) 2nd buffer pools group buffer pool duplexing 2nd updating/reading data 2nd cleansing data warehouses 2nd compressing customizations data integrity INSERT statements LOAD utility vs INSERT statements multiple rows, adding primary keys UPDATE/DELETE statements customizing changed columns , updating column updates columns, listing cursors 2nd 3rd DELETE statements FOR UPDATE OF clause generated values, retrieving indexed columns, updating large insertions long columns mass DELETE multiple rows, adding row updates rowset positioning cursors self-referencing DELETE statements self-referencing sub-SELECT statements UPDATE statements derivable denormalization distributed . dynamic accessing filtering WHERE clause floating point loading unloading frequently used, storing grouping 2nd index synchronization COPY utility integrity FOR UPDATE OF clause stored procedures limiting metadata storing modification indexes non-relational joining non-uniform dynamic SQL overactive online 2nd physical storage purging data warehouses quality data warehouses read-only data warehouses reading 2nd redundant denormalization replacing LOAD utility sharing sorting 2nd online stable RI, avoiding time/date tables uncertain updating 2nd Data Access Definition. Data Administration Newsletter, The (ital) data analysts DATA CAPTURE parameter tables data cleansing data warehouses, populating 2nd 3rd reformatting value validation 2nd data consistency utilities 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 2nd phases 2nd referential integrity rerunning running SCOPE PENDING option work data sets 2nd CHECK INDEX 2nd dangerous operations DB2 Catalog locks partition levels phases rerunning running work data sets 2nd CHECK LOB 2nd EXCEPTIONS parameter locks phases DIAGNOSE REPAIR 2nd 3rd VERSIONS parameter REPAIR DBD 2nd DROP/REBUILD parameter error resolution LOG YES parameter 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 option 2nd 3rd 4th Data Control Language. data conversions LOAD utility data currency block fetches 2nd 3rd Data Definition Language. data derivation views data dictionaries data distribution accessing application-directed 2nd 3rd 4th methods , comparing system-directed 2nd 3rd 4th ASCII support binding options 2nd block fetches continuous 2nd 3rd cursors 2nd 3rd 4th 5th data currency 2nd 3rd limited 2nd 3rd CDB 2nd client/server applications DDF DDF suspend/resume DDF. dynamic cursor pre-opens locations one-phase commit two-phase, compared optimization 2nd 3rd partitioned table spaces performance buffer pools DDF dispatching priority 2nd OPTIMIZE FOR n ROWS clause response times SQL result sets throughput chains throughput, analyzing 2nd 3rd VTAM parameters 2nd placement 2nd private protocol converting to DRDA problem resolution logs remote processing, deleting requests requests, combining security authid translations 2nd come-from checking PUBLIC AT ALL LOCATIONS parameter TCP/IP support threads connection pools 2nd inactive DBATs 2nd two-phase commit actual commit 2nd multi-site updates one-phase, compared preparation phase syncpoint trees type-2 connections Unicode support units of work Version 8 database aliases location aliases TCP/IP network member routing versions (DB2) workstation DB2 data extraction 4GL applications DATA INITIALLY DEFERRED parameter data integrity violations Data Junction data management Version 7 enhancements 2nd 3rd data sharing declared temporary tables 2nd deferred data set creation identity columns 2nd LOG SUSPEND command Unicode 2nd utilities 2nd 3rd Data Management Review (ital) Data Manager. Data Manipulation Language. data marts data warehouses, compared data mining intelligent miner scoring data modeling CASE tools support data modifications. data movement tools 2nd data organization utilities LOAD 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 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 REORG 2nd 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 3rd 4th 5th 6th 7th 8th 9th 10th 11th partitions, rebalancing performance philosophies 2nd recovery REORG INDEX 2nd 3rd 4th 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 UNLOAD 2nd concurrency data, limiting encoding schemes floating point data JCL listing LOAD control statements locking phases restarting security terminating data pages index Type 1 Type 2 2nd 3rd LOB table spaces 2nd data partitioned secondary indexes. 2nd data requests serializing Data Set Dump Creator utility. data sets allocating allocating. DB2 Catalog multiple extents SQL access, monitoring deferred creating deleting delimited input loading 2nd down-level repairing DSN1DMP utility ESDS image copy allocating specifying indexes size 2nd 3rd input sequencing 2nd LDS log DSN1COPY utility non-DB2 buffering open tuning 2nd 3rd output utilities pages 2nd 3rd 4th partition sizes 2nd STOGROUP-defined moving SYSCOPY allocating 2nd buffering MERGECOPY utility 2nd SYSDISC space requirements SYSMAP SYSREC synchronizing SYSUT1 MERGECOPY utility 2nd 3rd REBUILD INDEX utility SYSUT2 size unloaded REORG utility VSAM closing 2nd 3rd deleting LOB table spaces 2nd non-partitionted objets 2nd pages 2nd partitionted objets 2nd RECOVER utility REORG utility user -defined 2nd 3rd work buffering 2nd CHECK INDEX utility 2nd checking 2nd LOAD utility 2nd 3rd online utilities 2nd 3rd REBUILD INDEX utility RECOVER utility REORG utility 2nd 3rd separating data sharing administration backup/recovery buffer pools CF failures CF recovery database statuses DSNDB07 work file database name EDM pools group buffer pool duplexing 2nd groups, creating groups, monitoring 2nd lock structures logs, archviing LPL page recovery member shutdowns multiple coupling facilities naming conventions restart light row-level locking subsystem availability advantages 2nd application support applications attachment interfaces binding CF cache structures defining failures global data buffering 2nd global locking management 2nd inter-system communications list structures lock structures multiple naming conventions recovery commits DCL DDL DSNJU003 groups 2nd monitoring 2nd IMMEDWRITE parameter lock avoidance locks, minimizing naming conventions 2nd 3rd group-level member-level Parallel Sysplex pre-existing subsystems requirements 2nd 3rd Sysplex 2nd sysplex parallelism tuning Version 7 enhancements data sharing environments auto rebind data sharing group buffer pools tuning 2nd 3rd 4th 5th castout process duplexing GBPCACHE parameter partitioned tablespaces size thresholds data sharing groups global locks 2nd structures hierarchical locks L-locks P-locks data stable Data Transaction Manager. data transfer rates increasing DB2 Connect data transformations data warehouse population aggregation transformations automating 2nd data cleansing 2nd 3rd integration 2nd simple transformations summarization transformations data types base UDTs, compared columns customizing 2nd 3rd 4th columns/rows, selecting 2nd 3rd DATE 2nd equivalent 2nd lengths 2nd native DB2 2nd promotability 2nd REXX ROWID SMALLINT Java stored procedures tables 2nd TIME 2nd TIMESTAMP 2nd user-defined. valid listing of 2nd Data Warehouse Center 2nd data warehouses accessing backing up check constraints data cleansing 2nd data quality Data Warehouse Center 2nd data-compression DB2 designs denormalization dirty reads environment format conversions implmenting 2nd indexes managing 2nd MQTs operational needs parallelism purging data pyramid query tools read-only data referential integrity triggers 2nd troubleshooting Warehouse Manager data warehousing data marts, compared designing 2nd metadata 2nd star schema 2nd 3rd ODS 2nd OLAP 2nd operational databases, compared overview 2nd populating data transformations 2nd 3rd 4th 5th 6th 7th 8th replication vs propagation snapshots data-compression data warehouses DATA_SHARING_GROUP_NAME session variable database analysis tools 2nd database authority query database changes online schema changes column data types 2nd 3rd 4th exception states implementing indexes 2nd 3rd 4th 5th 6th 7th pre-V8 table space partitioning 2nd 3rd 4th V8 new features 2nd versioning 2nd 3rd 4th DATABASE class privileges database code usage (long accounting reports ) DATABASE DB2 object database descriptors. database management systems object/relational 2nd database modeling and design tools 2nd database object lists adding/deleting objects from 2nd creating 2nd example 2nd expanding 2nd guidelines 2nd indexes LOBs 2nd preveiwing referential integrity testing 2nd wildcards 2nd database server (DS) function Database Services Address Space. databasees administration guide databases active aliases data sharing statuses subsystem availability DBDs 2nd 3rd size, reducing denormalization 2nd 3rd 4th avoiding combined tables derivable data hierarchies 2nd 3rd 4th large page sizes mirror tables pre-joined tables redundant data repeating groups 2nd report tables split tables 2nd types validity, testing design tuning 2nd 3rd designs tuning DSNDB04 paraemter DSNDB07 work file database Fast Path IMS accessing 2nd multiple viewing normalization 2nd 3rd first normal form second normal form third normal form objects, dropping operations data warehouses, compared parameters 2nd sample security specific information, reporting navigational queries structures DB2 Family differences table average per DATACLAS option TEMPLATE statement Datamation (ital) dataset passwords Version 6 datbases EDM pools date and time addition table built-in options data types 2nd dates/non-dates combinations durations 2nd non-standard dates 2nd total number of days date and time arithmetic 2nd DATE data type 2nd 3rd promotability DATE durations DATE format nonstandard DATE function date/time data tables date/time stamps tables 2nd DAY function day timestamp unit DAYOFMONTH function DAYOFWEEK function DAYOFWEEK_ISO function DAYS function DB2 Catalog active 2nd CHECK INDEX utility columns, customizing data sets multiple extents DDL first-time effect I/O indexes rebuilding integrated links 2nd 3rd nonsubvertible proliferation queries 2nd queries. reorganizing 2nd 3rd synchronizing 2nd table spaces 2nd REPAIR LOCATE utility semiactive shadow copies size SQL access, monitoring statistics 2nd 3rd 4th 5th 6th 7th 8th column cardinality filter factors first key cardinality HIGH2KEY/LOW2KEY 2nd inner/outer tables maintenance optimizing 2nd 3rd relationships RUNSTATS SYSADMs 2nd troublesome queries unclulstered indexes updateable 2nd 3rd 4th updating values statistics, customizing structure 2nd 3rd tables 2nd 3rd 4th 5th IPLIST IPNAMES LOCATIONS LULIST LUMODES LUNAMES MODESELECT SYSAUXRELS SYSCHECKDEP SYSCHECKS SYSCHECKS2 SYSCOLAUTH 2nd SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS SYSCOLSTATS SYSCOLUMNS SYSCOLUMNS_HIST SYSCONSTDEP SYSCOPY SYSDATABASE SYSDATATYPES SYSDBAUTH SYSDBRM SYSDUMMY1 SYSFIELDS SYSFOREIGNKEYS SYSINDEXES SYSINDEXES_HIST SYSINDEXPART SYSINDEXPART_HIST SYSINDEXSTATS SYSINDEXSTATS_HIST SYSJARCLASS_SOURCE SYSJARCONTENTS SYSJARDATA SYSJAROBJECTS SYSKEYCOLUSE SYSKEYS SYSLINKS SYSLOBSTATS SYSLOBSTATS_HIST SYSPACKAGE SYSPACKAUTH SYSPACKDEP SYSPACKLIST SYSPACKSTMT SYSPARMS SYSPKSYSTEM SYSPLAN SYSPLANDEP SYSPLSYSTEM SYSPROCEDURES SYSRELS SYSRESAUTH SYSROUTINEAUTH SYSROUTINES SYSROUTINES_OPTS SYSROUTINES_SRC SYSSEQUENCEAUTH SYSSEQUENCES SYSSEQUENCESDEP SYSSTMT SYSSTOGROUP SYSSTRINGS SYSSYNONYMS SYSTABAUTH SYSTABCONST SYSTABLEPART SYSTABLEPART_HIST SYSTABLES SYSTABLES_HIST SYSTABLESPACE SYSTABSTATS SYSTABSTATS_HIST SYSTRIGGERS SYSUSERAUTH SYSVIEWDEP SYSVIEWS SYSVLTREE SYSVOLUMES SYSVTREE USERNAMES tablespaces separating tuning 2nd 3rd 4th contention 2nd 3rd data set placement 2nd data sets indexes 2nd performance reorganizing RUNSTATS size SQL access, monitoring tablespaces, separating timeouts/deadlocks updates utilities 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 Version 4 features Version 5 features Version 6 features DB2 Commands option DB2I DB2 Connect 2nd advantages applications, binding character data types data transfer rates DDF for z/OS distributed threads 2nd overview 2nd 3rd packaging 2nd ASE EE 2nd 3rd 4th PE 2nd UE packging EE PE SQLCODE/SQLSTATE differences supported platforms utilities, binding DB2 Connect Application Server Edition (ASE) DB2 Connect Enterprise Edition (EE) 2nd thread pooling 2nd DB2 Connect Personal Edition (PE) 2nd DB2 Connect Unlimited Edition (UE) DB2 data accessing (Internet) Java Net.Data 2nd 3rd 4th network traffic software versions encrypting 2nd DB2 Data Warehouse Center. DB2 DataPropagator. DB2 Development Center DB2 Directory reorganizing regular table spaces 2nd restrictions 2nd 3rd six special table spaces 2nd table spaces 2nd REPAIR LOCATE utility tables DBD01 SCT02 SPT01 SYSLGRNX SYSUTILX utilities 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 Estimator table space space requirements DB2 Express DB2 Family code bases differences 2nd 3rd database structures directories optimizer products DB2 intelligent miner for data DB2 intelligent miner for text DB2 intelligent miner scoring DB2 Interactive. DB2 Log Preformat utility. DB2 Magazine (ital) DB2 Magazine Web site DB2 objects ALIAS COLUMN DATABASE defining 2nd hierarchy identifiers INDEX native data types 2nd security 2nd STOGROUP SYNONYM TABLE TABLESPACE VIEW DB2 OLAP server DB2 Performance Monitor. DB2 PM monitoring reference 2nd 3rd report sets 2nd accounting 2nd 3rd 4th 5th 6th accounting. audit 2nd 3rd explain I/O activity 2nd 3rd locking 2nd record trace 2nd 3rd SQL trace 2nd 3rd statistics 2nd 3rd 4th 5th 6th 7th 8th summary 2nd system parameters 2nd 3rd transit time 2nd 3rd 4th report traces, starting 2nd 3rd DB2 PM (DB2 Performance Monitor) DB2 resources Internet bookmarks cross-posting (newsgroups) emoticons FAQs flames information sources mailing list archives mailing lists, digesting mailing lists, finding newsgroups tips newsgroups vs mailing lists privacy search engines spams mailing lists 2nd Usenet newsgroups 2nd 3rd Web 2nd 3rd 4th 5th 6th DB2 tables declaring application programs DB2 Times Web site DB2 Today (ital) DB2 Update (ital) DB2 USA Web site DB2 Version 4 client/server features DB2 Catalog features DBA features performance features programming features DB2 Version 5 DB2 Catalog features DBA features performance features programming features utility features DB2 Version 6 database administration features dataset passwords DB2 Catalog features host variables performance features programming features REBUILD INDEX utility RECOVER INDEX utility 2nd SROD 2nd stored procedure registration 2nd Type 1 indexes 2nd Type 2 indexes utility features DB2 Version 7 application development enhancements 2nd 3rd Precompiler Services row expressiosn rows fetched 2nd SAVEPOINTs 2nd scrollable cursors 2nd SPB 2nd SQL Assist business intelligence enhancements 2nd data management enhancements 2nd 3rd data sharing declared temporary tables 2nd deferred data sets creation identity columns 2nd LOG SUSPEND command Unicode 2nd utilities 2nd 3rd DBA tools e-business enhancements 2nd migration utility core functionality 2nd utility improvements utility packaging DB2 Version 8 architecture 2nd DBAs 2nd 3rd log volumes multi-level security padded variable length indexes partitions 2nd Schema Evolution sequences 2nd migration 2nd 3rd programming 2nd 3rd CTEs Java recursion SQL system limits XML DB2 Warehouse Manager. DB2-enforced referential integrity DB2-L mailing list DB2-PM DB2Audio UDF audio DB2AUDIO UDT DB2AudioA UDF audio DB2CONN parameter command thread attributes 2nd connection attributes 2nd pool thread attributes 2nd 3rd THREADERROR parameter DB2ENTRY parameter thread operation attributes 2nd thread selection attributes DB2I 2nd 3rd 4th 5th 6th bind option bind panels DB2 Commands option DCLGEN option DCLGEN panel Defaults option Defaults panel environment commands, issuing 2nd Free Plan option JCL generation panels 2nd 3rd main menu menu panels Commands Defaults Free Package Free Plan Rebind Package Rebind Plan Run panel SPUFI SPUFI Defaults precompile option Precompile panel Program Preparation option Program Preparation panel rebind option Run option Run panel SPUFI option 2nd 3rd 4th 5th defaults input data set 2nd SPUFI Defaults panel SPUFI panel Utilities option DB2I (DB2 Interactive) DB2ID parameter DB2CONN parameter DB2Image UDF image DB2IMAGE UDT DB2ImageA UDF image DB2TEXTFH UDT DB2TEXTH UDT DB2TRAN parameter 2nd DB2Video UDF video DB2VIDEO UDT DB2VideoA UDF video DBA Version 4 features Version 5 features Version 6 DBA tools 2nd Version 7 enhancements DBaAdminGetInaccessibleFiles API DBADM group-level authorization DBAs DBAS BM DM DBAs procedural Procedural political issues 2nd procedural SQL 2nd role 2nd schemas tasks 2nd technical issues 2nd triggers DBAS RDS DBAs roles 2nd 3rd statistics 2nd 3rd Version 8 2nd 3rd log volumes multi-level security padded variable length indexes partitions 2nd Schema Evolution sequences 2nd DBAS (Database Services Address Space) DBATs inactive 2nd Dbazine.com (ital) DBAzine.com Web site DBCLOB data type promotability DBCLOB function DBCLOBs (Double Byte Character Large Objects) DBCTRL group-level authorization DBD01 table DBD01 table space DBDs 2nd 3rd multi-table table spaces size, reducing DBDs (database descriptors) DBE Software, Inc. DBID column INDEXSPACESTATS table TABLESPACESTATS table DBID queries QMF forms DBINFO UDF characteristic DBMAINT group-level authorization DBMS protection stored procedures DBMS logic support Procedural DBA DBNAME column INDEXSPACESTATS table TABLESPACESTATS table DBNAME parameter buffer pools DBRM libraries programs, precompiling DBRMs defined long accounting reports information 2nd names 2nd retaining 2nd DCE (Distributed Computing Environment) DCL data sharing DCL (Data Control Language) DCLGEN command program preparation 2nd 3rd column prefixing 2nd null indicators DCLGEN declare members names DCLGEN libraries DCLGEN option (DB2I) DCLGEN panel (DB2I) DCLGEN statements break apart columns 2nd DCLGEN libraries DCLGEN members 2nd field name PREFIX host variables, prefixing unqualified table references DCRM (Distributed Communication Resource Manager) DDF 2nd DCRM DDIS dispatching priority 2nd DRDS DTM DDF (Distributed Data Facility) 2nd DDF for z/OS DDF suspend/resume DDFS (Distributed Data Facility Services) DDIS (Distributed Data Interchange System) DDL applications data sharing DB2 Catalog DSNTIAD execution, planning IMS DDL (Data Definition Language) DDLs CICS DDM (Distributed Data Management) DE (UDB Developer •s Edition) deactivating versions (online schema changes) DEADLINE parameter online reorganizations deadlock errors DEADLOCK parameter IRLM address space deadlocks 2nd batch programs IMS 2nd debugging CICS tools SQL Procedural DBA DEC function decimal columns DECIMAL columns LOAD utility DECIMAL data type promotability DECIMAL function decimal precision precompiling decimals precision/scale declarations (variables) LOBs 2nd declarative referential integrity triggers DECLARE CURSOR statement FOR UPDATE OF clause order DECLARE GLOBAL TEMPORARY TABLE statement DECLARE statement cursors DECLARE TABLE statements declared temporary tables 2nd 3rd advantages 2nd scrollable cursors storage 2nd Version 7 enhancements 2nd declaring cursors DECPT parameter DECRYPT_BIT function DECRYPT_CHAR function DECRYPT_DB function Defaults option DB2I Defaults panel (DB2I) DEFER parameter CREATE INDEX statement deferred data sets creating Version 7 enhancements deferred write threshold buffer pools DEFINE NO parameter index data sets DEFINE parameter index data sets defining CF columns LOB columns referential constraints 2nd 3rd RLSTs degrees (parallelism) DEGREES function DELAY parameter online reorganizations DELETE authority restricting DELETE command CICS file processing DELETE parameter MODIFY STATISTICS utility 2nd DELETE statements cursor controlled cursors mass self-referencing DELETE statemetns DELETE YES parameter CHECK DATA utility deleting columns base table views data sets duplicate rows 2nd IN list duplicates mass deletes LOAD utility nonuniform distribution statistics 2nd objects database object lists 2nd PLAN TABLE rows remote processing RIDs rows cursors non-SELECT dynamic SQL trigger packages VSAM data sets delimited input data sets loading 2nd denormalization 2nd 3rd 4th 5th avoiding combined tables data warehouses derivable data distributed fragmentation 2nd 3rd 4th replication 2nd snapshot tables 2nd hierarchies 2nd 3rd 4th department queries speed tables 2nd large page sizes mirror tables pre-joined tables redundant data repeating groups 2nd report tables split tables 2nd types validity, testing department hierarchies department table 2nd dependent tables referential constraints navigational queries derivable data denormalization DES tools 2nd DESC keyword ORDER BY clause DESCRIBE PROCEDURE statements DESCRIPTION parameter DB2CONN parameter DESCTAT parameter design CICS application size 2nd Attach Facility availability 2nd COBOL file processing COBOL verbs conditional table access conversational applications DDLs debugging linking locking problems paragraphs, executing plans sequential number assignments SQL synchronization variables, initializing databases tuning 2nd 3rd online TSO applications 2nd 3rd 4th 5th efficient performance fast application development designing data warehouses 2nd metadata 2nd star schema 2nd 3rd designs databases tuning dynamic SQL reviewing 2nd 3rd 4th phase five phase four phase one phase seven phase six phase three phase two destinations trace specifying traces 2nd DETAIL parameter DISPLAY BUFFERPOOL command DETERMINISTIC parameter UDFs DETERMINISTIC UDF characteristic developing application programs applications Version 7 enhancements 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th applications (SQL only) domains, simulating 2nd 3rd integrity native SQL SQL stored procedures stored procedures LE/370 language nested procedure calls 2nd parameters 2nd program preparations result sets, returning 2nd 3rd development CASE tools support RDBMS cardinal rule DFSMS backup copies DFSMS copies recovering DFSORT utility sort work spaces DIAGNOSE utility diagramming CASE tools support dictionaries compression data dictionary pages digesting mailing lists DIGITS function Direct Computer Resources direct index lookups direct requests Net.Data direct row access online applications 2nd directories DB2 Family differences Directory (DB2) reorganizing regular table spaces 2nd restrictions 2nd 3rd six special table spaces 2nd table spaces 2nd REPAIR LOCATE utility tables DBD01 SCT02 SPT01 SYSLGRNX SYSUTILX utilities 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 dirty reads BIND statements 2nd 3rd 4th benefits problems UR isolation levels 2nd data warehouses isolation levels advantages 2nd implementing 2nd requirements DISABLE PARALLEL parameter DISABLE parameters BIND statements 2nd DISABLE QUERY OPTIMIZATION parameter disabling environments index access list prefetch 2nd parallel disaster recovery active log sizes archiving backups compression copying documentation environments 2nd normal business return offsite copies offsite recovery validation planning QMF forms DBID/PSID/OBID queries shipping image copies offsite table spaces testing disaster recovery plans 2nd application classes 2nd DSN1COPY 2nd 3rd instant copies/restore 2nd RECOVER utility recovery basics requirements 2nd risks scalpel 2nd 3rd 4th 5th SET LOG SUSPEND command 2nd sledgehammer 2nd synchronizing disasters defined 2nd DISCONNECT parameter DISCONNECT parameters application-directed distribution disk devices retrieval costs disk options TEMPLATE statement 2nd disk volumes storage groups disks COPY utility image copies DISP option TEMPLATE statement dispatching priorities batch jobs hierarchy dispatching priority (DDF) 2nd DISPLAY (/ before) command DISPLAY BUFFERPOOL command DETAIL parameter DISPLAY command OVERVIEW parameter resource status, viewing DISPLAY DATABASE command 2nd 3rd 4th 5th ACTIVE paraemter CLAIMERS/LOCKS clauses RESTRICT parameter USE parameter wildcards DISPLAY FUNCTION SPECIFIC command 2nd DISPLAY GROUP command DISPLAY LOG command DISPLAY PROCEDURE command 2nd DISPLAY UTILITY command 2nd LOAD utility utilities, monitoring DISTINCT keyword 2nd clauses DISTINCT TYPE class privileges distinct type names Distributed Communication Resource Manager. Distributed Computing Environment. distributed cursors client/server applications distributed data accessing application-directed 2nd 3rd 4th methods, comparing system-directed 2nd 3rd 4th DRDA architectures 2nd 3rd 4th benefits 2nd five levels 2nd 3rd 4th 5th 6th 7th functions 2nd 3rd 4th 5th overview RDA, compared remote processing location example 2nd placement 2nd private protocol converting to DRDA Distributed Data Facility Services. Distributed Data Facility. 2nd Distributed Data Interchange System. Distributed Data Management. distributed denormalization fragmentation 2nd 3rd 4th replication 2nd snapshot tables 2nd distributed processing distributed query blocks controlling Distributed Relational Data System. Distributed Relational Database Architecture. distributed requests (DRDA) distributed threads DB2 Connect 2nd Distributed Unit of Work . distributed unit of work. distributing data ASCII support binding options 2nd block fetches continuous 2nd 3rd cursors 2nd 3rd 4th 5th data currency 2nd 3rd limited 2nd 3rd CDB 2nd client/server applications DDF DDF suspend/resume DDF. dynamic cursor pre-opens locations one-phase commit two-phase, compared optimization 2nd 3rd partitioned table spaces performance buffer pools DDF dispatching priority 2nd OPTIMIZE FOR n ROWS clause response times SQL result sets throughput chains throughput, analyzing 2nd 3rd VTAM parameters 2nd problem resolution logs remote processing, deleting requests requests, combining security authid translations 2nd come-from checking PUBLIC AT ALL LOCATIONS parameter TCP/IP support threads connection pools 2nd inactive DBATs 2nd two-phase commit actual commit 2nd multi-site updates one-phase, compared preparation phase syncpoint trees type-2 connections Unicode support units of work Version 8 database aliases location aliases TCP/IP network member routing versions (DB2) workstation DB2 divertable transactions DL/I batch interface 2nd DM DM (Data Manager) DML (Data Manipulation Language) Document Type Definitions. documenting disaster recovery strategies domains simulating 2nd 3rd views support 2nd 3rd Double Byte Character Large Objects. DOUBLE data type promotability DOUBLE function down-level data sets repairing DPMODE ENTRY macro parameter DPMODE POOL macro parameter DPMODI RCT INIT macro parameter DPROP (DB2 DataPropagator) DPSIs troubleshooting 2nd DPSIs (data partitioned secondary indexes) 2nd drains 2nd 3rd claims compatibility 2nd 3rd locks DRAW command QMF DRDA architectures APPC CDRA DDM FD( colon )OCA benefits 2nd five levels 2nd distributed requests distributed unit of work remote processing location example 2nd remote request remote unit of work user-assited distribution functions application requesters application server database server returns ODBC, compared overview private protocol distribution, converting RDA, compared DRDA (Distributed Relational Database Architecture) DRDA levels DUW remote request RUW DRDS (Distributed Relational Data System) drivers JDBC 2nd DROLLBACK parameter CICS pool thread attributes CICS thread operation attributes DROP parameter REPAIR DBD utility tables DS (database server) function DSD tools DSN command DSN command processor invoking TSO online applications 2nd DSN commands 2nd 3rd group attach processing sessions, terminating tracing DSN FUNCTION TABLE 2nd 3rd 4th columns RUNSTATS DSN option TEMPLATE statement DSN STATEMENT TABLE 2nd 3rd columns 2nd 3rd APPLNAME COLLID COST CATEGORY EXPLAIN TIME GROUP MEMBER PROCMS PROCSU PROGNAME QUERYNO REASON STMT ENCODE STMT TYPE RUNSTATS version 8 DSN_FUNCTION_TABLE table 2nd 3rd columns 2nd DSN_FUNCTION_TABLE. DSN_STATEMNT_TABLE. DSN1CHKR (Catalog Integrity Verification) utility DSN1CHKR utility 2nd integrity verification JCL read-only mode scheduling table spaces DSN1COMP (Compression Analyzer) utility DSN1COMP utility compression, planning DSSIZE parameter JCL PAGESIZE parameter parameters prefixes DSN1COPY (Offline Copy) utility DSN1COPY disaster recovery strategy 2nd 3rd DSN1COPY utility 2nd BUFND parameter hex dumps identity columns JCL listing large table spaces LOB table spaces log data sets OBIDXLAT option OBIDXLAT option JCL PAGESIZE parameter prefixes record OBIDs, translating running SYSUT2 data set SYSXLAT file DSN1LOGP (Recovery Log Extractor) utility DSN1LOGP utility active logs JCL output reports DSN1PRNT (Data Set Dump Creator) utility DSN1PRNT utility 2nd 3rd errors JCL LOB table spaces page sizes PAGESIZE parameter running DSN1SDMP utility JCL DSN1SDMP (Dump and Trace) utility. DSN1SDMP utility data sets user authority DSN8810.ACT table DDL DSN8810.DEPT table 2nd DSN8810.EMP table 2nd DSN8810.EMP_PHOTO_RESUME table 2nd DSN8810.EMPPROJACT table DSN8810.PROJ table 2nd DSN8810.PROJACT table 2nd DSN8DLPL application DSN8DLRV application DSN8ED3 sample program DSN8ES1 sample program DSN8HUFF routine DSNACCOR stored procedure 2nd DSNC command DSNC DISCONNECT command DSNC DISPLAY command DSNC DISPLAY STATISTICS command 2nd DSNC MODIFY command DSNC STOP command DSNC STRT command DSNCLI language interface DSNDB04 parameter DSNDB07 work file database DSNDB07 work files DSNH command DSNHSQL sample program DSNJ002I message DSNJ1391 message DSNJCNVB utility 2nd BSDS, expanding DSNJLOGF utility 2nd (DB2 Log Preformat) JCL listing timestamps DSNJU003 (Change Log Inventory) utility DSNJU003 utility CCSID information data sharing JCL listing RESTORE SYSTEM utility combination running DSNJU004 (Print Log Map) utility DSNJU004 utility 2nd DSNT375I messages DSNT376I messages DSNT501I messages DSNTEJ63 sample program DSNTEJ64 sample program DSNTEP2 (dynamic SQL processor) application 2nd 3rd batch environment comments error handling input data sets rerunning DSNTEP2 (sample unload) application return codes DSNTEP2 application DSNTIAD (dynamic SQL update) application 2nd 3rd comments DDL error handling executing authority JCL preparations rerunning DSNTIAD (sample unload) application return codes DSNTIAUL (sample unload) application 2nd 3rd data movement JCL LOCK TABLE statement maximum unloads preparations return codes SQL statements SYSREC data sets unloaded flat files views, unloading WHERE/ORDER BY clauses DSNTPSMP SQL stored procedures, creating DSNTPSMP (SQL procedure processor) DSNU command DSNUTILB parameter DSNZ002I message DSNZPARM parameter lock escalation table spaces 2nd DSNZPARMs tuning active users EDM pools locks logs 2nd timeouts 2nd traces DSSIZE parameter DSN1COMP utility DSN1COPY parameter partitioned table spaces table spaces DTD repository tables 2nd DTDs (Document Type Definitions) DTM (Data Transaction Manager) dual image copies COPY utility dummy tables Dump and Trace utility. dumps REPAIR LOCATE utility duplexing data sharing group buffer pools group buffer pools 2nd 3rd 4th duplicate rows deleting 2nd Duration UDF audio video durations date and time 2nd DUW DUW (distributed unit of work) DUW (Distributed Unit of Work) DWQT parameter buffer pools dynamic authorities dynamic cursor pre-opens dynamic data accessing dynamic SQL DYNAMIC parameter scrollable cursors 2nd dynamic plan selecting 2nd dynamic reoptimization dynamic scrollable cursors 2nd 3rd dynamic sequential prefetches dynamic SQL 2nd 3rd access, customizing 2nd advantages/disadvantages avoiding bind-time authorization checking classes designs dynamic data, accessing EXECUT IMMEDIATE statement host variables one-time processing syntax EXECUTE IMMEDIATE statement 2nd fixed-list SELECT 2nd 3rd flexibility listing parameter markers 2nd prepared statements SQLDA flexibility governing JDBC maintenance design non-SELECT 2nd 3rd EXECUTE IMMEDIATE statements, compared parameter markers 2nd prepared statements rows, deleting syntax non-uniform data overview parallelism parameter markers performance 2nd prepared statements, caching 2nd 3rd prepares, reducing QMFCI reoptimization RLSTs static SQL, compared tuning varying-list SELECT 2nd 3rd 4th 5th listing minimal SQLDA SQLDA 2nd SQLTYPE values 2nd varying-list SELECT statements dynamic SQL processor (DSNTEP2) application 2nd 3rd dynamic SQL statements stored procedures dynamic SQL update (DSNTIAD) application 2nd 3rd dynamic system parameters DYNAMICRULES parameter BIND statements 2nd 3rd dynamism SQL statements
|
| < Day Day Up > |