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 |
Techflames is an online training hub where we provide experienced tutors on any technology. We serve all the major time zones be it USA, UK, Canada, Australia, New Zealand, India, Saudi, Dubai..
