Understanding DB2: Learning Visually with Examples (2nd Edition)

Index

[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] [Z]

Packages

     creating     definition 2nd     description     privileges 2nd     querying paths

Page cleaners

Page cleaning buffer pools Page overflow 2nd Pages 2nd

Parallelism Parameter markers Parameter names

Parameters

    configuring instances [See configuration parameters]

    database configuration [See configuration parameters]

Parent keys Parent rows

Parent tables

Partition groups     classifications     creating 2nd     default

     definition 2nd 3rd

     description 2nd 3rd

     DPF environment 2nd

     dropping

     listing 2nd

     modifying

     multipartition

     singlepartition

partitioned database option 2nd

Partitioned databases

Partitioning databases [See DPF (database partitioning feature]

Partitioning keys 2nd 3rd

Partitioning map indexes

Partitioning maps 2nd 3rd

Partitions

    active, determining [See DB2NODE]     case study     catalog

     coordinator

     definition 2nd     description 2nd 3rd 4th 5th

     dropping

     instances in multipartitioned environments     logical 2nd 3rd 4th 5th 6th

     multipartition databases 2nd 3rd     singlepartition databases 2nd 3rd

Paths Pattern searches 2nd PC version of Integrated Exchange Format (PC/IXF) PC version of IXF (PC/IXF) format PC/IXF (PC version of Integrated Exchange Format)

PC/IXF (PC version of IXF) format

PDE (DB2 Personal Developer's Edition) 2nd PE (Personal Edition) 2nd Percent sign (%), wildcard

Performance    access plans [See Configuration Advisor, configuring]    case study [See Configuration Advisor, configuring]

    CPU requirements [See Configuration Advisor, configuring]

    disk requirements [See Configuration Advisor, configuring]

    Event Monitor [See Configuration Advisor, configuring]

    explain tables [See Configuration Advisor, configuring]    explain tool [See Configuration Advisor, configuring]

    I/O requirements [See Configuration Advisor, configuring]

    load utility [See Configuration Advisor, configuring]    loading table data [See Configuration Advisor, configuring]    maintenance requirements [See Configuration Advisor, configuring]    memory requirements [See Configuration Advisor, configuring]

    monitoring [See Configuration Advisor, configuring, monitoring, Monitoring;tools for]

    optimizer [See Configuration Advisor, configuring]

    overview [See Configuration Advisor, configuring]

    package cache [See Configuration Advisor, configuring]

    reorganizing table data [See Configuration Advisor, configuring]

    REORGCHK utility [See Configuration Advisor, configuring]

    RUNSTATS utility [See Configuration Advisor, configuring]

    Snapshot Monitor [See Configuration Advisor, configuring]

    snapshots [See Configuration Advisor, configuring]

    statistics gathering [See Configuration Advisor, configuring]

    system/server configuration [See Configuration Advisor, configuring]

    Visual Explain [See Configuration Advisor, configuring]

Perrequest EDUs 2nd 3rd 4th 5th

Personal Edition (PE) 2nd

Phantom reads

Phantom rows PIT (point in time) recovery 2nd Plugins

Plus sign (+), turning off CLP options

Point in time (PIT) recovery 2nd Pointers 2nd

Points of consistency

Populated page 2nd Port number, getting

Pound sign (#), comment delimiter 2nd 3rd 4th Precision

precompile command 2nd 3rd Predicate Prefetch queue Prefetching 2nd 3rd Prepare

Prepared SQL statement

PREVIOUS VALUE FOR statement, uses for PREVVAL FOR statement, uses for Primary databases

PRIMARY KEY clause 2nd 3rd Primary key constraints 2nd 3rd Primary keys 2nd 3rd 4th

Primary log files 2nd 3rd

Primary logs

Principal

Priority page 2nd Private memory

Privileges

     definition     storing and retrieving 2nd 3rd 4th 5th 6th     Windows 2nd 3rdProcedures [See stored procedures]

Processes

    agents

        active subagents [See EDUs (engine dispatchable units]

        associated (idle) subagents [See EDUs (engine dispatchable units]

        case study [See EDUs (engine dispatchable units]

        coordinator agents [See EDUs (engine dispatchable units]

        monitoring and tuning [See EDUs (engine dispatchable units]

        unassociated subagents [See EDUs (engine dispatchable units]

    case study [See EDUs (engine dispatchable units]

    common executables [See EDUs (engine dispatchable units]

    connection concentrator [See EDUs (engine dispatchable units]

    EDUs [See EDUs (engine dispatchable units]

    EDUs (engine dispatchable units)

        active subagents [See EDUs (engine dispatchable units]

        application-level [See EDUs (engine dispatchable units]

        associated (idle) subagents [See EDUs (engine dispatchable units]        coordinator agents [See EDUs (engine dispatchable units]        database-level [See EDUs (engine dispatchable units]

        instance-level [See EDUs (engine dispatchable units]

        overview [See EDUs (engine dispatchable units]        perrequest [See EDUs (engine dispatchable units]

        processes [See EDUs (engine dispatchable units]

        threads [See EDUs (engine dispatchable units]        tuning [See EDUs (engine dispatchable units]

        unassociated subagents [See EDUs (engine dispatchable units]    FCM (Fast Communication Manager) [See EDUs (engine dispatchable units]

    listeners [See EDUs (engine dispatchable units]    monitoring agents [See EDUs (engine dispatchable units]    overview [See EDUs (engine dispatchable units]    page cleaners [See EDUs (engine dispatchable units]    prefetch queue [See EDUs (engine dispatchable units]

    prefetching [See EDUs (engine dispatchable units]

    tuning        agents [See EDUs (engine dispatchable units]        EDUs [See EDUs (engine dispatchable units]

    Windows [See EDUs (engine dispatchable units]Profile registry     overview 2nd

     registry variables 2nd 3rd

     setting variables

     viewing variables

Program fixes (FixPaks) 2nd 3rd 4th Program updates (FixPaks) 2nd 3rd 4th

Project Deployment Tool 2nd 3rd

Propagating data to servers 2nd Pseudo deleted Public authorityPublications [See books and publications]

Категории