C1000-122 Exam Information and Outline
Db2 12 for z/OS DBA Fundamentals
C1000-122 Exam Syllabus & Study Guide
Before you start practicing with our exam simulator, it is essential to understand the official C1000-122 exam objectives. This course outline serves as your roadmap, breaking down exactly which technical domains and skills will be tested. By reviewing the syllabus, you can identify your strengths and focus your study time on the areas where you need the most improvement.
The information below reflects the latest 2026 course contents as defined by IBM. We provide this detailed breakdown to help you align your preparation with the actual exam format, ensuring there are no surprises on test day. Use this outline as a checklist to track your progress as you move through our practice question banks.
Below are complete topics detail with latest syllabus and course outline, that will help you good knowledge about exam objectives and topics that you have to prepare. These contents are covered in questions and answers pool of exam.
Exam Code: C1000-122
Exam Name: Db2 12 for z/OS DBA Fundamentals
Number of questions: 63
Number of questions to pass: 44
Time allowed: 90 minutes
Status: Live
Section 1: Planning (12%)
- Db2 12 system requirements and supported z/OS levels
- Processor requirements (z196 and later, z13, z14, z15, z16)
- Memory requirements and buffer pool planning
- Installation methods: SMP/E, DB2 Installation CLIST, new function mode (NFM), catalog migration
- Migration from Db2 11 or earlier versions, fallback and fallback SPE
- Enabling new function mode (ENFM), catalog changes in V12
- DSNZPARM (ZPARM) parameters relevant to installation
- Subsystem parameters (DSNTIJUZ, DSN6SYSP, DSN6ARVP, DSN6LOGP, DSN6SPRM)
- Buffer pool sizing and attributes (BP0 to BP49, BP32K, page sizes 4K, 8K, 16K, 32K)
- Use of zIIP processors for DB2 workload offloading
- High availability and disaster recovery planning (Data Sharing, HADR, GDPS)
- Distributed Data Facility (DDF) planning and DRDA
- Storage requirements and use of SMS, extended addressability
- Function levels in Db2 12 (V12R1M500, M501, M502, M505, etc.)
- DSNZPARM
- IRLM
- EDM pool
- RDS pool
- DDF
- ZPARM
- function level
- CATMAINT
- ENFM
- fallback SPE
- zIIP
- SMS
- extended addressability
- data sharing group
- coupling facility
Section 2: Working with SQL and XML (15%)
- Data types: CHAR, VARCHAR, INTEGER, DECIMAL, DATE, TIME, TIMESTAMP, CLOB, BLOB, XML
- Basic SQL: SELECT, INSERT, UPDATE, DELETE, MERGE
- Joins: inner join, left/right/full outer join, cross join
- Subqueries: scalar, correlated, non-correlated, EXISTS, NOT EXISTS
- Common table expressions (CTE), recursive CTE
- SQL functions: scalar (COALESCE, NULLIF, CASE), aggregate (SUM, AVG, COUNT, MIN, MAX), string functions
- Grouping and HAVING clause
- UNION, UNION ALL, INTERSECT, EXCEPT
- XML data type, XML columns, XML storage (XML tablespaces)
- XML parsing and validation (XMLPARSE, XMLVALIDATE)
- Querying XML with SQL/XML functions: XMLQUERY, XMLEXISTS, XMLTABLE
- XML indexes and XML schema registration (XSR)
- Dynamic vs static SQL, parameter markers, PREPARE, EXECUTE IMMEDIATE
- predicate
- sargable predicate
- stage 1 predicate
- stage 2 predicate
- indexable predicate
- XMLTABLE
- XMLEXISTS
- XMLQUERY
- XMLPARSE
- XSR (XML Schema Repository)
- pureXML
Section 3: Security (12%)
- Authentication methods: z/OS (RACF, ACF2, Top Secret), LDAP, Kerberos
- Authorization IDs: primary, secondary, role, trusted context
- DB2 privileges: SYSADM, SYSCTRL, SYSOPR, DBADM, DBCTRL, DBMAINT
- Object privileges: SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, TRIGGER, EXECUTE
- Administrative authorities: PACKADM, SQLADM, DATAACCESS, ACCESSCTRL
- Row and column access control (RCAC): row permissions, column masks
- Multilevel security (MLS) and security labels
- Audit policies and audit trace
- Trusted context and role-based access
- Encryption: data at rest (z/OS dataset encryption), in-flight (DRDA encryption), application-level encryption
- SECADM authority
- RACF
- SYSADM
- DBADM
- DATAACCESS
- ACCESSCTRL
- RCAC
- row permission
- column mask
- trusted context
- role
- SECADM
- audit policy
- multilevel security
Section 4: Operations (15%)
- Starting and stopping DB2: START DB2, STOP DB2, STOP DB2 MODE(FORCE)
- DISPLAY commands: DISPLAY DATABASE, DISPLAY THREAD, DISPLAY UTILITY, DISPLAY DDF
- DB2 commands: -START RLIMIT, -TERM UTILITY, -ALTER BUFFERPOOL, -REFRESH DB2
- Utility execution: RUNSTATS, REORG, COPY, RECOVER, LOAD, UNLOAD, REPAIR
- Online schema changes: ALTER TABLE, ALTER INDEX, pending changes
- Backup and recovery: image copies (full, incremental), QUIESCE, BACKUP SYSTEM, RESTORE SYSTEM
- Log management: active log, archive log, BSDS, log preformatting
- Monitoring: -DISPLAY LOG, -DISPLAY BUFFERPOOL, -ACCESS DATABASE
- BSDS
- active log
- archive log
- image copy
- QUIESCE
- online REORG
- pending definition
- materialization
- TERM UTILITY
- DISPLAY THREAD
- CANCEL THREAD
Section 5: Data Concurrency (14%)
- Locking: lock escalation, lock avoidance, lock modes (IS, IX, S, U, X)
- Isolation levels: CS (cursor stability), RS (read stability), RR (repeatable read), UR (uncommitted read)
- Claim and drain process
- Deadlock and timeout detection (IRLM parameters)
- Bind options: ACQUIRE(USE/ALLOCATE), RELEASE(COMMIT/DEALLOCATE), ISOLATION(CS/RS/RR/UR)
- Currentdata option and blocking
- Lock avoidance with CS and lock skipping
- LOB and XML locking behavior
- lock escalation
- lock avoidance
- claim
- drain
- deadlock
- timeout
- IRLM
- isolation level
- cursor stability
- read stability
- uncommitted read
- CURRENTDATA
Section 6: Application Design (15%)
- Bind options and package management
- REOPT(ONCE/ALWAYS/NEVER), PLANMGMT, APREUSE
- Static vs dynamic SQL performance considerations
- Use of global temporary tables (DGTT), declared temporary tables
- Sequence objects and identity columns
- Triggers: BEFORE, AFTER, INSTEAD OF
- Stored procedures: native SQL procedures, external procedures
- Versioning of packages (APPLCOMPAT)
- Concentration of packages and thread reuse
- High performance DBATs in DDF
- package
- collection
- version
- APPLCOMPAT
- REOPT
- PLANMGMT
- APREUSE
- DGTT
- sequence
- trigger
- native SQL procedure
- high performance DBAT
Section 7: Working with Database Objects (15%)
- Tablespaces: partitioned, universal (PBG, PBR), segmented, LOB tablespaces
- Indexes: unique, non-unique, partitioning index, index on expression, DPSI
- Index page sizes and compression
- Cloning tables and databases
- Temporal tables: system-period temporal, application-period temporal, bitemporal
- Views, materialized query tables (MQT), aliases
- Constraints: primary key, unique, foreign key, check constraint
- Storage groups (STOGROUP), volumes, VCAT vs SMS
- Altering objects: ALTER TABLESPACE, ALTER INDEX, deferred alters
- universal tablespace
- PBG
- PBR
- partition-by-growth
- partition-by-range
- DPSI
- expression-based index
- temporal table
- history table
- STOGROUP
- clone table
- pending alter
- immediate alter