|
Components
of DB2
 The 4 Address Spaces
Data Manager and RDS
Plans & Packages in EDM Pool
Sort and RID Pool Sizing
Creating Databases & Tablespaces
DBD Design Considerations
Analysis of
Tablespace Param.
Appropriate Use of Free Space
Locksize Choices
Control of Limits & Escalation
Close Processing
Segmented & Partitioned Tablespaces
1 vs. Multiple Tables/Tablespace
Header, Space, & Data Pages
Partitioned Tablespace
Partitioning Index Alternatives
Virtual Pools, Data Spaces, and Hiperpools
Various Uses of Multiple Pools
Balancing Speed & Storage Costs
Data Spaces and Hiperpools
Thresholds & Customizing Pools
Displaying
Pool Activities
Data Compression
Compression Costs and Savings
How to Use
Compression
Building
& Refining the Dictionary
CPU and I/O
Time Test Results
Creating Tables
Data Type and Lengths
Identity Column
ROWID Data Type
User Defined Data Types
Check
Constraints and Domains
Managing
Nulls and Future Dates
Qualifiers, Synonyms and Aliases
Value of
Views and Limitations
Object
Dependencies
DB2 or User
Enforced RI?
Creating
Primary & Foreign Keys
|
Index
Usage for Performance
 Index
Structure Details
How
Indexes are Used
The
Clustering Index
Using An Index
to Avoid a Sort
Index Cardinality
Index
Lookaside
1-Fetch
Index Scan
Use
of Multiple Indexes
Use
of Composite Indexes
Direct Row Access without
Index
Usage and Tablespace Scan
Index Design for Performance
Advantages & Disadv.
of Indexes
Columns Which Should be
Indexed
Analyze Processing of Data
Composite Index Design
Data Only Locking
Insertion of Sequential Values
Beware of Indexing Some Columns
Synonym Chain Management
Deletions and Reuse of Space
Creation & Building Indexes
Triggering
Actions in DB2
What are
Triggers
BEFORE Trigger
to Validate Data
Activation
Time and Events
Granularity
and Mode
Transition
Variables
WHEN
Conditions & Trigger Body
SIGNAL
SQLSTATE
Examples of
Trigger Usage
AFTER Triggers
Trigger
Package
Constraints
& Triggers Contrasted
Stored Procedures
Advantages of
Stored Procedures
Return Result Sets
Procedures in
the Catalog Tables
 SAVEPOINT Management
 Access to Non-DB2 Resources
 Create and Declare Global
Temporary Tables
 Preparation of External Procedures
 SQL Procedures
 Procedural Statements
 Stored Procedure Builder
|
User Defined Functions
Sourced and
External UDF
External UDF
Explanation of
Create Function
Information in the Catalog
Table UDF
UDF Program
Preparation
Use of
DSN_FUNCTION_TABLE
DB2 Supplied
UDF
Concurrency Control
& Perform.
The Purpose and Need for Locks
Timeouts
and Deadlocks
Cost
and Benefit of Row Locking
Duration
of Locks and Latches
CS/RR/RS/UR by Statement
Lock
Avoidance
Monitoring Locks and Latches
Load
and Check Data
LOAD Phases
Inline STATISTICS
and COPY
Discarding
Error Records
Enforcement of
Constraints
LOAD Utility
vs. Appl. INSERTs
Object
Wildcarding
Dynamic
Allocation
Partition
Independence
Claims and
Drains on Objects
UNLOAD Utility
Check Data for
Integrity Violations
Checking
Indexes
Runstats and Reorganization
Why and When
to Execute Runstats
Scheduling
Utilities and Rebinds
Catalog Tables
Updated
Statistics on Non-Indexed Columns
When to Reorg.
Using the Catalog
Online REORG
Inline COPY
and STATISTICS
Unload &
Delete Rows with REORG
Copy, Recover, Quiesce, and Report
The Backup and
Recovery Process
Full and Incremental Copies
CHANGELIMIT COPY Parameter
Recovering Tablespaces and Indexes
Point_in_Time Recovery
Purpose & Use of Quiesce &
Report
|
