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]
P-locks PACKADM group -level authorization package authorization caching query package authority query PACKAGE class privileges package dependency queries PACKAGE_NAME session variable PACKAGE_SCHEMA session variable PACKAGE_VERSION session variable packages administrative issues production/test applications coexistence systematic rebinding version maintenance 2nd authorizations average size query benefits 2nd 3rd BIND lock parameters BIND statements binding DB2I collection identifiers collections 2nd 3rd CURRENT PACKAGE PATH special register multiple package list size size concurrent query creating DB2 Connect 2nd ASE EE 2nd 3rd 4th PE 2nd UE DB2 Connect EE DB2 Connect PE DE defined ESE executing freeing DB2I IBM utility 2nd 3rd information, storing location identifiers long accounting reports information 2nd mirror table support names 2nd 3rd 4th Operational Utilities operational utilities PDE PE performance 2nd plans, compared production EXPLAIN feature rebinding DB2I recover & diagnostic utilities Recover and Diagnostics security static SQL triggers 2nd utilities Version 7 enhancements utilities suite version maintenance 2nd versioning 2nd 3rd wildcard lists WSE WSUE padded indexes PADDED parameter padded variable length indexes Version 8 PADIX parameter page locking (repeatable reads) PAGE RANGE column PLAN TABLE page sets linear partitioned page stealing algorithm buffer pools pages buffer pools available stealing algorithm unavailable data index index. LOB table spaces 2nd data sets 2nd dictionary far off header I/O retrieval index data type 1 2nd 3rd 4th index data pages type 1 leaf 2nd 3rd type 1 non-leaf indexes 2nd leaf 2nd Type 2 indexes LOB 2nd locks 2nd 3rd 4th 5th 6th 7th compatibility row locks, compared 2nd LPL recovery map LOB space modified table spaces near off non-leaf 2nd Type 1 indexes Type 2 indexes retrieving limiting root 2nd size table spaces 2nd sizes denormalization space map 2nd system placement VSAM data sets 2nd PAGESAVE column PAGESIZE parameter DSN1COMP utility DSN1COPY utility DSN1PRNT utility paging paging I/O tuning 2nd 3rd panels DB2I Commands Defaults Free Package Free Plan Rebind Package Rebind Plan Run SPUFI SPUFI Defaults ISFP TSO QMF Form Home Proc Query Report Rebind Package paragraphs executing parallel disabling parallel joins query parallelism 2nd 3rd hybrid joins merge scan joins nested loop joins PARALLEL parameter RECOVER utiliity parallel plans parallel processing batch programs 2nd 3rd parallel queries 2nd 3rd parallel restorations RECOVER utility Parallel Sysplex parallelism assistants coordinators CPU data warehouses degrees dynamic SQL I/O query 2nd 3rd 4th 5th 6th 7th CP I/O parallel joins 2nd 3rd parallel plans restrictions 2nd sequential plans Sysplex 2nd sysplex data sharing PARALLELISM MODE column PLAN TABLE parallism sysplex parameter IMMEDWRITE binding PARAMETER CCSID UDF characteristic parameter markers dynamic SQL fixed-list SELECT 2nd non-SELECT dynamic SQL 2nd ODBC PARAMETER STYLE options stored procedures PARAMETER STYLE parameter PARAMETER STYLE UDF characteristic parameters ACCOUNTREC CICS pool thread attributes CICS thread operation attributes ACQUIRE EDM pools table space locks ACTION BIND statements ACTIVE DISPLAY DATABASE command ADD PART ALTER TABLE ALLOCATE table space locks ALWAYS rows/ columns AUDIT ALL tables AUDIT CHANGES tables AUDIT NONE tables AUTHID CICS pool thread attributes CICS thread operation attributes AUTHTYPE CICS pool thread attributes CICS thread operation attributes AUXERROR LOB references BIND pages/rows locks 2nd 3rd 4th table space locks bind default BIND package locks BIND plan locks buffer pool tuning 2nd DWQT PGSTEAL VDWQT VPSEQT 2nd 3rd 4th 5th 6th VPSIZE VTYPE BUFFERPOOL table spaces 2nd 3rd 4th BUFND DSN1COPY BUFNO MERGECOPY utility utilities BY DEFAULT rows/columns CACHESIZE BIND command BIND statements CASTOUT member shutdowns CASTOWNR buffer pools CCSID DSNJU003 utility table spaces 2nd tables CHANGELIMIT COPY utility 2nd 3rd CHARDEL CHKFREQ CLOSE table spaces 2nd 3rd COLDEL COLLID stored procedures COMAUTHID CICS command thread attributes COMAUTHTYPE CICS command thread attributes COMPRESS table spaces 2nd 3rd 4th COMTHREADLIMIT CICS command thread attributes CONNECTERROR CICS connection attributes CONNECTION SSMs CONVLIMIT CRC SSMs CTHREAD CURRENTCOPYONLY CURRENTDATA 2nd CURRENTSERVER DATA CAPTURE tables DATA INITIALLY DEFERRED databases 2nd DSNDB04 parameter DB2ID CICS connection attributes DBNAME buffer pools DEADLOCK IRLM address space DECPT DEFER CREATE INDEX statement DEFINE index data sets DEFINE NO index data sets DELAY DELETE MODIFY STATISTICS utility 2nd DELETE YES CHECK DATA utility DESCRIPTION CICS connection attributes DESCSTAT DETAIL DISPLAY BUFFERPOOL command DETERMINISTIC UDFs DISABLE BIND statements 2nd DISABLE PARALLEL DISABLE QUERY OPTIMIZATION DISCONNECT application-directed distribution DROLLBACK CICS pool thread attributes CICS thread operation attributes DROP REPAIR DBD utility tables DSN1COMP utility DSNDB04 DSNUTILB DSNZPARM lock escalation table spaces 2nd DSSIZE DSN1COMP utility DSN1COPY parameter partitioned table spaces table spaces DWQT buffer pools DYNAMIC scrollable cursors 2nd DYNAMICRULES BIND statements 2nd 3rd ENABLE BIND statements 2nd ENABLE QUERY OPTIMIZATION ERASE table spaces ERR SSMs ESMT SSMs EXCEPTIONS CHECK LOB utility EXCLUDING COLUMN DEFAULTS FREEPAGE table spaces 2nd 3rd FREQVAL RUNSTATS utility GBPCACHE GBPDEP buffer pools GENERATED identity columns GROUP DSN commands hiperpool tuning 2nd HISTORY RUNSTATS utility 2nd HPSEQT HPSIZE IDBACK 2nd identical input stored procedures UDFs IDFORE 2nd IMMEDWRITE data sharing IN CREATE PROCEDURE statement INCLUDING COLUMN DEFAULTS INDEXBP INDREFLIMIT REORG utility INOUT CREATE PROCEDURE statement IRLM locks ISOLATION data sharing locks dirty reads 2nd 3rd 4th 5th 6th page/row locks 2nd 3rd 4th ITRACE IRLM address space KEEPDICTIONARY LOAD utility REORG utility KEYCARD RUNSTATS utility LARGE table spaces 2nd 3rd LEAFDISTLIMIT REORG utility LIGHT LIMIT information-gathering commands UNLOAD utility LIST buffer pool infomration LIT SSMs LOAD utility LOCKMAX table space locks table spaces LOCKMAX 0 table spaces LOCKPART table spaces LOCKSIZE table spaces 2nd 3rd LOCKSIZE ANY LOCKSIZE ROW table spaces LOG YES REPAIR DBD utility REPAIR LOCATE utility LOGAPSTG LONG VARGRAPHIC stored procedures LSTATS buffer pool information MAINTAINED BY SYSTEM MAINTAINED BY USER MAXDBAT MAXROWS table spaces MAXROWS 1 table spaces MEMBER CLUSTER table spaces MODE FORCE option MSGQUEUE1 CICS connection attributes MSGQUEUE2 CICS connection attributes MSGQUEUE3 CICS connection attributes NO COLLID stored procedures NONTERMREL CICS connection attributes NOT DETERMINISTIC UDFs NOT PADDED null input UDFs NUMLKTS NUMLKUS NUMPARTS table spaces OBID tables OFFPOSLIMIT REORG utility online REORGs DEADLINE DELAY LONGLOG MAXRO 2nd OPTHINT access paths OUT CREATE PROCEDURE statement OVERVIEW DISPLAY command PADDED PADIX PAGESIZE DSN1COMP utility DSN1COPY utility DSN1PRNT utility PARALLEL RECOVER utility PARAMETER STYLE PARTKEYU PATH BIND statements PC IRLM address space PCTFREE growth rate formula table spaces 2nd 3rd performance-oriented PGSTEAL buffer pools PLAN CICS pool thread attributes CICS thread operation attributes SSMs PLANEXITNAME CICS pool thread attributes CICS thread operation attributes PRIORITY CICS pool thread attributes CICS thread operation attributes PRIQTY table spaces 2nd 3rd 4th 5th PRIQTY. PROCLIM IMS SYSGEN PROGRAM SSMs PROTECTNUM CICS thread operation attributes PUBLIC AT ALL LOCATIONS PURGECYCLE CICS connection attributes QUALIFIER BIND statements RCT AUTH values COMD macro 2nd 3rd ENTRY macro 2nd 3rd 4th example 2nd INIT macro 2nd 3rd 4th POOL macro 2nd RDO DB2CONN 2nd 3rd 4th 5th 6th 7th 8th DB2ENTRY 2nd 3rd 4th DB2TRAN 2nd wildcarding REBUILD REPAIR DBD utility REFRESH DEFERRED REOPT RESTRICT DISPLAY DATABASE command RESULT_SETS RETAIN BIND statements RI LISTDEF statements RTT SSMs SAMPLE UNLOAD utility SCOPE LOB references SCOPE PENDING CHECK DATA utility SECQTY 0 option table spaces 2nd 3rd 4th 5th SECURITY UDFs SEGSIZE table spaces sequence objects SHRLEVEL REORG utility SHRLEVEL CHANGE REORG INDEX utility REORG TABLESPACE utility REORG utility 2nd SHRLEVEL NONE REORG INDEX utility REORG TABLESPACE utility SHRLEVEL REFERENCE COPY utility REORG INDEX utility REORG TABLESPACE utility RUNSTATS utility SIGNID CICS connection attributes SORTDEVT 2nd SORTKEYS REORG utility SORTNUM 2nd SPACENAM buffer pools SQLERROR SSMs 2nd SSN SSMs STANDBYMODE CICS connection attributes STATIC scrollable cursors 2nd STATSQUEUE CICS connection attributes STAY RESIDENT stored procedures 2nd configuring 2nd SYSDEFLT system customizing dynamic system. table spaces BUFFERPOOL 2nd 3rd 4th CCSID 2nd CLOSE 2nd 3rd COMPRESS 2nd 3rd 4th DSNZPARM 2nd DSSIZE ERASE FREEPAGE 2nd 3rd LARGE 2nd 3rd LOCKMAX LOCKMAX 0 LOCKPART LOCKSIZE 2nd 3rd LOCKSIZE ROW MAXROWS MAXROWS 1 MEMBER CLUSTER NUMPARTS PRIQTY 2nd 3rd 4th 5th 6th 7th 8th PRIQTY. SECQTY 2nd 3rd 4th 5th SEGSIZE TRACKMOD USING 2nd 3rd tables AUDIT ALL AUDIT CHANGES AUDIT NONE CCSID DATA CAPTURE DROP OBID TABLESPACESET QUIESCE utility TCBLIMIT CICS connection attributes THRDA THRDM THREADERROR CICS connection attributes THREADLIMIT CICS pool thread attributes CICS thread operation attributes THREADWAIT CICS pool thread attributes CICS thread operation attributes TRACKMOD table spaces TRANSID CICS thread selection attributes TSO 2nd UDFs casting defining not required portability USE DISPLAY DATABASE command USING table spaces 2nd 3rd USING TYPE DEFAULTS UTIMOUT VDWQT buffer pools VERIFY REPAIR LOCATE utility VERSIONS REPAIR utility VPSEQT buffer pools 2nd 3rd 4th 5th 6th VPSIZE buffer pools VTAM distribution performance 2nd VTYPE buffer pools WHEN UNLOAD utility WITH HOLD cursor positioning WITH ROWSET POSITIONING paremters BUFFERPOOL LONG VARCHAR stored procedures PARENT QBLOCKNO column PLAN TABLE parent tables referential constraints navigational queries partial recovery JCL PARTITION column INDEXSPACESTATS table TABLESPACESTATS table partition levels checking indexes checking online utilities QUIESCE utility partition statistics queries 2nd partition-level statistics RUNSTATS utility partitioned indexes 2nd partitioned objects VSAM data sets 2nd partitioned page sets partitioned table spaces 2nd 3rd advantages 2nd 3rd clustering creating DASD volumes data set sizes 2nd disadvantages 2nd distributing indexes large 2nd 3rd maximum size multiple tables, compared 2nd 3rd 4th 5th partition key ranges partition key updates size SMS 2nd table-controlled 2nd three-partition example 2nd 3rd partitioned tablespace scans partitioned tablespaces data sharing group buffer pools partitioning indexes 2nd 3rd table spaces 2nd 3rd 4th adding partitions 2nd boundaires rebalancing partitions 2nd rotating partitions 2nd partitioning indexes 2nd partitioning indexes (not same as partitioned, not the verb) partitioning keys ranges partitioned table spaces updating partitions independence locks 2nd limited scanning loading rebalancing REORG utility Version 8 secondary indexes partitions (tables) key ranges PARTKEYU parameter passwords datasets Version 6 encrypting 2nd PATH column DSN_FUNCTION_TABLE table PATH parameter BIND statements paths access customizing MQTs OPTHINT parameter selection 2nd 3rd access. PC parameter IRLM address space PC tools PC-based tools PCBs copying PCT (Program Control Table) PCTEROP RCT INIT macro parameter PCTFREE parameter DSN1COMP utility growth rate formula table spaces 2nd 3rd PCTPRIME option TEMPLATE statement PDE (UDB Personal Developer •s Edition) PE (UDB Personal Edition) 2nd pending states correcting 2nd 3rd pending flags reasons for 2nd PERCDROP column performance 4GL applications buffer pools CICS plans COPY utility data compression data sharing DB2 Catalog dirty reads distributed environments distribution 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 DPSIs dynamic SQL 2nd dynamic system parameters governing historical statistics IFI improving buffers, maximizing data access, minimizing index scans, avoiding optimization hints index lookaside index only access Java join methods limited partition scanning list prefetch LOAD utility lock avoidance lock escalation MQTs navigational queries operating system exploitation optimizer access path selection 2nd 3rd hints 2nd overview 2nd transitivity 2nd packages 2nd partition independence problems 2nd 3rd 4th queries factors 2nd 3rd query parallelism RDS sorting real-time statistics RECOVER utility REORG utility run time reoptimization sequence objects sequential detection sequential prefetch SQL access path selection 2nd 3rd optimizer optimizer. SQL statements EXPLAIN feature 2nd 3rd Stage 1 processing Stage 2 processing stored procedures table expressions 2nd triggers Version 4 features Version 5 features Version 6 features performance enhancement tools performance groups MVS TSO performance monitoring console messages 2nd 3rd 4th BCT plan BINDCT plan locking contention log offloading resource unavailable timeouts DB2 PM monitoring reference 2nd 3rd report sets 2nd report sets. report traces, starting 2nd 3rd online GUI workstations MainView overview VTAM 2nd overview 2nd resource status, viewing traces 2nd accounting 2nd 3rd 4th audit 2nd 3rd 4th basic statistics, collecting destinations 2nd global 2nd 3rd IFCIDs monitor 2nd 3rd 4th performance 2nd 3rd 4th starting statistics 2nd performance monitors tools 2nd performance traces 2nd 3rd 4th performance-oriented parameters Personal Edition (DB2 Connect) 2nd workstations personnel issues Pervasive Software PGSTEAL parameter buffer pools phases COPYTOCOPY utility phases (design review) 2nd 3rd 4th 5th 6th 7th physical analysis queries 2nd 3rd 4th 5th 6th CASE expression index disk storage index statistics physical characteristics reorganization frequency reorganization indicators SPACE values tablespace DASD tablespace statistics physical objects physical storage limits 2nd 3rd physicl data independence 2nd 3rd PIECESIZE clause 2nd 3rd pivoting tables placement distributed data 2nd plan analysis tools 2nd plan authority query PLAN class privileges plan dependency queries PLAN ENTRY macro parameter PLAN parameter CICS pool thread attributes CICS thread operation attributes SSMs PLAN POOL macro parameter PLAN TABLE access path examples access paths efficiency access paths, populating 2nd 3rd columns 2nd 3rd 4th 5th 6th ACCESS DEGREE ACCESS PGROUP ID ACCESSCREATOR ACCESSNAME ACCESSTYPE APPLNAME BIND TIME COLLID COLUMN FN EVAL CORRELATION 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 PLANNO PREFETCH PRIMARY ACCESSTYPE 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 SORTN UNIQ TABLE DCCSID TABLE ENCODE TABLE MCCSID TABLE SCCSID TABLE TYPE TABNO TIMESTAMP TNAME TSLOCKMODE VERSION WHEN OPTIMIZE compressing indexes missing pieces 2nd optimization hints populating querying 2nd rows, deleting RUNSTATS version 7 version 8 PLAN_NAME session variable PLAN_TABLE columns 2nd PLANEXITNAME parameter CICS pool thread attributes CICS thread operation attributes PLANI RCT INIT macro parameter PLANNAME column RLSTs planned SQL planning DDL execution disaster recovery 2nd 3rd active log sizes application classes 2nd archiving backups compression copying documentation DSN1COPY 2nd 3rd environments 2nd instant copies/restore 2nd normal business return offiste recovery validation offsite copies QMF forms with DBID/PSID/OBID queries RECOVER utility recovery basics requirements 2nd risks scalpel 2nd 3rd 4th 5th SET LOG SUSPEND command 2nd shipping image copies offsite sledgehammer 2nd table spaces testing PLANNO column PLAN TABLE plans authorization caching query authorizations average size query BCT BIND lock parameters BINDCT binding 2nd DB2I cache size CICS design concurrent query creating defined disaster recovery plans synchronizing dynamic selecting 2nd freeing DB2I information, storing managing CICS 2nd names 2nd 3rd 4th 5th packages, compared parallel production binding rebinding DB2I security sequential platforms DB2 Connect supported multiple CASE tools support PLN tools 2nd PLNEXIT ENTRY macro parameter PLNEXIT POOL macro parameter PLNPGME ENTRY macro parameter PLNPGME POOL macro parameter PLNPGMI RCT INIT macro parameter PLNXTR1 RCT INIT macro parameter PLNXTR2 RCT INIT macro parameter PM tools 2nd political issues 2nd 3rd Procedural DBA 2nd POOL macro parameters RCT 2nd AUTH DPMODE PLAN PLNEXIT PLNPGME ROLBE TASKREQ THRDM THRDS TWAIT pool thread attributes DB2CONN parameter 2nd 3rd pool threads CICS 2nd 3rd pooling connection 2nd pools buffer. EDM prepared statements, caching EDM Pool populating data warehouses data transformations 2nd 3rd 4th 5th 6th 7th 8th replication vs propagation snapshots populating LOB data (tables) population MQTs 2nd 3rd portability ODBC applications POSSTR function POWER function PPT (Processing Program Table) 2nd Praxis Interational pre-existing subsystems merging into data sharing pre-joined tables denormalization precompile option (DB2I) Precompile panel (DB2I) PRECOMPILE_OPTS column SYSIBM.SYSPSMOPTS table precompiler services Precompiler Services Version 7 enhancements precompiling binding, avoiding DBRM libraries DBRM names DBRMs, retaining decimal precision programs 2nd 3rd requirements versioning predicate transitive closure 2nd predicate transtitive closure 2nd predicates BETWEEN IN indexability 2nd IS NULL LIKE comparisons host variables 2nd NOT EXISTS NOT IN outer join placement 2nd reducing 2nd redundant avoiding restrictive sequence 2nd stages 2nd 3rd predictive governing RLF 2nd PREFETCH column PLAN TABLE prefetches list 2nd sequential access paths 2nd 3rd bufferpools 2nd CPU costs dynamic processing sequential detection static skip sequential PREFIX field name prefixes DSN1COMP utility DSN1COPY utility prefixing columns 2nd DCLGEN host variables PRELINK_OPTS column SYSIBM.SYSPSMOPTS table preparation phase (two-phase commit distribution) prepared statements caching 2nd 3rd fixed-list SELECT holding past COMMIT non-SELECT dynamic SQL presumed abort protocol PREVIEW keyword OPTIONS control statement previewing database object lists PRF tools PRG tools PRIMARY ACCESSTYPE column PLAN TABLE primary keys indexes rows WHERE clauses primary space allocations indexes primary storage table spaces 2nd 3rd 4th 5th calculating cylinder allocations data type lengths 2nd default values segmented table spaces Princeton SOFTECH Print Log Map utility. PRIOR keyword scrollable cursors PRIORITY parameter CICS pool thread attributes CICS thread operation attributes PRIQTY parameter table spaces 2nd 3rd 4th 5th calculating cylinder allocations data type lengths 2nd default values segmented table spaces privacy Internet private areas virtual storage private protocol distribution converting to DRDA privileges extenders granting 2nd REFERENCES revoking problem resolution logs Procedural DBA political issues 2nd procedural SQL 2nd role 2nd schemas tasks 2nd technical issues 2nd triggers procedural DBAs procedural SQL 2nd 3rd 4th 5th 6th advantages 2nd bodies 2nd creating 2nd catalog 2nd 3rd DSNTPSMP JCL 2nd sample programs 2nd developing disadvantages 2nd example 2nd executing external stored procedures, compared Procedural DBA 2nd PROCEDURENAME column SYSIBM.SYSPSMOPTS table procedures batch program preparation 2nd edit data integrity field data integrity stored 2nd application programs atomic parameters built-in 2nd calling 2nd CODE/370 language column names, returning consistency creating 2nd data integrity data types DB2 Development Center 2nd DBMS protection developing executing 2nd 3rd 4th failures, controlling 2nd flexibility identical input parameters implementing 2nd 3rd IMS databases, accessing internal DBA tools LE/370 language 2nd learning LONG VARCHAR/LONG VARGRAPHIC parameters maintenance managing 2nd monitoring names nesting 2nd 3rd Net.Data ollection IDs parameter lists, configuring 2nd PARAMETER STYLE options parameters 2nd performance program preparations reentrant resident result sets, returning 2nd 3rd reuseability 2nd security SQL. SQLCA starting static/dynamic SQL statements stopping 2nd subprograms temporary tables 2nd WLM 2nd 3rd procedures (DB2 implmenentation) 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 process modeling CASE tools support processes Net.Data flow 2nd processing batch operating environments buffer pools 2nd client/server cursors 2nd distributed multiple buffer pool requirements record-level RID list long accounting reports information sequential prefetches set-level 2nd 3rd utility row-level MLS processing environments Processing Program Table. processors DSN command TSO online applications 2nd PROCLIM parameter IMS SYSGEN PROCMS column DSN STATEMENT TABLE PROCSU column DSN STATEMENT TABLE production BINDs production control production package EXPLAIN feature production plans binding PROGNAME column DSN STATEMENT TABLE DSN_FUNCTION_TABLE table PLAN TABLE Program Control Table. PROGRAM parameter SSMs program preparation background jobs batch procedures 2nd BIND command 2nd CICS 2nd CICS preprocessors CLIST compiling DB2I 2nd 3rd 4th 5th bind panels DCLGEN panel Defaults panel main menu Precompile panel Program Preparation panel Run panel DCLGEN command 2nd 3rd column prefixing 2nd null indicators default names goals Java 2nd linking programs multiple methods 2nd bind CLIST 2nd precompile/compile/link CLIST 2nd objects 2nd precompiling 2nd 3rd REXX EXEC Program Preparation panel (DB2I) program status (long accounting report) PROGRAM TYPE UDF characteristic programmatic RI programmer aid queries 2nd 3rd 4th programmers programming Version 4 features Version 5 features Version 6 features Version 8 2nd 3rd CTEs Java recursion SQL system limits XML programming and development tools programming languages 4GLs. Java applets 2nd applications bytecodes character data columns required defined 2nd dynamic SQL EJBs isolation levels JDBC 2nd 3rd JDBC drivers 2nd JDK JVM performance program preparation 2nd resources result set iterators 2nd servlets SMALLINT data type SQL, reducing SQLJ 2nd 3rd REXX 2nd comments data types host variables null SQL statements SGML UDFs 2nd XML. programming techniques (Net.Data) programs batch clustered access COMMIT statements 2nd 3rd cursor repositioning deadlocks external savepoints 2nd LOCK TABLE command lock timeouts locking parallel processing 2nd 3rd restarting 2nd 3rd 4th 5th units of work 2nd CICS cloning critical resident, creating impact names 2nd 3rd resident project activity table 2nd project table 2nd projection SQL proliferation avoiding proliferation avoidance rule Prolifics promotability data types 2nd promoting locks Prompted Query propagation data warehouses protected threads transacations PROTECTNUM parameter CICS thread operation attributes protocols limited block presumed abort prototyping CASE tools support pseudo close VSAM data sets pseudo-conversational applications pseudo-conversational CICS programs scrollable cursors pseudo-deletes PSID column INDEXSPACESTATS table TABLESPACESTATS table PSID queries QMF forms public access granting 2nd PUBLIC AT ALL LOCATIONS parameter public display authority granting publishing functions (XML) PURGEC RCT INIT macro parameter PURGECYCLE parameter DB2CONN parameter purging data data warehouses pyramid (data warehouses)
|
| < Day Day Up > |