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]
A-marks abbreviation standards columns /rows ABEND command abends UDFs ABS function ABSOLUTE keyword scrollable cursors absolute positioning. ABSVAL function access buffer pools isolating clustered batch programs conditional table CICS customizing dynamic SQL 2nd direct row access 2nd index-only 2nd indexed 2nd 3rd 4th 5th 6th clustered index access direct index lookups index lookasides index scans index screening index-only access list prefetches 2nd matching index scans 2nd multi-indexes 2nd non-clustered index access non-matching index scans 2nd skip sequential prefetches indexes disabling multi-index 2nd public granting 2nd read-only cursors SYSIBM.SYSDUMMY1 table views access controls row-level MLS ACCESS DEGREE column PLAN TABLE access methods XML collection column DAD files access paths application tuning 2nd 3rd 4th 5th customizing MQTs OPTHINT parameter PLAN TABLE examples PLAN TABLE, populating 2nd 3rd 4th PLAN TABLEs efficiency reviewing/analyzing Procedural DBA selecting optimizer selection 2nd 3rd statistics 2nd strategies 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 strategy compatibility 2nd subqueries 2nd 3rd 4th correlated 2nd inside-out subquery access non-correlated outside-in-outside subquery access view materialization 2nd view merge ACCESS PGROUP ID column PLAN TABLE ACCESSCREATOR column PLAN TABLE accessing data warehouses DB2 data (Internet) Java Net.Data 2nd 3rd 4th network traffic software versions distributed data application-directed 2nd 3rd 4th methods, comparing system-directed 2nd 3rd 4th dynamic data dynamic SQL IMS databases stored procedures Internet LOB data non-DB2 resources triggers ACCESSNAME column PLAN TABLE ACCESSTYPE column PLAN TABLE accounting records CICS accounting report sets 2nd 3rd 4th 5th 6th long buffer pool information 2nd 3rd 4th CPU and Elapsed Time 2nd 3rd database code usage information highlights 2nd 3rd locking activity 2nd miscellaneous information 2nd 3rd package/DBRM information 2nd program status RID list processing SQL activity 2nd 3rd short 2nd 3rd 4th traces accounting traces 2nd 3rd 4th ACCOUNTREC parameter CICS pool thread attributes CICS thread operation attributes accuracy RTS ACENDATE column ACOS function ACQUIRE parameter EDM pools, tuning table space locks ACS (Automatic Class Selection) ACSTDATE column ACTION clause stored procedures ACTION parameter BIND statements activating triggers active buffer pools converting active databases active logs DSN1LOGP RECOVER utility active objects viewing ACTIVE parameter DISPLAY DATABASE command active traces maximum active users tuning DSNZPARMs activity checking RTS activity table DDL actual commit (two-phase commit distribution) 2nd ad hoc SQL ADD PART parameter ALTER TABLE statements add-on tools auditing 2nd 3rd Catalog query and analysis 2nd categories 2nd 3rd client/server compression 2nd DASD and space management data movement 2nd database analysis 2nd database modeling and design 2nd integrity 2nd Internet enabling miscellaneous object migration operational support 2nd PC-based performance enhancements performance monitors 2nd plan analysis 2nd programming and development QMF enhancements query 2nd 3rd repositories 2nd security 2nd table editors 2nd talbe altering 2nd 3rd utility enhancement ADD_MONTHS function adding columns base table views 2nd 3rd indexes 2nd multiple rows rowset positioning cursr objects database object lists 2nd partitions table spaces 2nd address spaces DBAS BM DM RDS DDFS dispatching priority IRLM non-swappable SPAS SSAS administration application development guide data standards/procedures 2nd data sharing 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, archiving LPL page recovery member shutdowns multiple coupling facilities naming conventions restart light row-level locking subsystem availability databases guide initial binds ODBC applications packages production/test application coexistence systematic rebinding version maintenance 2nd responsibilities 2nd 3rd roles 2nd 3rd security security guide system guide XML 2nd support tables 2nd 3rd XML Extender administrative commands 2nd 3rd 4th active traces ALTER BUFFERPOOL ALTER UTILITY ARCHIVE LOG 2nd RECOVER INDOUBT START DATABASE 2nd START PROCEDURE START RLIMIT START TRACE 2nd START/STOP STOP STOP DATABASE system parameters TERM UTILITY 2nd Advanced Program-to-Program Communication. advanced training topics Advisor (ital) Advisory Rebuild Pending exception state Advisory Reorg exception state AEY9 bends avoiding AFTER keyword scrollable cursors after triggers 2nd aggregation data transformations data warehouses, populating algorithms buffer pools FIFO buffer pools LRU buffer pools page stealing space search non-segmented table spaces segmented table spaces ALIAS DB2 object aliases 2nd databases listing navigational queries location names AlignValue UDF audio video ALLOCATE parameter table space locks allocating buffer pools 2nd 3rd data sets data sets. ALT tools 2nd 3rd ALTER BUFFERPOOL command 2nd ALTER TABLE ALTER PART ROTATE FIRST TO LAST statement ALTER TABLE ALTER PART VALUES statement ALTER TABLE statement ADD PART parameter query rewrites ALTER UTILITY command ALWAYS parameter rows/columns Ambeo Systems ambiguous cursors 2nd analysis tools SQL statements Aonix APIs DBaAdminGetInaccessibleFiles APPC (Advanced Program-to-Program Communication) appending data LOAD utility applets (Java) 2nd Net.Data application efficiency queries 2nd 3rd application I/O tuning 2nd 3rd application joins data retrieval listing 2nd application programs active databases black boxes 2nd code literals complex SQL statements cursors developing embedded SQL 2nd 3rd comments DB2 tables, declaring delimiting statements error codes error trapping statement 2nd error-handling paragraph 2nd 3rd flat files, compared 2nd GET DIAGNOSTICS statement 2nd 3rd 4th 5th names 2nd 3rd SQLCA 2nd 3rd SQLCODE statement 2nd types filtering data host structures host variable lists, simulating isolation levels joins 2nd modular programs non-relational data, joining read-only access row sequencing rows, retrieving sample programs scrollable cursors SELECT statements size , minimizing stored procedures unqualified SQL user -defined functions application requesters (AR) function application server (AS) function Application Server Edition (DB2 Connect) application supoort data sharing application-directed distribution connections establishing releasing 2nd system-directed distribution, compared application-enforced referential integrity applications 4GLs data extraction embedded SQL join tables performance storage formats strengths training weaknesses authorizations 2nd batch IMS TSO 2nd 3rd 4th batch message processor IMS binding DB2 Connect CAF sample CASE tools 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 classes 2nd client/server complex environment DB2 connections 2nd distributed cursors SQL anomalies SQL requests , consolidating stored procedures tools documentation triggers conversational data sharing DB2I 2nd bind option DB2 Commands option DCLGEN option Defaults option Free Plan option menu precompile option Program Preparation option rebind option Run option SPUFI option 2nd 3rd 4th 5th Utilities option DDL design reviews Procedural DBA development enhancements DB2 Version 7 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th development guide DSN8DLPL DSN9DLRV DSNTEP2 IMS 2nd IMS/TM online 2nd Java like, grouping link-editing language interface modules LOB sample non-critical DSN1COPY recovery strategy ODBC 2nd 3rd 4th administration COMMIT/ROLLBACK cursors DRDA, compared embedded SQL parameter markers portability restrictions return codes sample code 2nd SQLError() function online cascading delete rule commits concurrency, increasing cursor repositioning 2nd data sorting direct row access 2nd empty tables joins, limiting list prefetch, disabling modifications, saving overactive data 2nd pages retrieved sequential values timestamps transactions TSO 2nd 3rd 4th 5th 6th 7th 8th precompiling binding, avoiding DBRM libraries DBRM names DBRMs, retaining decimal precision requirements versioning program preparation background jobs batch procedures 2nd BIND command 2nd CICS preprocessors CLIST compiling DB2I 2nd 3rd 4th DCLGEN command 2nd 3rd 4th 5th default names goals linking programs multiple methods 2nd 3rd 4th 5th 6th objects 2nd precompiling 2nd 3rd REXX EXEC pseudo-conversational report writers 2nd capabilities REXX 2nd comments data types host variables null SQL statements running 2nd sample DSNTEP2 2nd 3rd 4th 5th 6th 7th 8th DSNTIAD 2nd 3rd DSNTIAUL 2nd 3rd sources SQL only developed domains, simulating 2nd 3rd integrity native SQL tuning 2nd 3rd access paths 2nd 3rd 4th 5th nonuniform distribution statistics, deleting 2nd optimizer, influencing. referential integrity 2nd 3rd APPLNAME column DSN STATEMENT TABLE DSN_FUNCTION_TABLE table PLAN TABLE AQR (automatic query rewrite) 2nd DDL queries supported 2nd query rewrites referential constraints 2nd refreshes special registers 2nd AR (application requester) function architecture Version 8 2nd architectures DRDA APPC CDRA DDM FD( colon )OCA ARCHIVE LOG command 2nd disaster recovery archive logs RECOVER utility archives mailing lists archiving data REORG utility 2nd disaster recovery logs arithmetic date and time 2nd dates/non-dates combinations arithmetic expressions 2nd 3rd column renaming columns 2nd date and time 2nd decimal precision/scale MULTIPLY_ALT two numbers AS (application server) function Ascential Software ASCII support asensitive scrollable cursors ASG Software Solutions ASIN function AspectRatio UDF video assignments multiple buffer pools assistants parallelims ASTs. ASUTIME [NO] LIMIT UDF characteristic ASUTIME column RLSTs ATAN function ATAN2 function ATANH function athorities DSNTIAD execution atomic parameters stored procedures Attach Facility availability 2nd CICS 2nd 3rd 4th IMS 2nd 3rd Attachment Facility (TSO) attachment interfaces data sharing attributes columns MQTs 2nd command thread DB2CONN parameter 2nd connection DB2CONN parameter 2nd pool thread DB2CONN parameter 2nd 3rd thread operation DB2ENTRY parameter 2nd thread selection DB2ENTRY parameter AUD tools 2nd 3rd AUDIT ALL parameter tables AUDIT CHANGES parameter tables AUDIT clause AUDIT NONE parameter tables audit report sets 2nd 3rd Audit Summary report audit trace audit traces 2nd 3rd 4th auditable tables auditing tables auditing tools 2nd 3rd AUTH COMD macro parameter AUTH ENTRY macro parameter AUTH POOL macro parameter AUTHID column RLSTs AUTHID parameter CICS pool thread attributes CICS thread operation attributes authids secondary 2nd translating 2nd consistent authids network specific authids password encryption authorites public display grannting SYSCTRL authorities BINDAGENT DELETE restricting dynamic group INSERT restricting SELECT SYSIBM.SYSDUMMY1 table SYSADM restricting revoking UPDATE restricting user DSN1SDMP utility authorization applications 2nd automatic security bind-time checking BINDAGENT authority built-in groupings DELETE/UPDATE/INSERT authorities dynamic authorities external 2nd grants 2nd group authorities group-level multilevel security 2nd package caching packages plan caching plans proliferation avoidance rule public access 2nd public display authority re-creating REFERENCES privilege restricted userids secondary authids 2nd synonyms SYSADM authority restricting revoking SYSCTRL authority SYSIBM.SYSDUMMY1 table authorization cache EDM pools authorization errors authorization queries 2nd 3rd authorizations group-level RACF CICS AUTHTYPE parameter CICS pool thread attributes CICS thread operation attributes Automatic Class Selection. automatic query rewrite. automatic summary tables. automatic versions names automating data transformations 2nd AUXERROR parameter LOB references auxiliary tables creating indexes names navigational queries availability throughput average package size query average plan size query AVG function avoidance (locks) 2nd 3rd occurences 2nd
|
| < Day Day Up > |