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]
S-locks Sagent Technology, Inc. sample applications DSNTEP2 2nd 3rd batch environment comments error handling input data sets rerunning return codes DSNTIAD 2nd 3rd comments DDL error handling executing authority JCL preparations rerunning return codes DSNTIAUL 2nd 3rd data movement JCL LOCK TABLE statement maximum unloads preparations return codes SQL statemetns SYSREC data sests unloaded flat files views, unloading WHERE/ORDER BY clauses sample databases SAMPLE parameter UNLOAD utility sample programs SQL stored procedures, creating 2nd sample table spaces sample tables activity DDL department 2nd employee 2nd employee assignment employee photo & resume 2nd project 2nd project activity 2nd storage group views 2nd 3rd sample views 2nd 3rd sampling RUNSTATS utility SamplingRate UDF audio video sargable processing SAS Institute Inc. savepoints external batch programs 2nd SAVEPOINTs Version 7 enhancements 2nd saving cursor positions scalar fullselects scalar functions 2nd ABS ABSVAL ACOS ADD_MONTHS ASIN ATAN ATAN2 ATANH BLOB CCSID_ENCODING CEIL CEILING CHAR CLOB COALESCE CONCAT COS COSH DATE DAY DAYOFMONTH DAYOFWEEK DAYOFWEEK_ISO DAYS DBCLOB DEC DECIMAL DECRYPT_BIT DECRYPT_CHAR DECRYPT_DB DEGREES DIGITS DOUBLE ENCRYPT_TDES EXP FLOAT FLOOR GENERATE_UNIQUE GETHINT GETVARIABLE GRAPHIC GREATEST HEX HOUR IDENTITY_VAL_LOCAL IFNULL INSERT INT INTEGER JULIAN_DAY LAST_DAY LCASE LEAST LEFT LENGTH LN LOCATE LOG LOG10 LOWER LTRIM MAX MICROSECOND MIDNIGHT_SECONDS MIN MINUTE MOD MONTH MULTIPLY_ALT NEXT_DAY NULLIF POSSTR POWER QUARTER RADIANS RAND REAL REPEAT REPLACE RIGHT ROUND ROUND_TIMESTAMP ROWID RTRIM SECOND SIGN SIN SINH SMALLINT SPACE SQRT STRIP SUBSTR TAN TANH TIME TIMESTAMP TIMESTAMP_FORMAT TRANSLATE TRUNC TRUNC_TIMESTAMP TRUNCATE UCASE UPPER VALUE VARCHAR VARCHAR_FORMAT VARGRAPHIC WEEK WEEK_ISO WHERE clauses scalar user -defined functions scalpel disaster recovery strategy 2nd 3rd 4th 5th scans access path strategies 2nd 3rd limited partition partitioned tablespace segmented tablespace tablespace 2nd index matching 2nd non-matching 2nd indexes avoiding scheduling COMMIT statements DSN1CHKR RUNSTATS utility SCHEMA class privileges SCHEMA column SYSIBM.SYSPSMOPTS table Schema Evolution Version 8 SCHEMA_NAME column DSN_FUNCTION_TABLE table schemas Procedural DBA snowflake star data warehouses 2nd 3rd tables duplicating UDFs 2nd schemes encoding table spaces 2nd tables unloaded data SCOPE parameter LOB references SCOPE PENDING option REORG utility SCOPE PENDING parameter CHECK DATA utility Scratch Pad Areas. SCRATCHPAD clause scratchpads screening indexes scrollable cursors 2nd 3rd asensitive declared temporary tables dynamic 2nd 3rd insensitive 2nd keywords pseudo-conversational CICS programs result set navigation static 2nd types 2nd Version 7 enhancements 2nd warnings SCT01 table space SCT02 table 2nd search criteria joins search engines Internet Search_Result UDF text SEC tools 2nd SECLABEL session variable SECLABELs comparing SECOND function second normal form second timestamp unit secondary authids 2nd secondary indexes partitioned Version 8 secondary space allocations indexes secondary storage table spaces 2nd 3rd 4th 5th calculating cylinder allocations data type lengths 2nd default values segmented table spaces SECQTY parameter 0 option table spaces 2nd 3rd 4th 5th calculating cylinder allocations data type lengths 2nd default values segmented table spaces security administration authorization applications 2nd automatic security BINDAGENT authority built-in groupings DELETE/UPDATE/INSERT authorities dynamic authorities external 2nd grants 2nd group authorities group-level multilevel security 2nd packages plans proliferation avoidance rule public access 2nd public display authority re-creating REFERENCES privilege restricted userids secondary authids 2nd synonyms SYSADM authority, restricting SYSADM authority, revoking SYSCTRL authority SYSIBM.SYSDUMMY1 table automatic CICS database DB2 2nd DCE distributed data authid translations 2nd come-from checking PUBLIC AT ALL LOCATIONS parameter encryption DB2 data 2nd userids/passwords environment control commands extenders 2nd guide implementing views index-only access 2nd Kerberos LOAD utility multi-index access 2nd multi-level Version 8 multilevel 2nd multilevel. Net.Data packages plans privileges granting 2nd revoking resource privileges row level MLS session variables 2nd user-created special registers 2nd stored procedures 2nd tables UDFs UNLOAD utility views 2nd write down security label columns SECURITY parameter UDFs security tools 2nd SECURITY UDF characteristic segmented table spaces 2nd 3rd MQTs multiple tables, defining 2nd space search algorithm storing segmented tablespace scans SEGSIZE parameter table spaces SEGUS Inc. SELECT authority SYSIBM.SYSDUMMY1 table SELECT statement ORDER BY clause 2nd selection/projection SELECT statements application programs base table views existence, checking 2nd fixed-list SELECT dynamic SQL 2nd flexibility listing parameter markers 2nd prepared statements SQLDA fixed-list SELECT dynamic SQL SELECT dynamic SQL FOR READ ONLY clause FOR UPDATE OF clause host variables 2nd MQTs nesting 2nd 3rd non-SELECT dynamic singleton 2nd overhead, reducing varying-list varying-list SELECT dynamic SQL 2nd 3rd 4th 5th listing minimal SQLDA SQLDA 2nd SQLTYPE values 2nd selecting access paths 2nd 3rd rows 2nd selection SQL selection priorities self-referencing constraints 2nd sensitive scrollable cursors sequence authority query sequence objects 2nd 3rd SEQUENCE objects sequence objects creating identity columns, compared 2nd SEQUENCE objects navigational queries sequence objects parameters performance rows/columns sequences Version 8 2nd sequencing columns/rows 2nd rows sequential detection 2nd sequential number assignments sequential plans sequential prefetch COPY utility sequential prefetches access path strategies 2nd 3rd bufferpools 2nd CPU costs dynamic processing sequential detection skip sequential prefetch static sequential values online applications serializing resources claims 2nd claims/drains compatibility 2nd 3rd drains 2nd 3rd servers location aliases OLAP service level agreements. service level management. service levels services precompiler servlets (Java) session DSN terminating session variables 2nd DATA_SHARING_GROUP_NAME PACKAGE_NAME PACKAGE_SCHEMA PACKAGE_VERSION PLAN_NAME SECLABEL SYSTEM_ASCII_CCSID SYSTEM_EBCDIC_CCSID SYSTEM_NAME SYSTEM_UNICODE_CCSID user-created VERSION sessions QMF SET command QMF SET ENCRYPTION PASSWORD statement SET LOG SUSPEND command disaster recovery 2nd SET NULL option referential constraints SET SYSPARM command set-level processing SQL 2nd 3rd 4th SGML (Standard Generalized Markup Language) shadow copies DB2 Catalog shared read only data. sharing data administration. advantages 2nd application support applications attachment interfaces binding CF. commits DCL DDL groups 2nd IMMEDWRITE parameter lock avoidance locks, minimizing naming conventions 2nd 3rd Parallel Sysplex pre-existing subystems requirements 2nd 3rd Sysplex 2nd sysplex parallelism tuning Version 7 enhancements IRLMs SHDDEST RCT INIT macro parameter Sheryl M. Larsen, Inc. Web site short accounting reports 2nd 3rd 4th Short Record Trace report short statistics report 2nd 3rd 4th SHRLEVEL CHANGE image copies SHRLEVEL CHANGE parameter REORG INDEX utility REORG TABLESPACE utility REORG utility 2nd SHRLEVEL NONE parameter REORG INDEX utility REORG TABLESPACE utility SHRLEVEL parameter REORG utility SHRLEVEL REFERENCE clause offsite copies SHRLEVEL REFERENCE parameter COPY utility REORG INDEX utility REORG TABLESPACE utility RUNSTATS utility shutdowns member speeding up SIGN function SIGNID parameter DB2CONN parameter SIGNID RCT INIT macro parameter simple data transformations data warehouses, populating simple statements guidelines access paths, customizing analysis tools arithmetic expressions 2nd 3rd automatic rebinds BETWEEN predicate built-in functions 2nd column expressions 2nd data sharing auto rebind data, limiting date and time arithmetic 2nd decimal precision/scale distributed query blocks dummy tables duplicate rows, deleting 2nd embedded SQL, pretesting equivalent data types 2nd EXPLAIN command 2nd FOR READ ONLY clause function tables host variables 2nd IN predicate index access, disabling indexability indexed columns isolation levels LIKE predicate list prefetch, disabling NOT keyword, avoiding ordering columns ordering rows partition key ranges PLAN_TABLE columns 2nd predicate sequence 2nd predicate stages 2nd 3rd predicates, reducing 2nd queries, limiting 2nd 3rd query tweaks renaming columns rows, returning rows, selecting 2nd scalar functions SQL Assist statement tables updates, serializing Visual Explain 2nd simple table spaces 2nd SIN function single table spaces singleton SELECT statements 2nd overhead, reducing SINH function sites. size active logs application programs minimimzing BSDS, expanding buffer pools tuning 2nd 3rd CICS applications 2nd collections data set partitions 2nd data sharing group buffer pools DB2 Catalog DBDs reducing EDM pools 2nd 3rd index data sets 2nd 3rd locks log output buffer package lists pages denormalization table spaces 2nd partitioned table spaces 2nd SYSPRINT block size DSNTEP2 utility DSNTIAD utility SYSUT2 data set Size UDF audio image video sizes data set pages SKCTs (skeleton cursor tables) skeleton cursor tables. skip sequential prefetches SLAs (service level agreements) sledgehammer disaster recovery strategy 2nd SLM (service level management) SMALLINT columns SMALLINT data type Java promotability SMALLINT function SmartDBA SMS (System Managed Storage) 2nd partitioned table spaces 2nd SNAP RCT INIT macro parameter snapshot tables 2nd snapshots data warehouses, populating snowflake schema Softbase Systems Inc. sort buffer pools sort I/O tuning 2nd sort pools tuning 2nd sort work spaces DFSORT utility SORTC GROUP column PLAN TABLE SORTC JOIN column PLAN TABLE SORTC ORDERBY column PLAN TABLE SORTC PGROUP ID column PLAN TABLE SORTC UNIQ column PLAN TABLE SORTDEVT parameter 2nd sorting data 2nd online SORTKEYS keyword SORTKEYS parameter REORG utility SORTN GROUPBY column PLAN TABLE SORTN JOIN column PLAN TABLE SORTN ORDERBY column PLAN TABLE SORTN PGROUP ID column PLAN TABLE SORTN UNIQ column PLAN TABLE SORTNUM parameter 2nd SORTWKxx DD statement SOURCE UDF characteristic sourced functions 2nd UDTs 2nd SOURCEDSN column SYSIBM.SYSPSMOPTS table sources applications modified SPACE column INDEXSPACESTATS table TABLESPACESTATS table SPACE function space map pages 2nd 3rd SPACE option TEMPLATE statement space search algorithm non-segmented table spaces segmented table spaces SPACENAM parameter buffer pools spams Internet SPAs IMS SPAs (Scratch Pad Areas) SPAS (stored procedure address space) SPAS (Stored Procedure Address Spaces) SPB (Stored Procedure Builder) SPEC_FUNC_NAME column DSN_FUNCTION_TABLE table special registers AQR 2nd CURRENT PACKAGE PATH special registers (security) 2nd SPECIAL REGISTERS UDF characteristic SPECIFIC UDF characteristic speed tables hierarchies 2nd split tables base table views 2nd denormalization 2nd SPT01 table SPT02 table space SPUFI command SPUFI option (DB2I) 2nd 3rd (SQL Processor Using File Input) defaults input data set 2nd SPUFI Defaults panel SPUFI panel SPUFI optoion (DB2I) 2nd SQ requests consolidating SQL 2nd (Structured Query Language) 3VL 2nd access paths ad hoc analyzing Procedural DBA Cartesian products 2nd 3rd CASE expressions 2nd 3rd CICS clauses GROUP BY HAVING 2nd 3rd ORDER BY WHEN WHERE 2nd COBOL, compared 2nd complex statement 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 7th Top Ten 2nd unions 2nd CTEs 2nd column names cyclic references recursion 2nd data customizations changed columns, updating column updates columns, listing DELETE statements FOR UPDATE OF clause generated values, retrieving indexed columns, updating large insertions long columns mass DELETE multiple rows, adding row updates self-referencing DELETE statements self-referencing sub-SELECT statements UPDATE statements date and time addition table built-in options data types 2nd dates/non-dates combination durations 2nd non-standard dates 2nd total number of days DB2 objects ALIAS COLUMN DATABASE defining 2nd hierarchy INDEX native data types 2nd security 2nd STOGROUP SYNONYM TABLE TABLESPACE VIEW debugging Procedural DBA dynamic 2nd 3rd access, customizing 2nd advantages/disadvantages avoiding bind-time authorization checking classes designs dynamic data, accessing EXECUTE IMMEDIATE statement EXECUTE IMMEDIATE statement. fixed-list SELECT 2nd 3rd 4th flexibility governing JDBC maintenance design non-SELECT 2nd non-SELECT. non-uniform data overvivew 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 varying-list SELECT statements embedded 4GL applications application programs 2nd 3rd application programs. ODBC applications pretesting embedded. equivalent functionality existential functions column scalar system-defined user-defined grouping data 2nd IBM reserved words 2nd joins 2nd 3rd 4th 5th criteria data retrieval listing INNER keyword JOIN keyword outer. subqueries, compared 2nd table limits three-table keywords JOIN native SQL only applications nulls avoiding database design equivalency IS NOT DISTINCT FROM comparison operator IS NULL predicate performance access path selection 2nd 3rd optimizer optimizer. performance guide planned procedural Procedural DBA 2nd projection recursion data knowledge duplicate output rows necessity for stopping 2nd reducing in Java relational division 2nd reoptimizing reserved words 2nd rewriting Procedural DBA selection set-level processing 2nd 3rd 4th simple statement guidelines , limiting access paths, customizing analysis tools arithmetic expressions 2nd 3rd automatic rebinds BETWEEN predicate built-in functions 2nd column expressions 2nd data sharing auto rebind data, limiting date and time arithmetic 2nd decimal precision/scale distributed query blocks dummy tables duplicate rows, deleting 2nd embedded SQL, pretesting equivalent data types 2nd EXPLAIN command 2nd FOR READ ONLY clause function tables host variables 2nd IN predicate index access, disabling indexability indexed columns isolation levels LIKE predicate list prefetch, disabling NOT keyword, avoiding ordering columns ordering rows partition key ranges PLAN_TABLE columns 2nd predicate sequence 2nd predicate stages 2nd 3rd predicates, reducing 2nd queries, limiting 2nd query tweaks renaming columns rows, returning rows, selecting 2nd scalar functions SQL Assist statement tables updates, serializing Visual Explain 2nd sorting data 2nd statements dynamism execution types existence functionality writing statements. 2nd static 2nd 3rd dynamic SQL, compared packages reoptimization stored procedures 2nd 3rd 4th 5th advantages 2nd bodies 2nd creating 2nd creating with catalog 2nd 3rd creating with DSNTPSMP creating with JCL 2nd creating with sample programs 2nd developing disadvantages 2nd example 2nd executing external stored procedures, compared subqueries 2nd 3rd correlated joins, compared 2nd non-correlated UDF options 2nd 3rd unions 2nd unqualified SQL activity (long accounting report) 2nd 3rd SQL Assist 2nd Version 7 enhancements SQL Communication Area. SQL Long Trace report SQL procedure processor. SQL Processor Using File Input. SQL result sets distribution performance SQL Short Trace report SQL system limits Verison 8 SQL trace report sets 2nd 3rd SQL Trace Summary report 2nd SQLABC field (SQLCA) SQLCA application programs 2nd 3rd fields 2nd 3rd stored procedures SQLCA (SQL Communication Area) SQLCAID field (SQLCA) SQLCODE field (SQLCA) SQLCODE statement application programs 2nd SQLCODEs SQLSTATEs, compared SQLDA fixed-list SELECT minimal varying-list SELECT dynamic SQL varying-list SELECT dynamic SQL 2nd SQLERRD field (SQLCA) SQLERRM field (SQLCA) SQLERROR parameter SQLError() function ODBC SQLERRP field (SQLCA) SQLJ code fragment program preparation SQLSTATE field (SQLCA) SQLSTATEs SQLCODEs, compared SQLTYPE field values varying-list SELECT dynamic SQL 2nd SQLWARN0 field (SQLCA) SQLWARN1 field (SQLCA) SQLWARN2 field (SQLCA) SQLWARN3 field (SQLCA) SQLWARN4 field (SQLCA) SQLWARN5 field (SQLCA) SQLWARN6 field (SQLCA) SQLWARN7 field (SQLCA) SQLWARN8 field (SQLCA) SQLWARN9 field (SQLCA) SQLWARNA field (SQLCA) SQRT function SRM z/OS SRM (Systems Resource Manager) SROD Version 6 2nd SROD (shared read only data) SSAS (System Services Address Space) SSMs parameters 2nd SSMs (subsystem member) SSN parameter SSMs SSR (/ before) command stability cursors reads stable data RI, avoiding STACK option TEMPLATE statement Stage 1 predicates 2nd 3rd Stage 1 processing Stage 2 predicates 2nd 3rd Stage 2 processing stand-alone utilities 2nd DSN1CHKR 2nd integrity verification JCL read-only mode scheduling table spaces DSN1COMP compression, planning DSSIZE parameter JCL PAGESIZE parameter parameters prefixes DSN1COPY 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 active logs JCL output reports DSN1PRNT 2nd 3rd errors JCL LOB table spaces page sizes PAGESIZE parameter running DSN1SDMP 2nd data sets JCL user authority DSNJLOGF 2nd JCL listing timestamps DSNJU003 2nd 3rd CCSID information data sharing JCL listing RESTORE SYSTEM utility combination running standard deviation Standard Generalized Markup Language. standard libraries maintenance standard methods optimizer, influencing 2nd 3rd 4th 5th standards (DB2 implementation) application development guide data administration 2nd database administration guide design review 2nd 3rd 4th phase five phase four phase one phase seven phase six phase three phase two migrations/turnovers naming conventions 2nd QMF guide roles/responsibilities 2nd 3rd security guide SQL performance guide system administration guide vendor tools guide STANDBY RCT INIT macro parameter STANDBYMODE parameter DB2CONN parameter star joins 2nd star schema data warehouses 2nd 3rd START (/ before) command START command UDFs START DATABASE command 2nd start day timestamp unit START DB2 command START DDF command 2nd START PROCEDURE command 2nd START RLIMIT command START TRACE command 2nd STARTBR command CICS file processing starting DB2 PM report traces 2nd 3rd RLSTs stored procedures traces UDFs 2nd 3rd 4th 5th 6th Starware Software statement tables statement-level triggers statements ALTER TABLE ADD PART parameter query rewrites ALTER TABLE ALTER PART ROTATE FIRST TO LAST ALTER TABLE ALTER PART VALUES base table views BIND ACTION parameter CACHESIZE parameter collections DBRMs, retaining default parameters dirty reads 2nd 3rd 4th dynamic reoptimization DYNAMICRULES parameter 2nd 3rd ENABLE/DISABLE parameters 2nd errors explicit consistency tokens IMMEDWRITE parameter initial administration isolation levels kplans like programs, grouping lock avoidance mirror tables multiple qualified tables OPTHINT parameter packages 2nd packages, creating parallelism 2nd PATH paraemter prepared statements production BNDs QUALIFIER parameter read stability reoptimization reoptimzation, isolating repeatable reads 2nd 3rd RETAIN parameter statistics (current) table space locking 2nd validation wildcard package lists block style coding 2nd 3rd CALL stored procedures CLOSE cursors 2nd code literals COMMENT ON tables comments COMMIT batch programs 2nd 3rd 4th stored procedures complex application prorams CONNECT CREATE GLOBAL TEMPORARY TABLE CREATE INDEX 2nd CREATE LOB TABLESPACE CREATE PROCEDURE CREATE TABLE AUDIT clause CREATE TRIGGER DDL 2nd 3rd 4th 5th 6th activation events, selecting examples 2nd 3rd granularity logic SQL statements tables, defining transition variables 2nd WHEN clause DCLGEN break apart columns 2nd DCLGEN libraries DCLGEN members 2nd field name PREFIX host variables, prefixing unqualified table references DECLARE cursors DECLARE CURSOR FOR UPDATE OF clause order DECLARE GLOBAL TEMPORARY TABLE DECLARE TABLE DELETE cursor controlled cursors mass self-referencing DESCRIBE PROCEDURE dynamic stored procedures dynamic SQL, avoiding EXEC SQL control 2nd 3rd 4th cursor-driven SELECT statements issuing 2nd non-SELECT dynamic statements EXECUTE IMMEDIATE 2nd host variables non-SELECT dynamic SQL, compared one-time processing syntax FETCH cursors host variables FREE LOCATOR GETDIAGNOSTICS application programs 2nd 3rd 4th 5th combined information condition information 2nd connection information 2nd statement information 2nd GRANT privileges 2nd HOLD LOCATOR INSERT base table views columns, listing LOAD utility, compared multiple rows set-level processing invalidating RUNSTATS utility LISTDEF database object lists 2nd 3rd 4th database object lists, previewing example 2nd indexes list expansion 2nd LIST keyword 2nd LOBs 2nd RI parameter RUNSTATS utility utilities wildcards 2nd LOAD control creating LOCK TABLE 2nd DSNTIAUL utility OPEN cursors optimizer OPTIONS control OFF keyword PREVIEW keyword prepared caching 2nd 3rd holding past COMMIT non-SELECT dynamic SQL REFRESH TABLE MQTs REVOKE privileges ROLLBACK stored procedures SELECT application programs existence, checking 2nd fixed-list 2nd 3rd fixed-list SELECT dynamic SQL FOR READ ONLY statements FOR UPDATE OF clause host variables 2nd MQTs non-SELECT dynamic ORDER BY clause 2nd singleton 2nd 3rd varying-list varying-list SELECT dynamic SQL 2nd 3rd 4th 5th SET ENCRPTION PASSWORD SORTWKxx DD SQL dynamism execution types existence functionality REXX procedures writing SQL Assist SQLCODE application programs 2nd static stored procedures sub-SELECT self-referencing TEMPLATE data sets, allocating 2nd database object lists disk options 2nd examples 2nd names options 2nd symbolics 2nd tape options utilities UNION UDTs 2nd UPDATE cursor controlled cursors VALUES triggers WHENEVER application programs 2nd statements (SQL) DSNTIAUL utility dynamic 2nd performance analysis EXPLAIN feature 2nd 3rd SELECT nesting 2nd 3rd selection/projection simple guidelines. static 2nd triggers tweaking optimizer, influencing 2nd 3rd states exception online schema changes pending correcting 2nd 3rd pending flags reasons for 2nd STATIC DISPATCH UDF characteristic STATIC parameter scrollable cursors 2nd static scrollable cursors 2nd static sequential prefetches static SQL 2nd 3rd dynamic SQL, compared packages reoptimization static SQL statements stored procedures statistics access paths 2nd column data type changes column/column group gathering 2nd DB2 Catalog 2nd 3rd 4th 5th 6th 7th 8th column cardinality filter factors first key cardinality HIGH2KEY/LOW2KEY 2nd inner/outer tables maintnenace optimizing 2nd 3rd relationships RUNSTATS SYSADMs 2nd troublesome queries unclustered indexes updateable 2nd 3rd 4th updating values DBAs 2nd 3rd EXPLAIN feature gathering LOAD utility historical gathering 2nd indexes inline gathering 2nd 3rd 4th 5th list of objects gathering nonuniform distribution deleting 2nd partition-level RUNSTATS utility partitions queries 2nd physical index queries physical tablespaces query Real Time. reports RUNSTATS utility table spaces UDF monitoring value gathering STATISTICS keyword LOAD utility statistics report sets 2nd 3rd EDM pools locking log management short 2nd 3rd 4th Statistics Short report 2nd 3rd 4th statistics traces 2nd STATSDELETES column INDEXSPACESTATS table TABLESPACESTATS table STATSINSERTS column INDEXSPACESTATS table TABLESPACESTATS table STATSLASTTIME column INDEXSPACESTATS table TABLESPACESTATS table STATSMASSDELETE column INDEXSPACESTATS table TABLESPACESTATS table STATSQUEUE parameter DB2CONN parameter STATSTIME column STATSUPDATES column TABLESPACESTATS table statuses GRECP LPL STAY RESIDENT parameter STAY RESIDENT UDF characteristic STDDEV function stealing buffer pools STMT ENCODE column DSN STATEMENT TABLE STMT TYPE column DSN STATEMENT TABLE STOGROUP DB2 object STOGROUP function STOGROUP sample table STOGROUP-defined data sets moving REORG utility STOGROUPs. STOP (/ before) command STOP command 2nd STOP DATABASE command STOP DB2 command STOP DDF command 2nd STOP FUNCTION SPECIFIC command UDFs STOP PROCEDURE command stopping stored procedures 2nd UDFs 2nd 3rd 4th 5th 6th storage 4GL applications EDM pools, moving extended frequently used data indexes 2nd physical limits 2nd 3rd real Type 2 indexes 2nd 3rd virtual common areas private areas virtual. storage areas EDM pools storage group table storage groups 2nd buffer pools default defining 2nd 3rd disk volumes names navigational queries SMS 2nd partitioned table spaces 2nd user-defined VSAM data sets 2nd 3rd volumes, assigning STORCLAS option TEMPLATE statement stored procedure address space. Stored Procedure Address Space. Stored Procedure Builder. 2nd stored procedures 2nd application programs atomic parameters built-in 2nd calling 2nd client/server applications CODE/370 language collection IDs column names, returning consistency creating 2nd parameter lists, configuring 2nd data integrity data types DB2 Development Center 2nd DBMS protection developing LE/370 language nested procedure calls 2nd parameters 2nd program preparations result sets, returning 2nd 3rd DSNACCOR 2nd executing 2nd 3rd 4th external SQL stored procedures, compared failures, controlling flexibility identical input parameters implementing 2nd 3rd IMS databases, accessing internal DBA tools LE/370 language learning LONG VARCHAR/LONG VARGRAPHIC parameters maintenance managing 2nd monitoring 2nd names nesting Net.Data PARAMETER STYLE options performance reentrant registration Version 6 2nd resident reuseability 2nd security security, implementing SPB 2nd SQL. SQLCA starting static/dynamic SQL statements stopping 2nd 3rd subprograms temporary tables 2nd triggers, compared WLM 2nd 3rd stored proceduress failures, controlling storing declared temporary tables 2nd indexes metadata package information plan information table spaces 2nd 3rd primary storage 2nd 3rd 4th 5th secondary storage 2nd 3rd 4th 5th triggers STOSPACE utility 2nd 3rd concurrency DASD usage DB2 Catalog updates JCL generation JCL listing locking phases running strategies access paths compatibility 2nd indexed access 2nd 3rd 4th 5th 6th joins 2nd 3rd 4th 5th 6th 7th 8th 9th joins. query parallelism 2nd 3rd 4th 5th 6th scans 2nd 3rd sequential prefetch 2nd 3rd streams reorganization jobs 2nd STRIP function Striva Corporation strong typing UDTs 2nd 3rd STRTWT RCT INIT macro parameter structural limits 2nd 3rd 4th structure indexes 2nd Structured Query Language. structures cach databases DB2 Family differences DB2 Catalog 2nd 3rd host 2nd application programs list lock locking specifying sub-SELECT statements self-referencing SUBID RCT INIT macro parameter subprograms stored procedures subqueries access paths 2nd 3rd 4th correlated 2nd inside-out subquery access non-correlated outside-in-outside subquery access view materialization 2nd view merge joins, compared 2nd multiple table data retrieval negation logic SQL 2nd 3rd correlated joins, compared 2nd non-correlated subscribing mailing lists 2nd SUBSTR function subsystem tuning buffer pool parameters buffer pool parameters. buffer pool size 2nd 3rd buffer pools 2nd 3rd 4th 5th 6th 7th 8th data sharing group buffer pools 2nd 3rd 4th 5th DB2 Catalog 2nd 3rd 4th DSNZPARMs 2nd 3rd 4th 5th 6th 7th 8th 9th hiperpools 2nd 3rd 4th 5th IRLM address space 2nd subsystem IDs CICS subsystem members. subsystem size buffer pool size subsystems data sharing availability pre-exisiting merging into data sharing SUFFIX RCT INIT macro parameter suites Operational Utilities Recover and Diagnostics SUM function summarization data transformations data warehouses, populating summary report sets 2nd support education 2nd 3rd advanced topics external training in-house training industry periodicals 2nd 3rd 4th introductory courses (DB2) mailing lists on-site library reference material environmental operational 2nd tools required support tables XML administration 2nd backing up DTD repository table 2nd XML usage table 2nd surrogate keys rows/columns suspending locks logs swappable jobs Sybase Corporation symbolic cursors. synchronization CICS data/indexes COPY utility synchronizing DB2 Catalog reorganization 2nd views 2nd syncpoint coordinator syncpoint trees synonym columns SYNONYM DB2 object synonyms 2nd authorizations built-in functions 2nd listing navigational queries names SYSADM authority restricting revoking SYSADM group-level authorization SYSADM utility Catalog statistics, customizing SYSADMs DB2 Catalog statistics 2nd SYSAUXRELS table SYSCHECKDEP table SYSCHECKS table SYSCHECKS2 table SYSCOLAUTH table 2nd SYSCOLDIST table 2nd 3rd SYSCOLDIST_HIST table SYSCOLDISTSTATS table 2nd SYSCOLSTATS table 2nd SYSCOLUMNS table 2nd 3rd SYSCOLUMNS_HIST table SYSCONSTDEP table SYSCOPY data set allocating 2nd buffering MERGECOPY utility 2nd SYSCOPY queries QMF forms SYSCOPY table SYSCOPY table space SYSCTRL authority SYSCTRL group-level authorization SYSDATABASE table SYSDATATYPES table SYSDBASE table space SYSDBAUT table space SYSDBAUTH table SYSDBRM table SYSDDF table space SYSDEFLT parameter SYSDISC data sets space requirements SYSDUMMY1 table SYSFIELDS table SYSFOREIGNKEYS table SYSGEN IMS PROCLIM parameter read-only transactions transaction modes WFI transactions SYSGPAUT table space SYSGROUP table space SYSGRTNS table space SYSIBM.SYSCOPY table ICTYPE column SYSIBM.SYSDUMMY1 table access granting SYSIBM.SYSPSM table SQL stored procedures, creating SYSIBM.SYSPSMOPTS table SQL stored procedures, creating 2nd SYSINDEXES table 2nd 3rd SYSINDEXES_HIST table SYSINDEXPART table 2nd 3rd SYSINDEXPART_HIST table SYSINDEXSTATS table 2nd SYSINDEXSTATS_HIST table SYSJARCLASS_SOURCE table SYSJARCONTENTS table SYSJARDATA table SYSJAROBJECTS table SYSJAVA table space SYSKEYCOLUSE table SYSKEYS table SYSLGRNX table SYSLGRNX table space SYSLINKS table SYSLOBSTATS table 2nd SYSLOBSTATS_HIST table SYSLOCATIONS table SYSLULIST table SYSLUMODES table SYSLUNAMES table SYSMAP data sets SYSMODESELECT table SYSOBJ table space SYSOPR group-level authorization SYSPACKAGE table SYSPACKAUTH table SYSPACKDEP table SYSPACKLIST table SYSPACKSTMT table SYSPARMS table SYSPKAGE table space SYSPKSYSTEM table SYSPLAN table SYSPLAN table space SYSPLANDEP table Sysplex distributed access requests query Sysplex parallelism 2nd sysplex parallelism dat sharing SYSPLSYSTEM table SYSPRINT block size DSNTEP2 utility DSNTIAD utility SYSPROCEDURES table SYSREC data sets synchronizing SYSRELS table SYSRESAUTH table SYSROUTINEAUTH table SYSROUTINES table 2nd 3rd SYSROUTINES_OPTS table SYSROUTINES_SRC table SYSSEQ2 table space SYSSEQUENCEAUTH table SYSSEQUENCES table SYSSEQUENCESDEP table SYSSTATS table space SYSSTMT table SYSSTOGROUP table SYSSTR table space SYSSTRINGS table SYSSYNONYMS table SYSTABAUTH table SYSTABCONST table SYSTABLEPART table 2nd SYSTABLEPART_HIST table SYSTABLES table 2nd 3rd SYSTABLES_HIST table SYSTABLESPACE table 2nd 3rd SYSTABSTATS table 2nd 3rd SYSTABSTATS_HIST table system administration guide backing up BACKUP SYSTEM utility 2nd 3rd 4th 5th restoring RESTORE SYSTEM utility 2nd 3rd 4th SYSTEM class privileges system databases QUIESCE utility system indexes reorganizing System Managed Storage. system of records system pages placement COPY utility system parameters customizing on the fly dynamic system parameters report sets 2nd 3rd system parameters. System Services Address Space. system table spaces recovering system testing CASE tools support system-defined functions system-directed distribution 2nd application-directed distribution, compared three-part names 2nd SYSTEM_ASCII_CCSID session variable SYSTEM_EBCDIC_CCSID session variable SYSTEM_NAME session variable SYSTEM_UNICODE_CCSID session variable systematic rebinding packages systems MVS monitoring 2nd read-only RI systems analysts Systems Resource Manager. SYSTRIGGERS table SYSUSER table space SYSUSERAUTH table SYSUSERNAMES table SYSUT1 data set MERGECOPY utility 2nd 3rd SYSUT1 data sets REBUILD INDEX utility SYSUT2 data set size SYSUTILX table space SYSVIEWDEP table SYSVIEWS table SYSVIEWS table space SYSVLTREE table SYSVOLUMES table SYSVTREE table SYSXLAT file DSN1COPY utility
|
| < Day Day Up > |