Training z/OS and DB2 Basics for DB2 for z/OS DBA Beginners
Practical information about training
- CATEGORY: Technologies
- SUBCATEGORY: Data and analytics
- TRAINING CODE: CV041G
- DURATION: 5 days
- PRICE INFORMATION from: 13000 PLN net per person
- TYPE OF TRAINING: closed training
- LANGUAGE OF TRAINING: polish
- FORM OF IMPLEMENTATION: stationary, online
Training description
Beginning database administrators of DB2 11 for z/OS can develop basic skills or recognition through lectures and hands-on exercises on:
Participant profile
This basic DB2 course is designed for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.
Agenda
Day 1
- (00:30) Welcome
- (01:00) Unit 1: Introduction
- (01:30) Unit 2: TSO/E and ISPF
- (01:00) Exercise 1: TSO and ISPF
- (00:15) Exercise 1 – overview
- (01:00) Unit 3: Data Sets (Data Sets and Sequential Data Sets)
- (01:00) Exercise 2: Sequential data sets
- (00:15) Exercise 2 – overview
Day 2
- (01:00) Unit 3: Data sets (partitioned data sets)
- (01:00) Exercise 3: Partitioned data sets
- (00:15) Exercise 3 – overview
- (00:45) Unit 3: Data sets (VSAM data sets)
- (00:30) Exercise 4: VSAM data sets
- (00:15) Exercise 4 – overview
- (01:30) Unit 4: JCL and SDSF
- (01:30) Exercise 5: JCL and SDSF
- (00:15) Exercise 5 – overview
Day 3
- (01:15) Unit 5: DB2 relational database concepts
- (01:15) Unit 6: Structured Query Language (SQL) and SPUFI
- (00:45) Exercise 6: SQL and SPUFI
- (00:15) Overview of Exercise 6
- (01:30) Unit 7: DB2 objects (databases and tablespaces)
- (00:45) Exercise 7: Databases and tablespaces
- (00:15) Overview of Exercise 7
- (01:30) Unit 7: DB2 objects (tables, indexes and views)
- (00:45) Exercise 8: Tables, indexes and views
- (00:15) Overview of exercise 8
Day 4
- (01:00) Unit 7: DB2 objects (qualified names, creating classified objects and SQL statements)
- (00:30) Exercise 9: Qualified names, creating secret objects and SQL statements
- (00:15) Overview of exercise 9
- (01:30) Unit 8: DB2 system
- (00:45) Exercise 10: DB2 system
- (00:15) Overview of exercise 10
- (02:00) Unit 9: DB2 commands and program preparation
- (00:45) Exercise 11: DB2 Commands
- (00:15) Overview of exercise 11
Day 5
- (02:00) Unit 10: DB2 Tools.
- (01:00) Exercise 12: DB2 tools
- (00:15) Overview of exercise 12
- (01:15) Unit 11: Shutting down, starting up and recovering DB2
- (00:45) Exercise 13: DB2 recovery
- (00:15) Overview of Exercise 13
- (00:30) Unit 12: Course Summary
Required preparation of participants
There are no formal prerequisites for this course.
Issues
- Describing several services provided in a z/OS environment
- Explanation of loads in a batch environment
- Explaining the burden in the online environment
- Describing professional roles in a z/OS environment
- Login to TSO/E
- Navigating the TSO/E and ISPF
- Using TSO commands
- Configuring and using JCL (Job Control Language)
- Use of SDSF
- Describing the different types of data sets in a z/OS environment
- Assign datasets and display information about datasets and their contents
- Create and modify the contents of data sets
- Providing an overview of the DB2 environment 9
- Describing and using DB2 objects
- Describing and using several DB2 tools
- Describing the DB2I (DB2 Interactive Facility) environment.
- Using SPUFI (SQL Processing Using File Input) to create and execute SQL code
- Configuring and executing DB2 commands
- Understanding DB2 logging
- Describing the DB2 program preparation process
- Understanding DB2 startup and shutdown
- Understand and use DB2 recovery strategies
Do you have any questions?
Feel free to contact us.
Klaudia Janecka
+48 539 064 686
klaudia.janecka@eitt.pl
31 Ząbkowska Street 03-736 Warsaw
Forms of training delivery
Stationary training
- Training at the customer's premises or at a designated location
- Training room equipped with the necessary equipment
- Training materials in electronic form
- Coffee breaks and lunch
- Direct interaction with the trainer
- Networking in a group
- Workshop exercises in teams
Remote training
- Virtual training environment
- Electronic materials
- Interactive online exercises
- Breakout rooms for group work
- Technical support during the training
- Recordings of the session (optional)
Possibility of funding
The training can be financed with public funds under:
- National Training Fund (KFS)
- Development Services Base (BUR)
- EU projects implemented by PARP
- HR Academy Program (PARP)
- Regional operational programs
If you are interested in funding, our team will help you prepare the required documentation.
HAVE A QUESTION?
Contact us for more information about our training, programs and cooperation. We will be happy to answer all your inquiries!
They trusted us
Get to know our company
Do you have any questions?
Feel free to contact us.
Klaudia Janecka
+48 539 064 686
klaudia.janecka@eitt.pl
31 Ząbkowska Street 03-736 Warsaw
FAQ - Frequently Asked Questions
We offer training in a variety of tailored formats: onsite (at the client's location or our training center), live online interactive with a trainer, and in a hybrid format. Detailed information about the available delivery forms for a specific training is always included in its description on the website.
Open online trainings usually take place from 9:00 - 17:00 Polish time. In the case of closed trainings dedicated to companies, the schedule is flexible and we arrange it individually with the client to best fit the needs of the organization.
We use proven and popular video conferencing platforms, such as Microsoft Teams and Zoom, to conduct interactive online training. They provide seamless communication, the ability to work in groups and direct contact with the trainer. We provide information about the platform used in a specific training to participants before the training begins.
To comfortably participate in the online training, all you need is a standard computer (desktop or laptop) with stable internet access and an up-to-date version of a web browser installed. We recommend using headphones with a microphone for better sound quality and communication, although this is not absolutely required. Having a webcam is usually not mandatory either.
Yes, each participant receives a set of training materials prepared by our experts. We usually provide them in electronic form (e.g., PDF files) a few days before the start of the training, after confirmation of participation and payment.
Upon successful completion of most of our training courses, participants receive a named EITT Certificate of Completion, confirming the competencies gained. In addition, we offer accredited training courses (e.g., ITIL®, PRINCE2®) that prepare for official internationally recognized certification exams. Information about the type of certificate available after a specific training is always included in the detailed description of the training.
The enrollment process depends on the type of training. For open trainings (open to anyone who is interested), you can sign up directly through the application form available on the page of the particular training. If you are interested in closed training (dedicated to employees of one company), please contact us directly by email or phone - we will prepare an offer tailored to your needs.
As standard, the price of the training includes: participation in classes taught by an experienced trainer-practitioner, a set of original training materials in electronic form, and a named EITT Certificate of Completion. For accredited training courses, the price often also includes the cost of taking the official certification exam. The detailed scope of benefits for a given course is always given in its description.
The preferred form of payment for our training courses is by bank transfer, executed on the basis of an issued pro forma invoice or VAT invoice. Detailed information on payment terms and conditions is provided in the process of confirming the enrollment in the training or can be found in the regulations.
Of course! Our specialty is closed-door training, designed "tailor-made" - according to the individual needs and business objectives of a given organization. If you are interested in a topic outside of our regular offerings or would like to modify the program of an existing course, feel free to contact us. We will be happy to prepare a dedicated solution.
We are flexible and adapt to the client's needs. We can organize closed trainings even for small groups - usually the minimum number of participants is 4 people, and the cost is often calculated for the whole group. Taking care of the highest quality and comfort of learning, in case of very large groups (more than 40 people) we usually recommend dividing into smaller teams to ensure effective interaction.
Your feedback is extremely important to us, as it allows us to continuously improve our offerings. After each training session, we send participants a link to a short online evaluation survey. You can also always contact us directly by email or phone to provide your comments.
- One-pager invitation with deadlines
- Project kick-off
- Strategic leadership and thinking
- Communication and Cooperation. Conflict management
- Motivating, engaging and difficult decisions in business
- Managing Change and Innovation. Leadership in crisis
- Building the organization of the future
- Best practices workshop - retrospective; creating a coherent program for middle and lower management levels