TD-CV880G DB12 for zOS Advanced Database Administration
Inhalte
- 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
Ziele
- 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
Zielgruppe
Persons needing to augment their skill set in administering a Db2 12 for z/OS database environment.
Voraussetzungen
- 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.
Unterlagen
Special
Preise
Kursgebühr
3.400,00 € exkl. MwSt.
4.046,00 € inkl. MwSt. Kursdauer 4 Tage
Ihr CBT Trainingsteam
Gabriela Bücherl
Geschäftsführung
Vertrieb
Kontakt/Fragen:
beratung@cbt-training.de
Telefon: +49 (0)89-4576918-16
Anfrage für ein Firmenseminar
- Individuelle Zusammenstellung der Themen
- Maßgeschneidert auf Ihre Ziele
- Inhouse oder als Virtual Classroom LIVE Training
Leistungen Präsenz
- Schulung im Trainingscenter
- Verpflegung
- Teilnahmebestätigung / Zertifikat
Leistungen bei VCL Training
- Technischer Support
- Online Zugang
- Teilnahmebestätigung / Zertifikat