Db2 12 for zOS Advanced Database Administration (all optional themes included)
Institut: ETC - Enterprise Training Center GmbHBereich: Technik, EDV, Telekommunikation
Kursbeschreibung
This course will introduce the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.
Objective:
- 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 type
- 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
- Consideratons for PBG table spaces
- Online REORG with LOBs (included)
- UNLOAD
- Overview
- Image copy specification
- Table-only input specification
- SHRLEVEL option
- Modes of operation
- Program preparation and the use of packages part 2 (included)
- Table mirroring
- Package versioning
- Plan management
- Other REBIND PACKAGE options
- Application compatibility
- Stored procedures part 2 (included)
- Native stored procedures
- Native procedure deployment
This course will introduce the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.
Objective:
- 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 type
- 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
- Consideratons for PB…
mehrweniger lesen
Beginn
16.06.2025
Ende
18.06.2025
Uhrzeit
ca 09:00 - 16:00 Uhr
Dauer
21.0 LE
Ort
ETC-Wien
E-Mail
Kontakt
Mathias Leiner
Ort
ETC - Enterprise Training Center
Straße
Modecenterstrasse 22/Office 4
PLZ
1030
Ort
Wien
Land
Österreich
Bundesland
Wien
Tel
Fax
+431533 17 77-85
Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements
Basic skills administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.
Zielgruppe
Students needing to augment their skill set in administering a Db2 12 for z/OS database environment.
Kosten
€ 2.400
exkl. 20% MwSt
exkl. 20% MwSt
Kursnummer
TD-CV880Gspecial
