CV041G z/OS and DB2 Basics for DB2 for z/OS DBA Beginners (update to DB2 11 for z/OS)

Corso

A Segrate

2.750 € +IVA

Chiama il centro

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

Segrate (Milano)
Visualizza mappa
Via Cassanese, 224, Palazzo Mantegna, Scala A, 20090

Inizio del corso

Consultare

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Chi vuoi che ti risponda?

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

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.

Chiama il centro

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)

2.750 € +IVA