IBM DB2 is a family of database server products developed by IBM. Browse through the contents of the program.
DB2 DATA Course Contents |
Brief History of Db2 |
Different product types in DB2 |
Various editions of Db2 |
Detailed analysis of DB2 architecture |
Demonstrate the ability to configure/manage DB2 servers, instances, and databases |
Demonstrate the ability to obtain and modify registry variable information |
Demonstrate the ability to obtain/modify database manager configuration information |
Demonstrate the ability to obtain/modify database configuration information |
Demonstrate the ability to schedule jobs |
tools catalog |
Task Manager |
Administration Configuration (DAS) |
Demonstrate the ability to use autonomic features |
Automatic Maintenance |
Self-Tuning Memory Manager |
Utility throttling |
Analysis Instance ana databse |
Various Background process in db2 |
Demonstrate the ability to create a database and manipulate various DB2 objects |
Create database |
Create and discuss the characteristics of DMS, SMS, and AS table spaces |
Describe the use of schemas |
Demonstrate knowledge of partitioning capabilities |
Range/table partitioning |
XML indexes |
XML data types |
XML functions |
New features in V9.7 |
enabling compression |
index compression |
automatic dictionary creation |
replication support |
compress XML and LOBs inline |
temporary tables |
Demonstrate the ability to create constraints on tables |
Referential Integerity |
Informational |
Unique constraints/unique indexes/primary keys |
NOT NULL |
WITH DEFAULT |
Check |
Demonstrate the ability to create views WITH CHECK OPTION |
LOCAL |
CASCADE |
Demonstrate the ability to use Admin views and SQL functions for monitoring |
ADMIN_GET_INDEX_COMPRESS_INFO |
Demonstrate the ability to use Work Load Manager |
time spent metrics |
new waterfall approach to set up |
Demonstrate the ability to use additional auto-monitoring tools |
Event monitoring |
Demonstrate the ability to configure Health Monitor using the Health Center |
Demonstrate the ability to identify the functions of Problem Determination Tools |
db2pd |
db2mtrk |
db2diag command |
Interpret the Notify log |
Describe the various table space states |
db2top |
Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information |
EXPLAIN FROM SECTION |
Demonstrate the ability to use the data movement utilities |
Demonstrate the ability to use EXPORT utility to extract data from a table |
Demonstrate the ability to use IMPORT utility to insert data into a table |
Demonstrate the ability to use the LOAD utility to insert data into a table |
Knowledge to identify when to use IMPORT vs. LOAD |
DB2Move |
DB2Look |
Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities |
Demonstrate the ability to use the DB2 Advisor utility |
db2advis utility |
GUI |
Describe the purpose of Data Studio Administrator (basic concepts � replacing existing DB2 tools) |
Describe DB2 data integrity actions |
transactions and logging |
logging strategies |
crash recovery |
version recovery |
roll forward recovery |
Demonstrate the ability to perform database-level and table space level backup and recovery operations |
BACKUP |
RESTORE |
ROLLFORWARD |
RECOVER |
Describe backing up with split mirroring |
Demonstrate the ability to configure and manage HADR |
automatic client re-route |
Describe DB2 authentication |
Describe DB2 authorizations and privileges |
Describe the ability to set and remove user, group, and role authorities and privileges |
Roles |
GRANT |
REVOKE |
Demonstrate general knowledge of the Audit facility |
Demonstrate knowledge of the DB2 Security Infrastructure |
LBAC |
Trusted contexts |
LDAP |
Plug-ins |
Demonstrate the ability to configure database connectivity |
steps required to setup connection pools |
using DB2 DISCOVERY |
Demonstrate knowledge federating communications |
connection concentration |
sysplex utilization |
DB2COMM |
automatic client re-route |
Demonstrate knowledge of using JDBC/SQLJ connections with DB2 |
DB2 drivers |
licensing |