ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners  (CV040)

Format: Formation en classe avec formateur
Autres formats:
 
 

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/OS
  • TSO/E and ISPF
  • Data sets
  • JCL and SDSF
  • DB2 Objects
  • Structured Query Language
  • DB2 Commands
  • DB2 Utilities
  • DB2 Logging
  • DB2 Program Preparation
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 
  • Tell some services provided in a z/OS environment
  • Log On to TSO/E
  • Navigate TSO/E and ISPF
  • Use SDSF (SYSLOG Display and Search Facility)
  • Give an overview of the DB2 9 environment
  • Describe DB2 Objects
  • Describe and use some DB2 Utilities
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Setup and execute DB2 Commands from DB2I (DB2 Interactive Facility)
  • Describe DB2 Logging
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Describe job roles in a z/OS environment
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Setup and use JCL (Job Control Language) to administer DB2 9 databases
  • Describe the different types of data sets in a z/OS environment
  • Use ISPF utilities to allocate a data set and list data set information and content
  • Create and modify data set content
  • Compare volume and logical partitions
  • Describe DB2 program preparation process
  • Use TSO commands

Qui peut en profiter
 

This basic course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Préalables
 

You should be able to:

  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables

Abstract
 

IBM Education Advantage Program Eligibility:

  • Yes - IBM Education Pack - online account
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: CV040
Format: Formation en classe avec formateur
Durée: 5 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners  (CV040) Contenu détaillé
 
 
Introduction
  • 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
TSO/E and ISPF
  • 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
Data Sets (Part 1)
  • 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
Introduction and Concepts
  • 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
Structured Query Language (SQL)
  • 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
DB2 Objects
  • Relate DB2 objects and their properties
  • Create DB2 objects
  • Explain DB2 object dependencies
Data Sets (Part 2)
  • Describe a VSAM Cluster
  • Explain VSAM Cluster definition syntax for a KSDS
DB2 Overview
  • 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
DB2 Commands
  • 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
JCL and SDSF
  • Describe JCL-related activities
  • Write JCL - Basic statements
  • Make use of some SDSF options
 
Utilities
  • Explain the sequence of the Load utility
  • Explain the sequence of the DB2 Image copy
  • Communicate with DB2 online utilities
DB2 Logging
  • 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
Shutting down and Restarting the DB2
  • Explain two-phase commit processing
  • Relate the DB2 Restart phases
DB2 Program Preparation
  • Difference between BIND and REBIND
Agenda
 
Day 1
  • 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
Day 2
  • Exercise 4
  • Unit 5: Structured Query Language (SQL)
  • Exercise 5
  • Exercise 6
  • Unit 6: DB2 Objects
  • Unit 7: Data Sets (Part 2)
  • Exercise 7
Day 3
  • Unit 8: DB2 Overview
  • Exercise 8
  • Unit 9: DB2 Commands
  • Exercise 9
  • Unit 10: JCL and SDSF
Day 4
  • Exercise 10
  • Unit 11: Utilities
  • Exercise 11
  • Exercise 12
  • Exercise 13
  • Exercise 14
Day 5
  • Unit 12: DB2 Logging
  • Unit 13: Shutting down and Restarting the DB2
  • Unit 14: DB2 Program Preparation


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI