P

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 3rd
Procedures [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 authority
Publications [See books and publications]