{"EXAM_SERIES_CODE":"C1000-184","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 - Associate","WITHDRAWAL_DATE":null,"CREATED_BY_EMAIL":"rena_chang@us.ibm.com","CREATED_BY_DATE":"2024-04-12 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>The IBM Certified Db2 13 for z/OS Database Administrator - Associate is designed for an entry-level DBA who is knowledgeable about the fundamental concepts of Db2 13 for z/OS through either hands-on experience or formal and informal education. The database administrator should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.</p>","OVERVIEW_JOB_SKILL":null,"EXAM_TIME_LIMIT":90,"EXAM_PASSING_SCORE":73,"EXAM_NUMBER_OF_QUESTIONS":60,"EXAM_NUMBER_OF_QUESTIONS_TO_PASS":44,"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>The IBM Certified Db2 13 for z/OS Database Administrator - Associate is designed for an entry-level DBA who is knowledgeable about the fundamental concepts of Db2 13 for z/OS through either hands-on experience or formal and informal education. The database administrator should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.</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>The IBM Certified Db2 13 for z/OS Database Administrator - Associate is designed for an entry-level DBA who is knowledgeable about the fundamental concepts of Db2 13 for z/OS through either hands-on experience or formal and informal education. The database administrator should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.</p>","ITEMTYPE_MULTIPLE_CHOICE":true,"ITEMTYPE_DOMC":false,"ITEMTYPE_BUILD_LIST":true,"ITEMTYPE_HOT_AREA":true,"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-04-12 14:55:40.018226","TLASTUPDTS":"2026-01-06 22:04:53.790550","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>The IBM Certified Db2 13 for z/OS Database Administrator - Associate is designed for an entry-level DBA who is knowledgeable about the fundamental concepts of Db2 13 for z/OS through either hands-on experience or formal and informal education. The database administrator should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.</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 16:07:39.090060","READY_FOR_LIVE_DATE":"2024-06-18 16:08:36.435528","UUID":"0e42cc32-6ab2-4d0c-b49e-95dfff16f3b9","GO_LIVE_DATE":"2024-06-18 17:08:36.000000","MKTGCATEGORY":"MBDA1","EXAM_STATUS":"Live","MKTGCATEGORY_NAME":"Data, Analytics, and AI","OBJECTIVES":[{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":0,"EXAM_OBJECTIVE_TITLE":"Planning","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"12","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Demonstrate knowledge of subsystem parameters.</li><li>Understand the modes of migration and the continuous delivery process.</li><li>Identify the Db2 address spaces and their purposes.</li><li>Understand data sharing concepts.</li></ul>","EXAM_OBJECTIVE_ORDER":0,"TINSERTTS":"2026-01-06 22:04:53.657975","TLASTUPDTS":"2026-01-06 22:04:53.657975"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":1,"EXAM_OBJECTIVE_TITLE":"Operations","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"20","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Connect to Db2 servers.</li><li>Understand Db2 and DSN commands.</li><li>Understand the Db2 start up process.</li><li>Understand the Db2 logging and recovery environment.</li><li>Understand the Db2 subsystem recovery/restart process.</li><li>Demonstrate a basic knowledge of Db2 utilities.</li><li>Navigate the Db2 catalog / directory.</li></ul>","EXAM_OBJECTIVE_ORDER":1,"TINSERTTS":"2026-01-06 22:04:53.661777","TLASTUPDTS":"2026-01-06 22:04:53.661777"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":2,"EXAM_OBJECTIVE_TITLE":"Security","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"5","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Utilize the Data Control Language to establish access to Db2 objects.</li><li>Describe the authorization hierarchy.</li></ul>","EXAM_OBJECTIVE_ORDER":2,"TINSERTTS":"2026-01-06 22:04:53.665529","TLASTUPDTS":"2026-01-06 22:04:53.665529"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":3,"EXAM_OBJECTIVE_TITLE":"Database Design ","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"20","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Create and modify database objects using DDL.</li><li>Understand the Db2 data types.</li><li>Illustrate the basic concepts of relational databases.</li><li>Understand the relationship(s) between Db2 tables.</li></ul>","EXAM_OBJECTIVE_ORDER":3,"TINSERTTS":"2026-01-06 22:04:53.670420","TLASTUPDTS":"2026-01-06 22:04:53.670420"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":4,"EXAM_OBJECTIVE_TITLE":"Application Development ","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"21","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>Develop stored procedures, UDFs, and triggers.</li><li>Understand the mechanisms for validating SQL execution.</li><li>Understand basics of DML.</li><li>Demonstrate knowledge of static and dynamic SQL.</li><li>Understand program preparation and BINDs.</li></ul>","EXAM_OBJECTIVE_ORDER":4,"TINSERTTS":"2026-01-06 22:04:53.673979","TLASTUPDTS":"2026-01-06 22:04:53.673979"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":5,"EXAM_OBJECTIVE_TITLE":"Data Concurrency","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"12","EXAM_OBJECTIVE_DESCRIPTION":"<ul><li>&nbsp;Understand locking and concurrency concepts.</li><li>Demonstrate the knowledge of transaction isolation.</li><li>Understand application logical units of work and how they are managed.</li></ul>","EXAM_OBJECTIVE_ORDER":5,"TINSERTTS":"2026-01-06 22:04:53.678010","TLASTUPDTS":"2026-01-06 22:04:53.678010"},{"EXAM_SERIES_CODE":"C1000-184","EXAM_OBJECTIVE_ID":6,"EXAM_OBJECTIVE_TITLE":"Performance","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"10","EXAM_OBJECTIVE_DESCRIPTION":"<ol><li>Utilize explains.</li><li>Understand access paths and statistics.</li><li>Understand traces and reports.</li></ol>","EXAM_OBJECTIVE_ORDER":6,"TINSERTTS":"2026-01-06 22:04:53.681580","TLASTUPDTS":"2026-01-06 22:04:53.681580"}],"RESOURCES":[],"RELATED_CERTS":[{"PARTNERWORLD_CODE":"C9006800","CREDENTIAL_TITLE":"IBM Certified Db2 13 for z/OS Database Administrator - Associate"}],"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"}],"ASSOC_NON":[],"ASSOC_PATHS":[],"ASSESSMENT":"A1000-184","LANGUAGES":"English","PRICE":200,"STUDY_GUIDE_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-184_STU_Db2FundamentalsStudyGuide.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260927%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260927T212540Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-184_STU_Db2FundamentalsStudyGuide.pdf%22&X-Amz-Signature=85284601627954b94532c7daf43f13889aed5c42b5e42fdea3dde5044aa83e41","SAMPLE_EXAM_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-184_SAM_SAMC1000184.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260927%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260927T212540Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-184_SAM_SAMC1000184.pdf%22&X-Amz-Signature=fd8732387dbda7590f240f2b5e336595be0b2abfdd0efea3077c86305bc69887"}