{"EXAM_SERIES_CODE":"C1000-181","EXAM_STATUS_ID":"1","EXAM_REVIEW_APPROVAL_STATUS_OPS":null,"EXAM_REVIEW_APPROVAL_STATUS_OTHER":null,"EXAM_REVIEW_APPROVAL_STATUS_PUBLISH":null,"EXAM_TITLE":"IBM Db2 13 for z/OS Database Administrator - Professional","WITHDRAWAL_DATE":null,"CREATED_BY_EMAIL":"rena_chang@us.ibm.com","CREATED_BY_DATE":"2024-03-27 00:00:00.000000","OWNER_NAME":"Rena Chang","OWNER_EMAIL":"rena_chang@us.ibm.com","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":"<p>An IBM Certified Db2 13 for z/OS Database Administrator - Professional is an experienced database administrator for the Db2 product on the z/OS operating system.&nbsp; This individual has three or more years experience as a DBA and strong knowledge of Db2, up to and including Db2 13 for z/OS. This individual is capable of performing intermediate tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and a good understanding of installation and migration/upgrades specific to Db2 z/OS.</p>","OVERVIEW_JOB_SKILL":null,"EXAM_TIME_LIMIT":90,"EXAM_PASSING_SCORE":66,"EXAM_NUMBER_OF_QUESTIONS":60,"EXAM_NUMBER_OF_QUESTIONS_TO_PASS":40,"EXAM_PRICE_DEVELOPED":null,"EXAM_PRICE_EMERGING":null,"EXAM_PRICE_JAPAN":null,"AVAILABLE_FOR_PROCTOR_FLAG":true,"WITHDRAWAL_WARNING_DAYS":30,"BADGE_REPLACED_FLAG":false,"REPLACE_BY_BADGE_ID":null,"EDUCATION_OVERVIEW":"<p>All IBM certification tests presume a certain amount of \"on-the-job\" experience which is not present in any classroom or Web presentation. The recommended courses and links will help you gain the skill and product knowledge represented in the test objectives. They do not teach the answers to the test questions and are not intended to do so. This information may not cover all subject areas in the certification test or may contain more recent information than is present in the certification test. Taking these or any classes will not guarantee that you will achieve certification.</p>","JTA_OBJECTIVE_UPLOAD_PATH":null,"JTA_SURVEY_FLAG":true,"JTA_JOB_ROLE_DESCRIPTION":"<p>An IBM Certified DBA on IBM Db2 13 for z/OS is an experienced database administrator for the Db2 product on the z/OS operating system.&nbsp; This individual has three or more years experience as a DBA and strong knowledge of Db2, up to and including Db2 13 for z/OS. This individual is capable of performing intermediate tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and a good understanding of installation and migration/upgrades specific to Db2 z/OS.</p>","BLUEPRINT_UPLOAD_PATH":null,"SURVEY_FROM_JTA_COUNT":20,"PLANNED_ASSESSMENT_EXAM_FLAG":true,"PLANNED_SAMPLE_QUESTIONS_FLAG":true,"NUMBER_OF_LIVE_FORMS":2,"NUMBER_OF_ITEMS_PER_FORM":60,"MINIMALLY_COMPETENT_CANDIDATE":"<p>An IBM Certified DBA on IBM Db2 13 for z/OS is an experienced database administrator for the Db2 product on the z/OS operating system.&nbsp; This individual has three or more years experience as a DBA and strong knowledge of Db2, up to and including Db2 13 for z/OS. This individual is capable of performing intermediate tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and a good understanding of installation and migration/upgrades specific to Db2 z/OS.</p>","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":6,"SAMPLE_EXAM_COS_KEY":null,"STUDY_GUIDE_COS_KEY":null,"TINSERTTS":"2024-03-27 17:44:58.015571","TLASTUPDTS":"2026-01-06 22:10:06.092024","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 version of an existing exam","STANDARDS_JOB_ROLE_DESC":"<p>An IBM Certified DBA on IBM Db2 13 for z/OS is an experienced database administrator for the Db2 product on the z/OS operating system.&nbsp; This individual has three or more years experience as a DBA and strong knowledge of Db2, up to and including Db2 13 for z/OS. This individual is capable of performing intermediate tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, and a good understanding of installation and migration/upgrades specific to Db2 z/OS.</p>","ITEMTYPE_OTHER":false,"TARGET_PUBLICATION_DATE":"2024-06-14","PEARSONVUE_START_DATE":null,"ACTUAL_START_DATE":null,"FORMS_PSYCHOMETRICIAN_NAME":"Isaac Pfleger","FORMS_PSYCHOMETRICIAN_EMAIL":"isaac@cms.itemexperts.com","PEARSONVUE_SELECTION":"Publish according to business rules","ASSESSMENT_FLAG":true,"PARENT_FORMS":"Form A,Form B","GOVERNANCE_COMPLETED_FLAG":true,"WITHDRAWAL_REASON":null,"WITHDRAWAL_REASON_COMMENT":null,"PV_PUBLISH_DATE":"2024-06-18 15:56:16.771023","READY_FOR_LIVE_DATE":"2024-06-18 15:56:28.417890","UUID":"590cc0ce-f27b-4b5b-b942-7059b19577bf","GO_LIVE_DATE":"2024-06-18 16:00:25.678464","MKTGCATEGORY":"MBDA1","EXAM_STATUS":"Live","MKTGCATEGORY_NAME":"Data, Analytics, and AI","OBJECTIVES":[{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":0,"EXAM_OBJECTIVE_TITLE":"Database Design and Implementation","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"12","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Demonstrate knowledge of logical design and relational databases</li><li>Demonstrate knowledge of physical design practices</li><li>Demonstrate ability to create Db2 Objects</li></ul>","EXAM_OBJECTIVE_ORDER":0,"TINSERTTS":"2026-01-06 22:10:05.886547","TLASTUPDTS":"2026-01-06 22:10:05.886547"},{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":1,"EXAM_OBJECTIVE_TITLE":"Operations and Recovery","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"23","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Demonstrate knowledge of Db2 and DSN commands (START, DISPLAY, BIND).</li><li>Describe system level backup and recovery versus application/object backup and recovery.</li><li>Monitor and respond to Db2 health indicators.</li><li>Utilize various Db2 utilities (LOAD, COPY, REORG).</li><li>Understand process of disaster recovery.</li><li>Manage and use distributed access.</li></ul>","EXAM_OBJECTIVE_ORDER":1,"TINSERTTS":"2026-01-06 22:10:05.892030","TLASTUPDTS":"2026-01-06 22:10:05.892030"},{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":2,"EXAM_OBJECTIVE_TITLE":"Security and Auditing ","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"8","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Design ACL and groups: Privileges and Authorizations.</li><li>Demonstrate usage of DCL to control access to Db2 objects.</li><li>Demonstrate usage of encryption options.</li><li>Demonstrate how to create an audit table.</li></ul>","EXAM_OBJECTIVE_ORDER":2,"TINSERTTS":"2026-01-06 22:10:05.898617","TLASTUPDTS":"2026-01-06 22:10:05.898617"},{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":3,"EXAM_OBJECTIVE_TITLE":"Performance","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"17","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Establish performance monitoring procedures.</li><li>Understand and use traces and reports.&nbsp;</li><li>Review and Tune SQL.</li><li>Collect and utilize Db2 statistics.</li><li>Describe and demonstrate use of system profile tables.</li><li>Demonstrate knowledge of Db2 workload classifications in WLM.</li></ul>","EXAM_OBJECTIVE_ORDER":3,"TINSERTTS":"2026-01-06 22:10:05.936422","TLASTUPDTS":"2026-01-06 22:10:05.936422"},{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":4,"EXAM_OBJECTIVE_TITLE":"Planning and Migration ","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"12","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Demonstrate knowledge of how to find DSNZPARM settings and their meanings.</li><li>Understand the usage and concepts of data sharing.</li><li>Describe SMS and storage classification and usage.</li><li>Understand the modes of migration and continuous delivery.</li></ul>","EXAM_OBJECTIVE_ORDER":4,"TINSERTTS":"2026-01-06 22:10:05.941001","TLASTUPDTS":"2026-01-06 22:10:05.941001"},{"EXAM_SERIES_CODE":"C1000-181","EXAM_OBJECTIVE_ID":5,"EXAM_OBJECTIVE_TITLE":"Application Design and Development ","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"28","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Describe the concepts and usage of IBM Db2 Analytics Accelerator for z/OS.</li><li>Show options for JSON support.</li><li>Describe the concepts and usage of SQL Data Insights (DI).</li><li>Demonstrate knowledge of Db2 REST services.</li><li>Explain the benefits of using XML with Db2 for z/OS.</li><li>Describe the facilities for communication and error handling.</li><li>Create and construct stored procedures, UDFs and triggers.</li><li>Demonstrate knowledge of dynamic vs static SQL.</li><li>Understand application logical units of work and how they are managed.</li><li>Understand program preparation and BINDs.</li><li>Demonstrate knowledge of Locking and concurrency mechanisms.</li><li>Describe the Db2 attach facilities and their usage (RRSAF, CAF, DSNALI).</li><li>Describe and use SQL constructs.</li></ul>","EXAM_OBJECTIVE_ORDER":5,"TINSERTTS":"2026-01-06 22:10:05.945452","TLASTUPDTS":"2026-01-06 22:10:05.945452"}],"RESOURCES":[],"RELATED_CERTS":[{"PARTNERWORLD_CODE":"C9006700","CREDENTIAL_TITLE":"IBM Certified Db2 13 for z/OS Database Administrator - Professional"}],"PREREQS":[],"ASSOC_COURSES":[{"COURSE_CODE":"CV854G","CSEMSTRNAME":"Db2 for z/OS 13: Introduction to System Administration"},{"COURSE_CODE":"CV845G","CSEMSTRNAME":"Db2 13 for z/OS Basic Database Administration"},{"COURSE_CODE":"CV972G","CSEMSTRNAME":"Db2 13 for z/OS Utilities for Database Administrators"},{"COURSE_CODE":"CV881G","CSEMSTRNAME":"Db2 13 for z/OS Advanced Database Administration"}],"ASSOC_NON":[],"ASSOC_PATHS":[],"ASSESSMENT":"A1000-181","LANGUAGES":"English","PRICE":200,"STUDY_GUIDE_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-181_STU_Db2DBAStudyGuide.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T213946Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-181_STU_Db2DBAStudyGuide.pdf%22&X-Amz-Signature=e051a0fc95df6b279ddefc9fcc33ffdc38eda799d4a12bf5fb9da567a48fa08b","SAMPLE_EXAM_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-181_SAM_SAMC1000181.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T213946Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-181_SAM_SAMC1000181.pdf%22&X-Amz-Signature=dd67b734c3a3c333f20598ed4595eb6c3617c893e963afc2dd1e48e622a96333"}