|
Provided by: Serebra Learning Corporation DB2 Design Administration II ver 4 xDB2 |
 |
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. Database administrators, analysts and systems designers.
|
|
||||||||
Training
Provided by Serebra Learning Corporation
DB2 Design Administration II ver 4 x
AudienceObjectives
Database administrators, analysts and systems designers.
TopicsDB2 Storage Definition
- Estimating Storage Quantities
- Introduction
- Creating Tablespaces
- Estimating Storage Quantities
- Components of a Data Page
- Page Space
- Space Requirement
- Parameters of CREATE
- Operators
- SECONDARY QUANTITY (SECQTY)
- FREE SPACE
- PCTFREE AND FREEPAGE
- FREE SPACE
- Insertions within Sequence
- Inserting a Row
- Adding Rows to Tables
- Relocation of Rows
- Expanding Tables
- Concurrency Control Locks
- IMPLICIT and EXPLICIT LOCKS
- LOCKSIZE
- LOCKSIZE = PAGE
- LOCKSIZE = TABLE/TABLESPACE
- Deciding Which Alternatives to Use
- SEGMENTED TABLESPACES
- SEGSIZE
- Data Compression
- User Table Space Layout
- Database Space Requirements
- The STOSPACE Utility
- SQL Query Examples
- The RUNSTATS Utility
- Th
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
