CV041G z/OS and DB2 Basics for DB2 for z/OS DBA Beginners (update to DB2 11 for z/OS)
Corso
A Segrate
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Segrate
-
Durata
5 Giorni
A continuazione troverai il programma di questo corso disegnato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. z/OS and DB2 Basics for DB2 for z/OS DBA Beginners will help beginning DBAs develop fundamental z/OS and DB2 for z/OS skills through lectures and hands-on labs in the areas of: z/OSTSO/E and ISPFData setsJCL and SDSFDB2 ObjectsStructured Query LanguageDB2 CommandsDB2 UtilitiesDB2 LoggingDB2 Program Preparation
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Opinioni
Programma
Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.
- List some benefits of z/OS
- Describe typical mainframe workloads
- Tell typical batch applications
- Explain online transaction processing
- Report job roles in the Mainframe environment
- Invoke TSO from a desktop using IBM Personal Communications (PCOMM)
- Explain TSO Logon parameters
- Invoke ISPF from TSO
- Explain ISPF Primary options
- Swap screens within ISPF
- Customize ISPF
- Allocate a sequential data set
- Allocate a partitioned data set
- Describe a VSAM data set
- Maintain a sequential data set
- Maintain members of a partition data set
- Use ISPF Data Set List Utility
- List some benefits of using DB2
- Describe the structure of a DB2 table
- Give some rules for a relational data model
- State DB2 delete rules for referential integrity
- Communicate the components of the SQL language
- Describe four SELECT statement clauses (SELECT, FROM, WHERE, ORDER BY) and their purpose
- Retrieve all rows of a table
- Retrieve specific columns
- Retrieve rows based on comparisons to numeric or alphanumeric column values
- Use the keywords BETWEEN, IN, LIKE, DISTINCT
- Order the resulting rows in a desired sequence
- Use some of the DB2I facilities to communicate with DB2
- Relate DB2 objects and their properties
- Create DB2 objects
- Explain DB2 object dependencies
- Define the acronyms:
- VSAM
- KSDS
- ESDS
- LDS
- BSDS
- Describe a VSAM Cluster
- Explain VSAM Cluster definition syntax for a KSDS
- Identify Z/OS Allied Address Spaces
- Describe DB2 address space functions
- Explain the function of the IRLM (Internal Resource Lock Manager)
- Interact with the DB2 catalog
- Describe the DB2 Directory
- Relate ways to issue DB2 commands
- Identify the syntax of a DB2 command
- Demonstrate commands:
- DISPLAY DATABASE
- DISPLAY THREAD
- DISPLAY UTILITY
- DISPLAY GROUP
- DISPLAY LOG
- START DATABASE
- STOP DATABASE
- TERM UTILITY
- ARCHIVE LOG
- CANCEL THREAD
- SET SYSPARM
- Describe JCL-related activities
- Write JCL - Basic statements
- Make use of some SDSF options
- Categorize DB2 utilities:
- Online
- Standalone
- Service aids and samples
- Explain the sequence of the Load utility
- Explain the sequence of the DB2 Image copy
- Communicate with DB2 online utilities
- Explain at a high-level the DB2 logging process
- Relate the interaction of archive/active logs and the BSDS
- Recite the contents of the BSDS
- Explain two-phase commit processing
- Relate the DB2 Restart phases
- Explain the program preparation steps
- Explain:
- DBRM
- PLAN
- PACKAGE
- Difference between BIND and REBIND
- Welcome
- Unit 1: Introduction
- Exercise 1
- Unit 2: TSO/E and ISPF
- Exercise 2
- Unit 3: Data Sets (Part 1)
- Exercise 3
- Unit 4: Introduction and Concepts
- Exercise 4
- Unit 5: Structured Query Language (SQL)
- Exercise 5
- Exercise 6
- Unit 6: DB2 Objects
- Unit 7: Data Sets (Part 2)
- Exercise 7
- Unit 8: DB2 Overview
- Exercise 8
- Unit 9: DB2 Commands
- Exercise 9
- Unit 10: JCL and SDSF
- Exercise 10
- Unit 11: Utilities
- Exercise 11
- Exercise 12
- Exercise 13
- Exercise 14
- Unit 12: DB2 Logging
- Unit 13: Shutting down and Restarting the DB2
- Unit 14: DB2 Program Preparation
Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
CV041G z/OS and DB2 Basics for DB2 for z/OS DBA Beginners (update to DB2 11 for z/OS)