The DB2 Family
- The DB2 family of products
- DB2 communications options
Getting started with DB2 (INSTANCES)
- The DB2 hierarchy of objects
- TCP/IP Connectivity for DB2
- Instance creation and configuration
- CLP (command line processor) coding options
- The DB2 Administration Server
DB2 and GUI
- Administration (GUI) tools
- Configuring a DB2 Client to access remote instances and databases
- using the Command Editor to run queries or commands
- Using the Control Center to create a database object
Creating databases and tablespaces
- Know how to create a database
- Create SMS and DMS tablespaces
- List tablespace and container information for a database
- Alter a tablespace and change container sizes
- List and change the database and instance configuration files
Creating Tables and other objects
- Creating tables and indexes
- Using data types and nullity attributes for columns
- Defining Referential and table Check constraints
- Creating views and nested table expressions
TRIGGERS, UDT and UDF
- when and how to use DB2 triggers
- create and code triggers
- when and how to use UDT’s
- Define sourced and external UDF
- Define table functions
DB2 LOCKING
- How DB2 controls concurrency and integrity for multiple users
- Know the factors effecting data locking
- use commands to effect the behavior of DB2 locking
- use monitors to analyze user locking activity
- database configuration parameters that effect locking
- How to GRANT privileges
- Know of administration Authorities in DB2
- How to create tables and other objects for use of groups
DB2 Data Management
- Identify logging techniques that DB2 uses
- basic features of some DB2 Utilities, that help manage data
- when to use these utilities
IMPORT/EXPORT/LOAD Utilities
- when and how to use IMPORT, EXPORT and LOAD
- Choose options to improve performance
- the effects of using LOAD and how to bring a table to normal status
- Compare LOAD and IMPORT
Basic Database Recovery
- when and how to use BACKUP and RECOVERY operations.
- Choose a database configuration for “full recovery” after failure.
- ROLLFORWARD through the transaction logs to reapply changes to data.
- Check the status of a tablespace.
- Accomplish point-in-time recovery of a tablespace
Disaster Recovery for tables and tablespaces
- Complete a redirected restore, to replace lost or changed containers for tablespaces.
- Recover from dropped table
Incremental backup and recovery techniques
- why and how to choose an incremental backup activity.
- Determine options for database and tablespace recovery, when incremental backup has been used.
- Setup for a database for incremental backup activity
Logical Design and Normalization
- Logical design through normalization
- Denormalization
- Techniques for de-normalized table access
Index Design and the Design Advisor
- Index design choices
- Using the design advisor
Multi-Dimensional Clustering (MDC)
- the terminology of multi-dimensional data.
- Know why and how to create a table that is clustered in multiple dimensions.
- Create generated columns to be used for dimension columns.
- Understand the concept of monotonicity associated with generated dimension columns.
Advanced table options
- Using table range partitions
- advanced options for REORG, RUNSTATS utilities
- Supporting identity columns in utilities
Configuring for self tuning of DB2
- automatic maintenance with utilities
- Self tuning memory
- database global memory
- automatic tuning
|
