Test 000-541: DB2 9.7 DBA for Linux UNIX and Windows

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%)

1. Demonstrate the ability to configure/manage DB2 servers, instances, and databases (e.g. scope)
   1. Demonstrate the ability to obtain and modify registry variable information
   2. Demonstrate the ability to obtain/modify database manager configuration information
   3. Demonstrate the ability to obtain/modify database configuration information
   4. Oracle compatibility (one item for practice form)
2. Demonstrate the ability to schedule jobs
   1. tools catalog
   2. Task Manager
   3. Administration Configuration (DAS)
3. Demonstrate the ability to use autonomic features
   1. Automatic Maintenance
   2. Self-Tuning Memory Manager
   3. Utility throttling

Section 2 - Physical Design (20%)

1. Demonstrate the ability to create a database and manipulate various DB2 objects
   1. Create database
   2. Create and discuss the characteristics of DMS, SMS, and AS table spaces
   3. Describe the use of schemas
2. Demonstrate knowledge of partitioning capabilities
   1. Range/table partitioning
3. Demonstrate knowledge of XML data objects
   1. XML indexes
   2. XML data types
   3. XML functions
   4. New features in V9.7
4. Demonstrate knowledge of compression
   1. enabling compression
   2. index compression
   3. automatic dictionary creation
   4. replication support
   5. compress XML and LOBs inline
   6. temporary tables

Section 3 - Business Rules Implementation (5%)

1. Demonstrate the ability to create constraints on tables
   1. RI
   2. Informational
   3. Unique constraints/unique indexes/primary keys
   4. NOT NULL
   5. WITH DEFAULT
   6. Check
2. Demonstrate the ability to create views WITH CHECK OPTION
   1. LOCAL
   2. CASCADE

Section 4 - Monitoring DB2 Activity (15%)

1. Demonstrate the ability to use Admin views and SQL functions for monitoring
   1. ADMIN_GET_INDEX_COMPRESS_INFO -- new admin view for checking compression results
2. Demonstrate the ability to use Work Load Manager
   1. time spent metrics
   2. new waterfall approach to set up
3. Demonstrate the ability to use additional auto-monitoring tools
   1. Event monitoring
   2. Demonstrate the ability to configure Health Monitor using the Health Center
4. Demonstrate the ability to identify the functions of Problem Determination Tools
   1. db2pd
   2. db2mtrk
   3. db2diag command
   4. Interpret the Notify log
   5. Describe the various table space states
   6. db2top
5. Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
   1. EXPLAIN FROM SECTION

Section 5 - Utilities (15%)

1. Demonstrate the ability to use the data movement utilities
   1. Demonstrate the ability to use EXPORT utility to extract data from a table
   2. Demonstrate the ability to use IMPORT utility to insert data into a table
   3. Demonstrate the ability to use the LOAD utility to insert data into a table
   4. Knowledge to identify when to use IMPORT vs. LOAD
   5. DB2Move
   6. DB2Look
2. Demonstrate the ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
3. Demonstrate the ability to use the DB2 Advisor utility
   1. db2advis utility
   2. GUI
4. Describe the purpose of Data Studio Administrator (basic concepts - replacing existing DB2 tools)

Section 6 - High Availability (20%)

1. Describe DB2 data integrity actions
   1. transactions and logging
   2. logging strategies
   3. crash recovery
   4. version recovery
   5. roll forward recovery
2. Demonstrate the ability to perform database-level and table space level backup and recovery operations
   1. BACKUP
   2. RESTORE
   3. ROLLFORWARD
   4. RECOVER
   5. Describe backing up with split mirroring
3. Demonstrate the ability to configure and manage HADR
   1. automatic client re-route

Section 7 - Security (10%)

1. Describe DB2 authentication
2. Describe DB2 authorizations and privileges
3. Describe the ability to set and remove user, group, and role authorities and privileges
   1. Roles
   2. GRANT
   3. REVOKE
4. Demonstrate general knowledge of the Audit facility
5. Demonstrate knowledge of the DB2 Security Infrastructure
   1. LBAC
   2. Trusted contexts (why as opposed to how)
   3. LDAP
   4. Plug-ins

Section 8 - Connectivity and Networking (5%)

1. Demonstrate the ability to configure database connectivity
   1. steps required to setup connection pools
   2. using DB2 DISCOVERY
   3. Demonstrate knowledge federating communications
   4. connection concentration
   5. sysplex utilization
   6. DB2COMM
   7. automatic client re-route
2. Demonstrate knowledge of using JDBC/SQLJ connections with DB2
   1. DB2 drivers
   2. licensing