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), understanding how to create databases and database objects, and basic knowledge of database security and transaction isolation.
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.
-
Section 1: Planning9%
- Demonstrate knowledge of subsystem parameters.
- Understand the modes of migration and the continuous delivery process.
- Identify the Db2 address spaces and their purposes.
- Understand data sharing concepts.
-
Section 2: Operations15%
- Connect to Db2 servers.
- Understand Db2 and DSN commands.
- Understand the Db2 start up process.
- Understand the Db2 logging and recovery environment.
- Understand the Db2 subsystem recovery/restart process.
- Demonstrate a basic knowledge of Db2 utilities.
- Navigate the Db2 catalog / directory.
-
Section 3: Security7%
- Utilize the Data Control Language to establish access to Db2 objects.
- Describe the authorization hierarchy.
-
Section 4: Database Design22%
- Create and modify database objects using DDL.
- Understand the Db2 data types.
- Illustrate the basic concepts of relational databases.
- Understand the relationship(s) between Db2 tables.
-
Section 5: Application Development20%
- Develop stored procedures, UDFs, and triggers.
- Understand the mechanisms for validating SQL execution.
- Understand basics of DML.
- Demonstrate knowledge of static and dynamic SQL.
- Understand program preparation and BINDs.
-
Section 6: Data Concurrency10%
- Understand locking and concurrency concepts.
- Demonstrate the knowledge of transaction isolation.
- Understand application logical units of work and how they are managed.
-
Section 7: Performance17%
- Utilize explains.
- Understand access paths and statistics.
- Understand traces and reports.
Reviews
There are no reviews yet.