Use this quick start guide to collect all the information about IBM Db2 13 for z/OS Database Administrator Professional (C1000-181) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C1000-181 IBM Db2 13 for z/OS Database Administrator - Professional exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM Db2 13 for z/OS Database Administrator Professional certification exam.
The IBM Db2 13 for z/OS Database Administrator Professional certification is mainly targeted to those candidates who want to build their career in Data, Analytics, and AI domain. The IBM Certified Db2 13 for z/OS Database Administrator - Professional exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM Db2 13 for z/OS Database Administrator Professional.
IBM Db2 13 for z/OS Database Administrator Professional Exam Summary:
| Exam Name | IBM Certified Db2 13 for z/OS Database Administrator - Professional |
| Exam Code | C1000-181 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 60 |
| Passing Score | 67% |
| Books / Training |
Db2 for z/OS 13: Introduction to System Administration (CV854G) Db2 13 for z/OS Basic Database Administration (CV845G) Db2 13 for z/OS Utilities for Database Administrators (CV972G) Db2 13 for z/OS Advanced Database Administration (CV881G) |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM Db2 13 for z/OS Database Administrator Professional Sample Questions |
| Practice Exam | IBM C1000-181 Certification Practice Exam |
IBM C1000-181 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Database Design and Implementation |
- Demonstrate knowledge of logical design and relational databases - Demonstrate knowledge of physical design practices - Demonstrate ability to create Db2 Objects |
12% |
| Operations and Recovery |
- Demonstrate knowledge of Db2 and DSN commands (START, DISPLAY, BIND). - Describe system level backup and recovery versus application/object backup and recovery. - Monitor and respond to Db2 health indicators. - Utilize various Db2 utilities (LOAD, COPY, REORG). - Understand process of disaster recovery. - Manage and use distributed access. |
23% |
| Security and Auditing |
- Design ACL and groups: Privileges and Authorizations. - Demonstrate usage of DCL to control access to Db2 objects. - Demonstrate usage of encryption options. - Demonstrate how to create an audit table. |
8% |
| Performance |
- Establish performance monitoring procedures. - Understand and use traces and reports. - Review and Tune SQL. - Collect and utilize Db2 statistics. - Describe and demonstrate use of system profile tables. - Demonstrate knowledge of Db2 workload classifications in WLM. |
17% |
| Planning and Migration |
- Demonstrate knowledge of how to find DSNZPARM settings and their meanings. - Understand the usage and concepts of data sharing. - Describe SMS and storage classification and usage. - Understand the modes of migration and continuous delivery. |
12% |
| Application Design and Development |
- Describe the concepts and usage of IBM Db2 Analytics Accelerator for z/OS. - Show options for JSON support. - Describe the concepts and usage of SQL Data Insights (DI). - Demonstrate knowledge of Db2 REST services. - Explain the benefits of using XML with Db2 for z/OS. - Describe the facilities for communication and error handling. - Create and construct stored procedures, UDFs and triggers. - Demonstrate knowledge of dynamic vs static SQL. - Understand application logical units of work and how they are managed. - Understand program preparation and BINDs. - Demonstrate knowledge of Locking and concurrency mechanisms. - Describe the Db2 attach facilities and their usage (RRSAF, CAF, DSNALI). - Describe and use SQL constructs. |
28% |
To ensure success in IBM Db2 13 for z/OS Database Administrator Professional certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM Db2 13 for z/OS Database Administrator - Professional (C1000-181) exam.
