Section 1 – DB2 Server Management (19%)
Ability to configure/manage DB2 instances (e.g. scope)
Knowledge of DB2 authentication
Knowledge of DB2 authorizations
Ability to set user and/or group privileges
Knowledge of the DB2 force command
Ability to configure client/server connectivity
Ability to schedule jobs
Ability to configure client server connectivity using DISCOVERY
Skill in interpreting the Notify log
Section 2 – Data Placement (17%)
Ability to create a database
Skill in discussing the use of schemas
Skill in discussing the various table space states
Ability to create and manipulate the various DB2 objects
Ability to create and discuss the characteristics of an SMS tablespace
Ability to create and discuss the characteristics of a DMS tablespace
Section 3 – Database Access (17%)
Ability to create DB2 Tasks using the GUI tools
Knowledge of the creation and management of indexes
Ability to create constraints on tables (e.g., RI, Informational, Unique)
Ability to create views on tables
Skill in examining the contents of the System Catalog tables
Ability to use GUI Tools to access DB objects
Knowledge of how to enforce data uniqueness
Section 4 – Monitoring DB2 Activity (16%)
Ability to obtain/modify database manager configuration information
Ability to obtain/modify database configuration information
Ability to capture EXPLAIN/VISUAL EXPLAIN information
Skill in analyzing EXPLAIN/VISUAL EXPLAIN information (sortheap, buffpage, degree)
Ability to identify the functions of the DB2 Governor and Query Patroller
Ability to obtain and modify DB2 registry variables
Ability to capture snapshots
Ability to create and activate event monitors
Ability to Identify output from the Health Center
Section 5 – DB2 Utilities (17%)
Ability to use EXPORT utility to extract data from a table
Ability to use IMPORT utility to insert data into a table
Ability to use the LOAD utility to insert data into a table
Knowledge to identify when to use IMPORT vs. LOAD
Ability to use the REORG, REORGCHK, REBIND and RUNSTATS utilities
Ability to use DB2Move and DB2Look
Knowledge of the functionality of the DB2 Advisors
Ability to use the DB2 Control Center
Section 6 – Backup and Recovery (14%)
Ability to perform database-level and table space level BACKUP & RESTORE
Knowledge to identify and explain issues on index recreation
Knowledge of database logging
Knowledge of crash recovery
Knowledge of version recovery
Knowledge of Roll Forward recovery
Killtest offers the latest dumps of IBM 000-701 exam. Try 000-701 free demo here, 100% guarantee to pass your exam.
Leave a Reply