index_P

 <  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  >    


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net