DB2 v.8 Mainframe DBA

  • $10.00


DB2 v.8 Mainframe DBA measures the overall knowledge of an OS/390 and z/OS DB2 DBA from either a systems or applications DBA perspective. Test questions will be derived from topics such as the Creation and Management of DB2 Objects, Data Recovery, Performance and Tuning, DB2 Utilities and Commands, and Security.

Assessments for DB2 v.8 UDB DBA, DB2 5.x DBA, and DB2 Developer are also available.

Number of questions 40
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Create/Manage DB2 Objects
Data Recovery
Performance Monitoring and Tuning
Security
Utilities and Commands
Tasks tested Access During Image Copy
Adding a Column to a Table
Adjusting the SEGSIZE
Altering a Tablespace
Authorization Levels
Check Constraints
Creating a Segmented Tablespace
DB2 Commands
DB2 Components
DB2 PM Reports
DB2 Privileges
DCL Interpretation
Disaster Recovery
Establishing a Point of Consistency
Executing Utilities
EXPLAIN Tool
Granting DB2 Access
Image Copies
Index Definition
Index Design
Index Properties
Load Option Create
Load Option Delete
LOGAPPLY
Logging
PLAN_TABLE
Primary and Unique Keys
Recovery Concepts
Resetting RBDP Status Condition
RUNSTATS
SQL Optimization and Tuning
Tablespace Recovery
Tablespace REORGs
Tablespace Types
Unique Indexes
Using DB2 Commands
Using the LOAD Utility
Views
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)