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]
C/S tools cache authorization EDM pools cache structures CACHESIZE parameter BIND command BIND statements caching indexes package authorization plan authorization plans prepared statements 2nd 3rd table spaces CAE (Client Application Enabler) CAF advantages/disadvantages 2nd calls sample applications threads, creating 2nd vendor tools CAF (Call Attach Facility) Call Attach Facility. Call Level Interface. CALL statements stored procedures calling stored procedures 2nd calls CAF Candle Computer Report (ital) Candle Corporation cardinal rule (RDBMS development) cardinality column indexes 2nd cardinality (table UDFs) overriding CARDINALITY keyword CARDINALITY UDF characteristic Cartesian products avoiding SQL 2nd 3rd CASCADE option referential constraints cascading delete rule online applications CASE (computer-aided software engineering) CASE expressions 2nd 3rd rows, counting CASE tools application development 2nd business strategy support data modeling support development support diagramming support generated SQL I/O routines integrated development platforms metadata support multiple platform support process modeling support prototyping support quality assurance support runtime modules system testing support technical environment support CAST function data type equivalency UDFs casting functions UDTs 2nd CASTOUT parameter member shutdowns castout process data sharing group buffer pools CASTOWNR parameter buffer pools CAT tools 2nd Catalog statistics, customizing Catalog (DB2) active 2nd CHECK INDEX utility columns , customizing data sets multiple extents reorganizing SQL access, monitoring DDL first-time effect I/O indexes rebuilding integrated links 2nd 3rd nonsubvertible proliferation queries 2nd queries. reorganizing 2nd synchronizing 2nd table spaces 2nd REPAIR LOCATE utility semiactive shadow copies size 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 unclustered indexes updateable 2nd 3rd 4th updating values 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 contnetion 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 Catalog Integrity Verification utility. Catalog query and analysis tools 2nd CATENFM utility CATMAINT utility 2nd CCSID parameter DSNJU003 utility table spaces 2nd tables CCSID UDF text CCSID_ENCODING function CDB 2nd CDB (Communication Database) CDB (Communications Database) CDB Sofware Inc. CDRA (Character Data Representation Architecture) CEIL function CEILING function century timestamp unit CF cache structures defining failures global data buffering 2nd buffer pools group buffer pool duplexing 2nd updating/reading data 2nd global locking management 2nd inter-system communications list structures lock structures multiple naming conventions recovery CF (Coupling Facility) CFRM (Coupling Facility Resource Management) CHANGE (/ before) command Change Log Inventory utilty. CHANGELIMIT parameter COPY utility 2nd 3rd CHAR data type promotability CHAR function character data Java Character Data Representaiton Architecture. character data types (DB2 Connect) Character Large Objects. characteristics UDFs 2nd 3rd characters naming conventions CHARDEL parameter CHARONWARE check constraints 2nd 3rd advantages checking 2nd data warehouses domains, simulating 2nd 3rd names navigational queries semantics table-level coding triggers, compared 2nd CHECK DATA utility bypassing check constraints 2nd check pending status DELETE YES parameter exception tables indexes informational referential constraints LOB references 2nd AUXERROR parameter SCOPE parameter locks partition levels phases 2nd referential integrity rerunning running SCOPE PENDING option work data sets 2nd CHECK INDEX utility 2nd 3rd dangerous operations DB2 Catalog locks partition levels phases rerunning running work data sets 2nd CHECK LOB utility 2nd EXCEPTIONS parameter locks phases check pending flags correcting reasons for 2nd repairing check pending status checking CHECK utility Chicago-Soft Products Ltd. CHKFREQ parameter CICS 2nd accounting records AEY9 bends, avoiding application size 2nd Attach Facility 2nd 3rd 4th Attach Facility availability 2nd COBOL file processing COBOL verbs COMD entries command thread attributes 2nd conditional table access connection attributes 2nd conversational applications DDLs debugging design DSNC DISPLAY STATISTICS command dynamic plan selection 2nd file processing commands IMS, compared language interface linking locking problems paragraphs, executing plan management 2nd plans pool thread attributes 2nd 3rd pool threads 2nd program preparation 2nd prorams protected threads RACF authoriation RCT RDO, compared 2nd RCT parameters 2nd 3rd AUTH values COMD macro 2nd 3rd ENTRY macro 2nd 3rd 4th INIT macro 2nd 3rd 4th POOL macro 2nd RCTs migrating to RDO RDO 2nd RDO parameter wildcarding RDO parameters DB2CONN 2nd 3rd 4th 5th 6th 7th 8th DB2ENTRY 2nd 3rd 4th DB2TRAN 2nd RDO vs RCT 2nd rollbacks security sequential number assignments SQL subsystem IDs synchronization tables 2nd FCT PCT PPT RCT tasks TCBs maximum THRDA parameter THRDM parameter thread operation attributes 2nd thread selection attributes thread types 2nd threads 2nd transactions transactions, grouping two-phase commits 2nd variables , iniatilizing CICS (Customer Information Control System) CICS commands 2nd 3rd controlling transactions, monitoring CICS preprocessors program preparation CLAIMERS clause DISPLAY DATABASE command claims 2nd classes drains compatibility 2nd 3rd classes accounting trace accounting traces applications 2nd audit trace claims dynamic SQL monitor traces performance traces 2nd privileges COLLECTION DATABASE DISTINCT TYPE FUNCTION PACKAGE PLAN SCHEMA SYSTEM TABLE USE VIEW statistics traces clasues GROUP BY HAVING WHERE clause, compared 2nd ORDER BY WHERE HAVING clause, compared 2nd clauses ACTION stored procedures AUDIT CLAIMERS DISPLAY DATABASE command DISTINCT keyword EDITPROC compression routines EXCLUDE LISTDEF statement 2nd FETCH FIRST n ROWS ONLY FOR FETCH ONLY cursors FOR READ ONLY cursors 2nd FOR UPDATE OF data integrity DECLARE CURSOR statement SELECT statements GROUP BY columns ORDER BY clause, compared HAVING column function results MQTs IN DATABASE tables INCLUDE LISTDEF statement 2nd join search criteria KEEP UPDATE LOCKS LIKE table schemas LOCKS DISPLAY DATABASE command NEXT VALUE FOR sequence objects OPTIMIZE FOR n ROWS optimizer, influencing 2nd 3rd OPTIMIZE FOR n ROWS clause distribution performance ORDER BY columns DSNTIAUL utility GROUP BY, compared joins row sequencing rows top ten retrieval PIECESIZE 2nd 3rd RETAIN CURSORS SAVEPOINT RETAIN LOCKS SCRATCHPAD SHRLEVEL REFERENCE offsiet copies UNIQUE WHERE NOT NULL WHEN CASE expressions triggers WHERE data filtering DSNTIAUL utility primary keys scalar functions WHERE CURRENT OF UPDATE/DELETE statements WITH isolation levels WITH CASCADED CHECK OPTION WITH CHECK OPTION views 2nd WITH HINT data encryption WITH HOLD locks WITH LOCAL CHECK OPTION WITH NO DATA MQTs 2nd cleansing data data warehouses 2nd data warehouses, populating 2nd 3rd data warehouses, populating;reformatting data warehouses, populating;value validation 2nd CLI (Call Level Interface) CLIENT ACCTNG register Client Application Enabler. CLIENT APPLNAME register CLIENT USERID register CLIENT WORKSTNNAME register client/server applications complex environment DB2 connections 2nd distributed cursors SQL anomalies SQL requests , consolidating stored procedures tools documentation triggers client/server environments Net.Data support client/server processing client/server tools clients /servers Version 4 features CLIST program preparation bind CLIST 2nd precompile/compile/link CLIST 2nd CLOB data type promotability CLOB function CLOBs (Character Large Objects) cloning programs CLOSE parameter table spaces 2nd 3rd CLOSE statement cursors CLOSE statements cursors closing cursors VSAM data sets 2nd 3rd closing points cursors CLUSTER keyword clustered columns joins clustered index access clustering indexes 2nd customizing 2nd locks partitioned table spaces REORG utility RUNSTATS utility clustering indexes ignoring CLUSTERRATIOF column CMs (conversation managers) COALESCE function outer joins 2nd table expressions COBOL host variables SQL, compared 2nd verbs COBOL error-handling paragraph example 2nd COBOL EXECUTE IMMEDIATE statement listing COBOL file processing COBOL non-SELECT dynamic SQL program COBOL stored procedure shell 2nd Codd, E. F code (DB2) tuning code bases DB2 Family code literals SQL statements code tables multi-table table spaces CODE/370 language stored procedures Cognos Inc. COLARDF column COLDEL parameter collection access method COLLECTION class privileges collection identifiers packages collection IDs stored procedures collections 2nd 3rd 4th BIND statements CURRENT PACKAGE PATH special register multiple packages names package list size size COLLID column DSN STATEMENT TABLE DSN_FUNCTION_TABLE table PLAN TABLE COLLID parameter stored procedures column access method column authority query column cardinality indexes 2nd COLUMN DB2 object COLUMN FN EVAL column PLAN TABLE column functions 2nd 3rd AVG COUNT 2nd COUNT_BIG MAX MIN STDDEV SUM VARIANCE column group statistics gathering RUNSTATS utility 2nd column statistics gathering RUNSTATS utility 2nd columns abbreviation standards ACENDATE ACSTDATE adding base table views 2nd 3rd indexes 2nd APPLNAME DSN_FUNCTION_TABLE table attributes MQTs 2nd average per table query averages avoiding (indexes) BIND_OPTS SYSIBM.SYSPSMOPTS table BUILDNAME SYSIBM.SYSPSMOPTS table BUILDOWNER SYSIBM.SYSPSMOPTS table BUILDSCHEMA SYSIBM.SYSPSMOPTS table changed, updating clustered joins CLUSTERRATIOF COLARDF COLLIC DSN_FUNCTION_TABLE table COMPILE_OPTS SYSIBM.SYSPSMOPTS table compressing correlated critical data types 2nd customizing 2nd 3rd 4th data types, selecting 2nd 3rd date/time data date/time stamp 2nd DB2 Catalog customizing decimal DECIMAL LOAD utility defaults 2nd defining deleting base table views DSN FUNCTION TABLE DSN STATEMENT TABLE 2nd 3rd APPLNAME COLLID COST CATEGORY EXPLAIN TIME GROUP MEMBER PROCMS PROCSU PROGNAME QUERYNO REASON STMT ENCODE STMT TYPE DSN_FUNCTION_TABLE table 2nd EMENDATE EMSTDATE EXPLAIN_TIME DSN_FUNCTION_TABLE table expressions 2nd extra (indexes) FARINDREF FAROFFPOSF FIRSTKEYCARDF FULLKEYCARDF function results, searching FUNCTION_NAME DSN_FUNCTION_TABLE table FUNCTION_TEXT DSN_FUNCTION_TABLE table FUNCTION_TYPE DSN_FUNCTION_TABLE table GROUP_MEMBER DSN_FUNCTION_TABLE table grouping homonyms ICTYPE SYSIBM.SYSCOPY table identity 2nd IDENTITY identity copying IDENTITY navigational queries identity problems 2nd sequence objects, compared 2nd values Version 7 enhancements 2nd indexed joins updating indexes INDEXSPACESTATS table 2nd 3rd integer 2nd labels largest values, returning LEAFDIST LINK_OPTS SYSIBM.SYSPSMOPTS table listing LOB pages 2nd LOBs defining 2nd LOBs, creating 2nd 3rd auxiliary tables defining example 2nd LOB table spaces populating unique indexes long multiple indexes names 2nd 3rd CTEs returning views NEARINDREF NEAROFFPOSF null referencing nullable LOAD utility nulls 2nd 3rd 4th avoiding database design equivalency IS NOT DISTINCT FROM comparison operator IS NULL predicate overview ordering 2nd 3rd PAGESAVE PATH DSN_FUNCTION_TABLE table PERCDROP PLAN TABLE 2nd 3rd 4th 5th 6th ACCESS DEGREE ACCESS PGROUP ID ACCESSCREATOR ACCESSNAME ACCESSTYPE APPLNAME BIND TIME COLLID COLUMN FN EVAL CORRLEATION NAME CREATOR GROUP MEMBER HINT USED IBM SERVICE DATA INDEXONLY JOIN DEGREE JOIN PGROUP ID JOIN TYPE MATCHCOLS MERGE JOIN COLS METHOD MIXOPSEQ OPTHINT PAGE RANGE PARALLELISM MODE PARENT QBLOCKNO PARIMARY ACCESSTYPE PLANNO PREFETCH PROGNAME QBLOCK TYPE 2nd QBLOCKNO QUERY NO REMARKS 2nd ROUTINE ID SORTC GROUP SORTC JOIN SORTC ORDERBY SORTC PGROUP ID SORTC UNIQ SORTN GROUPBY SORTN JOIN SORTN ORDERBY SORTN PGROUP ID SORTNO UNIQ TABLE DCCSID TABLE ENCODE TABLE MCCSID TABLE SCCSID TABLE TYPE TABNO TIMESTAMP TNAME TSLOCKMODE VERSION WHEN OPTIMIZE PLAN_TABLE 2nd PRECOMPILE_OPTS SYSIBM.SYSPSMOPTS table prefixing 2nd PRELINK_OPTS SYSIBM.SYSPSMOPTS table PROCEDURENAME SYSIBM.SYSPSMOPTS table PROGNAME DSN_FUNCTION_TABLE table QBLOCKNO DSN_FUNCTION_TABLE table QUERYNO DSN_FUNCTION_TABLE table renaming 2nd required Java RLSTs 2nd ROWID direct row access LOBs 2nd SCHEMA SYSIBM.SYSPSMOPTS table SCHEMA_NAME DSN_FUNCTION_TABLE table security label sequence objects 2nd 3rd creating identity columns, compared 2nd parameters performance sequencing 2nd smallest values, returning SMALLINT SOURCEDSN SYSIBM.SYSPSMOPTS table SPEC_FUNC_NAME DSN_FUNCTION_TABLE table STATSTIME sum surrogate keys synonyms tables 2nd ROWID sequence objects TABLESPACESTATS table 2nd 3rd uniqueness updating values, counting 2nd VARCHAR indexes LOBs, compared 2nd 3rd maximum size REORG utility VARGRAPHIC LOBs, compared 2nd 3rd variable indexes 2nd variable character 2nd compression, compared customizing effectiveness 2nd VIEW_CREATOR DSN_FUNCTION_TABLE table VIEW_NAME DSN_FUNCTION_TABLE table wasted space COM tools 2nd COMAUTHID parameter CICS command thread attributes COMAUTHTYPE parameter CICS command thread attributes combined tables base table views denormalization COMD entries CICS COMD macro parameters RCT 2nd 3rd AUTH EOLBE THRDA THRDM THRDS TWAIT come-from checking command processors DSN invoking command thread attributes DB2CONN parameter 2nd commands /CHANGE /DISPLAY /SSR /START /STOP /TRACE ABEND administrative 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 ALTER BUFFERPOOL 2nd ALTER UTILITY ARCHIVE LOG 2nd disaster recovery BIND CACHESIZE parameter program preparation 2nd reactive governing BIND PACKAGE program preparation BIND PLAN program preparation CICS 2nd 3rd controlling transactions, monitoring CICS file processing cursors DCLGEN program preparation 2nd 3rd 4th 5th DELETE CICS file processing DISPLAY OVERVIEW parameter resource status, viewing DISPLAY BUFFERPOOL DETAIL parameter DISPLAY DATABASE 2nd 3rd 4th 5th ACTIVE parameter CLAIMERS/LOCKS clauses RESTRICT parameter USE parameter wildcards DISPLAY FUNCTION SPECIFIC 2nd DISPLAY GROUP DISPLAY LOG DISPLAY PROCEDURE 2nd DISPLAY UTILITY 2nd LOAD utility utilities, monitoring DRAW QMF DSN 2nd 3rd 4th group attach processing sessions, terminating tracing DSNC DSNC DISCONNECT DSNC DISPLAY DSNC DISPLAY STATISTICS 2nd DSNC MODIFY DSNC STOP DSNC STRT DSNH DSNU END ENDBR CICS file processing environment information-gathering. issuing with DB2I 2nd structure environment control 2nd security EXPLAIN auto rebinds simple statements 2nd EXPORT QMF FREE IMS 2nd 3rd 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 IRLM 2nd 3rd LOCK TABLE batch programs LOG SUSPEND Version 7 enhancements READ CICS file processing READNEXT CICS file processing READREADPREV CICS file processing REBIND RECOVER INDOUBT RESETBR CICS file processing REWRITE CICS file processing RUN SET QMF SET LOG SUSPEND disaster recovery 2nd SET SYSPARM SPUFI START UDFs START DATABASE 2nd START DB2 START DDF 2nd START PROCEDURE 2nd START RLIMIT START TRACE 2nd STARTBR CICS file processing STOP 2nd STOP DATABASE STOP DB2 STOP DDF 2nd STOP FUNCTION SPECIFIC UDFs STOP PROCEDUREs TERM utilities, monitoring TERM UTILITY 2nd TSO WRITE CICS file processing XRST IMS COMMENT ON statement tables Comment UDF audio image video comments DSNTEP2 utility DSNTIAD embedded SQL statements REXX SQL statements tables commit scope. COMMIT statements stored procedures COMMIT statemetns batch programs data customizations 2nd lock timeouts scheduling commits data sharing online applications TSO two-phase CICS 2nd IMS 2nd 3rd common areas virtual storage common table expressions. Common Table Expressions. common threads CICS Communication Database. communications inter-system CF Communications Database. comparison operators IS NOT DISTINCT FROM nulls UDTs comparisons BETWEEN predicate IN predicate LIKE predicate compatibility access paths strategy 2nd claims/drains 2nd 3rd page locks row locks table space locks COMPILE_OPTS column SYSIBM.SYSPSMOPTS table compiling programs complex SQL statements application programs complex statements guidelines Cartesian products clustered columns columns order 2nd columns, grouping denormalization exception reporting existence tests 2nd explicit inner joins explicit outer joins flexibility IN lists duplicates IN lists, ordering indexed columns join rows join table limits 2nd 3rd joins 2nd joins vs subqueries 2nd left outer joins multi-row fetches outer join nulls 2nd outer join predicates 2nd predicate transitive closure 2nd result sets, limiting 2nd row expressions 2nd rows, counting scalar fullselects search criteria sorting joins subqueries subquery negation logic table expressions 2nd 3rd 4th 5th 6th Top Ten 2nd unions 2nd compliance names COMPRESS parameter table spaces third-party solutions 2nd 3rd compressing columns data data warehouses image copies COPY utility PLAN TABLEs table spaces advantages disadvantages third-party solutions 2nd compression disaster recovery planning DSN1COMP utility Compression Analyzer utility. compression dictionaries compression tools 2nd CompressType UDF video Computer Associates computer-aided software engineering. ComputerWorld (ital) Compuware Corporation COMTHREADLIMIT parameter CICS command thread attributes CONCAT function concentrators (connection) concurrency BACKUP SYSTEM utility COPY utility 2nd COPYTOCOPY utility LOAD utility 2nd MERGECOPY utility online applications QUIESCE utility REBUILD INDEX utility RECOVER utility REORG utility RESTORE SYSTEM utility RUNSTATS utility STOSPACE utility UNLOAD utility concurrent copies recovering concurrent copying concurrent packages estimating concurrent plans estimating concurrent users conditional table access CICS CONNECT statement CONNECTERROR parameter CICS connection attributes connecting DB2 2nd connection attributes DB2CONN parameter 2nd connection concentrators CONNECTION parameter SSMs connection pooling 2nd connection pools inactive threads 2nd connections application-directed distribution establishing releasing 2nd Net.Data type-2 consistency stored procedures UDFs utilities 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 consistency tokens BIND statements consistent authids consistent image copies recovering console messages performance monitoring 2nd 3rd 4th BCT plan BINDCT plan locking contention log offloading resource unavailable timeouts constants UDTs 2nd constraints check checking 2nd data warehouses column data type changes informational referential referential AQR 2nd specifying constratins informational referential checking Contains UDF text Content Manager Content UDF audio image video XML extenders ContentA UDF audio image video contention monitoring throughput contentsion utilities 2nd 3rd continuous block fetches 2nd 3rd control cards utilities 2nd control statements EXEC SQL 2nd 3rd 4th cursor-driven SELECT statements issuing 2nd non-SELECT dynamic statements LISTDEF LOAD creating OPTIONS OFF keyword PREVIEW keyword TEMPLATE controls access row-level MLS conversation managers. conversational applications conversions data LOAD utility CONVLIMIT parameter coordinators (parallelism) COPY jobs copy pending flags correcting repairing COPY utility 2nd 3rd backups CHANGELIMIT parameter 2nd 3rd concurrency 2nd data/index synchronization DFSMS disks dual image copies full image copies small table spaces full image copy JCL image copies, compressing incremental image copy JCL incremental/full image copies, balancing index copy JCL indexes 2nd locking 2nd logs, suspending performance phases recovery points recovery time restarting RI- related objects, copying sequential prefetch SYSCOPY data set, allocating 2nd SYSCOPY data set, buffering SYSIBM.SYSCOPY table system page placement COPYCHANGES column INDEXSPACESTATS table TABLESPACESTATS table copying concurrent disaster recovery plans indexes COPY utility PCBs RI-related objects COPYLASTTIME column INDEXSPACESTATS table TABLESPACESTATS table COPYTOCOPY utility 2nd concurrency inline copies JCL example locking phases running 2nd 3rd COPYUPDATEDPAGES column INDEXSPACESTATS table TABLESPACESTATS table COPYUPDATELRSN column INDEXSPACESTATS table TABLESPACESTATS table COPYUPDATETIME column INDEXSPACESTATS table TABLESPACESTATS table core functionality utilities 2nd correlated columns correlated subqueries 2nd 3rd CORRELATION NAME column PLAN TABLE COS function COSH function CoSORT COST CATEGORY column DSN STATEMENT TABLE cost estimates DSN STATEMENT TABLE 2nd columns 2nd 3rd creating version 8 cost estimations EXPLAIN feature costs CPU optimizer I/O optimizer COUNT function 2nd COUNT_BIG function Coupling Facility Resource Management. Coupling Facility. CPU and Elapsed Time (long accounting report) 2nd 3rd CPU costs optimizer CPU parallelism CPUs query CP parallelism tuning 2nd 3rd 4th 5th CRC parameter SSMs CREATE GLOBAL TEMPORARY TABLE statement CREATE INDEX statement CREATE INDEX statemetn CREATE LOB TABLESPACE statements CREATE PROCEDURE statement CREATE TABLE statement AUDIT clause CREATE TRIGGER DDL statement 2nd 3rd 4th 5th 6th activation events, selecting examples 2nd 3rd granularity logic SQL statements tables, defining transition variables 2nd WHEN clause created temporary tables 2nd advantages CREATOR column PLAN TABLE critical columns critical masses 2nd critical programs resident, creating Cross Access Corp. cross-posting newsgroups Cross-system Coupling Facility. Crystal Decisions CSECTs CTEs 2nd column names cyclic references recursion 2nd Version 8 CTEs (common table expressions) CTEs (Common Table Expressions) CTHREAD paraemter CURRENT keyword scrollable cursors CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION register CURRENT PACKAGE PATH special register CURRENT REFRESH AGE register CURRENTCOPYONLY parameter CURRENTDATA parameter 2nd CURRENTSERVER parameter cursor-driven SELECT statements cursors ambiguous application programs avoiding block fetches ambiguous FOR READ ONLY/FOR FETCH ONLY clauses non-updateable read-only closing closing points column updates commands data customizations 2nd 3rd declaring defining distributed client/server applications host variables, initializing non-updatable ODBC opening 2nd positioning, saving processing 2nd read-only access repositioning batch programs online browsing 2nd resources, releasing results table data, returning results tables data, returning;cursors tables;results;data, returning row retrieval rows, deleting rowset positioning 2nd data customizations multiple rows, adding scrollable 2nd 3rd asensitive declared temporary tables dynamic 2nd 3rd insensitive keywords pseudo-conversational CICS programs result set navigation sensitive static 2nd types 2nd Version 7 enhancements 2nd warnings stability unambiguous UPDATE/DELETE statements updating Customer Information Control System. customizing access dynamic SQL 2nd access paths Catalog statistics column data types 2nd 3rd 4th impact 2nd 3rd limitations data 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 databases. DB2 Catalog columns indexes 2nd clustering 2nd columns, adding 2nd system parameters on the fly table space partitioning 2nd 3rd 4th adding partitions 2nd boundaries rebalancing partitions 2nd rotating partitions 2nd variable character columns variable index keys 2nd customizing data data integrity INSERT statements LOAD utility vs INSERT statements multiple rows, adding primary keys UPDATE/DELETE statements cyclic references CTEs cylinder allocations table space storage allocation
|
| < Day Day Up > |