If you are knowledgeable with DB2 9.7 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role.
Section 1 - DB2 Server Management (10%)
a.Demonstrate the ability to configure/manage DB2 servers, instances, and databases
b.Demonstrate the ability to schedule jobs
c.Demonstrate the ability to use autonomic features
Section 2 - Physical Design (20%)
a.Demonstrate the ability to create a database and manipulate various DB2 objects
b.Demonstrate knowledge of partitioning capabilities
c.Demonstrate knowledge of XML data objects
d.Demonstrate knowledge of compression
Section 3 - Business Rules Implementation (5%)
a.Demonstrate the ability to create constraints on tables
b.Demonstrate the ability to create views WITH CHECK OPTION
Section 4 - Monitoring DB2 Activity (15%)
a.Demonstrate the ability to use Admin views and SQL functions for monitoring
b.Demonstrate the ability to use Work Load Manager
c.Demonstrate the ability to use additional auto-monitoring tools
d.Demonstrate the ability to identify the functions of Problem Determination Tools
e.Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
Section 5 - Utilities (15%)
a.Demonstrate the ability to use the data movement utilities
b.Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
c.Demonstrate the ability to use the DB2 Advisor utility
d.Describe the purpose of Data Studio Administrator (basic concepts ? replacing existing DB2 tools)
Section 6 - High Availability (20%)
a.Describe DB2 data integrity actions
b.Demonstrate the ability to perform database-level and table space level backup and recovery operations
c.Demonstrate the ability to configure and manage HADR
Section 7 - Security (10%)
a.Describe DB2 authentication
b.Describe DB2 authorizations and privileges
c.Describe the ability to set and remove user, group, and role authorities and privileges
d.Demonstrate general knowledge of the Audit facility
e.Demonstrate knowledge of the DB2 Security Infrastructure
Section 8 - Connectivity and Networking (5%)
a.Demonstrate the ability to configure database connectivity
b.Demonstrate knowledge of using JDBC/SQLJ connections with DB2
