CV880G Db2 12 for zOS Advanced Database Administration
Duração: 2 Dias
Nível: Avançado
Audiência: Systems Administrator
PRÓXIMAS SESSÕES
Início (AAAA-MM-DD) | Fim (AAAA-MM-DD) | Língua | Preço | |
---|---|---|---|---|
2023-11-09 | 2023-11-10 | Português | 1450 EUR | |
2023-11-23 | 2023-11-24 | Português | 1450 EUR | |
2023-12-07 | 2023-12-08 | Português | 1450 EUR | |
2023-12-21 | 2023-12-22 | Português | 1450 EUR | |
2024-01-18 | 2024-01-19 | Português | 1450 EUR | |
2024-02-01 | 2024-02-02 | Português | 1450 EUR | |
2024-02-15 | 2024-02-16 | Português | 1450 EUR | |
2024-02-29 | 2024-03-01 | Português | 1450 EUR | |
2024-03-14 | 2024-03-15 | Português | 1450 EUR | |
2024-03-28 | 2024-03-29 | Português | 1450 EUR | |
2024-04-11 | 2024-04-12 | Português | 1450 EUR | |
2024-04-25 | 2024-04-26 | Português | 1450 EUR | |
2024-05-09 | 2024-05-10 | Português | 1450 EUR | |
2024-05-23 | 2024-05-24 | Português | 1450 EUR | |
2024-06-06 | 2024-06-07 | Português | 1450 EUR | |
2024-06-20 | 2024-06-21 | Português | 1450 EUR |
SÍNTESE
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.
PREREQUISITOS
- 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.
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 (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
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
• 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