OpenExamsFREE PRACTICE — ANY EXAM

IBM Db2 12 for z/OS Administrator — Information & Free Practice

US · Examination information

100 free questions · Answer explanations · No signup required

Start free practice →

IBM Db2 12 for z/OS Administrator

Provider
Pearson VUE
Format
Proctored answer-scored certification examination; IBM's current record enables multiple-choice and build-list items.
Exam questions
Total questions: 60.
Time limit
90 minutes
Passing score
42 questions to pass; IBM's current examination record also gives 70 percent.
Examination outline
  • Database Design and Implementation (22%)
    • Design tables and views
    • Explain the different performance implications of identity column, ROWID, and sequence column definitions
    • Design indexes
    • Design universal table spaces
    • Perform partitioning
    • Normalize data (E-R model, process model) and translate data model into physical model
    • Understand and describe Db2 database enforced integrity rules
    • Use the appropriate method to alter Db2 objects
    • Explain the use and impact of different encoding schemes
  • Operation and Recovery (20%)
    • Explain and execute commands and subcommands for normal operational conditions
    • Explain and execute commands and utility control statements for use in abnormal conditions
    • Load and unload data into and from Db2 tables
    • Reorganize objects when necessary
    • Monitor objects by collecting statistics
    • Monitor and manage threads and utilities
    • Identify and respond to advisory/restrictive statuses on Db2 objects
    • Identify and perform problem determination
    • Perform object and catalog/directory health checks
    • Identify and perform actions needed to protect databases from planned and unplanned outages
    • Identify and perform actions needed to recover data to a consistent point in time
  • Security and Auditing (10%)
    • Explain privileges and authorities
    • Protect access to Db2 and its objects
    • Audit Db2 activity and resources and identify primary audit techniques
    • Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
    • Explain and use roles, trusted context, data masking and encryption
  • Performance (21%)
    • Plan for performance monitoring by setting up and running monitoring procedures
    • Analyze performance (manage and tune CPU requirements, memory, I/O, locks, response time, index and table compression)
    • Analyze and respond to RUNSTATS statistics analysis
    • Determine when and how to perform REBIND
    • Describe Db2 interaction with Workload Manager (WLM)
    • Review and tune SQL
    • Monitor dynamic SQL performance
    • Design features for performance
    • Explain how to control and influence access paths
  • Installation and Migration (9%)
    • Recommend settings for critical Db2 system parameters
    • Identify and explain Db2 data sharing components and commands
    • Describe use of premigration checklists
    • Describe the function of the catalog and directory
    • Demonstrate understanding of the Db2 12 continuous delivery process
    • Explain the migration process and activation of new function levels
  • Additional Database Functionality (9%)
    • Explain and use SQL constructs
    • Explain the use of stored procedures
    • Explain the use of SQL/XML and XQuery
    • Explain the use of user-defined functions
    • Explain and use global variables
    • Describe the use of triggers, merge statement, pagination options and JSON support
  • Distributed Access (9%)
    • Demonstrate understanding of distributed data access and the role of the communications database
    • Demonstrate understanding of Distributed Data Facility (DDF) implementation options
    • Recommend values for critical DDF configuration settings
    • Understanding and implementing distributed data access
    • Describe Db2 support for Native REST services and differentiate from RESTful API
Examination sources

Related license preparation

This examination may be required or accepted as an alternative, depending on the license and application pathway.