{"EXAM_SERIES_CODE":"C1000-078","EXAM_STATUS_ID":"1","EXAM_REVIEW_APPROVAL_STATUS_OPS":false,"EXAM_REVIEW_APPROVAL_STATUS_OTHER":null,"EXAM_REVIEW_APPROVAL_STATUS_PUBLISH":null,"EXAM_TITLE":"IBM Db2 12 for z/OS Administrator","WITHDRAWAL_DATE":null,"CREATED_BY_EMAIL":null,"CREATED_BY_DATE":"2020-03-04 00:00:00.000000","OWNER_NAME":null,"OWNER_EMAIL":null,"LAST_MODIFIED_BY_EMAIL":"jessfern@us.ibm.com","LAST_MODIFIED_BY_DATE":"2026-01-06 00:00:00.000000","EXAM_BUSINESS":"IBM Data and AI","EXAM_BRAND":"Analytics","EXAM_REPLACED_FLAG":false,"REPLACE_BY_EXAM_SERIES_CODE":null,"PREREQUISITE_EXAM_SERIES_CODE":null,"OVERVIEW_JOB_ROLE":null,"OVERVIEW_JOB_SKILL":null,"EXAM_TIME_LIMIT":90,"EXAM_PASSING_SCORE":70,"EXAM_NUMBER_OF_QUESTIONS":60,"EXAM_NUMBER_OF_QUESTIONS_TO_PASS":42,"EXAM_PRICE_DEVELOPED":null,"EXAM_PRICE_EMERGING":null,"EXAM_PRICE_JAPAN":null,"AVAILABLE_FOR_PROCTOR_FLAG":true,"WITHDRAWAL_WARNING_DAYS":30,"BADGE_REPLACED_FLAG":null,"REPLACE_BY_BADGE_ID":null,"EDUCATION_OVERVIEW":null,"JTA_OBJECTIVE_UPLOAD_PATH":null,"JTA_SURVEY_FLAG":true,"JTA_JOB_ROLE_DESCRIPTION":"The IBM Certified Database Administrator is the lead database administrator for the Db2 product on the z/OS operating system.� This individual has significant experience as a DBA and extensive knowledge of Db2, up to and including Db2 12 for z/OS Function Level 506.� This individual is capable of performing intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, installation and migration/upgrades specific to the z/OS operating system.","BLUEPRINT_UPLOAD_PATH":null,"SURVEY_FROM_JTA_COUNT":49,"PLANNED_ASSESSMENT_EXAM_FLAG":true,"PLANNED_SAMPLE_QUESTIONS_FLAG":false,"NUMBER_OF_LIVE_FORMS":2,"NUMBER_OF_ITEMS_PER_FORM":60,"MINIMALLY_COMPETENT_CANDIDATE":"The IBM Certified Database Administrator is the lead database administrator for the Db2 product on the z/OS operating system.� This individual has significant experience as a DBA and extensive knowledge of Db2, up to and including Db2 12 for z/OS Function Level 506.� This individual is capable of performing intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, installation and migration/upgrades specific to the z/OS operating system.","ITEMTYPE_MULTIPLE_CHOICE":true,"ITEMTYPE_DOMC":false,"ITEMTYPE_BUILD_LIST":true,"ITEMTYPE_HOT_AREA":false,"ITEM_WRITING_TOOL_OTHER":null,"ITEM_WRITING_BEST_PRACTICE":true,"ITEM_WRITING_BEST_PRACTICE_OTHER":null,"ITEM_WRITING_TYPES":2,"ITEM_WRITING_GRAMMAR_CHECK_FLAG":true,"ITEM_WRITING_TECHNICAL_CHECK_FLAG":true,"PSYCHO_REVIEWED_ALL_FLAG":false,"PSYCHO_EVALUATE_TEN_PERCENT_FLAG":false,"PSYCHOMETRIC_REVIEWER_NAME":null,"PSYCHOMETRIC_REVIEWER_EMAIL":null,"STANDARDS_TWO_STEP_METHOD_FLAG":true,"STANDARDS_OTHER":null,"STANDARDS_OTHER_WHO":null,"STANDARDS_OTHER_DATE":null,"STANDARDS_OTHER_COMMENTS":null,"STANDARDS_SUPPORTING_FILES_UPLOAD_PATH":null,"CUTSCORE_RATING_FILE_UPLOAD_PATH":null,"FORMS_ASSESSMENT":true,"FORMS_SAMPLE_QUESTIONS":true,"FORMS_ITEMS_PER_FORM":60,"FORMS_ANCHOR_ITEMS_PER_FORM":7,"SAMPLE_EXAM_COS_KEY":null,"STUDY_GUIDE_COS_KEY":null,"TINSERTTS":"2020-03-04 14:13:00.326916","TLASTUPDTS":"2026-01-06 18:45:54.878494","FINANCE_BUSINESS_UNIT":"IBM Data and AI","FINANCE_BRAND":"Data and AI","EXAM_TYPE_ID":0,"DIVERSE_COUNTRY_BACKGROUND_FLAG":true,"EXAM_TYPE_DEVELOPING":"New exam based on new technology","STANDARDS_JOB_ROLE_DESC":"The IBM Certified Database Administrator is the lead database administrator for the Db2 product on the z/OS operating system.� This individual has significant experience as a DBA and extensive knowledge of Db2, up to and including Db2 12 for z/OS Function Level 506.� This individual is capable of performing intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, installation and migration/upgrades specific to the z/OS operating system.","ITEMTYPE_OTHER":null,"TARGET_PUBLICATION_DATE":"2020-03-25","PEARSONVUE_START_DATE":"2020-03-25 00:00:00.000000","ACTUAL_START_DATE":"2020-03-25 00:00:00.000000","FORMS_PSYCHOMETRICIAN_NAME":"Scott Thayn","FORMS_PSYCHOMETRICIAN_EMAIL":"scott@itemexperts.com","PEARSONVUE_SELECTION":"PearsonVue start date","ASSESSMENT_FLAG":true,"PARENT_FORMS":"Form A and Form B","GOVERNANCE_COMPLETED_FLAG":false,"WITHDRAWAL_REASON":null,"WITHDRAWAL_REASON_COMMENT":null,"PV_PUBLISH_DATE":null,"READY_FOR_LIVE_DATE":null,"UUID":"ad5df2f6-4e9b-401f-b8a7-ce09bdc8d1de","GO_LIVE_DATE":null,"MKTGCATEGORY":"MBDA1","EXAM_STATUS":"Live","MKTGCATEGORY_NAME":"Data, Analytics, and AI","OBJECTIVES":[{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":0,"EXAM_OBJECTIVE_TITLE":"Database Design and Implementation","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"22","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Design tables and views
  2. Explain the different performance implications of identity column, ROWID, and sequence column definitions
  3. Design indexes
  4. Design universal table spaces
  5. Perform partitioning
  6. Normalize data (E-R model, process model) and translate data model into physical model
  7. Understand and describe Db2 database enforced integrity rules
  8. Use the appropriate method to alter Db2 objects
  9. Explain the use and impact of different encoding schemes
","EXAM_OBJECTIVE_ORDER":0,"TINSERTTS":"2026-01-06 18:45:54.727298","TLASTUPDTS":"2026-01-06 18:45:54.727298"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":1,"EXAM_OBJECTIVE_TITLE":"Operation and Recovery","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"20","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Explain and execute commands and subcommands for normal operational conditions
  2. Explain and execute commands and utility control statements for use in abnormal conditions
  3. Load and unload data into and from Db2 tables
  4. Reorganize objects when necessary
  5. Monitor objects by collecting statistics
  6. Monitor and manage threads and utilities
  7. Identify and respond to advisory/restrictive statuses on Db2 objects
  8. Identify and perform problem determination
  9. Perform object and catalog/directory health checks
  10. Identify and perform actions needed to protect databases from planned and unplanned outages
  11. Identify and perform actions needed to recover data to a consistent point in time
","EXAM_OBJECTIVE_ORDER":1,"TINSERTTS":"2026-01-06 18:45:54.732417","TLASTUPDTS":"2026-01-06 18:45:54.732417"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":2,"EXAM_OBJECTIVE_TITLE":"Security and Auditing","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"10","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Explain privileges and authorities
  2. Protect access to Db2 and its objects
  3. Audit Db2 activity and resources and identify primary audit techniques
  4. Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
  5. Explain and use roles, trusted context, data masking and encryption
","EXAM_OBJECTIVE_ORDER":2,"TINSERTTS":"2026-01-06 18:45:54.736500","TLASTUPDTS":"2026-01-06 18:45:54.736500"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":3,"EXAM_OBJECTIVE_TITLE":"Performance","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"21","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Plan for performance monitoring by setting up and running monitoring procedures
  2. Analyze performance (manage and tune CPU requirements, memory, I/O, locks, response time, index and table compression)
  3. Analyze and respond to RUNSTATS statistics analysis
  4. Determine when and how to perform REBIND
  5. Describe Db2 interaction with Workload Manager (WLM)
  6. Review and tune SQL
  7. Monitor dynamic SQL performance
  8. Design features for performance
  9. Explain how to control and influence access paths
","EXAM_OBJECTIVE_ORDER":3,"TINSERTTS":"2026-01-06 18:45:54.740248","TLASTUPDTS":"2026-01-06 18:45:54.740248"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":4,"EXAM_OBJECTIVE_TITLE":"Installation and Migration","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"9","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Recommend settings for critical Db2 system parameters
  2. Identify and explain Db2 data sharing components and commands
  3. Describe use of premigration checklists
  4. Describe the function of the catalog and directory
  5. Demonstrate understanding of the Db2 12 continuous delivery process
  6. Explain the migration process and activation of new function levels
","EXAM_OBJECTIVE_ORDER":4,"TINSERTTS":"2026-01-06 18:45:54.744114","TLASTUPDTS":"2026-01-06 18:45:54.744114"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":5,"EXAM_OBJECTIVE_TITLE":"Additional Database Functionality","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"9","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Explain and use SQL constructs
  2. Explain the use of stored procedures
  3. Explain the use of SQL/XML and XQuery
  4. Explain the use of user-defined functions
  5. Explain and use global variables
  6. Describe the use of triggers, merge statement, pagination options and JSON support
","EXAM_OBJECTIVE_ORDER":5,"TINSERTTS":"2026-01-06 18:45:54.749114","TLASTUPDTS":"2026-01-06 18:45:54.749114"},{"EXAM_SERIES_CODE":"C1000-078","EXAM_OBJECTIVE_ID":6,"EXAM_OBJECTIVE_TITLE":"Distributed Access","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"9","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Demonstrate understanding of distributed data access and the role of the communications database
  2. Demonstrate understanding of Distributed Data Facility (DDF) implementation options
  3. Recommend values for critical DDF configuration settings
  4. Understanding and implementing distributed data access
  5. Describe Db2 support for Native REST services and differentiate from RESTful API
","EXAM_OBJECTIVE_ORDER":6,"TINSERTTS":"2026-01-06 18:45:54.753164","TLASTUPDTS":"2026-01-06 18:45:54.753164"}],"RESOURCES":[{"TYPE":"Web Resource","RESOURCES":[{"RESOURCE_TITLE":"Db2 12 for z/OS documentation","RESOURCE_DESCRIPTION":"

Welcome to the IBM Db2 12 for z/OS documentation, where you can find topics that you need to use Db2 for z/OS. By using this information, you can install or migrate to Version 12 of Db2 for z/OS, develop and run application programs, and administer and operate Db2 databases and subsystems.

","RESOURCE_URL":"https://www.ibm.com/docs/en/db2-for-zos/12.0.0","RESOURCE_TYPE_NAME":"Web Resource"}]}],"RELATED_CERTS":[{"PARTNERWORLD_CODE":"C0005400","CREDENTIAL_TITLE":"IBM Certified Administrator - Db2 12 for z/OS"}],"PREREQS":[],"ASSOC_COURSES":[{"COURSE_CODE":"CV844G","CSEMSTRNAME":"Db2 12 for z/OS Basic Database Administration"},{"COURSE_CODE":"CV853G","CSEMSTRNAME":"Db2 12 for z/OS Introduction to System Administration"},{"COURSE_CODE":"CV964G","CSEMSTRNAME":"Db2 12 for z/OS SQL Performance and Tuning"},{"COURSE_CODE":"CV880G","CSEMSTRNAME":"Db2 12 for z/OS Advanced Database Administration"}],"ASSOC_NON":[],"ASSOC_PATHS":[{"PATH_CODE":615,"LEARNING_JOURNEY_TITLE":"IBM Db2 12 for z/OS","URL":"/training/learning-path/ibm-db2-12-for-zos-615"}],"ASSESSMENT":"A1000-078","LANGUAGES":"English","PRICE":200,"STUDY_GUIDE_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-078_STU_C1000078STU.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T214036Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-078_STU_C1000078STU.pdf%22&X-Amz-Signature=89094f4184eea995e438aeae6f98b60cc1e2ba8f6c4b19d98e4dfba0320be466","SAMPLE_EXAM_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-078_SAM_C1000078SAM.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T214036Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-078_SAM_C1000078SAM.pdf%22&X-Amz-Signature=eb99efb3c3854c458d5745ab28778339130c8272954d50d95840954fe4f97946"}