OpenExamsFREE PRACTICE — ANY EXAM

IBM Certified Administrator - Db2 12 for z/OS — Requirements & Free Practice

US · License preparation

100 free questions · Answer explanations · No signup required

Loading selected examination banks…

Choose what to practice

Start with an exam below. Your examination requirements depend on your application pathway. View licensing requirements

Licenses, application pathways and examination requirements

Each license and applicant pathway has its own requirements and exemptions. Choosing practice questions does not determine your eligibility.

IBM Certified Administrator - Db2 12 for z/OS

IBM certification for the lead database administrator for Db2 12 on z/OS, covering intermediate to advanced administration through Function Level 506.

Licensing authority: IBM

Initial by examination
IBM Db2 12 for z/OS Administrator
Certification Agreement
IBM requires prior acceptance of its Certification Agreement for credential issuance.
Date Boundaries
No official credential or route start date is published in the adopted evidence. Current status is Live; the certification replacement pointer carries no cessation date for this examination.
Delivery
Pearson appointment scheduling at an authorized center or online with OnVUE; online delivery requires a private space, a sufficient computer/network and proctor monitoring. Seat availability for an individual date is not guaranteed.
Language
English only in this investigation.
Preparation
The study guide recommends self-study and the preparation assessment. Its Next Steps says to schedule testing after passing that assessment; the current certification Requirements lists C1000-078 alone and describes the separate assessment as a preparedness score report, not a second award requirement.
Recommended Skills
IBM lists basic z/OS and WLM, extensive Db2, basic SQL/XML/JSON, database security and Db2 routines under Recommended Skills; these are preparation qualifications, not additional examination leaves.

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