The IBM DB2 UDB V8 DBA test poses real world questions in order to assess the skill level of the test take. This test covers all areas and topics required by a database administrator to perform the day-to-day duties associated with their job. The skill set tested includes knowledge of DB2 products, tools, wizards, various DB2 utilities, product installations, upgrades and migrations, configuration of the database in recovery and non-recovery modes, performance tuning, security, and regular database maintenance activities. The test is intended for those wishing to demonstrate their ability to perform DBA role and responsibilities in UNIX as well as Windows environments. Tests for DB2 V8 Mainframe DBA and DB2 5.x DBA are also available. Total Questions 55 Question Types Multiple Choice Competencies Tested DB2 Product FamilyInstallation and ConfigurationSecurityBackup and RecoveryDatabase MaintenancePerformance and SQL Tasks Tested DB2 Partition Support ProductDB2 ToolsProduct ConnectivityMobile Computing ProductDB2 Add on ComponentsBufferpools for TablespacesDefault TablespacesConfiguration ParameterSMS Tablespace PropertiesSYSCAT TablespaceUser Temp Tablespace db PartitionArchive LoggingDB2 Instance UpgradeSMS TablespaceBufferpool Size for Partitions in a Partition DBSystem Temp TablespaceTrusted Versus Un-trusted ClientsDB Authority DisplayAuthorityDB2 Authority LevelPrivilegesTable PrivilegesData MigrationData Export File TypeDB Restore OptionsTurning Archive Log ModeRestore - AuthorityTime Zone Base Rollforward RecoveryData LoadDB CloneSystem TablesRollforward RecoveryEvent MonitorsDB Maintenance AuthorityTablespace ContainersDRDA Data LoadDB2 LogsBufferpools ListBufferpool Block and Page Base Size RatioDB2 History FileSQL ViewsBufferpool Start IssueUser ConnectionData Validation with View DefinitionI/O CleanersInitialize MonitorsIsolation LevelGlobal Session Temp TablesExplain Plan ToolsBufferpool Hit RatioRunstatsBlockpage Based Bufferpool I/OExplain Plan Interpretation
