Db2 12 for zOS Advanced Database Administration (all optional AND "Large Objects" themes included)

Institut: ETC - Enterprise Training Center GmbH
Bereich: Technik, EDV, Telekommunikation

Kurs merken

Anmelden

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 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

Wählen Sie einen Kurs aus der Ergebnisliste

Db2 12 for zOS Advanced Database Administration (all optional AND "Large Objects" themes included)

Kursbeschreibung

Diese Kurse könnten Sie auch interessieren ...

BIZ Berufs-und Bildungsberatung

Berufsorientierung

Berufs- und Bildungsinformation

Jobsuche und Bewerbung

BIZ Veranstaltungen