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

package cache 2nd
package cache.
     Routine Authorization cache [See also EDM Statement cache]
package caches
     access plans
packages
     owner
     privileges
    runtime environment
         zSeries security 2nd
PARAMETER CCSID clause 2nd 3rd 4th 5th
parameter marker
parameter markers
parameters
     CREATE PROCEDURE statement 2nd 3rd 4th 5th
     names
partitioned table spaces
passwords
     DC projects 2nd
PCTFREE clause
     CREATE /ALTER TABLESPACE statements
PCTFREE statements
     tables
performance
    best practices
         CASE versus IF, ELSE statements 2nd 3rd
         DETERMINISTIC versus NOT DETERMINISTIC keywords 2nd 3rd 4th
         dynamic SQL for DDL 2nd 3rd 4th 5th
         exception handling
         functions 2nd
         locks 2nd 3rd 4th
         repeated statements
         SET statements for value assignment 2nd
         single INSERT statements 2nd
         table truncation
Performance Expert (DB2) 2nd 3rd
     Buffer Pool Analyzer
Performance Monitor (DB2)
performance monitoring/tuning 2nd 3rd
     Automatic Maintenance 2nd 3rd 4th
     Configuration Advisor 2nd 3rd
     DB2 Performance Expert 2nd 3rd
     Design Advisor 2nd
     direct I/O operations
     EDM Statement cache 2nd
     memory usage monitoring
     Navigator 2nd 3rd
     package cache 2nd
     PRTSQLINF command 2nd 3rd 4th
    query optimizer and access plans
         Visual Explain tool 2nd 3rd 4th 5th 6th 7th
     resource measurement facility 2nd
     Routine Authorization cache
     Statement Event Monitor 2nd 3rd 4th 5th 6th
     Statistics Manager 2nd 3rd
     stored procedures 2nd
         distributed environments
     STRDBMON and ENDDBMON commands 2nd 3rd
     temporary tables 2nd 3rd 4th 5th
         indexes 2nd
     variable length columns and large objects
     Visual Explain tool 2nd 3rd
         zSeries
performance tuning educational resources 2nd
periodicals as resources 2nd
PL/SQL (Oracle's procedural language)
placeholders for variables
     parameter markers
plan caches
     access plans
positioned deletes 2nd 3rd 4th 5th
positioned updates 2nd 3rd 4th 5th
positioned updates and deletes
precompile options
     iSeries 2nd 3rd
PREDICATES clause
     CREATE FUNCTION statements
PREPARE statement
     not supported in inline SQL PL 2nd
PREPARE statements
     SQL statement phases 2nd
         dynamic and static SQL 2nd
     versus EXECUTE IMMEDIATE statements 2nd 3rd 4th 5th 6th 7th
PREVIOUS VALUE expression
     sequence objects 2nd 3rd
PREVVAL expression
     sequence objects
privileges
     package objects
    required for stored procedures
         in production environment
         iSeries developers 2nd 3rd
         iSeries users 2nd
         LUW developers 2nd
         LUW users 2nd 3rd
         zSeries developers 2nd
         zSeries users
     sequence objects 2nd
procedure owners
procedure. [See stored procedures]
PRODINST 2nd
profile registries
     configuring 2nd 3rd 4th 5th 6th
PROGRAM TYPE clause
programming code
    best practices
         exception handling 2nd 3rd
         grouping SQL procedures by schema
         naming conventions 2nd
         readability 2nd
         size
         transaction controls
Project view (Development Center) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
projects (Development Center) 2nd
     connections 2nd 3rd 4th 5th 6th
     creating 2nd
    nested procedures
         breakpoints 2nd 3rd
         debugging 2nd
         stepping through code 2nd
     Project view 2nd
     Server view
     stored procedures 2nd 3rd 4th 5th
         breakpoints 2nd 3rd 4th
         debugging 2nd 3rd
         run settings 2nd 3rd
         running 2nd 3rd 4th 5th
         running procedures
         stepping through code 2nd 3rd
     user IDs and passwords 2nd
     views 2nd 3rd
PRTSQLINF command
     performance monitoring 2nd 3rd 4th
PUT ROUTINE command
    deploying
         SQL procedures 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
PUT_ROUTINE_SAR() procedure