Description
At Sixe Engineering we have been providing official IBM training around the world for over 12 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.
Course details
| IBM course code: CV880G | Category: DB2 / Db2 V12 |
| Delivery: Online & on-site** | Course length in days: 2 |
Target Audience
This course is designed for students who need to enhance their skills in administering a Db2 12 for z/OS database environment.
Desired Prerequisites
Participants should have:
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
- Knowledge of SQL DML statements (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL statements (CREATE, ALTER, DROP).
- Basic skills in administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.
Instructors
The majority of IBM courses we offer are taught directly by our engineers. This ensures the highest quality of instruction. We complement all training with our own materials and laboratories, based on our extensive experience in deployments, migrations, and courses conducted over the years.
Added Value
Our courses are deeply role-oriented. For example, the technological mastery requirements differ significantly between developer teams and those responsible for deploying and managing infrastructure. We take the level of prior experience very seriously. Thus, beyond routine commands and tasks, we focus on solving real-world problems that each team encounters daily, providing them with the necessary knowledge, competencies, and skills required for each project. Additionally, our documentation is based on the latest version of each product.
Agenda and Course Syllabus
Program Preparation and the Use of Packages – Part 1
- Program preparation overview
- Execution time errors
- BIND actions
- Package status and REBIND
- Deleting a package
- Determining the table/view qualifier
Online Schema Changes – Part 1
- Changing data types
- Adding columns to a table
- Renaming columns in a table
- Renaming indexes
- Adding columns to indexes
- Versioning
Online Schema Changes – Part 2
- Pending online schema changes
- Dropping columns from a table
- Converting to UTS
- Other pending changes
- Impact of pending changes on immediate options
- Restrictions and considerations
Partition Management – Part 1
- Adding partitions
- Rotating partitions
Partition Management – Part 2
- Modifying limit keys
- Rebalancing partitions
Stored Procedures – Part 1
- External stored procedures
- WLM-established application environments
- Altering and dropping a stored procedure
- Commands for stored procedures
- Execution privileges
- Catalog information
LOAD and REBUILD INDEX
- LOAD with parallel index build
- LOAD partitions in parallel
- REBUILD INDEX
- Inline image copies and statistics
- LOAD SHRLEVEL CHANGE
- LOAD REPLACE SHRLEVEL REFERENCE
REORG
- Performance features of REORG
- Online REORG
- Inline image copies and statistics
- Considerations for PBG table spaces
- Online REORG with LOBs (optional)
UNLOAD
- Overview
- Image copy specification
- Table-only input specification
- SHRLEVEL option
- Modes of operation
Program Preparation and the Use of Packages – Part 2 (Optional)
- Table mirroring
- Package versioning
- Plan management
- Other REBIND PACKAGE options
- Application compatibility
Stored Procedures – Part 2 (Optional)
- Native stored procedures
- Native procedure deployment
This comprehensive syllabus ensures that participants are well-prepared with advanced skills in SQL, tailored to their specific roles and project needs.
Do you need to adapt this syllabus to your needs? Are you interested in other courses? Ask us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London
