IBM DB2 000-701 Exam

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

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

  

  

  

Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.