IBM Db2 13 for z/OS Database Administrator - Professional — Information & Free Practice
US · Examination information
100 free questions · Answer explanations · No signup required
IBM Db2 13 for z/OS Database Administrator - Professional
- Provider
- Pearson VUE
- Format
- Proctored computer-delivered examination; IBM publishes multiple-choice and build-list item flags.
- Exam questions
- Total questions: 60.
- Time limit
- 90 minutes
- Passing score
- 40 questions to pass
- Exam fee
- United States: $200 USD per exam; indicative price subject to local availability and applicable taxes.
Examination outline
Database Design and Implementation (12%)
- Logical design and relational databases
- Physical design practices
- Create Db2 objects
Operations and Recovery (23%)
- Db2 and DSN commands
- System and application/object backup and recovery
- Db2 health indicators
- Db2 utilities
- Disaster recovery
- Distributed access
Security and Auditing (8%)
- ACL, groups, privileges and authorizations
- DCL and access control
- Encryption options
- Audit tables
Performance (17%)
- Performance monitoring procedures
- Traces and reports
- SQL review and tuning
- Db2 statistics
- System profile tables
- Db2 workload classifications in WLM
Planning and Migration (12%)
- DSNZPARM settings
- Data sharing
- SMS and storage classification
- z/OS installation commands
- Migration and continuous delivery
Application Design and Development (28%)
- IBM Db2 Analytics Accelerator for z/OS
- JSON support
- SQL Data Insights
- Db2 REST services
- XML with Db2 for z/OS
- Communication and error handling
- Stored procedures, UDFs and triggers
- Dynamic and static SQL
- Application logical units of work
- Program preparation and BINDs
- Locking and concurrency
- Db2 attach facilities
- SQL constructs
Examination sources
- IBM certification C9006700
Study Guide adoption
- IBM Certification Program C1000-181 Study Guide
p.2, Purpose of Exam Objectives; detailed Objectives on pp.3-7
- IBM certification C9006700
Exam Objectives, Section 1
- IBM C1000-181 record
STUDY_GUIDE_URL
- IBM certification C9006700
Exam Objectives, examination statistics
- IBM C1000-181 examination record
ITEMTYPE flags
- IBM certification C9006700
Testing Policy, language and US price
- Pearson VUE IBM program
Register to take your IBM certification exam online or at a test center
- Pearson VUE IBM program
Should you take your exam online?
- IBM certification C9006700
Exam Resources
- IBM C1000-181 record
WITHDRAWAL_DATE
Related license preparation
This examination may be required or accepted as an alternative, depending on the license and application pathway.